none
How to Print Sales Invoice

    Question

  • Visual Studio 2012, MySQL, MySQL-COnnector

    Table : Registration, r_sales, r_sales1, tbl_settings

    • Registration : Shop Name, Address, Contact, Email, DL_No.,CST
    • r_sales : Bill_No, Bill_Date, Cus_Name, Cus_Address, Modee_pay, Tot_Amt, Tot_Dis,Payable_Amt
    • r_sales1 : Bill_no, Name, Pack, Batch_No, Mfg, Exp, Qty, MRP, Amt
    • tbl_settings : Server, Database, User, Password

    How to print in Invoice format ?

    Shop NAME 
    Address                                                                                                            Contact : Contact                                 DL_No                                                                                                              CST : CST

    ----------------------------------------------------------------------------------------------------------------------------

    Name : Cus_Name                                    Pay_ Mode                                       Bill No. : Bill_No                                   Address : Cus_Address                                                                                     Bill Date : Bill_Date
    ---------------------------------------------------------------------------------------------------------------------------
            Description   |    Pack    |   Batch No.   |  Mfg. Dt.  |   Exp Dt. |   Qty   |    Rate     |      Amount   
    ---------------------------------------------------------------------------------------------------------------------------
        Name                     Pack        Batch No.         Mfg.            Exp        Qty        Rate            Amount





    ----------------------------------------------------------------------------------------------------------------------------
                                                                                                                    Total Amount :            0.00
                                                                                                                    Discount :                   0.00
                                                                                                             Net Payable Amt :              0.00

                                                                                                                                               Signature



    Tuesday, May 02, 2017 10:24 AM

Answers