How to Show Running Balance in Invoice for the Individual Currency Balance Events (Doc ID 2825084.1)

Last updated on DECEMBER 01, 2021

Applies to:

Goal

One user captures the running balance per EVENT set in Accounts Receivable (AR), OTHER, SUB ITEMS coming from make_invoice opcode. In the legacy system, the running balance is shown in invoice; however, the user migrated from legacy to Billing and Revenue Management (BRM) and is expecting the same running balance at per event level so that they can show the same in BRM invoices as well.

The running balance is needed in the invoice BLOB only which allows the user to utilize and retrieve the same amount values in custom logic codes for further display part per event/items. The user is not using Business Intelligence Publisher (BIP) for invoice Portable Document Format (PDF), the invoice BLOB information is shared through notification framework and Advanced Queue (AQ) payload will be consumed by consumer service.

For an invoice with "n" events, how to show running balance from event 1 till n with amounts displayed in calculated addition considering the needed AR items as well in sorted order?
How to scope the running balance in invoice BLOB?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.