Looking for Help with a Data Def

Epicor ERP 10
,
1

Hello All,

Hope you are all keeping well? - I am looking for some help with adding a Product Total Net weight to an AR Invoice…

The problem is I can’t seem to find it in the Report Data Def so that I can un-exclude it to I can see it in the SSRS Report builder to add it…

Field Name:

ShipDtl.TotalNetWeight

ShipDtl

TotalNetWeight!
Shipment Entry|394x340

AR Invoice Def
AR Invoice Def981×658 28.4 KB

2

You’ll need to

  1. Duplicate the ARForm (ex: ARForm-001)

  2. Add the ShipDtl table to Data Sources.

  3. Add a table relationship between InvcDtl and ShipDtl like:
    image

  4. Create a new Report style by duplicating an existing one.

  5. On the new Report Style, change the Datasource to the one you created in step 1.

  6. Edit the RDL created for the new Report Style. This isn’t as straight forward as you’d think. Lots of other posts on here for how to edit a RDL to add new fields.

1 Like
3

Thank you - This will be work for Monday…

Like to say this site has helped me so much…