Only for Debtors & Creditors Ledgers. 1. Normal Ledger screen 2. Bill-wise Outstanding 3. Ageing as per Bill Date 4. Ageing as per Due Date Work ongoing on 3 & 4.
Nice Ji, I think you fixed that Age-wise Periods. Give it in Based on Configuration. Because Customers may use Different set of days.
amit sir i have started recently using against reference in receipts its also showing previous references which have been settled without reference option is there any way in tally to hide those old invoices
Yet to start work on the age-wise for this though.................. Yes I am thinking on same line though............ default will be this set period and i think the default period-sets is more or less standard and meaningful. However customer choice will also be done..... yet to figure out a way for this. Been working few weeks to get these 4 together. will work on age-wise in a few days.
Not possible in conventional way ....either set-off the same or don't use references...........only these 2 options. By TDL way.....you need to find the Collection for these pending bills and introduce a filter for date cut-off.
But i need help also...... see code below........ [Collection : Monthly Ledger TiO] Use : List of Ledgers Variable : LedgerName Report : LedgerDisplayTiO Trigger : LedgerName Fetch : Name, Parent Filter : IsLedgerDrsCrs [System : Formula] IsLedgerDrsCrs : $$IsBelongsTo:$$GroupSundryDebtors OR $$IsBelongsTo:$$GroupSundryCreditors This is working ----- but it display all LEDGERS, but allows to select Debtors/Creditors only.......... I want to display only Drs/Crs Ledgers...........
Try This Way [Collection : ABCD] Use : VLedTable Type : Ledger Fetch : Name Include : Group:$$GroupSundryDebtors, Group:$$GroupSundryCreditors
You can remove Use, and Add Trigger Variable. I use This way only. It is Working Or Else Check this Default Collection "Party Ledgers", There Same way Collections are there.
You are right...........i tried all that before.......... in normal it will work.... but here......... In this case........ Variable and trigger is required as common fodder for all 4 parts of my report.... when i comment them out, it does not open at all. Let me try other things as u said..............
Hi Maulik...tried that also.......... I think I will make another collection from scratch...............
Ji Check This Filter IsLedgerDrsCrs : $$IsGrpOfGrp:$Parent:$$GroupSundryDebtors OR $$IsGrpOfGrp:$Parent:$$GroupSundryCreditors
Amitji, Have you tried calling your own trigger report instead of LedgerName as default trigger will fetch all ledgers.
Dear Maulik, Tried that also long back ....but then my reports are deprived of a Variable and shows blank............ See screenshot below. Thing is during various R&D on permutations and combination.....one thing is sure........... if there is no variable and trigger in the collection, the whole 4-in-1 concept will not work.
Dear Amit, 4-in-1 concept is not a mater. You can use a single Variable in whole Report. You r using Default Trigger Report. Change Like This you can Get Result [Collection: VC Monthly Ledger] Type : Ledger Variable : Ledger Name Report : Ledger Vouchers Trigger : VC Ledger Name Fetch : Name Filter : VCOnlyDrCrLedger [Report: VC Ledger Name] Use : Ledger Name Local : Field : Ledger NAme : Delete : Table Local : Field : Ledger NAme : Add : Table : VC Monthly Ledger Local : Field : Ledger NAme : Local : Table : Default : Title : "List Of Parties" [System: Formulae] VCOnlyDrCrLedger : ($$IsGrpOfGrp:$Parent:$$GroupSundryDebtors) Or ($$IsGrpOfGrp:$Parent:$$GroupSundryCreditors)
Dear Amitji, Try below code Code: [Collection : Monthly Ledger TiO] Use : List of Ledgers Variable: LedgerName Report : LedgerDisplayTiO Trigger : MLKLedgerName Fetch : Name, Parent Filter : IsLedgerDrsCrs [Report: MLK Ledger Name];;Auto Report Use : Collection Variable Local : Line : Collection Variable : Field : MLK Ledger Name Local : Field: MV Title : Info : $$LocaleString:"Name of Ledger" [Field: MLK Ledger Name] Use : Name Field Key : Create Ledger Modifies : LedgerName Table : MLK List of Ledger Show Table : Always CommonTable : No [Collection : MLK List of Ledger] Use : List of ExtractLedgers Fetch : Name Format : $Name, Parent Filter : IsLedgerDrsCrs
Dear Maulik, This worked wonders.....many thanks..........never thought of using this way........ you are well experienced. See screenshot.........
Dear KNSivam, Thanks for your efforts..........now i can concentrate on Ageing Analysis in the coming days............ Any other ideas / opinions are welcome. Thanks again.