[#Menu:Gateway of Tally] Add: Key Item: At End: Partywise calculation : Y : Display : CAB Ledger List : $$IsInventoryOn:$$CurrentCompany [Report: CAB Ledger List] Form : CAB Ledger Form Title : "Company Ledger List" [Form: CAB Ledger Form] Use : DSP Template Parts : CAB Ledger Part Height : 100% screen Width : 100% screen Background : Grey [Part: CAB Ledger Part] Lines : CAB Ledger Title, CAB Ledger Line Repeat : CAB Ledger Line : CAB My Ledgers CommonBorder: Yes Scroll : Vertical [Line: CAB Ledger Title] Use : CAB Ledger Line Local : Field : Default : Type : String Local : Field : Default : Align : Centre Local : Field : Default : Style : Normal Bold Local : Field : CAB Led No : Set as : "Sr. No" Local : Field : CAB Led Name : Set as : "Ledger Name" Local : Field : CAB Led Name : Align : Left Local : Field : CAB Led address : Set as : "Deposit" Local : Field : CAB Led States : Set as : "Target Sales" Local : Field : CAB Led CB : Set as : "Sales Done" Local : Field : CAB Led Qualified: Set as : "Qualified or Not" Local : Field : CAB Led Cont : Set as : "Incentive 2%" Border : Thin Top Bottom [Line: CAB Ledger Line] Fields : CAB Led No, CAB Led Name, CAB Led Address, CAB Led States, CAB Led CB, CAB Led Qualified, CAB Led Cont Option : AlterOnEnter [Field: CAB Led No] Set as : $$Line Width : 5 Align : Centre Border : Thin Right Alter : Ledger [Field: CAB Led Name] ; Use : Name Field Set as : $Name Full Width: Yes [Field: CAB LedAddress] Use : Amount forex field Set as : $CreditLimit Width : 15 Border : Thin Left Right [Field: CAB Led States] Use : AMount Forex field Set as : @@targetsalesamt Storage : TargetAmount Width : 15 Border : Thin Right [Field: CAB Led CB] Use : Amount forex Field Set as : $LedgerSalesTotal ;TBalClosing;$$IsDebit@PartyNett ;$ClosingBalance:Ledger@VchPartyname ;@@PartyNett ;#DBCAmount ;$LedgerSalesTotal ;@@PartyClbalance ;$BSDebits ;@@TrDrValue ;@@PartyNett Width : 15 Border : Thin Right [System: Formula] ForThisParty : $PartyLedgerName = @@ReqObjName [Collection: My Sales Vouchers] Type : Vouchers : Voucher Type Child Of : $$VchTypeSales ;Fetch : *.* Fetch : PartyLedgerName, LedgerEntries.Amount [#Object: Ledger] LedgerSalesTotal : $$FilterAmtTotal:MySalesVouchers:ForThisParty:$Amount [Field: CAB Led Qualified] Use : Name Field Set as : @@QualiORNotQuali ;"Qualified" Align : Centre Width : 15 Border : Thin Right [Field: CAB Led Cont] Use : Amount Forex Field Set as : If #CABLedQualified="Qualified" then ((@@PartyClbalance*2)/100) else 0 Width : 15 Border : Thin Right [System : Formulae] targetsalesamt : ($CreditLimit*3) PartyClbalance : $BSDebits QualiORNotQuali: If @@targetsalesamt<=@@PartyClbalance then "Qualified" else "" [Collection: CAB My Ledgers] Type : Ledger Child of : $$GroupSundryDebtors Belongs to : Yes ;; 'Belongs To' includes the Ledgers pertaining to the subgroups of the group ;; mentioned in Attribute 'Child Of'. Fetch : *.* ;; Fetch attribute required for remoting 2.0 ;; End-of-File
In my sales done column, i want to set sales value of party before ledger entries. Means only inventryentries value(subtotal)
May be this help, refer or try this Code: [Collection: My Sales Vouchers] Type : Vouchers : Voucher Type Child Of : $$VchTypeSales ;Fetch : *.* Fetch : PartyLedgerName, LedgerEntries.Amount [Collection: My Sales Inventory] Source Collection : My Sales Vouchers Walk: Inventory Entries Fetch : *, *.* By: PartyLedgerName: $PartyLedgerName Aggr Compute: Amount : Sum: $Amount may be alternate way available also Regards
Patel sir i want to filter sales> 5 lakh and hide ledger less than 5 lakh. i tried but getting sell > 5 lakh but ledger lesser are also showing Use : Amount forex Field Set as :If $LedgerSalesTotal >500000 then $LedgerSalesTotal else " " Width : 15 Border : Thin Right
The Solution to that code --- for faster process ---- is also given above. You must read all the posts and adopt the updates or corrections in the code if any.