I am in the process of migrating to 10.2.200.24 and I am having difficulty with the AR Invoice SSRS base report. I need the Saels Order number to print on the invoice. When I look at the RDD, it seems to be included, however when I look at the ARForm RDL file in report builder, the field does not exist. Am I missing something? Using the base RDD and a copy of the base SSRS report style.
RDD shows OrderNum is included (see below).
Is it included in your query phrase on the SSRS report?
If you look at a BAQ of that table, you will see that InvcHead.OrderNum can often be “0”. You may want to check InvcDtl.OrderNum instead.
Sales Order Number is on the InvDtl table.
Vinay Kamboj
The RDL file does not automatically include everything from RDD list. You have to go back and add it in. You can also click on “Sync Dataset” to have Epicor update the RDL. I would strongly caution against using that function though.
You can add the field in the RDL by going to dataset properties and adding the field there
Then add it to the list of shown fields
Paul -
Thanks for the detailed instructions. Worked like a charm.
Michael
