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.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
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
Version: Dynamics Ax 2009 SP1 RU8 5.0.1500.6491
A client of mine has his Ax system for 11 years and comes with the following question/issue:
Throughout the years several products have been retired and the stock level is zero. However when we run the Inventory value report (en-us language: inventory management > Reports > Status > Inventory value > Inventory value report) the INV: Financial amount is not for all the items zero, most have a negative balance.
The Inventory value report is using the following setup:
The inventory model group is setup to use FIFO.
Anyone has experienced this and knows if this is possible to solve?
Side note: There are 90 items like this so I really hope there is a script or function that can help me with
To give additional information about a possible reason the inventory value is off balance could be transactions before a cost price was set like the following (and in this case reversed after the cost price was set):
Are you running the inventory recalculation and closing periodically? During several postings, an average cost price is used for inventory transactions if you use FIFO. The inventory recalculation and closing will calculate the correct cost price for inventory deductions and post adjustments.
You can read more about this in the cost management whitepaper available here: Download Microsoft Dynamics AX 2009 White Paper: Cost Management from Official Microsoft Download Center
Please run an inventory recalculation / close first and then the inventory value report.
Do you still see the negative amounts?
Hi André, Ludwig,
Thank you for your response.
No the inventory closing has never been run.
I just turned it on in the test system and i will see what the result is.
Once the closing is done and i understand the result I will share it here.
Thanks André and Ludwig. This did the trick. I asked why the closing was not done regularly and it turned out that when the application was just introduced the closing was giving strange values. Maybe in the early version of Ax 2009 there were some bugs with the closing(?).
Can this function also be used to revalue items to a new cost price? For example when there is an item that is not being actively sold anymore so you want to deduct the value off the inventory (cost price 0) but want to keep the qty so any 'accidental' sales can still be recorded against the item? Some items were counted with value 0 but now have a value again, i suspect because the cost price on the item was filled with the original value from when the item was actively sold.
There were indeed some bugs in early AX2009 versions but I don't remember details. If you are lucky you can still find them on LCS. Please check it out.
The inventory closing and adjustment form can also be used for adjusting cost prices. Yet, the example that you mentioned is often handled by recording adjustments on special GL accounts only to avoid getting the inventory values and costing messed up. Accountants are usually doing this at the end of the year as part of their year end closing process.
Business Applications communities