Stock Status Report

Epicor ERP 10
, ,
1

Hi - I have a client who has just gone from E9.05 to E10.2.600 and we have found that the Stock Status has changed from displaying the ‘as of date’ historical cost in E9 to actually showing the current cost only in E10. They use the ‘as of date’ cost alongside the stock levels so the new E10 report is missing this key field (Epicor have said this is now standard funtionality :rofl: ).

To allow them to get around the missing historical cost field, I have created a BAQ which looks for an ADJ-CST entry (ref: annual cost reval) and returns the top trannum (<= as of date)… This works fine but they have to export to excel and do lookups which is messy. So I then decided to create a direct to SQL SSRS which does the same as the BAQ (which works fine independently) but when I insert it into the StockStatus as a subreport it doesn’t like it.

Any suggestions for ways to get historical stock status AND cost at the time?

2

check what the error is in the error log. also, ensure the sub report exist in the path.

3

I think this thread pretty much covers it, there are certainly others. Some have copied costs periodically, even daily, and use a BAQ to get the historical values.

Stock Status report shows incorrect cost - ERP 10 - Epicor User Help Forum (epiusers.help)