Add MtlUnitCost to Stock Status Report?

Epicor ERP 10
1

I’m trying to add StdMaterialCost to the Stock Status Report and I’m massively confused. It seems the base StockStatus report references the subreport ‘StockStatus_Activity’. In this subreport there is a dataset called StkActivity which doesn’t seem to grab data from the stkstatus report data definition, but instead queries a stkactivity report table:

="SELECT T1.Company,T1.ExtCost,T1.LegalNumber,T1.MtlBurUnitCost,T1.Multiplier,T1.PartNum,T1.LotNum,T1.TranDate,T1.TranQty,T1.TranType,T1.UnitCost,T1.WarehouseCode
 FROM StkActivity_" + Parameters!TableGuid.Value + " T1"

What I think I want to do is to somehow add the StdMaterialCost to this temp table, but I can’ figure out how this temp table is even generated and or managed. The StkStatus RDD mentions the table, but no fields are listed.

I’m so confused… and I miss Crystal.

2

Actually, I need “Mtl Unit Cost” and “Bur Unit Cost” displayed on this report.

3

Any thoughts anyone?

4

The SSR is a bastard of a report. It works by back calculating the QOH for the date entered, by taking the current QOH, and subtracting out all the part trans since then.

BUT…

It does not back calc the unit cost for the date entered.

If you never need to run it for date prior to today’s, make a BAQ report of QOH from PartBin and the cost from PartCost