Notifications
Clear all
General Tally Queries
1
Posts
1
Users
0
Reactions
51
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