Best way to do a full physical inventory count with a CSV of counts

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The best way to do a full physical inventory count with a CSV of counts in NetSuite, as discussed in the threads, is to use the Inventory Adjustment feature. Here are the steps: 1. Zero out your inventory: This can be done by creating an inventory adjustment and setting the quantity of all items to zero. This is to ensure that your new counts will accurately reflect the physical inventory. 2. Import your counts: After zeroing out your inventory, you can import your counts using another inventory adjustment. This can be done by uploading a CSV file with the new counts. Please note that the CSV file should contain the necessary information such as the item name, bin number (if bins are enabled), and the new quantity. Also, keep in mind that if you have transactions happening on the day of the adjustment, you need to take that into account to avoid ending up with negative inventory. Another method discussed in the threads is to use the Inventory Count feature in NetSuite. This feature allows you to set up items with a next count date and an A, B, C priority. Calculated counts will generate a list of items due to be counted, and manual counts allow you to select individual items to be counted. However, it seems that the Inventory Count feature does not support CSV import natively. You might need to create a custom record and use an event script to create the Inventory count, or use a third-party tool like Celigo data loader. Remember to always refer to the NetSuite Help Center for more detailed instructions and best practices.