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
Trying to understand what happens to cost under a weighted average date model that includes physical if an item is adjusted out prior to the inventory being financially received as well as where the dollar amounts are pulled from. Detail on the issue:
We use microsoft dynamics AX 2009. We are weighted average date and include physical. We had an issue arise when inventory close calculations inflated the cost of a sku. As seen below in the item detail box the the 2 skus in question were physically rec on 12/14. A journal was done on 12/22 to remove the inventory before the PO was financially received which occurred the next day on 12/23. When I looked at the settlement detail it shows that for sku1 -8905.27 was adjusted (systemically) from the inventory close and -11,377.79 for sku2 for a total of -20,283.06 but I don't understand where those amounts came from? For C106413 (sku1) PO cost is 147.75 and Base cost is at 205.67. I tried to trace the cost back as well and it didn't get me anywhere so I don't know how a max $205 cost can turn into $8,905. Even the 30 that are sitting in ordered status shown on the item detail wouldn't add up to the 8.9K. I'm assuming that because the inventory was removed before the PO was financially received it inflated the cost but I don't get the logic for why that triggered it?
Settlement detail for sku:
Hi Cost accountant pdx,
It is hard to say the reason as we don't know the details of all the inventory transactions for this item in your environment. We don't know if you might have customizations which also could influence the behavior. If you only have these three transactions, then the behavior is unexpected. Some other settings on the inventory dimension groups might also influence the behavior of the cost calculation.
If you had negative physical inventory for this item on a certain moment, it could be one of the reasons for incorrect calculations. I don't have an AX2009 environment anymore to check for some issues I encountered myself in the past.
Have a look at the 'Price amplification' topic discussed here
You are using 'Include physical value', which is a good way to minimise the impact of this problem, but it does not eliminate it (particularly if your PO receipt process uses the Registration step).
To be honest, I never found much mileage in manually trying to calculate how AX arrives at these cost prices in these scenarios. As long as you are posting PO invoices and regularly running Inventory close, an accurate cost price will, eventually, be used.
Business Applications communities