Hey, I've Created a TDL for Item wise sales; But unable to fetch the MRP for the items. Here is the code, could you please help me with the same.. [#Menu : Gateway of Tally] Add: Item : Piyush Reports: Menu: Piyush Reports [Menu : Piyush Reports] Item : Load (Item Wise) : Display : Item Wise Report [Report :Item Wise Report] Form :Item Wise Report Variable : SVFromDate,SVToDate Set : SVFromDate : $$CurrentDate Set : SVToDate : $$CurrentDate Variable : EBFVoucherNumberFrom,EBFVoucherNumberTo Set : EBFVoucherNumberFrom : $$SysName:NotApplicable Set : EBFVoucherNumberTo : $$SysName:NotApplicable [Form :Item Wise Report] Part : DSP AccTitles,MyReportTitle,Item Wise ReportTL,Item Wise Report Page Break : DSP ClPageBreak, CyDSPOpPageBreak Full Width : No Space Top : If $$InPrintMode Then 0.2 Else 0 inches Space Bottom : If $$InPrintMode Then 0.25 Else 0 inches Space Left : If $$InPrintMode Then 0.25 Else 0 inches Space Right : If $$InPrintMode Then 0.25 Else 0 inches Button : F2Change Period,EBFIsOfSelectedVchNo Bottom Buttons : BlankButton, InvReports, AcctReports, Report Operations, DYBKConfigure, FilterButton, ValueButton Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12 Buttons : PrintButton, ExportButton, UploadButton, MailButton Background : @@SV_UNYELLOW [Part : CyDSPOpPageBreak] Parts : DSP OpCompanyName,DSP Op ReportTitle,Item Wise ReportTL Vertical: Yes [Part : MyReportTitle] Line :MyReportTitle [Line :MyReportTitle] Field : Simple Field Local : Field : Simple Field : Set As : "Item Wise Load (Piyush Kankaria Format) from - " + $$String:##SVFromDate +" to " + $$String:##SVToDate Local : Field : Simple Field : Style : Normal Bold [Part : Item Wise ReportTL] Line : Item Wise ReportTL Border : Column Titles [Line : Item Wise ReportTL] Use : Item Wise Report Local : Field : Default : Type : string Local : Field : SRNO : Set As : "Sl. No." Local : Field : Item Wise ReportItem : Set As : "Particulars" Local : Field : MyItemsSalesMRP : Set As : "MRP" Local : Field : MyItemsSalesQty: Set As : "Sales Qty" Local : Field : MyItemsSalesRate : Set As : "Rate" Local : Field : MyItemsSalesAmount : Set As : "Sales Value" Local :Field : Default : Style : Small Bold [Part :Item Wise Report] Lines : Item Wise Report BottomLines:Item Wise ReportTotal Repeat : Item Wise Report :MySalesItems Scroll : Vertical Float : Yes Total : MyItemsSalesQty,MyItemsSalesAmount CommonBorder : Yes [Line :Item Wise Report] Left Field : SRNO Right Field : Item Wise ReportItem,MyItemsSalesMRP,MyItemsSalesQty,MyItemsSalesRate,MyItemsSalesAmount Border : Thin bottom [Field: SRNO] Use: Simple Field Set as: $$Line Width : 4 Format: "No Zero" Style:Normal Align: Center [Field : Item Wise ReportItem] Set As : $Stockitem Width : 40% Screen Style : Normal Display : Item Monthly Summary Variable : StockitemName Border : Thin Left [Field : MyItemsSalesMRP] Use : Number Field Style : Normal SET : $MrpRate Border : Thin Left Width : 10 [Field : MyItemsSalesQty] Use : Qty Primary Field Style : Normal Set As : $ActualQty Border : Thin Left Width : 10 [Field : MyItemsSalesRate] Use : Rate Price Field Set as : $Rate Style : Normal Border : Thin Left Width : 10 [Field : MyItemsSalesAmount] Use : Amount Field Set As : $Amount Style : Normal Border : Thin Left Right [Line : Item Wise ReportTotal] Use : Item Wise Report Local : Field : Item Wise ReportItem : Set As : "Total" Local : Field : MyItemsSalesQty : Set As : $$Total:MyItemsSalesQty Local : Field : MyItemsSalesAmount : Set As : $$Total:MyItemsSalesAmount Local : Field : Default : Style : Small Bold Border: Thin Top Bottom [Collection : MySalesSummaryCollection] Title : "List of Sales vouchers" Type : Vouchers : VoucherType Child of : $$VchTypeSales Belongs to : Yes Format : $VoucherNumber, 20 Fetch : VoucherNumber Fetch : Inventory Entries Filter : EBFIsOfSelectedVchNo Sort : @@InvoiceNumberIncr : $VoucherNumber [Collection : MySalesItems] Source Collection : MySalesSummaryCollection Walk : Inventory Entries By : StockItemName : $StockItemName Sort : StockItemName : $StockItemName Aggr Compute : ActualQty : Sum : $ActualQty Aggr Compute : Rate : Sum : $Rate Aggr Compute : Amount : Sum : $Amount Keep Source : (). [Button : EBFIsOfSelectedVchNo] Key : Alt+V Title : Selected Vch No Action : Alter:EBFIsOfSelectedVchNo [Report: EBFIsOfSelectedVchNo] Form : EBFIsOfSelectedVchNo [Form : EBFIsOfSelectedVchNo] Part : SelectedVchNoHead,EBFIsOfSelectedVchNo Width : 30% page [Part : SelectedVchNoHead] Line : SelectedVchNoPart1 Space Bottom :0.20 cm [Line: SelectedVchNoPart1] Fields : Name Field Local : Field: Name Field : Info : "Voucher Filter" Local : Field: Name Field : Style : SelectedVchNoStyle Local : Field: Name Field : Border : Double Bottom Local : Field: Name Field : Align : Center Local : Field: Name Field : Full Width : Yes [Style: SelectedVchNoStyle] Use : Normal Bold Height : 12 Italic : Yes [Part : EBFIsOfSelectedVchNo] Line : EBFVoucherNumberFrom,EBFVoucherNumberTo [Line : EBFVoucherNumberFrom] Field : Medium Prompt,EBFVoucherNumberFrom Local : Field : MediumPrompt :Info : "Voucher No.From:" [Field : EBFVoucherNumberFrom] Use : Name Field Modifies : EBFVoucherNumberFrom Table : MySalesSummaryCollection, Not Applicable Show Table : Default [Line : EBFVoucherNumberTo] Field : MediumPrompt,EBFVoucherNumberTo Local : Field : MediumPrompt :Info : "Voucher No.To:" [Field :EBFVoucherNumberTo] Use : Name Field Modifies : EBFVoucherNumberTo Set always : Yes Table : MySalesSummaryCollection, Not Applicable Show Table : Default [System : Variable] EBFVoucherNumberFrom : ($$SysName:NotApplicable) EBFVoucherNumberTo : ($$SysName:NotApplicable) [Variable : EBFVoucherNumberFrom] Type : String volatile : Yes Default : ($$SysName:NotApplicable) [Variable :EBFVoucherNumberTo] Type : String Volatile : Yes Default : ($$SysName:NotApplicable) [System :Formula] EBFIsOfSelectedVchNo:If (($$ExactMatch:##EBFVoucherNumberFrom:$$SysName:NotApplicable) OR ($$IsEmpty:##EBFVoucherNumberFrom)) AND (($$ExactMatch:##EBFVoucherNumberTo:$$SysName:NotApplicable) OR ($$IsEmpty:##EBFVoucherNumberTo)) Then yes else + ($$Number:$VoucherNumber >= $$Number:##EBFVoucherNumberFrom) AND ($$Number:$VoucherNumber <=$$Number:##EBFVoucherNumberTo)
you haven't written any "compute" or "fetch" in your collection, from where did you get that $MRPrate