how to csv import an inventory worksheet with bins...
# ask-stanley-ai
a
how to csv import an inventory worksheet with bins?
c
AI generated answer (using internal Slack threads):
Based on the conversations, it appears that you cannot directly import an inventory worksheet with bins using a CSV file. However, you can use an Inventory Adjustment transaction to set inventory details, including bins. Here are the steps: 1. Zero out your inventory: This can be done by creating an Inventory Adjustment transaction where you set all quantities to zero. This step is necessary to ensure that the subsequent import accurately reflects your physical count. 2. Import your counts: After zeroing out your inventory, you can import your counts using another Inventory Adjustment transaction. This transaction should reflect the quantities and bins from your physical count. Remember, when creating your CSV file for the Inventory Adjustment import, you need to include the necessary fields such as item, location, bin number, and quantity. Also, if you have transactions happening on the day you're making these adjustments, you need to take that into account to avoid ending up with negative inventory. For future reference, you might want to look into NetSuite's Inventory Count process. This process might be more straightforward if you're dealing with bins. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.876556814
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.872209311
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.850340366
Please provide your feedback on this answer.