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.
The actual average cost should be 888€, since we went from 0pcs inventory to 100pcs that cost 888€ each, once the variances were booked.
5) Sales Order: Item A - 50 pcs @ 10€ = 500€ total
The profit estimation uses the incorrect average cost of 1€.
(SO: 50pcs x10€) - (Avg. Cost: 50 pcs x 1€
In this case, the gross profit wouldn't be 450€ but negative 43900€.
6) Item Fulfillment: Item A - 50€
Item Fulfillment books only 50€ into COGS account.
The new completed inventory cost caluclation with 50 items left remains on 1€.
If this is a limitation, I would very much appreciate any feedback on workarounds other than touching every item receipt to update the cost.
I'm hoping I'm missing a setting to consider variances as part of the average cost.
Many thanks!
Chris