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…

Hi @CDuf, Please try adding the field Customer (Main Line) : Purchase Dates on the saved search. Based on my testing, this field refers to the date on the Items Purchased tab. For example, if you set the date on the Customer (Main Line) : Purchase Dates AND the Transaction Date to January 1, 2019, then the saved search…

Hi @dle_35705, Per checking, it is not yet possible to display the location as a separate column in reports. I found an enhancement related to this: Enhancement # 94651 : Inventory Valuation Reports - ability to display value by location in columns for the selected date The documented alternate solution is as follows:…

Hi Zeeshan, Have you also set up the Bar Code Scanning for NetSuite WMS? You can refer to the following SuiteAnswers which discuss this: 91417 - Bar Code Setup for NetSuite WMS 91419 - Setting Up Custom Application Identifiers for GS1 Bar Code Scanning 90093 - NetSuite WMS: Inbound Shipment Receiving and GS1 Bar Code For…

Hi @Martha Hakes, Glad to have you with us today and thank you for posting your concern here in our community! I'll be tagging our expert on this topic, @Shamaine Chan-Oracle. Any ideas on this, Shamie? ? In the meantime, you can refer to the following SuiteAnswers articles: 9182 - Creating Terms of Payment 9206 - Using…

Hi @Meherin, The Account number is a required field when adding a new UPS account to NetSuite, so it is best to contact UPS for this concern. You can refer to SuiteAnswers 9300 for more information about this. Anywan, I'm glad that you have resolved your concern! ?

Hi @User_U78W1, Glad to have you back with us today and thank you for creating another thread in the community! ? Allow me to coordinate this with our guru who specializes in this topic. @Michelle Jabanes-Oracle, any ideas on this? To the community, feel free to comment your insights about this concern.

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

Can you please send a screenshot of the CSV file you are trying to import? Just 1 or 2 lines/rows will do. Or if possible, attach a sample CSV file (with 1 or 2 lines) that you are trying to import, and I will also try it on my test account.

Hi @farrago, I just want to confirm if the import you are doing is under the Vendor record > Financial tab > Items subtab > Import Price Lists... button? Can you also send a screenshot of the CSV file you are trying to import?

You're welcome, Eunice! ?

Hi @Eunice_C, I have consulted this with our expert in scripting, and confirmed that it is possible to exclude the script for a specific customer. However, this involves editing the script itself, so we suggest that you reach out to your account manager or the team who implemented the script and discuss this requirement…

Hi @kastnerd, Upon investigation, it seems that the standard Inventory Turnover Report in NetSuite does not consider assembly builds or issuance of components on the computation of turnover rate. This is a current limitation and logged under: Enhancement # 179381: Reports > Inventory/Items > Inventory Turnover > Please add…

Hi @farrago, I have tested this on my account and I found that the import succeeds if the 1st column on the CSV file (Item Name) is in this format: 123XYZ : 123RED This is also what is being returned as the Name of Matrix Subitems on saved searches. If the name on the CSV file is just 123RED, the import of the line fails…

Hi @CDuf, I'm currently testing this in my account and I wanted to ask you for some screenshots of the Results tab of the saved search, so I can try reproducing the saved search you are using and check if what you need can be accomplished in a single saved search. Also, can you confirm the following: What is the item type…

Thanks Micah! Hi @dle_35705, Per checking, when Advanced Bin/Numbered Inventory Management is turned off, Item Receipts from created Standalone or Linked Customer Return Authorizations do not reflect the Restock as a checkbox for Kit Items. This is logged as an enhancement request under Enhancement 143922. You can vote for…

Hi @kastnerd, Glad to have you back with us today and thank you for creating another thread in our community! ? Kindly allow me to check first on this one, and I'll update you of my findings. To our other members, feel free to share in this thread if you have any ideas or suggestions about this!

Hi @User_ACVDL, I tested this on my test account and I had the same behavior you reported. I agree with @John Griffin's answer that you would need to replace all the BOMs on the items to be able to update the Master Default. You may refer to SuiteAnswers 49959 (Replacing the Bill of Materials Sublist with the CSV File) for…

Hi C! Are you using the Demand Planning feature? If you are, then there is a standard page called the Gross Requirements Inquiry page which provides an overview of the progressive supply and demand cycle, listing quantities required and supplied on each transaction date listed. This includes sales orders, transfer orders,…

Hi @dle_35705, Glad to have you back with us today and thank you for creating another thread here in our community! ? Allow me to tag our experts on this topic, @Camille Cagalingan-Oracle and @Micah Timbol-Oracle, who will be assisting you further with this. Other members of the community may also comment any ideas or…

Hi @aisaadaniya, Glad to have you with us today and thank you for posting your concern here in the community! ? I have already coordinated your concern to our gurus who will check on this first, and let you know about their findings, or if additional information is needed. Other community members, feel free to share your…

Hi @ruckus, It might be related to this accounting preference: You can refer to SuiteAnswers 9627 (Customer Credit Limits and Holds) for more information about other preferences or fields which may be affecting the customer credit warnings/alerts. Hope this helps! ? ====================================== If you find this…

Hi Paul, The main difference between AIM and Demand Planning is the Replenishment Method set on the Item Record. Items using AIM has the Replenishment Method set to Reorder Point while items which will use Demand Planning is set to Time Phased. On the item record, when the Replenishment Method is set to Time Phased, orders…

Glad this worked for you, @Tybrneryan! I marked my previous comment as correct so that our community members will find it easily should they have the same concern. Hope you have a great day! ?

Hi @User_0O8RF, Per checking, the ability to only enable stock count or inventory count in only some locations is not yet available in NetSuite. To request for this enhancement, you can create a Support Case or submit a new idea on the SuiteIdeas page.

Hi Paul, You are correct that when the AIM runs again, system will automatically recalculate the Reorder Point and Preferred Stock Level since as long as the Auto-Calculate box is checked on the item record. You can refer to the Field Help of the Auto-Calculate fields to see how it is computed, and how the other fields…