access 2003 invoice

[eyalco]

I have an invoice database where customer pays for a service and receives invoices. How do I create a return invoice (sorry if I miss name it right) - where cus pays for the whole year, receives an invoice for the whole amount but business agreement ceases to exist, so funds are needed to be returned.
My question is : How do I do it? do I need another table or it is entered in the invoice table?
Hope I explained well whet I need - if not, sorry in advance.
Thanks.

[mshmyob]

Not knowing anything about your design or the companies procedures you could try either of the follwoing:

By the way I assume you mean you want to issue a credit.

1. No design changes - Just override the price for the service or product to a negative amount - Negative amounts would indicate a credit.

2. Slight design change - Add a new field to the Invoice table indicating CREDT - YES/NO

cheers,

I have an invoice database where customer pays for a service and receives invoices. How do I create a return invoice (sorry if I miss name it right) - where cus pays for the whole year, receives an invoice for the whole amount but business agreement ceases to exist, so funds are needed to be returned.
My question is : How do I do it? do I need another table or it is entered in the invoice table?
Hope I explained well whet I need - if not, sorry in advance.
Thanks.

[eyalco]

Thanks, you've been very helpful.