Skip to Content
0
Former Member
Mar 27, 2009 at 03:06 AM

SQL query for QPLD replicating how SBO computes the aging in AGE10001

46 Views

Good Day Mentors,

In relation to the question I had [here|Using UDT columns in Standard PLD;, the only option left would be for me to try and replicate the "Customer Receivables Aging" (AGE10001)report via SQL query to be outputted in QPLD so that I would be able to include the UDT(s)/UDF(s) that the AddOns are using into the report. Customer Receivables Aging is found in

Financial->Financial Reports->Accounting->Aging->Customer Receivables Aging.

I am specifically having trouble as to how to compute the amount per date range.

How much is in 1-30, 31-60,61-90 days and so on. The system version of the report uses System Variables to output the values to standard PLD (AGE10001).

I was tracing how SBO computes these values, but I was not able to find how SBO does it manually. I was tracing the computation via the transactions/values I see in "Customer Receivables Aging" vs "Sales Analysis Report by Customer(Detailed). I also took into account the "Interest on Arrears%" (OCRD.IntrstRate) found in BP Master Data on Payment Terms Tab.

Am I missing something?

Thanks,

Sean