Dear all,
i,m doing a Invoice project in vb 6.0 and i,v no idea about it , can anyone tell me the solution
how to start the project
i created few forms like supplier,custom er,product, and i created the add,update,dele te, for the all forms , but i need to complete the sales invoice,purchas e order,and Reports of 1.sales,2.purch ase,3.Total to all and particular customer (or)supplier(or ) itemno
these are some table i made
1.Supplier - supid int, primarykey ,supname varchar(20),pho ne int
2.Customer-cusid int primarykey , cusname varchar(20),pho ne int
2.Product - itemno int primarykey,desc rption varchar(20),sup id int,Rate float,qty int
3.Pinvoice - invoiceno int primarykey,date datetime,supid int,supname varchar(20)
5.sinvoice - invoiceno int,date datetime,cusid int,cusname varchar(20)
and they like the result should be like this
sales invoice(The purchase invoice also similer the same instead of custmer we make supplier)
''''''''''''''' ''''''''''''''' ''
invoice no (textbox) date(textbox)
cusid(combobox)- here all the id to come which we cusname-(textbox)
given in the customer table and when we give the id the cuname will come
automatically in a textbox
cusname
(in datagrid) --------------------------------------------------------------------------------------------------------------
itemno description qty price gross(qty*price for each itemno)
-------------------------------------------------------------------------------------------------------------
Total (Textbox sum(gross))
so this is invoice both the sales and purchase
can anyone tell me how to do this and how to create report , and this is deadline project which i already spent some days
plzzzzzzzzzzzzz zzzzzzzzzzzzzzz zzzzzzzzzzzzzz guide me to do this project
i,m doing a Invoice project in vb 6.0 and i,v no idea about it , can anyone tell me the solution
how to start the project
i created few forms like supplier,custom er,product, and i created the add,update,dele te, for the all forms , but i need to complete the sales invoice,purchas e order,and Reports of 1.sales,2.purch ase,3.Total to all and particular customer (or)supplier(or ) itemno
these are some table i made
1.Supplier - supid int, primarykey ,supname varchar(20),pho ne int
2.Customer-cusid int primarykey , cusname varchar(20),pho ne int
2.Product - itemno int primarykey,desc rption varchar(20),sup id int,Rate float,qty int
3.Pinvoice - invoiceno int primarykey,date datetime,supid int,supname varchar(20)
5.sinvoice - invoiceno int,date datetime,cusid int,cusname varchar(20)
and they like the result should be like this
sales invoice(The purchase invoice also similer the same instead of custmer we make supplier)
''''''''''''''' ''''''''''''''' ''
invoice no (textbox) date(textbox)
cusid(combobox)- here all the id to come which we cusname-(textbox)
given in the customer table and when we give the id the cuname will come
automatically in a textbox
cusname
(in datagrid) --------------------------------------------------------------------------------------------------------------
itemno description qty price gross(qty*price for each itemno)
-------------------------------------------------------------------------------------------------------------
Total (Textbox sum(gross))
so this is invoice both the sales and purchase
can anyone tell me how to do this and how to create report , and this is deadline project which i already spent some days
plzzzzzzzzzzzzz zzzzzzzzzzzzzzz zzzzzzzzzzzzzz guide me to do this project
Comment