>Who has a good idea about how to set up tables and
>procedures to facilitate creating monthly statements,
>based on charges and payments, that will age balances,
>30, 60 90, 120 days?
In the customer record, have fields for currentdue, days30, days60, days90, and days120. The user should choose an option to age receivables or do it with the month-end close routine.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer