[#Menu : Gate Way of Tally] Add :Key Item : At End : "Cash Turnover " : L isplay: CashPayRecforAudit [Report:CashPayRecforAudit] Form:CashPayRecforAudit Full Screen:Yes [Form:CashPayRecforAudit] Part:CPRA Title Part, CPRA VchTitle Width : 100% Screen Height : 100% Screen UseSP Template [Part:CPRA Title Part] Line:CPRA Title Part, CPRA Title Part Period Horizontal Alignment:Centre Sync:Yes [Line:CPRA Title Part] Field:CPRA Title Part [Field:CPRA Title Part] Set as:"Cash Received" Style:Large Bold Border:sub totals [Line:CPRA Title Part Period] Field:CPRA Title Part Period [Field:CPRA Title Part Period] Set as:"" [Part:CPRA VchTitle] Line:CPRA VchTitle, CPRA VchBody Repeat:CPRA VchBody:CPRA VchBody Aggr Border:Thin Box Sync:Yes Common Borders:Yes [Line:CPRA VchTitle] Field:CPRA SRNO, CPRA Particulars, CPRA GroupName, CPRA CashReceipt [Field:CPRA SRNO] Use:info field Info:"Sr No" Style:NORMAL BOLD [Field:CPRA Particulars] Use:info field Info:"Particulars" Width:30 Style:NORMAL BOLD [Field:CPRA GroupName] Set as:GroupName Info:"Group Name" Width:15 Style:NORMAL BOLD [Field:CPRA CashReceipt] Use:Amount Field Info:"Cash Receipt" Width:15 Style:NORMAL BOLD [Line:CPRA VchBody] Field:CPRA SrNo, CPRA Particulars, CPRA GroupName, CPRA CashReceipt Local : Field : Default : Style : Normal Bold Local :Field:CPRA SrNo : Set as:$$Line Local :Field:CPRA Particulars:Set as:$PartyLedgerName Local :Field:CPRA GroupName:Set as:"" Local :Field:CPRA CashReceipt:Set as:if $ledgername CONTAINS "Cash" then $Amount else "" [System:Formula] PartyName1:$LedgerName:Group:"Cash In Hand" [System:UDF] CPRA VchBody Aggr:Aggregate:6801 [Collection : CPRA Rep Collection] Type : Vouchers Fetch : Date, Amount, VoucherTypeName, PartyLedgerName, VoucherNumber Please help with this i want to fetch Cash Received Partywise from all voucher type... Here i am unable to fetch any details. I am new with Reporting part.
I would suggest...that before attempting new Reports etc.... First you load up the SAMPLE.TCP in Developer....... learn about Collections, Aggregates and UDFs storages.........You need to have a minimum grasps of the basics first. Check out the sample code and learn about how to structure the same. From your comment... you want to have a Partywise report and aggregating all the Cash transactions to be displayed. However your code above is very very far from that requirement.
Amit sir, I have try to done and succeed to the some extent Party name and Amount is coming properly but i want to do aggregate of it, and have also review some Sample TDL and followed it. But still not able to compute aggregate sum of total amount received ledger wise. and also not able to get group name. Please help me with this code is as follow Code: [#Menu : Gate Way of Tally] Add :Key Item : At End : "Cash Turnover " : L :Display: CashPayRecforAudit [Report:CashPayRecforAudit] Form:CashPayRecforAudit Full Screen:Yes [Form:CashPayRecforAudit] Part:CPRA Title Part, CPRA VchTitle Width : 100% Screen Height : 100% Screen Use:DSP Template [Part:CPRA Title Part] Line:CPRA Title Part, CPRA Title Part Period Horizontal Alignment:Centre [Line:CPRA Title Part] Field:CPRA Title Part [Field:CPRA Title Part] Set as:"Cash Received" Style:Large Bold Border:sub totals [Line:CPRA Title Part Period] Field:CPRA Title Part Period [Field:CPRA Title Part Period] Set as:"" [Part:CPRA VchTitle] Line:CPRA VchTitle, CPRA VchBody Repeat:CPRA VchBody:CPRA Rep Collection Border:Thin Box Common Borders:Yes [Line:CPRA VchTitle] Use:CPRA VchBody Local : Field : Default : Type : String Local : Field : Default : Align : Centre Local : Field : Default : Style : Normal Bold Local : Field : Default : Border : Thin Box Local :Field :CPRA SrNo : Set as :"Sr No" Local :Field :CPRA Particulars : Set as :"Particulars" Local :Field :CPRA GroupName : Set as :"Group Name" Local :Field :CPRA CashReceipt : Set as :"Cash" Local :Field :CPRA CashReceipt : Width :15 [Line:CPRA VchBody] Field:CPRA SrNo, CPRA Particulars, CPRA GroupName, CPRA CashReceipt [Field:CPRA SRNO] Set as : $$Line Width : 3 Align : Centre Border : Thin Right [Field:CPRA Particulars] Use : Name Field Set as : $ledgername Border : Thin Right [Field:CPRA GroupName] Use : Name Field Set : $Parent Border : Thin Right [Field:CPRA CashReceipt] Use : Amount Field Set as : $amount Width:15 [Collection : CPRA Rep Collection] Type : Vouchers : VoucherType Child Of : $$VchTypeReceipt Belongs To : Yes Walk : AllAccountingEntries By :name:$ledgername Fetch : LedgerName, GroupName, Amount ;; Aggr Compute is computed based on the By Attribute and the values are stored in the Methods ;; specified. Aggr Compute : Amount : Sum : $Amount Keep Source : No
Your collection is wrong.......... You need to have a collection of Ledgers ... and maybe filter it for Debtors/Creditors only. ( for partywise ) Make another collection for Receipt Vouchers....walk all entries..... and compute the SUM, if the LedgerName = Your FIELDLedgerName and it contains the Ledger having Cash Ledger.......and Aggr Compute that. Again refer to some of the samples in the Developer's sample folders.
[Collection : CPRA Rep Collection] Type : Vouchers : VoucherType Child Of : $$VchTypeReceipt Belongs To : Yes Walk : AllAccountingEntries By :name:$ledgername Filter : onlycashentry Fetch : LedgerName, GroupName, Amount [System:Formulas] onlycashentry: $$IsLedOfGrp:$ParentLedgerName:$$GroupCash sir with this i am getting only sales related entry by fileter where as i want all ledger (partiwise irrespective creditor, debtor, loans so no need of collection for this) but i am only getting entry related to sales..
Really.... without a collection of Ledgers...... you will get Voucher-wise and not Party-wise/Ledger-wise. onlycashentry: $$IsLedOfGrp:$ParentLedgerName:$$GroupCash == Does this work for Single-entry and Double-entry modes?? Make some entries for Single and Double entry mode and check the results.
From your collection..... you will be getting ALL receipt related entries...........not only SALES......... Make a dummy ledger under other group and pass Receipt entries and check it out.
with this actually first i want to try with voucher wise... Actually i am stuck here because bank entries are also coming in collection. Mainly i am stuck with that, that's the i am not making collection for ledger. in below code all receipt voucher are coming, i have try to make only for voucher involving cash group ledger. but still not able to do.. have tried to learn from samples but not able to get much from it relating to sample. I feel making new report is biggest challenge in tdl making. please help to correct in below code [Collection : CPRA Rep Collection] Type : Vouchers : VoucherType Child Of : $$VchTypeReceipt Belongs To : Yes Walk : AllAccountingEntries By :name:$ledgername Filter : onlycashentry Fetch : LedgerName, GroupName, Amount Fetch : AllLedgerEntries.LedgerName, AllLedgerEntries.Amount Fetch : AllLedgerEntries.CashAllocations.* [System:Formulas] onlycashentry: $$IsVoucher:$$IsLedOfGrp:$ledgername:$$GroupCash ;;onlycashEntry: $$IsLedOfGrp:$ledgername:$$GroupDuties
sir actually alongwith cash, bank receipt also coming with the above mentioned collection.. where i am gone wrong will you please tell me.
Problem is with this........... [System:Formulas] onlycashentry: $$IsVoucher:$$IsLedOfGrp:$ledgername:$$GroupCash All Entries has Dr/Cr or multiple Dr/Cr ......... so which Ledger does your Formula refers to......... ?????
