Invoice applications and 'credit notes'

[Isis]

I wonder if anyone can help me here. I have built an invoicing application
- has Invoice and Item Tables (Item Table holds the individual Items on the
related Invoice Record) - What happens if someone buys something say before
Christmas and brings it back after Christmas and I have already accounted
for Purchase Tax in the meantime. I have depleted my stock of that item by
1 when the item has sold and now I have it back again - also I paid Tax and
I should now reclaim that - I am presuming that 'Credit Notes' have
something to do with this problem but do not know how they work. Do I need
more Tables ?

Any help appreciated.

Thanks

 

[Guest]

this is not intrinsic to Access itself......and would be dependent on how
your specific application was designed....

 

[Baz]

I wonder if anyone can help me here. I have built an invoicing application
- has Invoice and Item Tables (Item Table holds the individual Items on the
related Invoice Record) - What happens if someone buys something say before
Christmas and brings it back after Christmas and I have already accounted
for Purchase Tax in the meantime. I have depleted my stock of that item by
1 when the item has sold and now I have it back again - also I paid Tax and
I should now reclaim that - I am presuming that 'Credit Notes' have
something to do with this problem but do not know how they work. Do I need
more Tables ?

Any help appreciated.

Thanks

A credit note is simply an invoice with a negative value. Put them in your
invoices table.