Share
Report
1Overview:
Here is the item model setup:
During a test,
Purchase Order
| S/N | Trans Type | Received goods (Physical) | Invoice goods (Financial) | Cost | Physical Total | Financial Total |
| 1a | PO41 | 10 | 10 | 100 | ||
| 1b | PO41 | 10 | 10 | 100 | ||
| 2a | PO42 | 10 | 20 | 200 |
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.
All responses (
Answers (
