1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

create 5 new culumn in invoice as well as in sales voucher

Discussion in 'Requests' started by NainaSiraj, Nov 14, 2020.

    
Page 1 of 2
  1. NainaSiraj

    NainaSiraj Member


    good after noon

    kindly help me to create 5 additional column with storage in sales voucher as well as in print out in sale invoice
    thanks
     
    NainaSiraj, Nov 14, 2020
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Search for Garment Invoice THREAD ..........

    modify that as per your use.......... for addl. Col in Display and Print.
     
    Amit Kamdar, Nov 14, 2020
    #2


  3. NainaSiraj

    NainaSiraj Member


    thank for you sir
     
    NainaSiraj, Nov 14, 2020
    #3


  4. NainaSiraj

    NainaSiraj Member


    HI SIR
    SIR I HAVE THIS CODE
    HERE ALL THE COLUMN ADDING IN QUANTITY COLUMN
    BUT I WANT ALL DDITION IN AMOUNT COLUM
    MEANS TO SAT FARE+TAXES+OTHR=IN AMOUNT COLUMN


    PLZZZ SEE AND CORRECT THE FORMOLA PLZZZZZZZZZZZZZ
    [#LINE: EI COLUMNONE]
    OPTION : KC EI COLUMNONE : @@ISSALES

    [!LINE : KC EI COLUMNONE]

    ADD : RIGHT FIELDS : BEFORE : VCH QTYTITLE : KC NO OF PCS, KC MTS, KC NO OF PCS1
    LOCAL : FIELD : KC NO OF PCS : INFO : "NO OF PCS"
    LOCAL : FIELD : KC MTS : INFO : "MTS"

    LOCAL : FIELD : KC NO OF PCS1 : INFO : "NO OF PCS1"

    [#LINE : EI INVINFO]
    OPTION : KC EI INVINFO : @@ISSALES

    [!LINE : KC EI INVINFO]

    ADD : RIGHT FIELDS : AFTER : VCH ACTUALQTY : KC NO OF PCS, KC MTS, KC NO OF PCS1

    [FIELD : KC NO OF PCS]

    USE : NUMBER FIELD
    TYPE : NUMBER : FORCED
    STORAGE : KCNO OF PCS
    SET ALWAYS : YES
    WIDTH : 12
    ALIGN : CENTER


    [FIELD : KC MTS]

    USE : NUMBER FIELD
    TYPE : NUMBER : FORCED
    STORAGE : KCMTS
    SET ALWAYS : YES
    WIDTH : 12
    ALIGN : CENTER



    [FIELD : KC NO OF PCS1]

    USE : NUMBER FIELD
    TYPE : NUMBER : FORCED
    STORAGE : KCNO OF PCS1
    SET ALWAYS : YES
    WIDTH : 12
    ALIGN : CENTER


    [SYSTEM : UDF]

    KC NO OF PCS : NUMBER : 500
    KC MTS : NUMBER : 505
    KC NO OF PCS1 : NUMBER :510


    [#LINE: EXPINV COLUMN1]

    OPTION : KC EXPINV COLUMN1 : @@ISSALES

    [!LINE : KC EXPINV COLUMN1]
    ADD : LEFT FIELDS : AFTER : EXPINV DESCTITLE : KC NO OF PCS, KC MTS, KC NO OF PCS1

    LOCAL : FIELD : KC NO OF PCS : INFO : "Fare"
    LOCAL : FIELD : KC MTS : INFO : "Taxes"

    LOCAL : FIELD : KC NO OF PCS1 : INFO : "Others"

    LOCAL : FIELD : KC NO OF PCS : DELETE: STORAGE
    LOCAL : FIELD : KC MTS : DELETE: STORAGE
    LOCAL : FIELD : KC NO OF PCS1 : DELETE: STORAGE

    LOCAL : FIELD : KC NO OF PCS : TYPE : STRING
    LOCAL : FIELD : KC MTS : TYPE : STRING
    LOCAL : FIELD : KC NO OF PCS1 : TYPE : STRING

    [#LINE: EXPINV INVDETAILS]

    OPTION : KC EXPINV INVDETAILS : @@ISSALES

    [!LINE : KC EXPINV INVDETAILS]

    ADD : LEFT FIELDS : AFTER : EXPINV : KC NO OF PCSPRINT, KC MTSPRINT, KC NO OF PCS1PRINT


    [FIELD : KC NO OF PCSPRINT]

    USE : NUMBER FIELD
    SET AS : $KCNOOFPCS
    SET ALWAYS : YES
    WIDTH : 12
    ALIGN : CENTER


    [FIELD : KC MTSPRINT]

    USE : NUMBER FIELD
    SET AS : $KCMTS
    SET ALWAYS : YES
    WIDTH : 12
    ALIGN : CENTER



    [FIELD : KC NO OF PCS1PRINT]

    USE : NUMBER FIELD
    SET AS : $KCNOOFPCS1
    SET ALWAYS : YES
    WIDTH : 12
    ALIGN : CENTER




    [#FIELD : VCH bILLAMT ]

    OPTION : KC VCH NRMLBILLEDAMT : @@ISSALES

    [!FIELD : KC VCH NRMLBILLEAMT]

    SET BY CONDITION : YES : @@amtCALCULATION
    [#FIELD : VCH RATE]

    OPTION : KC VCH RATE : @@ISSALES

    [!FIELD : KC VCH RATE]

    DELETE : SET BY CONDITION
    [SYSTEM : FORMULA]

    amtCALCULATION : (($$ASQTY:#KCNOOFPCS * $$ASQTY:#KCMTS) + ($$ASQTY:#KCNOOFPCS1 * $$ASQTY)
     
    Last edited: Nov 14, 2020
    NainaSiraj, Nov 14, 2020
    #4


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Just add the Field names ......... #field1 + #field2 + #field3

    replace the above with your field name as per your code.
     
    Amit Kamdar, Nov 14, 2020
    #5


  6. NainaSiraj

    NainaSiraj Member


    sir actually
    i have tried kindly can u guide ma i want to add all value in amount column not in quantity
    ow can i change quantity field to amount field
    please sir
     
    NainaSiraj, Nov 15, 2020
    #6


  7. NainaSiraj

    NainaSiraj Member


    sir kindly help me for formula plzzzzz
     
    NainaSiraj, Nov 15, 2020
    #7


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I have already helped you....guided you.......

    It is upto you now to make some sincere efforts to learn and implement TDL codes. Do not expect ready made solutions. No professor/teacher writes answers for the students. It is for students to learn and answer them.
     
    Amit Kamdar, Nov 15, 2020
    #8


  9. NainaSiraj

    NainaSiraj Member


    sir field
    KC NO OF PCSPRINT + KC MTSPRINT + KC NO OF PCS1PRINT = Amount

    or amount =?????????
    sir now how can i set these fields

    how can i start formula plzzzzzzzzzz
     
    NainaSiraj, Nov 15, 2020
    #9


  10. NainaSiraj

    NainaSiraj Member


    sir still not complete my code kindly plzzzzzzzzzzzz
     
    NainaSiraj, Nov 18, 2020
    #10


  11. NainaSiraj

    NainaSiraj Member


    I HAVE ADD 3 ADITIONAL COLUMN WHEN I ENTER THE VALUE IN THREE COLUMN ITS ADDING TOTAL IN QUANTITY COLUMN BUT I WANT TO ADD TOTAL IN AMOUNT COLUMN PLZZZZ CHECK THE SYSTEM FORMULA
     
    NainaSiraj, Nov 19, 2020
    #11


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    MyTotal : #KCNOOFPCSPRINT + #KCMTSPRINT + #KCNOOFPCS1PRINT
     
    Amit Kamdar, Nov 19, 2020
    #12


  13. NainaSiraj

    NainaSiraj Member


    sorry sir not working
     
    NainaSiraj, Nov 20, 2020
    #13


  14. NainaSiraj

    NainaSiraj Member


    kindly please
     
    NainaSiraj, Nov 20, 2020
    #14


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You have to start learning a little.... and make genuine efforts.... this is a learning site.

    It is obvious you are not making any sincere efforts at all.
     
    Amit Kamdar, Nov 20, 2020
    #15


  16. NainaSiraj

    NainaSiraj Member


    i will try again bcoz sir i am not very well trained my brother started a new business about travel line he need some invoices formate differ then tally default so i have tried and sucess to add column in invoice but about formulas and others i have a weak knowledge,,so kindly do complete my code plzzzz
     
    NainaSiraj, Nov 20, 2020
    #16


  17. NainaSiraj

    NainaSiraj Member


    not getting this formula plzzzzzzz experts kindly help me
     
    NainaSiraj, Nov 29, 2020
    #17


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    amtCALCULATION : #Fld1 + #Fld2 + #Fld3
     
    Amit Kamdar, Nov 29, 2020
    #18


  19. NainaSiraj

    NainaSiraj Member


    AMTCALCULATION : #KC NO OF PCSPRINT+ #KC MTSPRINT+ #KC NO OF PCS1PRINT

    AMIT SIR CAN U CHK THIS
     
    NainaSiraj, Nov 29, 2020
    #19


  20. NainaSiraj

    NainaSiraj Member


    THIS IS NOT WORKING
     
    NainaSiraj, Nov 29, 2020
    #20


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Do not keep the SPACES in the field name.........

    AMTCALCULATION : #KCNOOFPCSPRINT+ #KCMTSPRINT+ #KCNOOFPCS1PRINT
     
    Amit Kamdar, Nov 29, 2020
    #21


  22. NainaSiraj

    NainaSiraj Member


    Sorry Sir Not working


    [#LINE: EI COLUMNONE]
    OPTION : KC EI COLUMNONE : @@ISSALES

    [!LINE : KC EI COLUMNONE]

    ADD : RIGHT FIELDS : BEFORE : VCH QTYTITLE : KC NO OF PCS, KC MTS, KC NO OF PCS1
    LOCAL : FIELD : KC NO OF PCS : INFO : "Fare"
    LOCAL : FIELD : KC MTS : INFO : "Taxes"
    LOCAL : FIELD : KC NO OF PCS1 : INFO : "Others"

    [#LINE : EI INVINFO]
    OPTION : KC EI INVINFO : @@ISSALES

    [!LINE : KC EI INVINFO]

    ADD: RIGHT FIELDS: AFTER : VCH ACTUALQTY : KC NO OF PCS, KC MTS, KC NO OF PCS1
    [FIELD : KC NO OF PCS]

    USE : NUMBER FIELD
    TYPE : NUMBER: FORCED
    STORAGE : KCNO OF PCS
    SET ALWAYS : YES
    WIDTH : 10
    ALIGN : CENTER
    Print Fg :Maroon
    Border:Thin Left right

    [FIELD : KC MTS]

    USE : NUMBER FIELD
    TYPE : NUMBER: FORCED
    STORAGE : KCMTS
    SET ALWAYS : YES
    WIDTH : 10
    ALIGN : CENTER
    Print Fg :Maroon
    Border:Thin Left right





    [FIELD : KC NO OF PCS1]

    USE : NUMBER FIELD
    TYPE : NUMBER: FORCED
    STORAGE : KCNO OF PCS1
    SET ALWAYS : YES
    WIDTH : 10
    Print Fg :Maroon
    ALIGN : CENTER
    Border:Thin Left right




    [SYSTEM : UDF]

    KC NO OF PCS : NUMBER : 500
    KC MTS : NUMBER : 505
    KC NO OF PCS1 : NUMBER :510

    [#LINE: EXPINV COLUMN1]

    OPTION : KC EXPINV COLUMN1 : @@ISSALES

    [!LINE : KC EXPINV COLUMN1]
    ADD : LEFT FIELDS : AFTER : EXPINV DESCTITLE : KC NO OF PCS, KC MTS, KC NO OF PCS1

    LOCAL : FIELD : KC NO OF PCS : INFO : "Fare"
    LOCAL : FIELD : KC MTS : INFO : "Taxes"

    LOCAL : FIELD : KC NO OF PCS1 : INFO : "Others"

    LOCAL : FIELD : KC NO OF PCS : DELETE: STORAGE
    LOCAL : FIELD : KC MTS : DELETE: STORAGE
    LOCAL : FIELD : KC NO OF PCS1 : DELETE: STORAGE


    LOCAL : FIELD : KC NO OF PCS : TYPE : STRING
    LOCAL : FIELD : KC MTS : TYPE : STRING
    LOCAL : FIELD : KC NO OF PCS1 : TYPE : STRING


    [#LINE: EXPINV INVDETAILS]

    OPTION : KC EXPINV INVDETAILS : @@ISSALES

    [!LINE : KC EXPINV INVDETAILS]

    ADD : LEFT FIELDS : AFTER : EXPINV DESC : KC NO OF PCSPRINT, KC MTSPRINT, KC NO OF PCS1PRINT


    [FIELD : KC NO OF PCSPRINT]

    USE : NUMBER FIELD
    SET AS : $KCNOOFPCS
    SET ALWAYS : YES
    WIDTH : 10
    ALIGN : CENTER
    Print Fg :Blue
    Border:Thin Left right

    [FIELD : KC MTSPRINT]

    USE : NUMBER FIELD
    SET AS : $KCMTS
    SET ALWAYS : YES
    WIDTH : 10
    ALIGN : CENTER
    Print Fg :Blue
    Border:Thin Left right



    [FIELD : KC NO OF PCS1PRINT]

    USE : NUMBER FIELD
    SET AS : $KCNOOFPCS1
    SET ALWAYS : YES
    WIDTH : 10
    ALIGN : CENTER
    Print Fg :Blue
    Border:Thin Left right




    [#FIELD : VCH BilledQty]

    OPTION : KC VCH NRMQty : @@ISSALES

    [!FIELD : KC VCH NRMLAMT]

    SET BY CONDITION : YES : @@AMTCALCULATION
    [#FIELD : VCH RATE]

    OPTION : KC VCH RATE : @@ISSALES

    [!FIELD : KC VCH RATE]

    DELETE : SET BY CONDITION
    [SYSTEM : FORMULA]

    AMTCALCULATION :#KCNOOFPCSPRINT + #KCMTSPRINT + #KCNOOFPCS1PRINT
     
    NainaSiraj, Dec 1, 2020
    #22


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Because your FIELDS are number and the Amount Field is Amount.........
     
    Amit Kamdar, Dec 1, 2020
    #23


  24. NainaSiraj

    NainaSiraj Member


    not getting sir

    should i remove # from from fields
     
    NainaSiraj, Dec 1, 2020
    #24


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Cannot Understand your requirement, Nor do have relevant Tally Data to try your code.

    Explain with screenshot what you want and require and also share your Dummy Data.
     
    Amit Kamdar, Dec 1, 2020
    #25


Page 1 of 2

Share This Page