How to sum UDF Field in payment voucher?

Discussion in 'Tally Developer' started by manjari m, Jul 15, 2014.

    
Thread Status:
Not open for further replies.
  1. manjari m

    manjari m New Member


    Hello Experts.,

    i want to sum my udf field in payment voucher and it will display in outstanding ., but i don't know how to sum that field please help me., here i include screenshot and TDL code., please help me.,

    [​IMG]

    [​IMG]

    [​IMG]

    TDL code:

    [System: UDF]
    BN:String:1001
    BC: Amount:4005

    [#Part: VCHTitle2Left]
    Option: EI_BC:$$IsPayment:##SVVoucherType

    [!Part: EI_BC]
    Add: Line: EI_BC_Line

    [Line: EI_BC_Line]
    Add: Field: EI_BN_Label
    Add: Field: EI_BN_Field

    Add: Field: EI_BC_Label
    Add: Field: EI_BC_Field

    [Field: EI_BN_Label]
    Info: "BILL NO:"
    Width: 15

    [Field: EI_BN_Field]
    Use: Name Field
    Storage: BN
    Width: 20

    [Field: EI_BC_Label]
    Info: "BANK CHARGE: "
    Width: 15

    [Field: EI_BC_Field]
    Use: Amount Field
    Storage: BC
    Width: 20

    ;; OUTSTANDING FIELD
    [#Line: BILLCol1]
    Local : Field : IBC : Set as: $$LocaleString:"BC"
    Local : Field : IBA : Set as: $$LocaleString:"BILL AMOUNT"

    [#Line: BILLCol2]
    Local : Field : IBC : Set as: $$LocaleString:""
    Local : Field : IBA : Set as: $$LocaleString:""

    [#Field: BILLFixed]

    Add : Field : After: IIBillno : IBC
    Add : Field : Before: IBC : IBA


    [Field : IBC]

    Use : Amount Field
    Set as: $$Total:$BC
    Width : 9
    Style : Normal Bold

    [Field : IBA]

    Use : Amount Field
    Set as : $ClosingBalance - $LedgerEntries[last].BC
    Width : 10
    Style : Normal Bold
     


  2. manjari m

    manjari m New Member


    i am new to TDL., please anyone help me.,
     


  3. Maulik Patel

    Maulik Patel Active Member


    Apply this code and restart your tally.

    You have to add " MLK BC Total" field instead of your field "IBC" in your code.

    Code:
    [Collection : MLK Voucher Col]
        Type    : Voucher
        Fetch    : Reference, BC
       
    [Field : MLK BC Total]
        Use        : Amount Field
        Set As    : $$FilterAmtTotal:MLKVoucherCol:MLKReference:$BC
       
    [System : Formula]
        MLK Reference    : $Reference = #BILLRef
     
    khushbu and manjari m like this.


  4. UTPAL

    UTPAL New Member


    Try the Attached Code
     

    Attached Files:



  5. manjari m

    manjari m New Member


    Thanks for your valuable code., it's working fine., you just awesome., once again thank you very much.,
     


  6. Maulik Patel

    Maulik Patel Active Member


    Dear Utpal,

    Please do not misunderstand me, your code will work fine but here requirement is to sum that amount while your code will give only for one voucher.
     


  7. UTPAL

    UTPAL New Member


    Yes You are Right
    Its my misunderstanding
     


Thread Status:
Not open for further replies.

Share This Page