Accounts Payable Table?

[janlosangeles]

I want to create a database to track my sales.
When I create an invoice, some customers pay me at the time of sale. In this case I mark my invoice as paid.
Other customers buy from me and pay me at later time. How do I create my database to track accounts recievables? What other tables and relationships do I need in addition to my Customer, Product, Invoice(sales), tables?

Thank you

Jan

 

[BoxHead]

Jan,

If you're relatively new to databases and/or Access, I'd strongly recommend that you create a new database using the built in template for Order Entry.

It has the tables and forms set up for entering parts, customers, orders, payments, invoices, etc. You can include your logo and track your accounts.

After a week or two of using it you'll have ways you'll want to modify it and improve it for your own business and most of those questions can be answered here in pretty short order. When you're ready to actually start from scratch on creating a new database, you'll have all of your information in the tables, you'll know precisely what you want from the database, and you'll know how to accomplish a lot of the things you need to accomplish.

Just one opinion.





John

Use what you have,
Learn what you can,
Create what you need.