This format is used to Create/Alter the
Stock Items in the Tally.
Columns in StockItems:
Columns in StockItems:
Name
Data Type: Text.
Field In Tally: Name.
Description: Name of the Stock Item. It is the Primary Key in the Stock Items. If the name already exists in Tally then the old record will be replaced with the new record.
NameAlias
Data Type: Text.
Field In Tally: (alias).
Description: Name Alias for the Stock Item.
PartNo
Data Type: Text.
Field In Tally: Part No.
Description: Part Number for the Stock Item.
Description
Data Type: Text.
Field In Tally: Description.
Description: Description for the Stock Item.
Parent
Data Type: Text.
Field In Tally: Under.
Description: Name of the Parent Item Group.
BaseUnits
Data Type: Text.
Field In Tally: Units.
Description: Name of the Primary Unit of Measure.
AdditionalUnit
Data Type: Text.
Field In Tally: Alternate Units.
Description: Name of the Alternate Unit of Measure.
Conversion
Data Type: Number.
Field In Tally: where.
Description: Conversion Factor for Primary Unit of Measure.
Denominator
Data Type: Number.
Field In Tally: =.
Description: Denominator Value for Alternate Unit of Measure.
Category
Data Type: Text.
Field In Tally:
Description: Name of the Item Category.
GodownName
Data Type: Text
Field In Tally: Godown.
Description: Godown Name of the Item in Allocation of Opening Balance Screen.
BatchName
Data Type: Text.
Field In Tally: Batch.
Description: Batch Name of the Item in Allocation of Opening Balance Screen.
OpeningBalance
Data Type: Number.
Field In Tally: Quantity.
Description: Quantity of the Item in Allocation of Opening Balance Screen.
OpeningRate
Data Type: Number.
Field In Tally: Rate.
Description: Rate of the Item in Allocation of Opening Balance Screen.
OpeningValue
Data Type: Number.
Field In Tally: Amount.
Description: Amount of the Item in Allocation of Opening Balance Screen.
IgnoreNegativeStock
Data Type: Text. (Yes/No)
Field In Tally: Ignore Negative Balances.
Description: Enter Yes to Ignore Negative Balances.
IsCostCentresOn
Data Type: Text. (Yes/No)
Field In Tally: -NA-
Description:-NA-.
IsBatchwiseOn
Data Type: Text. (Yes/No)
Field In Tally: Maintain In batches.
Description: Enter Yes to Maintain In batches.
RateOfVAT
Data Type: Number.
Field In Tally: Rate of VAT (%).
Description: Rate of VAT in % ge.
BasicRateOfExcise
Data Type: Number.
Field In Tally: Rate of Duty (eg 5).
Description: Rate of Excise in % ge.
Remark
Data Type: Text.
Field In Tally: Remarks.
Description: Remarks for Stock Item.
CostingMethod
Data Type: Text.
Field In Tally: Costing Method.
Description: Name of the Costing Method for the Item.
ValuationMethod
Data Type: Text.
Field In Tally: Market Valuation Method.
Description: Name of the Valuation Method for the Item.
StdCostDate
Data Type: Number/Date. (20090331/31-Mar-2008)
Field In Tally: Standard Cost – Applicable From.
Description: Effective Date of the Standard Cost of the Item.
StdCost
Data Type: Number.
Field In Tally: Standard Cost – Rate.
Description: Standard Cost of the Item.
StdPriceDate
Data Type: Number/Date. (20090331/31-Mar-2008)
Field In Tally: Standard Selling Price – Applicable From.
Description: Effective Date of the Standard Selling Price of the Item.
StdPrice
Data Type: Number.
Field In Tally: Standard Selling Price – Rate.Description: Standard Selling Price of the Item.