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