invoice with serial numbers and tax calculations

[Guest]

I need a detailed invoice that would include product, product number and
serial number, as well as tax calculations. Are there any templates like
this? Would it be able to link to a customer database? And then a product
database?

 

[Allen Browne]

The Northwind sample database that installs with Access has the tables and
forms to handle customers, products, orders, and the order details (line
items). Open it, and choose Relationships from the Tools menu to see how
they join up. Then look at the query named Order Details Extended to see how
calculated fields are handled: your tax calculations will be done like that.

 

[Guest]

Thanks, as you can see, I'm new at this. We have a large Appliance business,
but can't seem to find anyone who had a pre-written Point of Sale program
that will help us. So I am trying to design our own. I have limited
database knowledge going back to PFS and Paradox software and SQL software.
I would like to avoid writing code if possible.

??? Can I just copy the entire Northwind sample and rename it to redesign
it? Instead of starting from scratch?

Thanks for any help you can give me.

 

[Allen Browne]

Sure: there's lots in Northwind that would be helpful for you.
You will need to do some modifying though: it doesn't handle the tax side.