Inventory/WIP Reconciliation Report - Recreated RDD or BAQ

Epicor ERP 10
1

Hi All,

I need to get the same data that is presented on the Inventory / WIP Reconciliation report but with the part class for the transaction. Looking at the RDD, Epicor has hidden all the good stuff and there is no way to tell what tables they are pushing the data to the SSRS with.

Before we take a stab at recreating this, does anyone have a BAQ or a recreated RDD for this report they would be willing to share? Or at least some idea on the table structure to save some time on this?

Thanks,
Mike

2

If you have access to EpicWeb site
You could look for Answerbook 6135MPS

  • these WIP report notes for older versions
  • but I think most of it will still apply in E10
3

Add the Part Table to the RDD and then use the Lookup PartClass to get your info.

The “Trick” to adding the part table is to join on Recon.Company-Part.Company, and Recon.TmpPartNum - Part.PartNum

image
image.png777×470 10.2 KB

3 Likes