Notifications
Clear all
General Tally Queries
2
Posts
2
Users
0
Reactions
483
Views
Topic starter
21/11/2025 3:06 pm
I am new to tally . Unable to get the rows in the report..only the headings are displayed and no data
;; Collection that gathers all sales voucher lines
[Collection: SalesInvoiceLinesCollection]
Type : Voucher
Walk : InventoryEntries
By : Date : $Date
By : VoucherNumber : $VoucherNumber
By : StockItemName : $StockItemName
By : PartyLedgerName : $PartyLedgerName
By : BilledQty : $BilledQty
By : Amount : $Amount
By : Rate : $Rate
Filter : IsSalesVoucher
Sort : Date, VoucherNumber
[System: Formula]
IsSalesVoucher : $$IsSales:$VoucherTypeName
[#Menu: Gateway of Tally]
Add: Item: Custom Sales Report : Display : Custom Sales Report
[Report: Custom Sales Report]
Title : "Sales Invoice Party & Itemwise Report"
Form : Custom Sales Report Form
[Form: Custom Sales Report Form]
Part : SalesLinesHeader, SalesLinesBody
Space Top : if $$InPrintMode Then ##SVSpaceTop else 0.05 inches
Space Bottom : if $$InPrintMode Then 0.5 else 0 inches
Space Left : if $$InPrintMode AND $$InPixelMode then 0.5 else 0 inches
Space Right : if $$InPrintMode AND $$InPixelMode then 0.25 else 0 inches
Option : Small Size Form : NOT $$InPrintMode
Width : 100% Screen
Height : 100% Screen
[Part: SalesLinesHeader]
Line : SalesLinesHeaderLine
Scroll : Vertical
[Line: SalesLinesHeaderLine]
Field : DateHeading, VoucherNoHeading, ItemHeading, ParticularsHeading, BilledQtyHeading, IPRRateHeading, RateHeading
[Field: MediumPrompt1]
Use : Name Field
Set as : "Sales Invoice Report"
Width : 40
Align : Center
Style : Small bold
[Field: DateHeading]
Use : Name Field
Set as : "Date"
Width : 12
Align : Left
[Field: VoucherNoHeading]
Use : Name Field
Set as : "Vch No"
Width : 10
Align : Left
[Field: ItemHeading]
Use : Name Field
Set as : "Item"
Width : 25
Align : Left
[Field: ParticularsHeading]
Use : Name Field
Set as : "Particulars"
Width : 30
Align : Left
[Field: BilledQtyHeading]
Use : Name Field
Set as : "BilledQty"
Width : 10
Align : Right
[Field: IPRRateHeading]
Use : Name Field
Set as : "Purch Rate"
Width : 12
Align : Right
[Field: RateHeading]
Use : Name Field
Set as : "Rate"
Width : 12
Align : Right
;; Body part: repeated lines from the collection
[Part: SalesLinesBody]
Line : SalesLinesRepeatLine
Repeat : SalesLinesRepeatLine : SalesInvoiceLinesCollection
Scroll : Vertical
;;Fetch : Date ;; Ensure collection fetches Date
[Line: SalesLinesRepeatLine]
Field : FDate, FVchNo, FItem, FParticulars, FBilledQty, FIPRRate, FRate
[Field: FDate]
Use : Name Field
Set as : $$String:##Date ;; fetched Date
Width : 12
Align : Left
[Field: FVchNo]
Use : Name Field
Set as : $$String:##VoucherNumber
Width : 10
Align : Left
[Field: FItem]
Use : Name Field
Set as : $$String:##StockItemName ;; typical field - replace if different
Width : 25
Align : Left
[Field: FParticulars]
Use : Name Field
Set as : $$String:##PartyLedgerName ;;$$String:##Particulars ;; often stored as Particulars or Narration
Width : 30
Align : Left
[Field: FBilledQty]
Use : Number Field
Set as : ##BilledQty ;; typical name for billed qty on line
Width : 10
Align : Right
Format : "Qty"
[Field: FIPRRate]
Use : Amount Field
Set as : ##Amount ;; replace with your purchase-rate field name/UDF if different
Width : 12
Align : Right
Format : "Amount"
[Field: FRate]
Use : Amount Field
Set as : ##Rate ;; selling rate (line-level)
Width : 12
Align : Right
Format : "Amount"
Tally Version
04/06/2026 10:25 am
It looks like the collection is being populated, but the report fields may not be referencing the collection values correctly.
A few things you can check:
- In the collection, try adding a
Fetchstatement for the required fields:Fetch : Date, VoucherNumber, PartyLedgerName, StockItemName, BilledQty, Rate, Amount - In the report fields, use
$FieldNameinstead of##FieldNamewhere appropriate, since##is generally used for variables rather than collection methods. - Verify that the company contains Sales vouchers with inventory entries. If the vouchers are accounting-only sales vouchers, the
Walk : InventoryEntriescollection may return no records. - You can also add a temporary field showing
$$CollectionCount:SalesInvoiceLinesCollectionto confirm whether records are being collected.
If you're looking for an easier way to analyze sales invoices by party, item, quantity, rate, and amount without custom TDL development, Reporting tools can provide these reports directly from Tally with filters, dashboards, and export options.