Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
We have currently a problem with weighted average adjustment in our books. We use inventory management in AX and ou valuation method is weighted average.
In 2013 (last fiscal year), we purchased some goods that were recorded in the inventory table with settings : unit price = meter. purchased quantity = 200 meter and price per unit 1.01.
The goods were used in a project and at this time the consumption cost was ok. (200X1.01)
This year this goods were puchased again, but the settings in inventory table were changed to unit price = package, purchased quantity = 2 packages ,
price per package : 116 euros.
The goods were used on the same project (but not totally : only one package)
During the inventory close, Ax generated a weighted average adjustement on the 2013 transaction ( but booked it on the current fiscal year) of (200) X (116-1.01). This weighted adjustment created an unwanted additionnal expense on the project, and now the financial value of the inventory is negative.
My question is : what is the way to correct both weighted average adjustment and financial value for these items ?
Thank you for your replies (and sorry for my bad english, i am french)
For a French person your English is extremely good ;)
Can you indicate if the goods from 2013 were invoiced by the vendor in 2013 or 2014?
Also I would like to know if the consumption of the first purchase was done in 2013 or 2014.
What was the result of the inventory adjustment//close at the end of the previous fiscal year?
Did you change the purchase unit on the item or also the inventory unit? When did this happen? Before or after the consumption of the 2013 stock?
So in fact I try to understand if a change was allowed at a certain moment. Please update, then I can try to guide you.
Thank you for your quick reply.
For the first purchase, the goods have been receipted in october 2013, but have not been invoiced yet (!?. I need to check it out with the accountancy department because it's strange)
The first consumption was done in 2013 (totally). So there was no adjustment in the fiscal year 2013.
The change was made on both unit price and inventory unit, and it was made after the first consumption : when the second purchase was made in 2014. this second purchase has been invoiced by the vendor.
I hope these explanations will help
Thanks in advance
When the goods from 2013 are not invoiced, AX cannot finalize the correct cost price. So this could be the cause of your issue. In this case it was not a correct moment to change the inentory unit. When the 2013 goods will be invoiced, it probably will be possible to correct the issue, but it will require undo of the inventory closing/recalculation where the consumption was adjusted. Also to ensure the correct cost price the Marking funcitonality should be used.
You can download the cost management whitepaper to fully understand the closing and use of Marking.
Thank you very much for your answer. I'm transferring this to the PO/Inv manager and to the accountant for action.
Business Applications communities