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 in OTBI the receivable balance for any transaction on any date

edited Oct 31, 2024 5:39PM in Receivables & Collections 3 comments

Hi all

I created a report that shows the balance of receivables for each transaction using Subject Area "Receivables - Transactions Real Time". It shows the current balance.

But I would like to show it for any day set in the report parameter. My idea is to subtract from the current balance all payments with a payment posting date after the report date.

I found the payments in "Receivables - Receipts Details Real Time" but I don't have a link to a specific transaction. the column named "Reference Transaction Number" is empty.

Is there any other link to "Transaction number" ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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