You’re offline. This is a read only version of the page.
450
Hi
I need help understanding how the costing in our AX works. I know the costing in our company was set up as a weighted average by location? In theory I understand what is happening..but when I look at the results, I get confused.
Look at the attached. The costing for this unit should be approx. 0.23 cents. There is a weighted average calculation showing this as well. Why does it have two line items for weighted average? Sold and Purchase? What does this mean. Is this the balance at Dec 15 of 53 units /$12.39 or is this an adjustment of 53 units/$12.39?
Then further on there are sales at 0.23 cents cost per item. This is good. But then at one point the cost of the sales increases to $12.10. How does this happen? I don't understand. What caused this to happen?
Thanks
Joe
*This post is locked for comments
I will look at the closing and adjustment form to see if I find anything, But there is a lot of detail there.
What is the price on the Manage costs fast tab of the Released product?
Was your inventory quantity in the system low prior to the counting adjustment?
You mentioned that you control at 'location level' - does location mean warehouse?
Was the production order ended or just RAF at the time you ran inventory close?
Hi,
Here some hints:
Open the closing and adjustment form and select the adjustment report
Select a ine where you can see an adjustment. In my case I take the one with the 200 USD value
Open the settlement form and find the line with the 200 USD adjustment
Select the transacton button .
Now you can see the transactions that have been matched. In my case a PO and a SO.
As the invoice of the PO was posted subsequently with a different price, the respective SO amount was adjusted by the difference.
This is the way how you can trace the adjustments made.
As you can see from the screenprints, it takes a while to find out what caused the adjustments.
Irrespective of that, I would recommend that you test this for some transactions in your system.
Best regards,
Ludwig
Good Morning,
Can you open the settlement report from the closing and adjustment form in inventory and share that report?
Many thanks,
Ludwig
Hi
Yes I have but it still does not give me an explanation as to where my costs are coming from.
Hello Joe,
Have you checked the whitepaper that Andre mentioned above?
Please go through this document first because there are literally hundred of possibilities what might cause such a change.
The database log won't help here to understand this but the whitepaper and the MS docs sites.
Many thanks,
Ludwig
I have a screenshot of the database log.
You can see the cost changes from 40.43 to 191.90. Can someone show me where I can see in the system that it changes...but more importantly why does it change? What happened that caused this to change?
Thanks
Joe
Hi,
Just check inventory management - periodic - closing & adjustment, select the adjustment made and then select details-adjustment report.
You can also check the settlements made and the voucher created from there.
Best regards,
Ludwig
Hi Joe,
The inventory closing form is a periodic option in the inventory management module. It is explained in the whitepaper which was shared in my previous post (contains a link to the document).
Thanks. I am able to look at the cost explorer. Very useful. I understand. There seems to have been a count..an adjustment of 100 items but at 12.10 an item? How does this happen? The cost should be 0.23 cents per item. How did the adjustment happen at 12.10? I can't seem to get this. This adjustment at $12.10 is causing the problem.
You also mention the inventory closing form? Where do I get this? Not sure where in AX I can run this?
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (