Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Account Aging Report - how do I do mathematics?
Message
From
01/10/1999 23:02:36
 
 
To
01/10/1999 14:54:56
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00270271
Message ID:
00271861
Views:
27
>Hi Stephen,
>
>>Don't you have to tie payments against / to an invoice or scheduled payment?
>
>I think I see where Peter is coming from on this issue. I had a similar application at one point with an insurance company. They wanted premiums applied to the earliest due and could have cared less what the payment was ostensibly for.


It can get more complicated than this. In my aging routine, I have to apply payments first to finance charges (in date order), then penalties, then invoice amounts. I read all of the open items into an array and make multiple passes through. I also keep a CLOSED DATE in the item record that shows exactly when it was paid.

Peter Robinson
Peter Robinson ** Rodes Design ** Virginia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform