I want to create a database to track my sales and accounts recievables. 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...
I want to create product table. I have many products with many colors. For example:
Product COLOR
Hat Blue
Hat Pink
Hat Red
Shirt Blue
Shirt Red
Shirt Pink
Pants Black
Pants Red
1) How should I create...
I want to create a product table. I have many products with different colors. For example I have Product X with Red, Blue, and Green colors. I can also have Product Y in Red, Blue, and Green Colors. But I can not have more than one Product X in blue color. How should I create my table?
What...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.