Dear all,
I am using AX 2012 R3 Cumulative Update 12.
I create Purchase Order with 1 item, Quantity = 10, unit price = 10000.
I add charge with value 1000.
After Post Purchase Invoice, I click Invoice > Lines > Inventory > Lot Transactions > Inventory > Transactions in Financial Voucher, why there is amount in adjustment with value -1000?
In other database, I try the same scenario and no adjustment value?
Why there is adjustment when I use charge in Purchase Order in my database?
Why there is no adjustment when I use charge in Purchase Order in my other database?
Please help. Thank you.
Best regards,
Johanna
*This post is locked for comments
Dear Zain,
I have found that when my Item does not have Avail Physical, there is adjustment in financial transaction.
Thank you for your thought.
Best regards,
Johanna
Dear Ludwig,
Thank you for your reply.
The posting type is price difference for moving average.
Best regards,
Johanna
Hi Johanna,
This is what i thought, the inventory adjustment is due the item model group Moving average. You would have had issued some quantity of the item you are financially updating/invoicing through purchase order. When there's a difference between the cost of the inventory issued & the final cost of the inventory, system will post an inventory adjustment at the time of financial posting.
For more information about Moving average, please download this white paper www.microsoft.com/.../details.aspx
Thanks & Regards,
Zain Mehmood
Hi Johanna,
The -1000 adjustment amount... what posting type does it have attached?
I assume that this is related to your moving average price and that the -1000 amount captures the difference between your previous moving average price and the $11000 that you entered.
Would be great if you could double check that and possibly share a screenprint of the voucher with the posting types.
Many thanks and best regards,
Ludwig
Hi Zain,
Thank you for your response.
I am using MOV Item model group (Moving Average).
PO status is open order.
Thanks,
Johanna
Hi Johanna,
Can you tell me which item model group you are using in the item attached to the PO?
What is the PO status in which you are adding the charges?
Regards,
Zain Mehmood
Dear Ludwig,
Thank you for your response.
I add charge from Purchase Order Lines > Financials > Maintain Charges.
Charge Code is fixed category with Debit is Item and Credit is Ledger Account.
Hello Johanna,
Can you share details how you added the charge of 1000 and how the charge code that was used for adding the charge is setup?
Many thanks and best regards,
Ludwig
Dear Mahmoud Hakim,
Thank you for your response.
I do not run inventory recalculation.
Have you run inventory recalculation?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156