I have a question, we have this customer that we upgraded him from a legacy text base system to SBO. Now in the old system they had a funcionality to calculate finance charges and to post does finance charges to the customer A/R.
In SBO this functionality is not present (only the dunning wizard funcionality and it's only applicable 10 times). Well the thing is that we have embark on creating a small addon that will calculate the finance charges for customer (BP) that has overdue balances base on the remaining balances of each overdue invoice, the way I forsaw doing this was by "reading" the records from the A/R balances for the corresponding BP.
After researching I realize that when I select to display an A/R aging for a BP this is actually calculated on the fly and there no table or object that can give you this information directly. We long ago got a store procedure from SAP that will create an aging but this was to overcome the problems in 2005A SP01, but we have seen that his has fail.
Do you know of a routine, store procedure or process that could get me back the BP pending invoices with due date and remaining balances? Is there a table or set of table that can give me that information?
Regards,
WB