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 Aging Report

Received Response
edited Feb 18, 2019 6:20AM in Reporting and Analytics for ERP 6 comments


AR Aging Report


Hi all,

I am doing a AR Aging Report using OTBI.

For example: AR aging report has following columns: Customer Name, Transaction Date, Transaction Number, Remaining Amount Due, 0-30 Days, 31-60 Days, >60 Days.

How can I sum up the "Remaining Amount Due" if Current_Date - Transaction Date <= 30 and put it under "0-30 Days" column? It prompts up an error for this. Please kindly advice. Many thanks.

CASE WHEN current_date - "Payment Schedules Details"."Transaction Date"  < 30 THEN sum("Payment Schedules"."Accounted Amount Due Remaining") ELSE 0 END

Howdy, Stranger!

Log In

To view full details, sign in.


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