Not Working please See....... And Suggest Possible Solutions. [#Line : LV Title] Add : Field : After : LEDMailName : RJSelectedTitle,RJSelected Use : SelectedAmt [Field : RJSelectedTitle] Use : Short Name Field Set as :"Selected Total :-" Color : Black [Field : RJSelected] Use : Amount Field Set As : @@onlyselected Color : Black Format : "Drcr" [System : Formulae] OnlySelected : $$Total:VchAmount [#Collection : Vouchers of Company] Fetch : Amount,MasterId, VoucherNumber, VoucherTypeName,LedgerName Fetch : InventoryEntries.* Fetch : AllInventoryEntries.StockitemName, AllInventoryEntries.ActualQty, AllInventoryEntries.Rate, AllInventoryEntries.Amount Fetch : LedgerEntries.* [Collection : SelectedAmt] Use : Voucher Walk : Voucher Entries Fetch : Amount,MasterId, VoucherNumber, VoucherTypeName Fetch : InventoryEntries.* Fetch : AllInventoryEntries.StockitemName, AllInventoryEntries.ActualQty, AllInventoryEntries.Rate, AllInventoryEntries.Amount Fetch : LedgerEntries.* Data Source : Report : Selected Aggr Compute : VchAmount : Sum : $Amount Keep Source : ().
I would suggest as under: Code: [#Line : LV Title] Add : Field : After : LEDMailName : RJSelectedTitle,RJSelected Use : SelectedAmt [Field : RJSelectedTitle] Use : Short Name Field Set as :"Selected Total :-" Color : Black [Field : RJSelected] Use : Amount Field Set As : $VchAmount Color : Black Format : "DrCr" [Collection: SelectedAmt] Data Source : Report : Selected Fetch : All Ledger Entries Aggr Compute : VchAmount : Sum : $Amount
This is for Debit side amount.. You know there are two sides in vouchers... Code: [#Line : LV Title] Add : Field : After : LEDMailName : RBCLineselectedTotal [#Line : DSP VchDetail] Option : RBCSelectedLinesTotalOnFocus : ##IsLedgerReport [Field : RJSelectedTitle] Use : Short Name Field Set as :"Selected Total :-" Color : Black [!Line: RBCSelectedLinesTotalOnFocus] ;Line to Call Selected BillsTotal Function On : Focus : Yes : Call : RBCSelectedLinesTotal [Function: RBCSelectedLinesTotal] 0010 : Set : RBCSelectedLinesTotal : ($$CollAmtTotal:RBCSelectedLinesColl:$TotalLedVchAmt) 0011 : Set : RBCIsLineselected : (NOT $$IsEmpty:##RBCSelectedLinesTotal) [Field: RBCLineselectedTotal] Use : Name Field Set as : if ##RBCIsLineselected AND NOT $$IsEmpty:($$ReportObject:$$CollAmtTotal:RBCSelectedLinesColl:$TotalLedVchAmt) Then $$String:@SelectedTotal + $$String:@SelectedTotalVal Else "" Width : 60 Align : Centre Invisible : NOT ##IsLedgerReport OR NOT $$InDisplayMode SelectedTotal : $$LocaleString:"Entries Selected for : " SelectedTotalVal: $$String:##RBCSelectedLinesTotal:"DrCr" [System: Variables] RBcSelectedLinesTotal : 0 RBCIsLineselected : NO [Variable: RBcSelectedLinesTotal] Type : Amount [Variable: RBCIsLineselected] Type : Logical [Collection:RBCSelectedLinesColl] Data Source : Report : Selected Fetch : Name, TotalLedCrVchAmt,TotalLedDrVchAmt, TotalLedVchAmt Client Only : Yes
Sir Excellent work Please add More When We select the Line it will get some colour How Many Lines we are selected its total also appear In Daybook its also work When we do ledger as a columinar mode its show that total also
Refer .... http://tdlexpert.com/index.php?threads/daybook-selected-items-total.6014/#post-21130 Mr. Jaykumar will achieve the same..... wait for it...........
Jay Kumarji, CA Deendraji & Amitji Thank you very much for sharing & Inspiring... I got Selected Lines Total for Debit, Credit and Also Net Amount in Ledger and also in DayBook. Really enjoying... Once again Thanks to All.
@garima sir, thank you so much for your code, it's perfectly working. I've made a slight change to your code, I added color, height, and background to the code. see this image
@Bipin Damania, not showing in the daybook , in my tally only showing in ledger vouchers, so how to show in the daybook also.
@Bipin Damania sir cant understand. how to get this type of total, [ dr. total, cr.total, net amount ] separate total like displayed in your screenshot
sir when we are calculating sales, sales return, CN ,DN separate for re check of calculation, it will be more useful as Default Tally is not giving facility to use of Alt+R and Alt+U here so same if we can calculate by TDL, we can recheck the total value of CN , DN sales in month.
Check this one http://tdlexpert.com/index.php?threads/improvement-in-gst-returns-display-reports.6550/#post-25084
Hi All Jay Here, Try This For Net Total For 1. Daybook Selected Entries 2. Statics Vouchers (For Sub Values Selection You Will Need To Move Cousor Over Entries) Enjoy Code With Colours........ [#Form: Normal Day Book] Add:Bottom Parts : Daybook Total [Part : Daybook Total] Line : Daybook cr [Line : Daybook cr] Field : LineselectedTotal1 Right Field : Daybook dr, Daybook cr [Field : Daybook dr] Use : Amount Forex Field Set as : $$TotalSPDBDrAmt [Field : Daybook cr] Use : Amount Forex Field Set as : $$TotalSPDBcrAmt [#Part: DB Body] Total: DSP DBCrAmt,DSPDBDrAmt [#Line : DSP VchDetail] Option : SelectedLinesTotalOnFocus1 [!Line: SelectedLinesTotalOnFocus1] ;Line to Call Selected BillsTotal Function On : Focus : Yes : Call : SelectedLinesTotal1 [Function: SelectedLinesTotal1] 0010 : Set : SelectedLinesTotal1 : ($$CollAmtTotal:SelectedLinesColl1:$Amount) 0012 : Set : IsLineselected1 : (NOT $$IsEmpty:##SelectedLinesTotal1) [Field: LineselectedTotal1] Use : Name Field Set as : if ##IsLineselected1 AND NOT $$IsEmpty$$ReportObject:$$CollAmtTotal:SelectedLinesColl1:$Amount) Then $$StringSelectedTotal1 + $$StringSelectedTotalVal1 Else "" Width : 30 Align : Centre SelectedTotal1 : $$LocaleString:"Entries Selected for : " SelectedTotalVal1: $$String:##SelectedLinesTotal1:"DrCr" Background : if ##IsLineselected1 AND NOT $$IsEmpty$$ReportObject:$$CollAmtTotal:SelectedLinesColl1:$Amount) Then "Rosy Brown" Else @@SV_DAYBOOK Invisible : ##IsLedgerReport [System: Variables] SelectedLinesTotal1 : 0 IsLineselected1 : NO [Variable: SelectedLinesTotal1] Type : Amount Persistent : Yes [Variable: IsLineselected1] Type : Logical [Collection:SelectedLinesColl1] Data Source : Report : Selected Fetch : Amount Client Only : Yes [#System: Formula] SV_SEL_CURSOR_BG : Rosy Brown SV_SEL_CURSOR_FG : Released green SV_SELECTED_BG : Maron SV_SELECTED_FG : Released Blue