Ivy Lopez-Oracle NSC Guru

Hi @User_B1J9S, Thanks for creating another thread in our community! Regarding the concern, allow us to check on how we can help you with it. I am coordinating this with our gurus who have expertise on this matter and we will get back to you with our findings. Other members who have an idea, feel free to comment on this…

Hi @paula.courtemanche, Hope you're doing good today! Thanks for posting your concern here in the community! I'm tagging our guru who has expertise on this topic, @Shamaine Chan-Oracle. Any ideas on this one, Shamie? To our other members who faced the same scenario before, we invite you to share your solutions or…

Hi @BWM- Shem, Thanks for sharing a screenshot of the Purchase Order. I further checked on this, and was able to reproduce the greyed Close button when the PO was associated with an Inbound Shipment. When I tried to mark the item line as closed, I received a message: "Purchase order line cannot be closed when there are…

Thanks Mich! Hi Lily, There is an existing enhancement request for this functionality: Enhancement # 235637: Transactions > Purchases/Vendors > Enter Vendor Return Authorization - Inventory Returned Not Credited between Item Fulfillment and Vendor Credit - be able to clear this account just like Vendor Bill Variance…

You're welcome, Asher! ?

Hi Asher, In the Criteria tab, you can use the Inventory Location field to specify the location: While in the Results tab, you can use the field Location On Hand for the quantity on hand of the items: Hope this helps! ? -Ivy ====================================== If you find this reply to your question as helpful, others…

Thanks Emi! Hi Earmie (@BWM- Shem), I checked this one on my standard test account and noted that there was a Closed button in Purchase Orders with Partially Received status. After further checking my resources, I noted some reasons on why the Closed button might not show on the Purchase Order: There is a workflow (or…

Hi @sarahm_43874, Glad to have you back in the community and thank you for posting your concern here! Allow me to tag my colleague @Shamaine Chan-Oracle who has expertise on this topic. Any ideas on this Shamie? ? In the meantime, please check if there are custom scripts or workflows deployed that may be affecting this.…

Hi @CDuf, After extensively testing this on my account, I noted that getting the required information using only 1 saved search might not be possible at this time. This is because using the Customer: Items Purchased as a criteria will pull all customers who purchased that item even once in the past. I also checked and…

Hi Hayley, If you are unable to find the item with the internal ID in your item list, maybe it is inactive or might have been deleted. As for the lot numbers, you can also try to use the steps provided in SuiteAnswers 66956 to look for it. If there are no results on the search, then the lot number might have been deleted…

Hi @rburns515, Glad to have you back with us today and thank you for posting your concern here in the community! I have already coordinated your concern to our gurus who specialize on this topic. They will be checking this and will reply to this thread for any updates or should they require additional information. To our…

Hi @paula.courtemanche, Thank you for posting your concern here in the community! I have consulted this one with my colleagues in the SuiteCloud team, and they suggest that you reach out to the bundle owner since we don't support Celigo Connector and this is a third party bundle. We appreciate your understanding on this.…

Hi Hayley, The reference key is likely referring to the internal ID of the item record that is causing the error message. I would suggest creating a saved search to look for this item record. Here is how to do this: 1. Go to Lists > Search > Saved Searches > New 2. Click on the Item link 3. In the Criteria tab, use the…

Hi @CDuf, Please check if the items on the 2nd and 3rd customer on your screenshot are Kit/Package items which contain any of the items you set on the Customer (Main Line): Items Purchased criteria. Based on my testing, if the item is included in the criteria, the saved search will pull up the orders which include…

Hi @nag_m, Glad to have you back with us today and thank you for posting your concern here in the community. I'm tagging our gurus, @Micah Timbol-Oracle and @Camille Cagalingan-Oracle who have the expertise on your concern as they will further check this and update you on this thread. Anyone else who have any idea or…

Hi Asher, Based on my testing on this, I noted that whenever backordered items are received in the system, they are automatically committed to the orders. I tried to test for a saved search that will show the item line level changes, but it seems that this is not yet possible in the system and is logged in the following…

Hi @farrago, When you go to the Vendor record > Financial tab > Items subtab > Import Price Lists... button, a new window will appear: On the screenshot that you sent, it seems that the CSV file you are using has header rows. Please try to create a CSV file with no header rows and contain the values for the following…

You're welcome, Harika! Glad I was able to help! Have a great day! ?

Hi @sarahm_43874, Per checking, there is no standard report that shows this information. However, you can try to do a transaction saved search for Work Orders. Here is a sample search I tested, which shows the average run rate per unit of an item, based on the actual production start and end dates: Criteria tab: Results…

Hi Kyle, If we have the same criteria, then maybe you can try this: (SUM(ABS(CASE WHEN ({memo} LIKE '%Customs and Duty-LC%') THEN {amount} else 0 END+CASE WHEN ({memo} LIKE '%Freight-LC%') THEN {amount} else 0 END+CASE WHEN ({memo} LIKE '%Agent Fee-LC%') THEN {amount} else 0 END)))/MAX(NULLIF({quantity},0)) You mentioned…

Hi Harika @@User_YHY5Q, Based on my tests, the standard behavior of the system is that the Location in the Item Fulfillment and Item Receipt will automatically populate based on the Location set on the Sales Order and Purchase Order. For example, if there is no location set on the item line level of the Sales Order, then…

You're welcome, Asher! I'm glad that it is now working! Have a great day! ?

Which of those items is the regular inventory item? Is it the LADDER DISPLAY UNIT? Can you go to the item record and check if the Use Bins checkbox is marked for the regular inventory item?

Hi Kyle, Glad we're on the right track! ? Please make sure that the criteria on the saved search has the following (as documented in SuiteAnswers 49978): Type | is Item Receipt Account Type | is Other Current Asset Item : Track Landed Cost | is True There might be some transaction lines which are zeroing out the results.…

Hi Asher, If you have the feature Advanced Bin/Numbered Inventory Management enabled on your account, make sure that the Inventory Detail field is checked on your custom form. If the above mentioned feature is disabled, then just make sure that the Bin Numbers field is shown on the custom form. If this still does not allow…

Hi @Kyle_Lautzenhiser-Oracle, I found SuiteAnswers 49978 which has the steps to create a saved search for item receipts with landed costs. I followed the steps documented in the above, and just modified the formula a bit to get the Total Landed Cost per Unit. Here's the formula you can use: (SUM(CASE WHEN ({memo} LIKE…

Hi @sarahm_43874, Glad to have you with us today and thank you for posting your concern here in the community! Can you please clarify what you mean by "Run Rates"? Are you referring to the Run Rates related to Manufacturing?

You're welcome, @dle_35705! ? I'll be marking my previous answer the correct one for this thread so that others who might have similar concern will find the solution much easier. Should you have concerns or need assistance with the saved search you are creating, feel free to create a new thread! Hope you have a great day!…

Hi Asher, Glad to have you with us today and thank you for posting your concern here in the community! Users should be able to enter the bin in Inventory Adjustments, even for non-serialized items. Are you using a custom Inventory Adjustment form?

Hi @BWM- Shem, It is possible to use bar codes in NetSuite. You may refer to the following SuiteAnswers articles for more information: 28085 - Bar Codes and Item Labels 28126 - Scanning Bar Codes 9060 - Processing Orders Using Bar Codes Additionally, there is NetSuite WMS which is composed of 2 bundles (SCM Mobile and…