i want additional column in invoice sales

Discussion in 'Free Source Codes' started by bikash agarwal, Apr 6, 2024.

    

  1. code is

    [#Line: EI ColumnOne]
    Option : sms EI ColumnOne : @@IsSales
    [!Line : sms EI ColumnOne ]


    [#Line : sms EI ColumnOne]
    Add : Right Field: At Beginning:COLORCode

    [Field:COLORCode]
    Use:Name Field
    Set as: "COLOR"
    Skip: Yes
    Border:Thick Left Right
    Width:15
    Align: Center


    [System : UDF]
    Colorcode1 : String : 7001

    [#Line : EI Inv Info]
    Add: Right Field:At Beginning:COLORCode1

    [Field:COLORCode1]
    Use: Name Field
    Set as:$Colorcode1
    Storage : Colorcode1
    background: surf green
    Width:15
    Align: Center
    Max:15
    Set Always: Yes

    ;; issue is :eek:

    # print as pic shown below
    # want this column just after
    " product description " on sales voucher screen :(
     

    Attached Files:



  2. ROHIT JAISWAR

    ROHIT JAISWAR Active Member


    Firstly Clear
    You Want on Sales Voucher Screen or Print Screen?
    If You Want to Use On Print Screen then
    ;; For Title
    [#Line:EXPINVColumn1]

    .... Add your Fields here

    [#Line:EXPINVColumn2]

    ... Add your Fields here

    ;; for Value
    [#Line:EXPINVDetails]

    ... Add your Fields here

    Try to Add your fields in this Lines
     




  3. [#Line:EXPINVColumn1]

    Option : sms EI ColumnOne : @@IsSales

    [!Line : sms EI ColumnOne ]


    [#Line : sms EI ColumnOne]
    Add : Right Field: At Beginning:COLORCode


    [Field:COLORCode]
    Use:Name Field
    Set as: "COLOR"
    Skip: Yes
    Border:Thick Left Right
    Width:15
    Align: Center


    [System : UDF]

    Colorcode1 : String : 7001

    [#Line:EXPINVDetails]
    Add: Right Field:At Beginning:COLORCode1

    [Field:COLORCode1]
    Use: Name Field
    Set as:$Colorcode1
    Storage : Colorcode1
    background: surf green
    Width:15
    Align: Center
    Max:15
    Set Always: Yes

    i want to come in sales enty as well as on invoice when printed as shown in picture in - RED color
     


  4. ROHIT JAISWAR

    ROHIT JAISWAR Active Member


    I Think you Don't have TDL Knowledge
    Kindly First Learn Else Pay Any Developer and Done your Work.
    It's Going to be 600-1200 As Per your Requirement.
     



  5. yes u said correct / but this forum is for learning ..... you keep assuming on me but never in life do assume .... ;)
     



  6. and you will be impressed by seeing my collection of tdls
     



  7. ;-----------colorcode11 ---End List---------------;


    [#Line: EI ColumnOne]
    Add : Right Fields : Before:VCH QtyTitle : colorcode11Title,

    [Field:colorcode11Title]
    Use: Name Field
    Info: "Color"
    Width: 12
    Align:Center
    Border : Thin Left
    Style:Small Bold
    ;space right : 7




    [#Line : EI InvInfo]
    Add : Right Fields : Before : VCH ActualQty : colorcode11

    [Field : colorcode11]
    Use : Name Field
    Type : Forced
    Storage : udfMakeStorage
    ;Border : Thin Left
    Set Always : Yes
    Width : 12
    Align : Center
    background: surf green
    color: Stone Wash Red
    Invisible : not @@ISSales ;OR @@ISPurchase


    [System : UDF]
    udfMakeStorage : String : 6500



    ;[#Line: EXPINV Column1]

    ;Add : Left Fields : After : EXPINV DescTitle : colorcode11

    ;Local : Field : colorcode11 : Info : "Color"
    ;Local : Field : colorcode11 : Delete: Storage
    ;Local : Field : colorcode11 : Type : String
    ;Local : Field : colorcode11 : Align : Center
    ;Local : Field : colorcode11 : Width : 12
    ;Local : Field : colorcode11 : Border: thinleft ; $$String:"Cash "

    [#Line: EXPINV InvDetails]

    Add : Left Fields : After : EXPINV Desc : fldMakeStorage

    [Field : fldMakeStorage]

    Use : Name Field
    Type : Forced
    Set as : $$String:"" +"- "+ $udfMakeStorage
    Set Always : Yes
    Width : 15
    Style : Small
    Align : left
    ;Border : thin left



    ;;;; working and correct :rolleyes::rolleyes: but it have some issue when class selected it doesn't shows on creation mode / alter mode it shows
     
    Last edited: Apr 23, 2024



  8. :)
     
    Last edited: Apr 29, 2024


  9. ROHIT JAISWAR

    ROHIT JAISWAR Active Member


    Use Line for Class

    [#Line:CI InvInfo]

    .... Add your Fields here
     





  10. [#Line: EI ColumnOne]
    Add : Right Fields : Before:VCH QtyTitle : colorcode11Title,

    [Field:colorcode11Title]
    Use: Name Field
    Info: "Color"
    Width: 15
    Align:Center
    Border : Thin Left
    Style:Small Bold
    color:blue
    space right : 7
    Invisible : not @@ISSales ;OR @@ISPurchase




    ;[#Line : EI InvInfo]
    [#Line: CI InvInfo]
    Add : Right Fields : Before : VCH ActualQty : colorcode11

    [Field : colorcode11]
    Use : Name Field
    Type : Forced
    Storage : udfMakeStorage
    ;Border : Thin Left
    Set Always : Yes
    Width : 15
    Align : Center
    background: surf green
    color: blue
    Invisible : not @@ISSales ;OR @@ISPurchase



    [System : UDF]
    udfMakeStorage : String : 6500



    ;[#Line: EXPINV Column1]

    ;Add : Left Fields : After : EXPINV DescTitle : colorcode11

    ;Local : Field : colorcode11 : Info : "Color"
    ;Local : Field : colorcode11 : Delete: Storage
    ;Local : Field : colorcode11 : Type : String
    ;Local : Field : colorcode11 : Align : Center
    ;Local : Field : colorcode11 : Width : 9
    ;Local : Field : colorcode11 : Border: thinleft ; $$String:"Cash "

    [#Line: EXPINV InvDetails]

    Add : Left Fields : After : EXPINV Desc : fldMakeStorage

    [Field : fldMakeStorage]

    Use : Name Field
    Type : Forced
    Set as : $udfMakeStorage
    Set Always : Yes
    Width : 7
    background: surf green
    Style : Small Italic
    Align : left
    ;Border : thin left


    here it working fine but does not show on alter screen ... please see
     


  11. ROHIT JAISWAR

    ROHIT JAISWAR Active Member


    Why you have commented [#Line : EI InvInfo] ?
     



  12. aap ne hi correction karwaya tha

    Use Line for Class

    [#Line:CI InvInfo]

    .... Add your Fields here
     


  13. ROHIT JAISWAR

    ROHIT JAISWAR Active Member


    Sir, Maine Class Ke Liye

    [#Line:CI InvInfo]

    .... Add your Fields here

    Above Line use krne Bola tha Apka Previous Line Comment Krne Nahi Bola tha

    Apka Pahle ka Jaisa hai Vaisa hi Rakho and Class ke liye wo Line Use Kriye and dono Line 1 Code me Chalega
     




Share This Page