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.

 

[Kiwiman]

Howzit

You can have another field in the invoices table called DOCTYPE. Use this field to determine if it is an Invoice (e.g. SINV - Sales Return)or a Return (e.g. SCRN - Sales Credit Return)

 

[neileg]

You can also record the values as negative numbers so that when you need to report you can take a simple sum of the values.

 

[Simon_MT]

Using both these answers you could create a table with "I" or "SINV" for Invoice and "C" or "SCRN" for a Credit Note. Add a field called Value: Invoice = 1 Credit = -1 and multiply the Invoice amounts with this value. You do have to be careful with interfacing into some accounting systems as they only handle positive numbers so if you do use negative numbers you may need to use abs(Value) to interface the values.

Simon