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 at 8:41 AM


Share This Page