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

How to Calculate the outstanding balance based on the parameter for receivables invoice in OTBI

in Receivables & Collections 1 comment

Summary: How to Calculate the outstanding balance based on the parameter for receivables invoice in OTBI


Content (required): For example, if invoice is paid in October month, and I have a report parameter selected for accounting date is 1-09-2023 to 30-09-2023, then "Accounted Amount Due Remaining" should show the invoice amount as outstanding because it is paid after the parameter end date. Can we use any function in OTBI like "CASE WHEN" to achieve this.


Version (include the version you are using, if applicable): 23C


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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