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

Drill down query for GL->XLA->AR(Receipt Category)

edited Mar 11, 2025 10:37PM in Reporting and Analytics for ERP 2 comments

Drill down query for GL->XLA->AR(Receipt Category).

I have a custom report where I have to pick the details from GL_JE_Lines tables, and RA_CUSTOMER_TRX_ALL, AR_CASH_RECEIPTS_ALL.

Please let me know the joinings for these tables.

The majot columns are :

Transaction number,

Accounted_DR,

Accounted_CR,

Source,

Category,

GL_Date,

Account segments(Segment1 to segment8 ).

Please let me know how do I proceed for this report.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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