Microsoft Dynamics AX (Archived)

Inventory Cost

(0) Share

Report

Posted on by Danish Ali

884

Hi All

I have the following scenario for the item.

- Opening balance for the item WFWD26877 was entered incorrectly for store R0121 (@Cost= 219,181.60)

- I posted the adjustment for this item through movement journal (@Cost= -219,181.60) but system is picking 144.35 cost after I post the movement journal.

Attached is the screen shot.

Now my concern is

- My Inventory value report is showing 218,181.60 value for this item. How I can adjust this item to get correct WAV of 144.35.

Moreover I also tried to adjust this item but system is showing the cost amount 144.35 after I posted the movement journal.

Your advise please.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Ali,

On the Storage Dimension Group for Item WFWD26877, which dimensions are ticked for 'Financial inventory'?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,924 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ali,

In addition: Which inventory costing model are you using?

When you post a inventory deduction using an inventory journal, the cost on the line is ignored. It is only used when you post an increase. At a deduction AX will use it's own costing model logic.

Depending on the costing model, you can "mark" transactions (link two inventory transactions) and run a closing or recalculation job to assign to correct cost.

Was this reply helpful? Yes No
Danish Ali 884 on at

Like (0)

Report

Hi

I attached the storage dimension group.

Regards

Ali

Was this reply helpful? Yes No
Danish Ali 884 on at

Like (0)

Report

Hi

I am using Weighted average method for costing.

I am first entering the item @Cost= -219,181.60 (now I can't mark this transaction against the old one as inventory is closed for previous periods.

After that I am entering the actual cost of item which is 144. But in inventory value report system is still showing me 219,181.

Regards

Ali

Was this reply helpful? Yes No
André Arnaud de Cal... 300,924 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ali,

can you explain why you can't mark? If the transaction was not closed before, it is still open for the inventory valuation even if the receipt was in a previous period. If it is closed, which is not visible for me on these forms, it would be possible to revert the closing processes. Note that this could have financial impact on already reported periods. So please first try out some things in a copy of your environment.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report
Hi Ali,

I'm still trying to work out exactly why AX has done what it has done. And then I'll think about if we can undo it.

Was quantity -1 the opening balance for that Item in Warehouse R0121?

If so:

What have you configured to allow negative stock? Is it the 'Physical negative inventory' tick box on the Item model group? Or something else - maybe the Retail tick box on the Warehouse setup?

Where did AX get 144.35 from? Is that set on the Item ('Manage costs' fast tab)?

Looking at the dates - this all happened in May. And you've run inventory close since then. How many of that item are in that Warehouse today?

Was this reply helpful? Yes No