I have a report that I need to add shipping and invoice numbers into. Where do I add shiphead and invhead? In a new or modified data definition? Thank you in advance!

If it is a BAQ Report, you need to edit the BAQ that report uses. If it is a built-in report, or most likely uses an RDD (Report Data Definition). An RDD creates the dataset for the report (like a BAQ) but you don’t have access to the internal workings. You can add tables to an RDD, and then upda…

I was already on 1/2 way there! Do you know where the tracking number is? or what it is called.

[image] sweeti61: Do you know where the tracking number is? Looks like a case for [image] [ Download ] Epicor 10.2 & Kinetic .CHM Schema ERP 10 download We…

Wow Thanks… ok I have duplicated and added the shiphead table. Updated the Data definition. Opened my report, however I am not seeing the shphead table? What am I missing?

You need to add the fields to the report and the Reports Data Query. Also make sure the Report style is now using the new RDD you created (unless you just updated and already existing custom one)

I think have to create a relationship? Set it up so far as InvcHead parent, ShipHead child. anything else? company to company relationship

You need to make relationships between the added tables and ones that were already in the RDD. What report are you trying to update

Trying to add the tracking number to the invoice?

You shouldn’t need to add the InvcHead table as that’s already in the RDD. Just add the ShipHead, and make a relationship between the ShipHead.PackNum and the InvcDtl,PackNum.

[image] [image] (make sure PackNum and Company are NOT excluded)

Custom Reports

Epicor ERP 10

hkeric.wci (Haso Keric) April 15, 2019, 7:43pm 4

Looks like a case for