Is there any report to show cost price for the item in the particular date??
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
Is it a Standard Costed Item or an Actual Costed item?
The item is set as moving average cost.
I would like to see the cost for each item in the inventory on particular day.
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).