Data not in XML file (Data Definition problem)


(Mark Rowley) #1

Epicor version 9.05.701

In Data Definition, i made a duplicate of the “APPaymentEdit” file.
I’ve kept the report Type as “Base definition”.
I added field “LegalNumber” (APTRAN.LEGALNUMBER) from the excluded fields lists. I haven’t added any new tables.

When i run the report the data doesn’t appear in the xml file…any thoughts?


(John Dack) #2

Hi,

Is the Legal Number populated in the APTran table it’s empty for me? And as far as I’m aware ours is a standard setup.

Regards,

John


(Mark Rowley) #3

your right the column “legalnumber” in table aptran seems inconsistent…the invoice i’m testing shows a blank.

I guess i’ll need a new table to populate the legal number.


(Mark Rowley) #4

Thanks for your help.
I brought in APINVHED to the data definition and joined it to APTRAN.
APINVHED had the legal number i needed.