ITEM AND LEDGER SUMMARY

WITH THIS TALLY TDL FILE YOU CAN SEE ITEM WISE SALE SUMMARY AND PARTIES VOUCHER WISE TRANSACTION REPORTS. IT WILL BE VERY USEFUL FOR OUTSTANDING COLLECTION AND FOR STOCK SUMMARY.

[#Menu: Display Menu] Add: Item: Unique Sale Summary : Menu: Unique Sale Summary [Menu: Unique Sale Summary] Key Item: ITEM WISE : T : Display : ProductwiseRpt Item : Blank Key Item: LEDGER SUMMARY : S : Display Collection: TransVchLedgerColl Item : Blank [Report: LWLL] Use : DSP Template Form : LWLL Variable : DoSetAutoColumn, PName Repeat : PName Set : DoSetAutoColumn : Yes Set : DSPRepeatCollection : “LEARN Party” Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate [Form: LWLL] Use : DSP Template Parts : LWLL Background : White, Light Orange Option : Set Auto Vch Option : ##DoSetAutoColumn AND $$SetAutoColumns:PName [!Form: Set Auto Vch Option] [Part: LWLL] Lines : LWLL Title, LWLL Details BottomLines : LWLL Total Repeat : LWLL Details : Smp Stock Item Scroll : Vertical CommonBorder: Yes Total : LWLL Party, LWLL Col Total [Line: LWLL Title] Use : LWLL Details Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : LWLL Name : Set as : “Particulars” Local : Field : LWLL Name : Widespaced: Yes Local : Field : LWLL Party : Set as : ##PName Local : Field : LWLL Party : Lines : 0 Local : Field : LWLL ColTotal : Set as : “Total” Border : Flush Totals [Line: LWLL Details] Fields : LWLL Name, LWLL Party, LWLL Col Total Repeat : LWLL Party Total : LWLL Party [Field: LWLL Name] Use : Name Field Set as : $IName Display : Stock Vouchers Variable : Stock Item Name [Field: LWLL Party] Use : Qty Primary Field Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQty:@MyFormula:LEARNSummVoucher MyFormula : ##PName + #LEARNRepName Format : “NoZero” Border : Thin Left [Field: LWLL Col Total] Use : Qty Primary Field Set as : $$Total:LEARNRepParty Border : Thin Left [Line: LWLL Total] Fields : LWLL Name, LWLL Party, LWLL Col Total Repeat : LWLL Party Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : LWLL Name : Set as : “Total” Local : Field : LWLL Name : Widespaced: Yes Local : Field : LWLL Party : Set as : $$Total:LEARNRepParty Local : Field : LWLL ColTotal : Set as : $$Total:LEARNRepColTotal Border : Thin Top [Collection: LEARN Voucher] Type : Voucher Filter : IsSalesVT [Collection: LEARN Summ Voucher] Source Collection : LEARN Voucher Walk : Inventory Entries By : PName : $PartyLedgerName By : IName : $StockItemName Aggr Compute : BilledQty : SUM : $BilledQty Search Key : $PName + $IName [Collection: Smp Stock Item] Source Collection : LEARN Voucher Walk : Inventory Entries By : IName : $StockItemName Aggr Compute : BilledQty : SUM : $BilledQty Filter : NonEmptyQty [Collection: LEARN Party] Source Collection : LEARN Voucher Walk : Inventory Entries By : PName : $PartyLedgerName Aggr Compute : BilledQty : SUM : $BilledQty Filter : NonEmptyQty [Variable: PName] Type : String Repeat : ##DSPRepeatCollection [System: Formula] IsSalesVT : $$IsSales:$VoucherTypeName NonEmptyQty : NOT $$IsEmpty:$BilledQty [Report: ProductwiseRpt] Use : DSP Template Form : ProductwiseRpt Title : “Product-wise Sales Summary Report” [Form: ProductwiseRpt] Use : DSP Template Parts : ProductwiseRptHdr, ProductwiseRpt Height : 100% Screen Width : 100% Screen Delete : Buttons : ExplodeFlag Delete : Bottom Buttons : DSPAutoColumns, BudgetAnalysis, ReportConfig [Part: ProductwiseRptHdr] Lines : ProductwiseRptHeader [Line: ProductwiseRptHeader] Field : Name Field Right Field : DSP MainDateTitle Local : Field : Name Field : Set as : $$LocaleString:”Inventory Details” Local : Field : Name Field : Style : Normal Bold Space Bottom: 1 [Part: ProductwiseRpt] Lines : ProductwiseRptTitle, ProductwiseRptInfo Repeat : ProductwiseRptInfo : SummaryColl Scrolled : Vertical Common Borders : Yes Border : Thin Bottom Float : No [Line: ProductwiseRptTitle] Use : ProductwiseRptInfo Local : Field : Default : Type : String Local : Field : Default : Lines : 0 Local : Field : Default : Style : Normal Bold Local : Field : ProductTotalAmt : Align : Centre Local : Field : ProductMaxRate : Align : Centre Local : Field : ProductMinRate : Align : Centre Local : Field : ProductName : Set as : “Particulars” Local : Field : ProductTotalAmt : Set as : “Total Quantity” Local : Field : ProductMaxRate : Set as : “Maximum Rate” Local : Field : ProductMinRate : Set as : “Minimum Rate” Border : Thin Column Titles [Line: ProductwiseRptInfo] Fields : ProductName Right Fields : ProductTotalAmt, ProductMaxRate,ProductMinRate Local : Field : Default : Style : Normal [Field: ProductName] Use : Name Field Set as : $StockItemName Display : Stock Vouchers Variable : Stock Item Name [Field: ProductTotalAmt] Use : Qty Primary Field Set as : $StkTotalQty Border : Thin Left Right Width : 10 [Field: ProductMaxRate] Use : Rate Field Set as : $StkMaxRate Border : Thin Right Width : 10 [Field: ProductMinRate] Use : Rate Field Set as : $StkMinRate Border : Thin Right Width : 10 [Collection: SalesVouchersColl] Type : Voucher Filter : OnlySalesCreditNote [Collection: SummaryColl] Source Collection : SalesVouchersColl Walk : Inventory Entries By : StockItemName : $StockItemName Aggr Compute : StkTotalQty : Sum : $BilledQty Aggr Compute : StkMinRate : Min : $Rate Aggr Compute : StkMaxRate : Max : $Rate Keep Source : No Sort : Default : $StockItemName [System: Formula] OnlySalesCreditNote : $$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName [Collection: TransVchLedgerColl] Use : Ledger Report : Transact Report Trigger : Ledger Name Variable : Ledger Name [Report: Transact Report] Use : DSP Template Form : TransVchReport Variable : Ledger Name [Form: TransVchReport] Use : DSP Template Part : LV Title, TransVchTitle, TransVchBody Width : 100% Screen Height : 100% Screen Delete : Buttons : ExplodeFlag Delete : Bottom Buttons : DSPAutoColumns, BudgetAnalysis, ReportConfig Local: Line : LV Title : Local : Field : LV Title : Local : Field: Simple Prompt : Info : $$LocaleString:”Ledger” Local: Line : LV Title : Local : Field : LV Title : Local : Field: Name Field : Set as : #LedgerName [Part: TransVchTitle] Lines : TransVchTitle [Line: TransVchTitle] Use : TransVchLedDetail Local : Field : Default : Type : String Local : Field : Default : Align : Centre Local : Field : Default : Style : Normal Bold Local : Field : TransVchTypeName : Set as : “Voucher Type Name” Local : Field : TransVchDrAmt : Set as : “Debit Amt” Local : Field : TransVchCrAmt : Set as : “Credit Amt” Border : Thin Top Bottom [Part: TransVchBody] Lines : TransVchLedDetail Bottom Lines: TransVchLedTotal Repeat : TransVchLedDetail : TransVchSummaryColl Scroll : Vertical CommonBorder: Yes Total : TransVchDrAmt, TransVchCrAmt [Line: TransVchLedDetail] Fields : TransVchTypeName Right Fields : TransVchDrAmt, TransVchCrAmt Local : Field : Default : Style : Normal [Field: TransVchTypeName] Use : Name Field Set as : $TransVchName [Field: TransVchDrAmt] Use : Amount Forex Field Set as : $TransVchDrAmt Border : Thin Left Right [Field: TransVchCrAmt] Use : Amount Forex Field Set as : $TransVchCrAmt Border : Thin Right [Line: TransVchLedTotal] Use : TransVchLedDetail Local : Field : Default : Style : Normal Bold Local : Field : TransVchTypeName : Set as : “Total” Local : Field : TransVchDrAmt : Set as : $$Total:TransVchDrAmt Local : Field : TransVchCrAmt : Set as : $$Total:TransVchCrAmt Border : Thin Top Bottom [Collection: TransVchColl] Type : Voucher [Collection: TransVchSummaryColl] SourceCollection: TransVchColl Walk : Ledger Entries By : TransVchName : $VoucherTypeName By : TransVchLed : $LedgerName Aggr Compute : TransVchDrAmt : Sum : If $$IsDr:$Amount then $Amount else “” Aggr Compute : TransVchCrAmt : Sum : If NOT $$IsDr:$Amount then $Amount else “” Filter : TransVchFilter ;; Filtering done here to retrieve only values pertaining to the requested Party [System: Formula] TransVchFilter : #LedgerName = $TransVchLed TransVchOpBal : $OpeningBalance:Ledger:#LedgerName TransVchClBal : $ClosingBalance:Ledger:#LedgerName ;;WWW.LEARNWELLS.COM

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 

Now your TDL is ready to use.

1 thought on “ITEM AND LEDGER SUMMARY”

  1. SIR KOI ASI TDL JO DAILY SALE PUR PURCHASE KI DETAIL AK HI JAGHA DIKHAI DE ( MUJHE DAILY STOCK MAINTAIN KE LIYE CHAIYE ) OR SIRF VO DI PRODUCT DIKHAI DE JO AK HI DATE ME SALE PURCHASE HUI HO

    Reply

Leave a Comment