Search Knowledge Base Articles

STOCK ITEM IMPORT





STOCK ITEM IMPORT


This Utility module is used  to import Stock Item master form an Excel File. Download Sample Excel file and TCP from m-connect.

Configuring TCP in Tally.ERP9

To add a local TCP file in Tally.ERP 9

  • Go to Gateway of Tally > F12 : Configure > Product & Features .
  • Click F4 : Manage Local TDLs .
  • Set Load TDLs on Startup to Yes .
  • Enter the name of the TCP file along with file extension in List of TDLs to preload on Tally startup field. (TCP should be in the installation folder of Tally.ERP9) 

Note : In case the file is in a folder other than the Tally.ERP 9 installation folder, enter the location path with the file name.




  • Press Enter to save.

Item  Import Feature Configuration in tally .ERP 9

Gateway of tally-Inventory Info-Stock Items-Item Import

Load the path with the file name(“E:\Tally\Tally.ERP9\Item Import\ItemImport.xlsx”)
 

Following screen shorts will help you to understand more of this module.





first we manually create masters(unit, godowns).

Enable Gst Features

OUTPUT:







 

 

 

Did you find this article useful?

Related Articles