I am trying to add field in Ledger Report (Report: Ledger Vouchers), I would like to know which collections are used in Ledger Report.
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