Due to extreme currency fluctuations we have decided to keep a reference to the USD cost of our imported products in NetSuite and update the product cost regularly so that we do not loose money when selling imported items. We can achieve this using the Adjust Inventory Worksheet, but we would like to automate this process. Our NetSuite provider has not so far been able to help us with this.
We could of course download a CSV file, make the required adjustments, and then upload the CSV File again, but I cannot see why we shouldn’t be able to automate this process seeing that It is entirely based on information inside the NetSuite data base.
My first step in attempting to automate this was to accurately establish all the database actions that the Adjust Inventory Worksheet accomplishes. With a reasonable amount of investigation, I have been able to establish that the Adjust Inventory Worksheet performs the three following actions;
1) Directly alters the average product cost (when using the average cost costing method) [Item Table]
2) Creates a transaction that alters the value of the stock and the gain on stock holding revenue account. (Transaction Table)
3) Creates an entry that reflects the transaction above in the primary accounting book. (TransactionAccountingLine Table)
I would like to be sure that there are no other actions that the worksheet performs. in similar situations in other systems, I have traced all table changes in a specific time range to identify all data base actions performed. I haven’t been able to find this functionality available yet with NetSuite.
I would be glad of any suggestions that could help here.