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

AR Transaction status in OTBI

Accepted answer
51
Views
1
Comments
edited Jan 5, 2023 9:13AM in Reporting and Analytics for ERP 1 comment

I am creating a (crude) AR Aging report for a specific transaction type in OTBI, to include in in a dashboard. All columns I need are included in the subject area "Receivables - Transactions Real Time".

The only column I could not find / get data for is the Paid Status of the transaction. I've found the columns "Transaction Status", but for some reason there's 6 of them and they all seem to be null for the transactions I'm looking at.

"- General Information"."JE_RA_CUSTOMER_TRX_TRANSACTIONSTATUS_v"
"- General Information"."JE_RA_CUSTOMER_TRX_TRANSACTIONSTATUS2_v"
"- General Information"."JE_RA_CUSTOMER_TRX_TRANSACTIONSTATUS3_v"
"- General Information"."JE_RA_CUSTOMER_TRX_TRANSACTIONSTATUS4_v"
"- General Information"."JE_RA_CUSTOMER_TRX_TRANSACTIONSTATUS5_v"
"- General Information"."JE_RA_CUSTOMER_TRX_TRANSACTIONSTATUS6_v"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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