Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Why does 'Post Vendor Bill Variance' not update Item average cost?
Hello Gurus!
The post vendor bill variance doesn't seem to be considered during the item cost calucation. Therefore, netsuite incorrect average costs for bookings on sales item fulfillments.
Here is an example with big differences to demonstrate the issue. Inventoy costing preference is set to run after every transaction:
Item A - on hand inventory: 0 pcs
Then we have the following transactions:
1) Purchase Order : Item A - 100 pcs @ 1€ = 100€ total
2) Item receipt: Item A - 100 pcs @ 1€ = 100€ total
3) Bill: Item A - 100 pcs @ 888€ =88,800€
4) Bill Variance Journal: 88,700€
After the inventory cost calculation, the item still only has 1€ average cost. As you see the cost account status is complete.