Which means the inventory value here is 20 @ $300 and the running average is 15.
Sale Order
S/N
Trans Type
Shipped goods (Physical)
Invoice goods (Financial)
Avg Cost
Physical Total
Financial Total
3a
SO41
20
15
300
3b
SO21
20
15
300
Then I invoiced the PO with an increased cost
Purchase Order
S/N
Trans Type
Received goods (Physical)
Invoice goods (Financial)
Cost
Physical Total
Financial Total
2b
PO42
10
22
220
When I checked the cost entry on the item I have a value of $20 on it and not unit?
Note: the client doesn't want to use inventory closing or recalculation because they always want to include physical value on their weighted average cost.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.