Thank you for the information and screenshots provided! That is odd. Was the Inventory Status feature enabled and disabled on your account? Since there is no related documentation on this behavior and I am unable to reproduce this in my test account, I can't say for certain that what you pointed out is the cause, but it is…

You're welcome, Prtk! ? Glad I could help!

Hi Prtk, The Class Name associated with the Item should be pulled when using the Item: Class field. I noticed on the screenshot you provided that there is a value populating in the Item: Class field in the results of your search. Is this not the values you expect to be pulled? Or do you need only Freight and not Hardware:…

Hi Prtk, If you use the Class: Name field, it would pull the value of the Class set on the transaction. Kindly check if the transaction has a value on the Class field, in both line level and the item level, or if it is blank.

In my test account, the Item Receipt I created also doesn't have a GL Impact, but it is still showing in the report. You can find the Inventory Valuation Report by navigating to Reports > Inventory/Items > Inventory Valuation Report > Detail. This functions similar to the Inventory Activity Detail Report, but also shows…

You can check the following SuiteAnswers articles for more information regarding this report: 28022 26403 In troubleshooting this, please check the following as well: Is this the only item receipt not showing? Does the Item Receipt have a GL Impact? Are other transactions for this item showing in the report? Is the Item…

Hi Prtk, It will give you null values if the Class field is blank on the Item Record. Do you want to have a text populate the column instead of a blank? You can do this by adding a Formula (Text) field with the formula: NVL({item.class},'NoClass') As for the Internal ID of the Class, you can add another Formula (Text)…

Hi @User_DPITI, Have you tried adding the Item: Class field in the Results tab of your search? If you add this field to your transaction saved search, then it should pull the value of the Class field in the item record. Let us know if this works for you or if you need further assistance with this. ? -Ivy…

Hey there @User_FZNHI, Can you try this formula: CASE WHEN {internalid} <> {custbody_trandid} THEN 1 ELSE 0 END If this doesn't work, then kindly provide some screenshots of your custom field setup so we can further test in our account. ? -Ivy ========================= If you find this reply to your question as helpful,…

I am not able to reproduce the behavior in my test account. Even when the location in the item line and header level of the Item Receipt is different, it is still showing in the Inventory Activity Detail Report. Have you tried to set the Location filter of the report to -All-? Is it still not showing? Based on the…

Please check the Date Range in the report and make sure that the Item Receipt Date is within the range. Also try checking if the location set on the Item Receipt is the same, or included in the location filters of your report (if any).

Hi @Strategit_Shunta4, On the Item Receipt, please check if the ‘Restock’ checkbox is marked. Based on SuiteAnswers 9147 - Receiving a Customer Return: Check the Restock box to return this item to your inventory. Your inventory reflects the increased count of the returned item and the value of your inventory is also…

Hi @Biomerics_Admin, Thank you for being with us today and for posting your question here! Kindly allow our gurus/members some time to check this one for you and we will get back to you with our findings. @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle, any ideas? To anyone in the community who might have an idea, feel…

Hi there @User_NOMCY, Welcome to the community and thank you for posting your concern here. ? Kindly allow our gurus/members some time to check this one for you and we will get back to you with our findings. If you can share some screenshots as well, that would definitely help us in investigating this one. Also, you may…

You're welcome, Bee! Glad I could help! ?

The error might be happening because there are some lines in the search that are returning "invalid" when trying to convert the string to a date. For example, the lot number is WSA-20231025-20211325, so the system pulls 20211325, and tries to convert it to a date. 13/25/2021 is an invalid date. Also, are there lot numbers…

Hi there Bee @User_IE7NG, I've tested this one out, and I've come up with these Formula: If using Formula (Text): (SUBSTR(REGEXP_SUBSTR({inventorynumber},'[^-]+$'),5,2)) || '/' || (SUBSTR(REGEXP_SUBSTR({inventorynumber},'[^-]+$'),7)) || '/' || (SUBSTR(REGEXP_SUBSTR({inventorynumber},'[^-]+$'),1,4)) If using Formula (Date):…

Hi @eleran, Thank you for creating another thread here in our community! ? @Leonard Mallare-Oracle will be assisting you with this one. Anyone else experiencing a similar scenario? Feel free to comment here.

Hi @User_VSPJE, Welcome to the community! We are glad to have you here with us! ? To get you started, we recommend the following: Update your profile, add a profile picture and preferred username so other members can address you properly moving forward. You can check out Community Tip: Updating Your Profile! on how to do…

You're welcome! Glad I could help, @RichardMc! ?

Hi @RichardMc, Have you tried using the Document Number/ID or the Transaction Number/ID fields?

Hi Nahir, Please be informed that after further checking, I was able to verify that you can only use current on hand of the item using saved searches and not the beginning nor end on hand on a specific date. You mentioned in your initial post that the formula is: Sell through rate = total units sold per day / (units on…

Hi there @Wendy_M, Thank you for posting again here in the community! ? Please allow some time for the gurus/members to check on your concern and get back with more information. Hi @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Leonard Mallare-Oracle, any thoughts on this one? To everyone, feel free to share your…

Hi @Jay Schwausch, At this time, there is no preference yet on setting the Default Replenishment Method in items. We have an existing enhancement requesting for this feature: Enhancement # 239015: Have a preference to set a default Replenishment Method You can vote for the enhancement in the SuiteIdeas page. As for your…

Hi @Biomerics_Admin, You can refer to SuiteAnswers 61670: Impact of Accounting Preference Void Transactions Using Reversing Journals to Inventory-Affecting Transactions for further details. This article shows a list of inventory affecting transactions which can be voided, and Item Receipt/Item Fulfillment are not part of…

Hi @Biomerics_Admin, I got the below details in the Oracle NetSuite Support Community Inbox: Greetings Ivy, Thanks for the prompt response, I don’t see the void button on Inventory Adjustment is that a feature? Or a particular module? I will need to file the enhancement requests for the other ones. Thanks. For future…

Hi @KNason76, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other users, feel free join in the discussion as well. ?

Hi @Biomerics_Admin, For Inventory Adjustments, you can Edit, then click Void. However, there is no option like this for the other transactions that you mentioned. I did find some enhancements requesting for this functionality: Enhancement # 312004: Transactions > Allow users to void or reverse an item fulfillment or item…

Hi @kaj710, I have checked on your concern and noted that the ability to limit the quantity to be built on a WO Completion based on the quantity committed to the WO or the quantity in a WO Issue is not yet available in the standard NetSuite UI. I came across an enhancement request related to your requirement: Enhancement #…

Glad to know that the issue is now resolved on your end, Colleen! Thank you for updating this thread as well! ?