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

Topic		Replies	Views
Report Data Definition Add New Columns to Report Kinetic ERP report-builder , rdd	16	3275	June 2, 2022
Add a field to SSRS RDL report dataset Epicor ERP 10	12	10281	January 24, 2023
InvcHeadShip table does not show Exclusion options in Report Data Definition Kinetic ERP	1	503	July 28, 2022
Tracking Number in InvcHead/Dtl Table Epicor ERP 10 e10	15	2011	November 23, 2019
Report Data Definition Kinetic ERP epicor , customization , ssrs , reports	17	3321	July 13, 2023

Custom Reports

Related topics