I have an existing Access database which requires a little modification. The existing database has many different functions including, purchase orders, delivery notes, product & price maintenance, project management.
I need to add invoice functionality to the existing database.
The invoice information will be taken from the existing table data when creating a delivery note or quotation (both tables and queries exist), I need the report to provide an autonumber unique ref for the invoice number, Company address details, delivery address details and needs to include standard invoice fields like VAT reg number and due date etc. I am prepared to format the report myself once the fields have been output via the query so I don't reqire any detailed reprt formatting.
Once the invoice is recorded in its table I require another table to monitor due dates for all invoices raised and a form to input paid invoice information so that it can be removed from debtors. From the invoice table I also need to produce a debtors report detailing all invoices over due on 30, 60, 90 and over 90 days, again I will do the detailed report formatting here.
The mechanics of the tables, queries and forms are the main requirement here, I can do the formatting and minor tweaking once the above is done for me.