Just wanted to chime in and confirm that @jkane is correct here. I have added OrderNum to my customized invoice… so I’ll add some screen shots below.
As John stated, there is no need to duplicate that Report Data Definition as standard (out-of-the-box) RDD already includes InvcDtl.OrderNum. However, if you already duplicated the RDD and are using a custom one, that’s fine too. It shouldn’t hurt anything… BUT… One thing to make sure you do (IF you created a custom RDD) is to make sure you select/reference the new RDD in Report Style.
Below is a snip… This is the Report Style Maintenance of ARForm…
I had created a custom style called “NFM Invoice” and I am referencing a custom RDD called “ARInvoice_NFM” (circled in red).
I’ve never looked at the Kinetic versions of these screens either (Report style & RDD), so I had to fumble through them to get screen captures, hahaha. I guess I’ll need to get used to them sooner or later!
@Creese, like John mentioned… if you get errors, please post the details and we can help track down any issues.
Hello, thank you for this explanation. I am using the out of the box RDD but I did make a copy of the Standard SSRS so I can edit it. Originally I used T1.OrderNum but later found out it was T2.OrderNum
However that still gives an error and the monitor says unexpected error.
I see that you are doing this in Pilot. Have you uploaded the report to the Pilot environment? By default, Epicor does not load all of the reports in the Pilot environment. I always had to import them to test in Pilot.
So I selected New for RDD. There is a drop down for Duplicate. Though it is grayed out. How do I make a copy of the ARInvoices without manually adding each box?
Neat, Report duped.
So with the ARInvoice duplicate. go to Detail and InvcHead and uncheck the two boxes Exclude Column and Exclude Label for OrderNum.