Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Summary

AR Aging Report

Content

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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