How to Calculate the outstanding balance based on the parameter for receivables invoice in OTBI
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):