How to add the following fields (Std Material, Avg Material, Last Material) for all the materials in the BOM Cost report for the specific plant?
The BOM Cost Report is an Epicor built-in report, so you’ll need to do the following:
Make a copy of the base report data definition, “BOMCost,” to which you can add those new fields. Epicor won’t allow you to modify the system data definitions.
In SQL Report Builder, you’ll need to make a copy of the original BOMCost .rdl file and place it, along with any subreports, in your Custom Reports directory. While you technically can make changes to the pre-fab .rdl, it is strongly recommended that you make copies of the original and alter the copies, leaving the original in pristine condition.
Create a new report style for this report, specifying your custom data definition and report file location. Sync Dataset, then you may have to add the fields manually in Report Builder.
Test and tweak as needed.
Hope this helps,