Hi,
Did someone done such scenario:
Open Receivables is defined as invoiced Sales less any payments. Open receivables
does not trend over time as it is a point in time metric and only exists at the moment
it is calculated. Open receivables should be displayed in 30-brackets depending upon
how old the receivable is. Any receivable less than one day old is considered current
and current is a bucket that must be displayed. The BILL and AMTPAID field
should be used for this metric.
I have a table with billing table and want to calculate open receivables, but didn't understand how I can do this and wich formula I should use
| MEDNO | ACCTNUM | INVOICE | BILL | DATE | AMTPAID |
|---|
| 14627 | AA | 55552 | 165 | 11/6/1996 | 0 |
| 20514 | AA | 56897 | 130 | 1/2/1997 | 0 |
| 29102 | AA | 56970 | 155 | 1/6/1997 | 0 |
| 23955 | AA | 9700500 | 55 | 3/18/1997 | 0 |
Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
