Announcements
No record found.
Hi,
I'm trying to investigate why "Cost amount " column in the inventory transaction is 0 for a transfer journal transaction. I saw that the cost is the result of the sum of the fields CostAmountPosted and CostAmountAdjustment. In my case CostAmountPosted = 137.13 and CostAmountAdjustment = -137.13 (((137.13) + (-137.13)) = 0).
Where the CostAmountAdjustment value came from on a Transfer Journal?
Hi MartinER,
Can you tell which exact inventory costing mode you are using? What other transactions were created for this item? Can you check if the adjustment came from an inventory closing or recalculation?
Hi André,
Thanks for your quick response.
Can you tell which exact inventory costing mode you are using?
Moving Average
What other transactions were created for this item?
Sales Orders, Purchase Orders, Inventory Adjustment
Can you check if the adjustment came from an inventory closing or recalculation?
That is exactly what I want to identify, from what transaction the adjustment came from. Do you know how?
There are some caveats with the moving average. It is taking the cost amount known at time of the product receipt. If the PO price is zero and the items (or part of them) were consumed before the invoice, you can indeed have this type of transactions. I have not seen this scenario on transfer orders before.
Probably you can check the behavior of moving average using the documentation and see if you can find anything related: docs.microsoft.com/.../about-moving-average
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 510 Most Valuable Professional
André Arnaud de Cal... 302 Super User 2026 Season 2
CU-1234529-002 197
