As per the Help, there is an order of priority for transactions entered in a day. Here's the relevant section:
Note: Inventory transactions with the same date are calculated in a particular order to find the On Hand quantity of an item. This means that an inventory worksheet transaction posts at the start of the transaction date, and any additional inventory transactions on that date affect its figures.
The order transactions are used to calculate this quantity is:
1. Adjust Inventory Worksheet, Distributions
2. Adjust Inventory transaction
3. Receive Purchase Order
4. Bill Payment
5. Bill Credit
6. Item Fulfillment
7. Invoice, Cash Sale
8. Credit Memo, Return Authorization Item Receipts
Thinking about this, and based on live experience by my customers, wouldn't it make more sense if the Inventory Worksheet was in fact the LAST thing to affect inventory?In particular, a common scenario is a period end - say on 12/31 you take physical inventory. You need to enter it as of 12/31, but of course you'll have transactions on that day. So then the stated logical "workaround" would be to post it 1/1. But there's a HUGE difference accounting-wise between posting it 1/1 (an open, new period) and 12/31 (a closed, other period).Netsuite usually does things for a reason - what's the logic behind having the Worksheet post as the first transaction? Does anyone else think this is a problem? Should there be an Enhancement Request to change this (well, maybe there already is, I didn't check)?