Invoicing Tables

[mulu]

Hi there

I would like a quite bit of advice on creating tables for producing invoices. I currently have the following tables from which the invoice will be generated:

tblClients - holds basic client contact info ect
tblApplications - holds info for each application which is process for each client (clients are charged for each application we process for them)

tblInvoice - holds the InvoiceNo (AutoNum), the AppId (the primary key from the

tblApplications), the invoiceDate, VAT (percent field for 14% VAT), and then lastly the AmountDue - which will just be a total that the user inputs for each invoice

What is the best way to pull the required info for the invoice? Should I create a query which pulls all the info from the three tables together?
Thank you

 

[spoole]

Yes query will do it, but a couple of things to think about first.

How are you going to determine which invoices to print (have they already been paid in either part of full or are they even due yet)

When printing the invoice you will need to print at least 2 copies, one for the client and one for you as a paper invoice to be filed in the finance department.

Check with your finance department for other info that may be needed to printed on the invoice such as terms and conditions and registered office address's etc.

And finally if this is your only way of tracking and sending invoices you will need to retain the data in this DB for a minimum (if financial data) of 7 years depending on which country you are in.

As you can see there are many considerations when printing invoices, make sure you get it right or you might find yourself in deep water