JE Batch name from Invoice/Transaction Number — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

JE Batch name from Invoice/Transaction Number

edited Jun 25, 2025 2:39PM in Receivables & Collections 1 comment

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!