I am working on a database that will contain an accounts recevable
section. I know what I want to do, but just keep drawing a blank when
it comes to doing it.
Here are the Feilds I'm working with
* ClientID - The Key that relates thoughout the whole db
* PrevBal - balance remaining after the 10th of the previous month
* PaymentsMade - Paments made between the 1st and the 29th of
previous month
* BalCarried - balance left after payments
* InterestFee - 1.5% added to BalCarried if Bal Carried is over 30
days
* AdditionalServices - New Fee's for current billing
* CurrentBalDue - BalCarried + Interest Fee + AdditionalServices
Invoices are made the last day of each month, and mailed on the 1st.
CurrentBalDue needs to be added to PrevBal on the first of each month.
Payments between dates need to be calculated to find BalCarried. If
BalCarried is over 30 days then interest needs to be applied.
Once that's done the AdditionalServices need to be totaled and added to
the calculation. Leaving CurrentBalDue.
Any ideas, hints, tips, help??
This is driving me nuts.
Marina