Hi All... Hope You Will Like..... ;========================================== Stock Item Details Book ======================================= [#Menu:Gate Way Of Tally] Add : Item : Item Address Book : Execute : ChageItemGroup [Report: Item Address Book] Title : "Ledger Master Reports" Form : StockItem_Report Variable : SvFromDate, SvToDate Set : SvFromDate : @@DSPFromDate Set : SvToDate : @@DSPToDate [Form: StockItem_Report] Button : ExportButton,MailButton,PrintButton Bottom Toolbar Buttons : BottomToolBarBtn1,BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10 Background : @@SV_BALANCESHEET Part : StockItem_ReportsHeading, StockItem_ReportsBody ; DSP AccTitles, Width : 100 % Page Height : 100 % Page Space Bottom : 0.50 Space Left : 0.50 Space Right : 0.50 Space Top : 0.50 Vertical Align : Center Horizontal Align : Center [Part: StockItem_ReportsHeading] Line:StockItem_ReportsHeading [Line: StockItem_ReportsHeading] Field: Name Field Local: Field : Name Field : Set as : "ITEM ADDRESS BOOK" Local: Field : Name Field : Style : Large Bold Local: Field : Name Field : Align : Center Local: Field : Name Field : Full Width : Yes Local: Field : Name Field : Color : Blue Local: Field : Name Field : Inactive : $$InExportMode Local: Field : Name Field : Skip : Yes Space Bottom : 0.25 cm [Part: StockItem_ReportsBody] Line : StockItem_ReportsTitle,StockItem_ReportsDesc Repeat : StockItem_ReportsDesc : StockItemColl Scroll : Both Vertical : Yes Common Border : yes Float : No Border : Thin Bottom [Line: StockItem_ReportsTitle] Field : Stockitem_SNo, Stockitem_ItemName Right Field : Stockitem_Alias,Stockitem_PartNo, Stockitem_Description,STKRemarks,Stockitem_Group,Stockitem_Category,Stockitem_UOM,STKAltUom,StkAlQty,STKBaseQty,Stockitem_Batches Right Field : STKTrackDate,STKExpiryDate,STKAltStandRate,STKStandCostApplicable,STKRate1,STKUom1,STKStandSellingPrice,STKRate2,STKUom2,STKGSTApplicable,STKApplicable,STKGSTDetails,STKHSNDesc,STKHSNCode Right Field : STKCalType,STKTaxability,STKIGSTRate,STKCessRate,STKTypeSupply,STKReportUQC,STKMRPDetails,STKApplicableFrom,STKMRPRate,STKUOM3,STKCosting,STKMarketVal,STKPhysicalCount,STKNegBalance Right Field : STKSalesMfg,STKPurchConsume,STKRejection,STKExpBatch,STKOBQty,STKGodown,STKBatchNo,STKMFDate,STKEXPDate,STKQty,STKRate3,STKBaseUom,STKAmount Border : Totals Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Border : Thin Left Local : Field : Default : Style : Large Bold Local : Field : Default : Skip : Yes Local : Field : Default : Line : 2 Local : Field : Stockitem_SNo : Set as : $$LocaleString:"SL NO." Local : Field : Stockitem_ItemName : Set as : $$LocaleString:"Item Name" Local : Field : Stockitem_Alias : Set as : $$LocaleString:"Item Alias" Local : Field : Stockitem_PartNo : Set as : $$LocaleString:"Part No." Local : Field : Stockitem_Description : Set as : $$LocaleString:"Description" Local : Field : STKRemarks : Set as : $$LocaleString:"Remarks" Local : Field : Stockitem_Group : Set as : $$LocaleString:"Stock Group" Local : Field : Stockitem_Category : Set as : $$LocaleString:"Stock Category" Local : Field : Stockitem_UOM : Set as : $$LocaleString:"UOM" Local : Field : STKAltUom : Set as : $$LocaleString:"Alternative UOM" Local : Field : StkAlQty : Set as : $$LocaleString:"Alternative QTY \n (For Conversion)" Local : Field : STKBaseQty : Set as : $$LocaleString:"Base Unit Qty \n (For Conversion)" Local : Field : Stockitem_Batches : Set as : $$LocaleString:"Maintaine Batches" Local : Field : STKTrackDate : Set as : $$LocaleString:"Track Date Of Manufracturing" Local : Field : STKExpiryDate : Set as : $$LocaleString:"Use Expiry Date" Local : Field : STKAltStandRate : Set as : $$LocaleString:"Alter Standard Rates" Local : Field : STKStandCostApplicable : Set as : $$LocaleString:"Standard Cost Applicable From" Local : Field : STKRate1 : Set as : $$LocaleString:"Rate" Local : Field : STKUom1 : Set as : $$LocaleString:"UOM" Local : Field : STKStandSellingPrice : Set as : $$LocaleString:"Standard Selling Price \n (Apllicable From)" Local : Field : STKRate2 : Set as : $$LocaleString:"Rate" Local : Field : STKUom2 : Set as : $$LocaleString:"UOM" Local : Field : STKGSTApplicable : Set as : $$LocaleString:"GST Applicable" Local : Field : STKApplicable : Set as : $$LocaleString:"Applicable From" Local : Field : STKGSTDetails : Set as : $$LocaleString:"Set/Alter GST Details" Local : Field : STKHSNDesc : Set as : $$LocaleString:"HSN/SAC Description" Local : Field : STKHSNCode : Set as : $$LocaleString:"HSN/SAC Code" Local : Field : STKCalType : Set as : $$LocaleString:"Calculation Type" Local : Field : STKTaxability : Set as : $$LocaleString:"Taxability" Local : Field : STKIGSTRate : Set as : $$LocaleString:"IGST Rate" Local : Field : STKCessRate : Set as : $$LocaleString:"Cess Rate" Local : Field : STKTypeSupply : Set as : $$LocaleString:"Type of Supply" Local : Field : STKReportUQC : Set as : $$LocaleString:"Reporting UQC" Local : Field : STKMRPDetails : Set as : $$LocaleString:"Set/Alter MRP Details" Local : Field : STKApplicableFrom : Set as : $$LocaleString:"Applicable From" Local : Field : STKMRPRate : Set as : $$LocaleString:"MRP Rate" Local : Field : STKUOM3 : Set as : $$LocaleString:"UOM" Local : Field : STKCosting : Set as : $$LocaleString:"Costing Method" Local : Field : STKMarketVal : Set as : $$LocaleString:"Market Valuation Method" Local : Field : STKPhysicalCount : Set as : $$LocaleString:"Ignore Due to Physical Counting" Local : Field : STKNegBalance : Set as : $$LocaleString:"Ignore Negative Balance" Local : Field : STKSalesMfg : Set as : $$LocaleString:"Treate All Sales as New Manufracture" Local : Field : STKPurchConsume : Set as : $$LocaleString:"Treate All Purchase as Consumed" Local : Field : STKRejection : Set as : $$LocaleString:"Treate All Rejection Inward as Scrap" Local : Field : STKExpBatch : Set as : $$LocaleString:"Use Expiredy Batches During Voucher Entry" Local : Field : STKOBQty : Set as : $$LocaleString:"Opening Balance Qty" Local : Field : STKGodown : Set as : $$LocaleString:"Godown Name" Local : Field : STKBatchNo : Set as : $$LocaleString:"Batch No" Local : Field : STKMFDate : Set as : $$LocaleString:"Manufracturing Date" Local : Field : STKEXPDate : Set as : $$LocaleString:"Expiry Date" Local : Field : STKQty : Set as : $$LocaleString:"Quantity" Local : Field : STKRate3 : Set as : $$LocaleString:"Rate" Local : Field : STKBaseUom : Set as : $$LocaleString:"Base UOM" Local : Field : STKAmount : Set as : $$LocaleString:"Amount" [Line:StockItem_ReportsDesc] Field : Stockitem_SNo, Stockitem_ItemName Right Field : Stockitem_Alias,Stockitem_PartNo, Stockitem_Description,STKRemarks,Stockitem_Group,Stockitem_Category,Stockitem_UOM,STKAltUom,StkAlQty,STKBaseQty,Stockitem_Batches Right Field : STKTrackDate,STKExpiryDate,STKAltStandRate,STKStandCostApplicable,STKRate1,STKUom1,STKStandSellingPrice,STKRate2,STKUom2,STKGSTApplicable,STKApplicable,STKGSTDetails,STKHSNDesc,STKHSNCode Right Field : STKCalType,STKTaxability,STKIGSTRate,STKCessRate,STKTypeSupply,STKReportUQC,STKMRPDetails,STKApplicableFrom,STKMRPRate,STKUOM3,STKCosting,STKMarketVal,STKPhysicalCount,STKNegBalance Right Field : STKSalesMfg,STKPurchConsume,STKRejection,STKExpBatch,STKOBQty,STKGodown,STKBatchNo,STKMFDate,STKEXPDate,STKQty,STKRate3,STKBaseUom,STKAmount Local : Field : Default : Style : Normal Explode : LedDup_ReportsDescExp1 Border : Thin TopBottom Option : Alter on Enter [Part : LedDup_ReportsDescExp1] Line : LedDup_ReportsDescExp1 Repeat : LedDup_ReportsDescExp1:StockGodownColl [Line : LedDup_ReportsDescExp1] Field : Stockitem_SNo, Stockitem_ItemName Right Field : Stockitem_Alias,Stockitem_PartNo, Stockitem_Description,STKRemarks,Stockitem_Group,Stockitem_Category,Stockitem_UOM,STKAltUom,StkAlQty,STKBaseQty,Stockitem_Batches Right Field : STKTrackDate,STKExpiryDate,STKAltStandRate,STKStandCostApplicable,STKRate1,STKUom1,STKStandSellingPrice,STKRate2,STKUom2,STKGSTApplicable,STKApplicable,STKGSTDetails,STKHSNDesc,STKHSNCode Right Field : STKCalType,STKTaxability,STKIGSTRate,STKCessRate,STKTypeSupply,STKReportUQC,STKMRPDetails,STKApplicableFrom,STKMRPRate,STKUOM3,STKCosting,STKMarketVal,STKPhysicalCount,STKNegBalance Right Field : STKSalesMfg,STKPurchConsume,STKRejection,STKExpBatch,STKOBQty,STKGodown,STKBatchNo,STKMFDate,STKEXPDate,STKQty,STKRate3,STKBaseUom,STKAmount Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Border : Thin Left ;Local : Field : Default : Style : Nomal Local : Field : Default : Line : 0 Local : Field : Default : Skip : Yes Local : Field : Stockitem_SNo : Set as : "" Local : Field : Stockitem_ItemName : Set as : "";$StockItemName Local : Field : Stockitem_Alias : Set as : "" Local : Field : Stockitem_PartNo : Set as : "" Local : Field : Stockitem_Description : Set as : "" Local : Field : STKRemarks : Set as : "" Local : Field : Stockitem_Group : Set as : "" Local : Field : Stockitem_Category : Set as : "" Local : Field : Stockitem_UOM : Set as : "" Local : Field : STKAltUom : Set as : "" Local : Field : StkAlQty : Set as : "" Local : Field : STKBaseQty : Set as : "" Local : Field : Stockitem_Batches : Set as : "" Local : Field : STKTrackDate : Set as : "" Local : Field : STKExpiryDate : Set as : "" Local : Field : STKAltStandRate : Set as : "" Local : Field : STKStandCostApplicable : Set as : "" Local : Field : STKRate1 : Set as : "" Local : Field : STKUom1 : Set as : "" Local : Field : STKStandSellingPrice : Set as : "" Local : Field : STKRate2 : Set as : "" Local : Field : STKUom2 : Set as : "" Local : Field : STKGSTApplicable : Set as : "" Local : Field : STKApplicable : Set as : "" Local : Field : STKGSTDetails : Set as : "" Local : Field : STKHSNDesc : Set as : "" Local : Field : STKHSNCode : Set as : "" Local : Field : STKCalType : Set as : "" Local : Field : STKTaxability : Set as : "" Local : Field : STKIGSTRate : Set as : "" Local : Field : STKCessRate : Set as : "" Local : Field : STKTypeSupply : Set as : "" Local : Field : STKReportUQC : Set as : "" Local : Field : STKMRPDetails : Set as : "" Local : Field : STKApplicableFrom : Set as : "" Local : Field : STKMRPRate : Set as : "" Local : Field : STKUOM3 : Set as : "" Local : Field : STKCosting : Set as : "" Local : Field : STKMarketVal : Set as : "" Local : Field : STKPhysicalCount : Set as : "" Local : Field : STKNegBalance : Set as : "" Local : Field : STKSalesMfg : Set as : "" Local : Field : STKPurchConsume : Set as : "" Local : Field : STKRejection : Set as : "" Local : Field : STKExpBatch : Set as : "" Local : Field : STKOBQty : Set as : "" Local : Field : STKGodown : Set as : $GodownName Local : Field : STKBatchNo : Set as : $BatchName Local : Field : STKMFDate : Set as : $MfdOn Local : Field : STKEXPDate : Set as : $ExpiryPeriod Local : Field : STKQty : Set as : $OpeningBalance Local : Field : STKRate3 : Set as : $OpeningRate Local : Field : STKBaseUom : Set as : "" Local : Field : STKAmount : Set as : $OpeningValue Empty : $$ExplodeOwner:#Stockitem_Godwon1=$GodownName Option : Alter on Enter ;Border : Thin Bottom [Field : Stockitem_SNo] Use : Number Field Set as : $$Line Width : 8 Format : "NoZero" Alter : StockItem Invisible:$$InExportMode [Field : Stockitem_ItemName] Use : Name Field Set as : $Name Full Width : Yes ;Color : Red [Field:Stockitem_Alias] Use : Name Field Set as : $OnlyAlias width : 15 [Field:Stockitem_PartNo] Use : Name Field Set as : $PartNo width : 15 Align : Center [Field:Stockitem_Description] Use : Name Field Set as : $Description Full Width : Yes [Field: STKRemarks] Use : Name Field Set as : $Narration Width : 15 [Field : Stockitem_Group] Use : Name Field Set as : $Parent Width : 15 [Field:Stockitem_Category] Use : Name Field Set as : $Category Width : 15 [Field:Stockitem_UOM] Use : Name Field Set as : $BaseUnits width : 8 Align : Center [Field: STKAltUom] Use : Name Field Set as : $AdditionalUnits Width : 15 Align : Center [Field: StkAlQty] Use : Number Field Set as : $Conversion Width : 20 Format : "NoZero" Align : Center [Field: STKBaseQty] Use : Number Field Set as : $Denominator Width : 20 Format : "NoZero" Align : Center [Field: Stockitem_Batches] Use : Name Field Set as : $IsBatchWiseOn Width : 15 Align : Center [Field: STKTrackDate] Use : Logical Field Set as : $HasMfgDate Width : 20 Align : Center ;Invisible : $$InExportMode [Field: STKExpiryDate] Use : Logical Field Set as : $IsPerishableOn Width : 15 Align : Center ;Invisible : $$InExportMode [Field: STKAltStandRate] Use : Logical Field Set as : "" Width : 15 Align : Center Invisible : Yes [Field: STKStandCostApplicable] Use : Name Field Set as : $$CollectionField:$date-1):StandardCostList Width : 20 Align : Center [Field: STKRate1] Use : Rate Price Field Set as : $$CollectionField:$Rate-1):StandardCostList Width : 15 [Field: STKUom1] Use : Rate Units Field Set as : $$CollectionField:$Rate-1):StandardCostList Width : 8 Align : Center Invisible : $$InExportMode [Field: STKStandSellingPrice] Use : Name Field Set as : $$CollectionField:$date-1):StandardPriceList Width : 25 [Field: STKRate2] Use : Rate Price Field Set as : $$CollectionField:$Rate-1):StandardPriceList Width : 15 [Field: STKUom2] Use : Rate Units Field Set as : $$CollectionField:$Rate-1):StandardPriceList Width : 8 Align : Center Invisible : $$InExportMode [Field: STKGSTApplicable] Use : Name Field Set as : $GSTApplicable Width : 15 [Field: STKApplicable] Use : Uni Date Field Set as : $$GetInfoFromHierarchy:$Name:"StockItem":"ApplicableFrom":##SVCurrentDate:"GST" Width : 20 [Field: STKGSTDetails] Use : Logical Field Set as : If NOT $$IsSysNameEqual:Applicable:#STKIGSTApplicable Then No Else No Width : 15 Invisible : Yes [Field: STKHSNDesc] Use : Name Field Set as : If $$IsEmpty:##vGSTMstDesc Then @lfFieldVal Else ##vGSTMstDesc lfFieldVal : If $$IsEmpty:$GSTDetails[Last].HSN Then "" Else $GSTDetails[Last].HSN Width : 25 [Field: STKHSNCode] Use : Name Field Set as : If $$IsEmpty:##vGSTMstCode Then @lfFieldVal Else ##vGSTMstCode lfFieldVal : If $$IsEmpty:$GSTDetails[Last].HSNCode Then "" Else $GSTDetails[Last].HSNCode Width : 15 Align : Center [Field: STKCalType] Use : Name Field Set as : If $$IsEmpty:##vGSTClassfnCalcType Then If $$IsEmptylfFieldVal Then $$SysName:VATOnValue Else @lfFieldVal Else ##vGSTClassfnCalcType lfFieldVal : If $$IsEmpty:$GSTDetails[Last].CalculationType Then + $$SysName:VATOnValue Else $GSTDetails[Last].CalculationType Width : 20 [Field: STKTaxability] Use : Name Field Set as : If NOT $$IsEmpty:#GSTClassfnMstNatureofTrans AND NOT $$IsSysNameEqual:NotApplicable:#GSTClassfnMstNatureofTrans Then @locTxblty Else + If @OnItmRtTax Then $$SysName:Taxable Else If $$IsEmpty:##vGSTMstTaxability Then If $$IsEmptylfFieldVal Then $$SysName:Unknown Else @lfFieldVal Else + ##vGSTMstTaxability lfFieldVal : If $$IsEmpty:$GSTDetails[Last].Taxability Then $$SysName:Unknown Else $GSTDetails[Last].Taxability locTxblty : If NOT $$IsEmpty:$GSTDetails[Last].Taxability AND NOT $$IsFieldEdited:GSTClassfnMstNatureofTrans Then $GSTDetails[Last].Taxability + Else $$TableObj:GSTClassfnMstNatureofTrans:$V_ItemTaxType OnItmRtTax : $$IsSysNameEqual:OnItemRate:#GSTCalculationType AND NOT $$IsEmpty:$$FilterValue:$tempGSTTaxType:tempGSTItemSlabRates:1:IsTaxableTaxType AND ##SVGSTIsNonCreditable Width : 15 [Field: STKIGSTRate] Use : Number Field Set as : @GSTRate GSTRate : $$GetInfoFromHierarchy:$Name:"StockItem":"GSTRate":##SVCurrentDate:"GST":0@IGSTDutyHead Width : 15 Align : Center [Field: STKCessRate] Use : Number Field Set as : @CessRate CessRate : $$GetInfoFromHierarchy:$Name:"StockItem":"GSTRate":##SVCurrentDate:"GST":0@CessDutyHead Width : 15 Format : "No Zero" Align : Center [Field: STKTypeSupply] Use : Name Field Set as : $GSTTypeofSupply Width : 20 [Field: STKReportUQC] Use : Name Field Set as : $GSTRepUoM Width : 20 ;Invisible : $$InExportMode [Field: STKMRPDetails] Use : Logical Field Set as : "" Width : 15 Invisible : Yes [Field: STKApplicableFrom] Use : Name Field Set as : $MRPDetails[Last].FromDate Width : 15 Align : Center [Field: STKMRPRate] Use : Rate Price Field set as : $MRPDetails[Last].MRPRateDetails[Last].MRPRate Width : 15 ;Inactive : $$InExportMode [Field: STKUOM3] Use : Rate Units Field Set as : $MRPDetails[Last].MRPRateDetails[Last].MRPRate Width : 15 Align : Center Invisible : $$InExportMode [Field: STKCosting] Use : Name Field Set as : $CostingMethod Width : 15 Align : Center [Field: STKMarketVal] Use : Name Field Set as : $ValuationMethod Width : 20 Align : Center [Field: STKPhysicalCount] Use : Logical Field Set as : $IgnorePhysicalDifference Width : 20 Align : Center [Field: STKNegBalance] Use : Logical Field Set as : $IgnoreNegativeStock Width : 20 Align : Center [Field: STKSalesMfg] Use : Logical Field Set as : $TreatSalesasManufactured Width : 20 Align : Center [Field: STKPurchConsume] Use : Logical Field Set as : $TreatPurchasesasConsumed Width : 20 Align : Center [Field: STKRejection] Use : Logical Field Set as : $TreatRejectsasScrap Width : 20 Align : Center [Field: STKExpBatch] Use : Logical Field Set as : $AllowUseofExpiredItems Width : 15 Align : Center ;Invisible : $$InExportMode [Field: STKOBQty] Use : Qty Primary Field Set as : $OpeningBalance Width : 15 Invisible : $$InExportMode [Field: STKGodown] Use : Name Field Set as : "";$$CollectionField:$GodownName1):StockGodownColl Width : 15 [Field: STKBatchNo] Use : Name Field Set as : "";$$CollectionField:$BatchName1):StockGodownColl ;$BatchName Width : 15 Align : Center [Field: STKMFDate] Use : Short Date Field Set as : "";$$CollectionField:$MfdOn1):StockGodownColl ;$MfdOn Width : 15 ;Invisible : $$InExportMode [Field: STKEXPDate] Use : Due Date Field Set as : "";$$CollectionField:$ExpiryPeriod1):StockGodownColl ;$ExpiryPeriod Width : 15 Align : Center ;Invisible : $$InExportMode [Field: STKQty] Use : Qty Primary Field Set as : "";$OpeningBalance Width : 15 [Field: STKRate3] Use : Rate Price Field Set as : "";$$CollectionField:$OpeningRate1):StockGodownColl ;$OpeningRate Width : 15 [Field: STKBaseUom] Use : Rate Units Field Set as : "";$OpeningRate Width : 15 Align : Center Invisible : Yes [Field: STKAmount] Use : Amount Field Set as : "";$OpeningValue Width : 15 Border : Thin Right ;----------------------------------UDF-------------------------------------------------- [Collection : StockItemColl] Title : "Stock Item" Type : Stock Item Child Of : ##ItemGroupTable Belongs To : Yes [Collection : StockGodownColl] Type : Batch Child of : #Stockitem_ItemName Fetch : GodownName, BatchName, IsBatchWiseOn, Name, TrPurcQty, TrPurcValue, TrAvgPurcPrice Fetch : TrAvgPurcCost, TrSaleQty, TrSaleQty, TrSaleValue, TrAvgSalePrice, OpeningBalance Fetch : OpeningValue, StkClBalance, TBalClosing, StkOpBalance, TBalOpening, TBalCredits, StkOutQty, StkInQty, TBalDebits Fetch : ClosingRate,BSDebits, MFdOn, Expiry Period, StockItemName, TBalNettCredits Compute : IsEmptyObject : $$IsEmptyObject Compute : IsWithItems : Yes Compute : HasMfgDate : $$Owner:$HasMfgDate Compute : IsPerishableOn: $$Owner:$IsPerishableOn Sort : @@Default : $BatchName, $GodownName Filter : IsNotThirdPartiesGodown ;------------------------------------------------------------------------------------- [Report: ChageItemGroup] Use : Modify Variables Local : Part : Modify Variables : Lines : Item_Group Local : Field: MV Title : Info : $$LocaleString:"Select Group" Title : $$LocaleString:"Change Group" Local : Form : Modify Variables : Vertical Align :Top Local : Form : Modify Variables : on : Form Accept : Yes : Form Accept Local : Form : Modify Variables : On : Form Accept : Yes : Display : Item Address Book [Line: Item_Group] Field : Medium Prompt, Item Group Table Local : Field : Medium Prompt:Set as :$$LocaleString:"Item Group" [Field : Item Group Table] Use : Name Field Table : List of ExtractStockGroups, AllItems Show Table : Always Modifies : ItemGroupTable Variable : ItemGroupTable [Variable : Item Group Table] Type :String [System : Variables] Item Group Table : ""
Sir, This TDL is of very much use for me. Everything is working fine. But IGST rate is not showing sir. Also how can I remove any columns which I don't need Please help me. I am attaching the screen shot for your reference. ;========================================== Stock Item Details Book =======================================[/QUOTE]
[/QUOTE] Actually it's correct but issue is when we copy and paste I don't know why buy insted of @ "mad" appears actual formula for IGST & CESS is $$GetInfoFromHierarchy:$Name:"StockItem":"GSTRate":##SVCurrentDate:"GST":0@IGSTDutyHead $$GetInfoFromHierarchy:$Name:"StockItem":"GSTRate":##SVCurrentDate:"GST":0@CessDutyHead
It is getting auto corrected to SMILEY ......... To avoid above problem...always INSERT the code..........rather than copy-paste
Using same logic in the TDL try this....... Code: [Collection : InstaStkItm] Use : StockItem Fetch : $Name Compute : ItemSelling : $$CollectionField:$Rate:Last:StandardPriceList Compute : ItemCost : $$CollectionField:$Rate:Last:StandardCostList Compute : ItemIGST : $$GetInfoFromHierarchy:$Name:"StockItem":"GSTRate":##SVCurrentDate:"GST":0:@@IGSTDutyHead Compute : ItemCess : $$GetInfoFromHierarchy:$Name:"StockItem":"GSTRate":##SVCurrentDate:"GST":0:@@CessDutyHead Compute : ItemMRP : $MRPDetails[Last].MRPRateDetails[Last].MRPRate Compute : ItemHSN : $GSTDetails[Last].HSNCode ODBC : Yes ;;Select $Name,$ItemSelling,$ItemCost, $ItemIGST,$ItemCess,$ItemHSN from InstaStkItm ;;; for use in calculator panel