Why whenever csv importing an inventory adjustment I get the error "Invalid number (must be positive)" but I can manually create an inventory adjustment with negative number?

AI generated answer (using internal Slack threads):

The error "Invalid number (must be positive)" that you're encountering during CSV import of an inventory adjustment in NetSuite is likely due to the system's validation rules. When importing data, NetSuite checks the data against its validation rules to ensure data integrity. In the case of inventory adjustments, NetSuite typically expects positive numbers for quantities as it's generally used to increase inventory levels. However, when you're manually creating an inventory adjustment, you have the flexibility to enter negative numbers to decrease inventory levels. This discrepancy between manual entry and CSV import could be due to the fact that CSV import is a bulk operation, and NetSuite enforces stricter validation to prevent potential errors that could arise from bulk changes. One workaround suggested in the threads is to create separate transactions for inventory adjustments - one for positive adjustments and another for negative adjustments. After the import, you can then delete the first transaction. However, this method should be used with caution as it can result in negative inventory. Please note that this is based on the information available in the provided threads and the actual cause of the error might be different based on your specific setup and data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******