Show field transfer reference in A/R Invoice screen
We want to see when an invoice has been paid in the A/R invoice screen. So when you search for the invoicenumber in the A/R Invoice screen it has to show the transfer reference information (table ORCT - TrsfrRef) and the date (table ORCT - TrsfrDate).
For that we are creating two UDF (e.g. Transfer Info and Tranfer Date).
Does someone know what query we will need to 'copy' the transfer reference information (with a formatted search linked to the query) into the UDF.
So when you search for the invoice number in the A/R Invoice screen the query has to find the fransfer reference information and date of that particular invoice.
Our customers always pay there invoices full (so not in terms).
Thanks in advance!