Hi All,
I'm trying to get original PO number and date on the chkprint.rpt (based on if the Ref PO is entered when the invoice is put in A/P). So I created a duplicate data definition and added table APINVHED where I can get REFPONUM. I made a relationship between APTRAN/APINVHED and field relationship on INVOICENUM which I had hoped would only pull the one record that I need but instead it gets all the records from APINVHED and actually gets the one I want twice. Seems anything I do else (criteria, key, etc) gets rid of all APINVHED records alltogether. Guess I haven't figured out the logic here somewhere. Also after solving this, I want to link APINVHED to POHEADER (via REFPONUM/PONUM) so I can get ORDERDATE from there.
Thanks in advance,
-Ramsey
I'm trying to get original PO number and date on the chkprint.rpt (based on if the Ref PO is entered when the invoice is put in A/P). So I created a duplicate data definition and added table APINVHED where I can get REFPONUM. I made a relationship between APTRAN/APINVHED and field relationship on INVOICENUM which I had hoped would only pull the one record that I need but instead it gets all the records from APINVHED and actually gets the one I want twice. Seems anything I do else (criteria, key, etc) gets rid of all APINVHED records alltogether. Guess I haven't figured out the logic here somewhere. Also after solving this, I want to link APINVHED to POHEADER (via REFPONUM/PONUM) so I can get ORDERDATE from there.
Thanks in advance,
-Ramsey