Invoicing database design

I am redesigning an existing database and need to put some invoicing
capabilities in it need to carry forward some payments an credits to the next
invoice. the existing database was a simple one table database to store info
for the amount of credit cards that we need to reimburse our customers. Now
we are setting up the invoice for gas purchased less credit cards to be
reimbursed. Not always equal need to carry credit to next invoice. I have
made a form to add credit to next invoice but seems to be alot of manual work
and could run into problems if the the credit doesn't get entered

Thanks for your help
.

Relevant Pages

  • Re: Pipex billing error - solved?
    ... If they had been upfront about the billing error for February to start with I wouldn't have had a problem with the higher April invoice. ... I am in disagreement with you regarding the charge for April. ... The 1st being a Sunday and the 4th the date the payment was taken. ... I offered to pay the debt off on my credit card immediately. ...
    (uk.telecom.broadband)
  • Re: how can I change all currency fields from positive to negative
    ... How about setting up the TransactionType field as a Number field, ... for Invoice; ... -1 for Credit Memo ... > Invoice or Credit Memo. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Invoicing database design
    ... and complexities. ... payment from that customer, or other items affecting ... invoice each become a record, or whether the whole invoice becomes a ... for the amount of credit cards that we need to reimburse our customers. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Invoicing database design
    ... Now a customer wants to subtract the amount of credit card reimbursement ... show invoice amt and credit cards owed. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Query
    ... product that shows the sum of all invoice amounts for a selected month ... and the sum of all Credit amounts for that selected month and the net ... Sum query for Invoices and append for all products (selected by ...
    (microsoft.public.access.forms)