We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
84
Views
6
Comments
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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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