Hello,
My question is:
In my client we make inventory closing but we have some problems with physical value and financial value.
Inventory Model is weighted avarage
Ax Version 2012 R3
Inventory model: Include physical transactions is selected.
In my client the puchase invoices come months after packing slips. So we include physical inventory on inventory model.
Lets make an example in a simple scenario.
There is only one purchase and one sales for an item. in a month. The purchase invoice is not received. So only physical value is posted for the purchase transaction.
When we make closing, system makes settlements for the sales transaction, according to the physical value on inventory transaction form. And settle the sales transaction. The closed date is filled, value open field change in to value No.
So far the inventory is closed for this month.
On the following month, the purchase invoice is received and posted to ledger with different amount than the physical value posted last month.
Then we close the following month.
In this scenario system do not make any adjustment to the sales. The sales will remain the cost amount of the physical value. But the cost amount posted (the financial value) is different than the physical value.
Does anybody face such scenario, do you have any suggestion to me?
Best Regards
