Question Status

Suggested Answer
dsin asked a question on 8 Feb 2015 10:56 PM

Is there any report to show cost price for the item in the particular date??

Reply
Suggested Answer
Amir Nazim responded on 9 Feb 2015 3:19 AM

you mean item's on hand cost at given date ?  there is no out of box report in my knowledge you can build one. you can get help from below thread

community.dynamics.com/.../54780.aspx

Reply
Guy Terry responded on 9 Feb 2015 3:22 AM

Hi dsin,

Is it a Standard Costed Item or an Actual Costed item?

Reply
dsin responded on 9 Feb 2015 6:34 AM

The item is set as moving average cost.

I would like to see the cost for each item in the inventory on particular day.

Reply
Guy Terry responded on 9 Feb 2015 7:37 AM

Hi dsin,

I've always thought this would be hard enough to be impossible to do with an actual costed item, but with Moving average you know that only the price of the physical receipt is used, so you may have a fighting chance using inspiration from Amir's example.

Don't forget that every issue (of an item that has the Moving average inventory model) is stamped with the 'current' moving average price at the time the issue was posted. Looking at the 'issue' inventory transactions on a particular date should give you what you want (although obviously there would be no data available for days where there were no issues, and the cost price can change on a single day).

Reply
Suggested Answer
Amir Nazim responded on 9 Feb 2015 3:19 AM

you mean item's on hand cost at given date ?  there is no out of box report in my knowledge you can build one. you can get help from below thread

community.dynamics.com/.../54780.aspx

Reply