25
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?
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
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?
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?
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (