Dear Experts, I Created Commission Rates for Stock Items in Stock Item Master as below and its UDF is STDCOMM now I would like to generate a detailed stock report including standard commission but std commission value is not getting, Please help me Code is below
[#Menu:Gateway of Tally] Add:Key Item:before@locQuit:Item List:Iisplay:MSPItems [Report: MSPItems] Use : DSP Template Form : MSPItems [Form: MSPItems] Use : DSP Template Part : MSPItemsT, MSPItemsR Width : 100% Screen Background:white Bottom Part : LW Note Bottom Toolbar Buttons : BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10 [Part : MSPItemsT] Line : MSPItemsT [Line : MSPItemsT] Use : MSPItemsR Local : Field : LWsrn: Set as : "Srn" Local : Field : LWItmName: Set as : "Stock Item Name" Local : Field : LWItmAlias: Set as : "Alias" Local : Field : LWItmGrp: Set as : "Group" Local : Field : LWItmUnit: Set as : " Unit" Local : Field : LWItmHSN: Set as : "HSN" Local : Field : LWItmGSTP: Set as : "GST%" Local : Field : LWPrCst: Set as : "STRD.COST" Local : Field : LWSlCst: Set as : "SELL RATE" Local : Field : STDCOMM: Set as : "STRD.COMM" Local : Field : LWMrp: Set as : "MRP" Local : Field : LWItmGstOP: Set as : "Opening Qty." Local : Field : LWOpValue: Set as : "Opening Value" Local : Field : LWClsQty: Set as : "Closing Qty." Local : Field : LWClsValue: Set as : "Closing Value" Border : Column Titles Option : Alter On Enter [Part : MSPItemsR] Line : MSPItemsR Repeat : MSPItemsR: MSPItemsR;STOCKITEM Scroll : Vertical Float : No Common Border : Yes [Line : MSPItemsR] Field : LWsrn,LWItmName,LWItmAlias,LWItmGrp,LWItmUnit,LWItmHSN,LWItmGSTP,LWPrCst,LWSlCst,LWMrp,STDCOMM,LWItmGstOP,LWOpValue,LWClsQty,LWClsValue [Field : LWsrn] Use : Short Name Field Set as : $$Line Style : Normal Width : 4 Align : Centre [Field : LWItmName] Use : Name Field Set as : $NAME Width : 40 Style : Normal Bold Border : Thin Left Alter:StockItem [Field : LWItmAlias] Use :Name Field Set as : $OnlyAlias Style : Normal Width : 15 Align : Centre Border : Thin Left [FIELD:LWItmGrp] USE:Simple Field SET AS:$Parent Width : 10 Style : Normal Border : Thin Left [FIELD:LWItmUnit] USE:Simple Field SET AS:$BaseUnits Width : 8 Style : Normal Border : Thin Left [FIELD:LWItmHSN] USE:Simple Field SET AS:$GSTDetails[Last].HSNCode Width : 8 Style : Normal Border : Thin Left [FIELD:LWItmGSTP] USE:Simple Field Set as:$(StockItem, $Name).GstDetails[Last].STATEWISEDETAILS[1].RateDetails[1, @@IsIGST].GSTRate Width : 8 Style : Normal Border : Thin Left [FIELD:LWPrCst] USE: SIMPLE FIELD SET AS: $STANDARDCOST Width : 12 Style : Normal Border : Thin Left [FIELD:LWSlCst] USE: SIMPLE FIELD SET AS: $STANDARDPRICE Width : 12 Style : Normal Border : Thin Left [FIELD:LWMrp] Use : Name Field Set As : $MRPDetails[Last].MRPRateDetails[Last].MRPRate Width : 12 Style : Normal Border : Thin Left [FIELD:STDComm] Use : SIMPLE Field Set As : $Stdcomm;:KGNSwIwRptCmsnRatePricexx;:Last:KGNSwIwRptCmsnRateDate Width : 12 Style : Normal Border : Thin Left [Field : LWItmGstOP] Use : Simple Field Set as : $OpeningBalance Width : 12 Style : Normal Border : Thin Left [Field : LWOpValue] Use : Simple Field Set as : $OpeningValue Width : 12 Style : Normal Border : Thin Left [Field : LWClsQty] Use : Name Field Set as : $ClosingBalance Width : 12 Style : Normal Border : Thin Left [Field : LWClsValue] Use : Name Field Set as : $ClosingValue Width : 12 Style : Normal Border : Thin Left [Part : LW Note] Line : LW Note [Line : LW Note] Field : LW Note [Field : LW Note] Set as : "Ctrl+Enter to Edit Item" Color : Red Style : Large bold Fullwidth : yes Align:Center Border:Thin box [ Collection : MSPItemsR] Source Collection : Stockitem Type:StockItem Compute:StdComm:$KGNKEMStkItmCmsnRate Fetch:*