Nug Column need without decimal 00 and show total of nug under with total quantity

Discussion in 'Free Source Codes' started by M. Sajid Razzaq, Jan 15, 2022.

    

  1. Nug Column need without decimal 00 and show total of nug under with total quantity, and also calculated nug show in party ledger. How much nugs recived this party show in party ledger report. please help me. thanks


    [#LINE: EI COLUMNONE]

    OPTION : KC EI COLUMNONE : @@ISSALES

    [!LINE : KC EI COLUMNONE]

    ADD : RIGHT FIELDS : Before : VCH AmtTitle : KC MTS
    LOCAL : FIELD : KC MTS : INFO : "Nug"




    [#LINE: EXPINV COLUMN1]

    OPTION : KC EXPINV COLUMN1 : @@ISSALES

    [!LINE : KC EXPINV COLUMN1]
    ADD : LEFT FIELDS : After: EXPINV DESCTITLE : KC MTS


    LOCAL : FIELD : KC MTS : INFO : "Nug"


    LOCAL : FIELD : KC MTS : DELETE: STORAGE


    LOCAL : FIELD : KC MTS : TYPE : STRING


    [#LINE : EI INVINFO]

    OPTION : KC EI INVINFO : @@ISSALES

    [!LINE : KC EI INVINFO]

    ADD: RIGHT FIELDS: Before : VCH Value : KC MTS


    [FIELD : KC MTS]

    USE : Amount FIELD
    ;; TYPE : NUMBER
    STORAGE : KCMTS
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black






    [#LINE: EXPINV INVDETAILS]

    OPTION : KC EXPINV INVDETAILS : @@ISSALES

    [!LINE : KC EXPINV INVDETAILS]

    ADD : LEFT FIELDS : AFTER : EXPINV DESC : KC MTSPRINT


    [FIELD : KC MTSPRINT]

    USE : NUMBER FIELD
    SET AS : $KCMTS
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black

    [SYSTEM : UDF]


    KC MTS : Amount : 505



    [SYSTEM : FORMULA]

    TRSFormula : ( $KCMTS )
    IsSales0 : $$IsSales:##SVVoucherType
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Format : "No Decimals" in your Field.........
     



  3. Dear Sir Amit, you mean add this line in code file or other else. and please also guide me about nug total
     


  4. manuz

    manuz New Member


    in field add format No decimal or round the figure

    $$round:<value>:1
     



  5. Dear Manuz, Please tell me the write location or row , where I put this code. thanks / I tried but not get correct answer
     


  6. Damodaran

    Damodaran New Member


    need to add format in the field level as mentioned below:

    [FIELD : KC MTSPRINT]

    USE : NUMBER FIELD
    SET AS : $KCMTS
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black
    Format : " NoDecimal"
     



  7. Thanks Damodaran Sir for reply. Please see the attached file. One more thing how get the total of Nug left side of total amount
     

    Attached Files:




  8. Any one please help me, I need this TDL very much
     


  9. Arun Prasath

    Arun Prasath Member


    Use below code in the field level

    Format :"Decimal:0"
     



  10. Thank you very much Arun Prasath Sir. Please give me one more favor . I attached file. Total of Nug also show in parties ledger. Advance Thanks
     

    Attached Files:



  11. Sanjeev S

    Sanjeev S Active Member


    Please try this......

    Code:
    [#LINE: EI COLUMNONE]
    
    OPTION : KC EI COLUMNONE : @@ISSALES
    
    [!LINE : KC EI COLUMNONE]
    
    ADD : RIGHT FIELDS : Before : VCH AmtTitle : KC MTS Title
    LOCAL : FIELD : KC MTS Title : INFO : "Nug"
    
    [#LINE: EXPINV COLUMN1]
    
    OPTION : KC EXPINV COLUMN1 : @@ISSALES
    
    [!LINE : KC EXPINV COLUMN1]
    ADD : LEFT FIELDS : After: EXPINV DESCTITLE : KC MTS Title
    
    
    [FIELD : KC MTS Title]
    
    USE : Name FIELD
    Set as    :    "Nug"
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black
    Skip        :    Yes
    
    [#LINE : EI INVINFO]
    
    OPTION : KC EI INVINFO : @@ISSALES
    
    [#LINE : CI INVINFO]
    
    OPTION : KC EI INVINFO : @@ISSALES
    
    [!LINE : KC EI INVINFO]
    
    ADD: RIGHT FIELDS: Before : VCH Value : KC MTS
    
    
    
    [FIELD : KC MTS]
    
    USE : Number FIELD
    STORAGE : KCMTS
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black
    
    
    [#Part: EI InvInfo]
    
        Add    :    Total    :    KCMTS
    
    [#LINE: EXPINV INVDETAILS]
    
    OPTION : KC EXPINV INVDETAILS : @@ISSALES
    
    [!LINE : KC EXPINV INVDETAILS]
    
    ADD : LEFT FIELDS : AFTER : EXPINV DESC : KC MTSPRINT
    
    
    
    [FIELD : KC MTSPRINT]
    
    USE : NUMBER FIELD
    SET AS : $KCMTS
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black
    
    [SYSTEM : UDF]
    
    
    KC MTS : Number : 505
    
    
    
    [SYSTEM : FORMULA]
    
    TRSFormula : ( $KCMTS )
    IsSales0 : $$IsSales:##SVVoucherType
    
    
    [#Part    :    VCH Narration]
        Option        :    Nug Totals        :    @@IsSales
       
        [!Part        :    Nug Totals]
            Add    :    Line    :    At Beginning    :    KC MTS Total
    
            [Line    :    KC MTS Total]
                Field    :    Medium Prompt, EI Nug Total
    
                Local    :    Field        :    Medium Prompt        :    Info    :    "Total Nugs"
    
    [Field    :    EI Nug Total]
        Use                    :    Number Field
        Set as            :    $$Total:KCMTS
        Set Always    :    Yes
        Width            :    @@NumberWidth
    
     



  12. Dear Sanjeev S Sir, Thank you very much for sharing your knowledge with us.
     



  13. Sir Sanjeev S, Is it possible to take print out with same information in print mode ? Last request ( how to get total's of nug in party ledger report )
     


  14. Sanjeev S

    Sanjeev S Active Member


    Just try. I am sure small efforts you can easily do it. :)
     



  15. [#LINE: EI COLUMNONE]

    OPTION : KC EI COLUMNONE : @@ISSALES

    [!LINE : KC EI COLUMNONE]

    ADD : RIGHT FIELDS : Before : VCH AmtTitle : KC MTS Title
    LOCAL : FIELD : KC MTS Title : INFO : "Nug"

    [#LINE: EXPINV COLUMN1]

    OPTION : KC EXPINV COLUMN1 : @@ISSALES

    [!LINE : KC EXPINV COLUMN1]
    ADD : LEFT FIELDS : After: EXPINV DESCTITLE : KC MTS Title


    [FIELD : KC MTS Title]

    USE : Name FIELD
    Set as : "Nug"
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black
    Skip : Yes

    [#LINE : EI INVINFO]

    OPTION : KC EI INVINFO : @@ISSALES

    [#LINE : CI INVINFO]

    OPTION : KC EI INVINFO : @@ISSALES

    [!LINE : KC EI INVINFO]

    ADD: RIGHT FIELDS: Before : VCH Value : KC MTS



    [FIELD : KC MTS]

    USE : Number FIELD
    STORAGE : KCMTS
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black


    [#Part: EI InvInfo]

    Add : Total : KCMTS

    [#LINE: EXPINV INVDETAILS]

    OPTION : KC EXPINV INVDETAILS : @@ISSALES

    [!LINE : KC EXPINV INVDETAILS]

    ADD : LEFT FIELDS : after : EXPINV DESC : KC MTSPRINT



    [FIELD : KC MTSPRINT]

    USE : NUMBER FIELD
    SET AS : $KCMTS
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black

    [SYSTEM : UDF]


    KC MTS : Number : 505



    [SYSTEM : FORMULA]

    TRSFormula : ( $KCMTS )
    IsSales0 : $$IsSales:##SVVoucherType


    [#Part : VCH Narration]
    Option : Nug Totals : @@IsSales

    [!Part : Nug Totals]
    Add : Line : At Beginning : KC MTS Total

    [Line : KC MTS Total]
    Field : Medium Prompt, EI Nug Total

    Local : Field : Medium Prompt : Info : "Total Nugs"

    [Field : EI Nug Total]
    Use : Number Field
    Set as : $$Total:KCMTS
    Set Always : Yes
    Width : @@NumberWidth


    [#Line: DSP VchAccTitles]
    Add: Right Field: Before: DSP VchRefTitleFld : DSP KC MTS Title
    [Field: DSP KC MTS Title]
    Use: name field
    Set as: "Nug"
    Width: 4
    Align: Center
    Border: Thin Left
    Style: Normal Bold

    [#Line: DSP VchDetail]
    Add: Right Field: Before: DSP VchRefNumberFld : DSP KC MTS Total
    [Field: DSP KC MTS Total]
    Use: number field
    Set as: $$Total:KCMTS
    Width:4
    Align: Center
    Border: Thin Left
    Style: Normal Bold
     

    Attached Files:




  16. Amit Kamdar Sir, Arun Prasath Sir, Sanjeev S Sir, I need your attention. Please guide me for correction of this TDL file. Thanks
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Please make some efforts in solving your queries. This is a platform where TDL learning and knowledge is shared.

    We can help with technicalities..........if there are any hiccups.
     



  18. Sir give me a hint, not a solution
     



  19. Sir Amit, I am trying but not get correct answer. Please guide me. thanks
     



  20. [#LINE: EI COLUMNONE]

    OPTION : KC EI COLUMNONE : @@ISSALES

    [!LINE : KC EI COLUMNONE]

    ADD : RIGHT FIELDS : Before : VCH AmtTitle : KC MTS Title
    LOCAL : FIELD : KC MTS Title : INFO : "Nug"

    [#LINE: EXPINV COLUMN1]

    OPTION : KC EXPINV COLUMN1 : @@ISSALES

    [!LINE : KC EXPINV COLUMN1]
    ADD : LEFT FIELDS : After: EXPINV DESCTITLE : KC MTS Title


    [FIELD : KC MTS Title]

    USE : Name FIELD
    Set as : "Nug"
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black
    Skip : Yes

    [#LINE : EI INVINFO]

    OPTION : KC EI INVINFO : @@ISSALES

    [#LINE : CI INVINFO]

    OPTION : KC EI INVINFO : @@ISSALES

    [!LINE : KC EI INVINFO]

    ADD: RIGHT FIELDS: Before : VCH Value : KC MTS



    [FIELD : KC MTS]

    USE : Number FIELD
    STORAGE : KCMTS
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black


    [#Part: EI InvInfo]

    Add : Total : KCMTS

    [#LINE: EXPINV INVDETAILS]

    OPTION : KC EXPINV INVDETAILS : @@ISSALES

    [!LINE : KC EXPINV INVDETAILS]

    ADD : LEFT FIELDS : after : EXPINV DESC : KC MTSPRINT



    [FIELD : KC MTSPRINT]

    USE : NUMBER FIELD
    SET AS : $KCMTS
    SET ALWAYS : YES
    WIDTH : 4
    ALIGN : CENTER
    Print Fg :Black

    [SYSTEM : UDF]


    KC MTS : Number : 505



    [SYSTEM : FORMULA]

    TRSFormula : ( $KCMTS )
    IsSales0 : $$IsSales:##SVVoucherType


    [#Part : VCH Narration]
    Option : Nug Totals : @@IsSales

    [!Part : Nug Totals]
    Add : Line : At Beginning : KC MTS Total

    [Line : KC MTS Total]
    Field : Medium Prompt, EI Nug Total

    Local : Field : Medium Prompt : Info : "Total Nugs"


    [Field : EI Nug Total]
    Use : Number Field
    Set as : $$Total:KCMTS
    Set Always : Yes
    Width : @@NumberWidth
    Align : Center
    Color : Black
    Style : Normal Bold





    [#Line: DSP VchAccTitles]
    Add :Right Field :Before :DSP VchRefTitleFld : DSP KCMTS
    [Field: DSP KCMTS]
    Use : Name Field
    Set as :"Nug"
    Width :5
    Style :Normal Bold
    Border :Thin left
    Align :Center

    [#Line: DSP VchDetail]
    Add :Right Field :Before :DSP VchRefNumberFld : DSP EI Nug Total
    [Field: DSP EI Nug Total]
    Use : Number Field
    Set As :$$Total:KCMTS
    Width :5
    Color :Red
    Style :Normal
    Border :Thin left
    Align :Center
     


Share This Page