Microsoft Dynamics AX (Archived)

Inventory Costing

(0) Share

Report

Posted on by Community Member

we have implemented weighted average by date on stock but system is keeping values for zero stock items.

ALmost for all items system is keeping some value when stock level is zero.

I have only one receipt, unable to understand why system is taking different cost for issue transactions.

3884.Capture1.JPG

Physical date	Financial date	Reference	Receipt/Issue	Quantity	Cost amount	Per Unit
15/10/2012	15/10/2012	Transfer	Purchased	70.00	315.00	0.22
15/10/2012	15/10/2012	Weighted average inventory closing	Sold	-140.00	-630.00	0.22
15/10/2012	15/10/2012	Weighted average inventory closing	Purchased	140.00	630.00	0.22
14/11/2012	14/11/2012	Weighted average inventory closing	Sold	-148.00	-2,655.00	0.06
14/11/2012	14/11/2012	Weighted average inventory closing	Purchased	148.00	2,655.00	0.06
20/12/2012	20/02/2013	Production line	Sold	-8.00	-143.51	0.06
13/04/2014	13/04/2014	Transaction	Sold	-62.00	-1,112.23	0.06

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Naveed Nawaz,

Have you run an inventory close/recalculation for those items?

This should clean the remaining cost amounts.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

Recalculation/ closing process runs each month but these transactions remain same.

Many items are behaving same. on test environment i changed the valuation method from WA by date to WA then system removes the difference (For few items).

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Naveed,

If the WA method removes the difference then also the WA-date method should remove it, it might just require more time. Do you only have a handful of items that are affected or are almost all of the items affected? If you only have a handful, try posting an inventory counting Journal with a quantity of 0 to see if this removes the variance quickly. Would be great if you could test in a demo environment and keep us updated.

Thanks,

Ludwig

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

Like (0)

Report

Hi,

Is that is only a subset of the transactions for the item? How did you decide which transactions to use?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

For few items this workaround works,rest are same.We upgraded AX 2009 to 2012 and after that on R3. there few transaction which lye in between upgradation. might be this is the reason. i am still working on it. Hopefully will get something on ti.

Fingers crossed

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

Like (0)

Report

You could get this problem if you are looking at the transactions incorrectly. Is this a full list of transactions for the item? I'm thinking it is not, because the first transaction is a transfer and the item must have been transferred from somewhere.

Was this reply helpful? Yes No