Introduction: INVOICE BILLING AND INVENTORY CONTROL SYSTEM
With this instructables, I will give you a idea to create a Invoice and Inventory control system.using MS access.
It is very easy and no need more computer or programming knowledge.
If you have basic knowledge of Ms Access, Tables. forms and reports this will be very easy for you.
herewith give you a link of my already created database for your review. it is very user friendly invoicing system I'm given it to the world totally free.
if you interest, can download it from my website here
Step 1: Create Main Tables and Forms
Create Main Tables and forms
1. create following tables:
with same format
Step 2: Print Invoice
To print the invoice need to create two report according to the photo
first create the sub report for invoice data drag form invoice table ...
2nd final invoice..
After create both forms invoice will appear like this...
Step 3: Final Invoice
according to this way you can add some table to get the stock details and purchases also.
I have already created a full Invoice and inventory control system to give to world free.....
Anyone can Request it form my Website my site ..