Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!

Best regards,

Tim

replied

Try this query:

SELECT T0.TrsfrDate
 FROM ORCT T0  INNER JOIN RCT2 T1 ON T0.DocEntry = T1.DocNum
 Where T1.DocEntry = $[OINV.DocEntry]

and select the option Refresh Reguralry

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question