Ledger Report Collection

Discussion in 'Tally Developer' started by mahadev loke, Dec 11, 2012.

    
  1. mahadev loke

    mahadev loke New Member


    I am trying to add field in Ledger Report (Report: Ledger Vouchers), I would like to know which collections are used in Ledger Report.
     


  2. admin

    admin Administrator Staff Member


    If you want to a field in report, you need to add in Line level in Ledger Voucher report
     


  3. mahadev loke

    mahadev loke New Member


    I tried it please check my code it is not showing any value also I want to skip entry to udf when ledger name is blank

    ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara

    ;;=== Ledger report

    [#Line: DSP VchAccTitles]
    Add: Field : after : DSP VchDateTitle : SCS VCH CurTitle,SCS VCH CurRateTitle, SCS VCH CurAmtTitle

    [#Line: DSP VchInv1Titles]
    Add: Field : after : DSP VchDateTitle : SCS VCH CurTitle,SCS VCH CurRateTitle, SCS VCH CurAmtTitle


    [#Line: DSP VchDetail]
    Add : Field : after : DSP VchDate : ScsIICurrency

    [Field : ScsIICurrency]
    Use : Short Name Field
    Set as : $SCSCurrency ;$AllLedgerEntries.SCSCurrency
    Width : 10
    Style : Normal
    Set Always : yes

    [#Collection : Vouchers of Ledger]
    Fetch: AllLedgerEntries.SCSCurrency




    ; contra / receipt / payment
    [#Line: ACLSTitle]
    Add: Field : after : VCH NameTitle : SCS VCH CurTitle, SCS VCH CurRateTitle, SCS VCH CurAmtTitle

    [#Line: ACLSInfo]
    Add: Field : after : ACLSLed : SCS VCH Currency,SCS VCH CurRate,SCS VCH CurAmount

    [Field: SCS VCH CurTitle]
    Use: VCH ShortTitle
    Setas: $$LocaleString:"Currency"

    [Field: SCS VCH CurRateTitle]
    Use: VCH ShortTitle
    Setas: $$LocaleString:"Cur. Rate"

    [Field: SCS VCH CurAmtTitle]
    Use: VCH ShortTitle
    Setas: $$LocaleString:"Cur. Amount"

    [Field: SCS VCH Currency]
    Use: Short Name Field
    Storage: SCSCurrency
    Width: 10
    Table : Currency, NotApplicable
    Show Table : Always
    Add: Key : Create Currency, Alter Currency
    Set Always : Yes
    ;skip on : $$IsEmpty:$LedgerName


    [Field: SCS VCH CurRate]
    Use: Short Name Field
    Storage: SCSCurRate
    Set Always : Yes
    Width : 5
    Align : Right
    ;skip on : $$IsEmpty:$LedgerName

    [Field: SCS VCH CurAmount]
    Use: Short Name Field
    Storage: SCSCurAmount
    Set Always : Yes
    Width : 8
    Align : Right
    set : if ($$IsEmpty:$SCSMTR) then $$Value else ($Amount/$$Number:$SCSMTR)
    ;skip on : $$IsEmpty:$LedgerName

    [System: UDF]
    SCSCurrency: String: 3001
    SCSCurRate: String: 3002
    SCSCurAmount: String: 3003
     


Share This Page