JE Batch name from Invoice/Transaction Number
Summary:
"Receivables - Transactions Real Time" doesn't seem to contain a Batch Name for which the invoice transaction was batched into in the GL.
So I've tried to supplement it with a data model that returns it so which tables contain it and how do I join to A/R tables like RA_CUSTOMER_TRX_ALL
Content (please ensure you mask any confidential information):
The code I came up with doesn't seem to contain the batch name I can clear see from the UI. Am I using the wrong tables/fields in my where? i.e. batch_ID in AR is different from batch_ID in GL modules?