Free Code : Stock Item Address book With All details

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 : ""

 

I Think It Is Stock Item "Kundli" ...

 

YA ............

 

Simple Command Type In Calculator Panel - Select * From StockItem

 

Fantastic efforts sir.

 

True but it won't give you batch details, std price, mrp, gst etc.

 

cess rate on value and qty not reflected

 

nice one

 

Brilliant effort sir.. Shows efforlessly...

 

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]

 

SIR IS WANT STOCK ITEM NAME + HSN CODE + GST RATE REPORT WITH ODBC LINK

 

can you please add filter or search button

 

[/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

 

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

 

T

 

Thanks for Sharing but GST Rate not comming