Hello Everyone,
We have an unusual situation on our hand and it is related to Standard cost.
To give you some background,
Company is using standard cost, the Inventory GL $ value has not match the inventory on Hand (tried all Inventory related reports in AX) at the end of every month. Posting Profiles have been verified
|
The way Standard Cost should work is
New item A: $10 - There should be no GL or Inventory $ value as we do not have QTY.
Movement Journal adds QTY 2 = $10 (STC) x 2 (QTY)= $20 - GL$: 20 & Inventory$: 20
PO adds QTY 8: $10 (STC) x 8 (QTY)= $80 - GL$: 100 & Inventory$: 100
STC Increases to $11: System creates a transaction for $10 - GL$: 110 & Inventory$: 110
Posting Type - Inventory, inventory receipt : 500120 - Product Cost = $ -10
Posting Type - Inventory Cost revaluation : 160100 - Inventory= $10
STC Decrease to $9: System creates a transaction for $-20 - GL$: 90 & Inventory$: 90
Posting Type - Inventory, inventory receipt : 500120 - Product Cost = $ 20
Posting Type - Inventory Cost revaluation : 160100 - Inventory= $ -20
|
|
Issue: AX is taking PO QTY and Movement QTY as two different. AX should not create a Rounding Variance transaction.
New item A: $10 - There should be no GL or Inventory $ value as we do not have QTY.
Movement Journal adds QTY 2 = $10 (STC) x 2 (QTY)= $20 - GL$: 20 & Inventory$: 20
PO adds QTY 8: $10 (STC) x 8 (QTY)= $80 - GL$: 100 & Inventory$: 100
STC Increases to $11: System creates a transaction for $10 - GL$: 102 & Inventory$: 110
Posting Type - Inventory, inventory receipt : 500120 - Product Cost = $ -10
Posting Type - Rounding Variance : 500120 - Product Cost = $ 8 (PO QTY 8 * $1)
Posting Type - Inventory Cost revaluation : 160100 - Inventory= $ 2 (MV QTY 2 * $1)
STC Decrease to $9: System creates a transaction for $-20 - GL$: 112 & Inventory$: 90
Posting Type - Inventory, inventory receipt : 500120 - Product Cost = $ 20
Posting Type - Rounding Variance : 500120 - Product Cost = $ -16 (PO QTY 8 * $-2)
Posting Type - Inventory Cost revaluation : 160100 - Inventory= $ -4 (MV QTY 2 * $-2)
|
|
I'd really appreciate all feedback and help. If you require any further information please let me know.
Thanks,
Mohsin Kamal
