Dynamics Community Forum Thread Details

Remaining Cost Value on Cost Entry with No Quantity

Overview:

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.

Quick Links