Hi, For inventory, we have more than 3000 stock items in Tally.ERP 9 (Release 6.0.3), the item name are of typical format "XXXXXX|My Item Desc ...." where xxxxxx is the item number and 'My Item desc" is the name/description of the item. They are both separated by a pipe character "|". There is no space between item number, pipe character and item description. Just FYI, most item descriptions are pretty long. We want to alter the name of all 3000+ stock items (by replacing the pipe character with a space). In Tally, there is option to alter multiple/all stock items through: Gateway of Tally > Inventory Info. > Stock Item > Multiple Stock Items > Alter. But still, that is very time consuming process as we have more than 3000 items names to alter. I am looking for a faster solution like a TDL code or XML code; an add-on with excel template to replace old name with new name; or a backend solution, etc. Can someone please guide me? Your help will be appreciated. Thanks, Narendra
No, not yet. Thanks for checking the status. No further response from anyone. Will appreciate help in this matter. Thanks.
No. Not yet. As requested earlier, I provided my email id in post no. 3 above. Here is the same for your quick reference: narendra.ca <at> gmail <dot> com Thanks for checking
I figured a workaround. Used the attached excel macro to rename stock item name/description and alias. It is used to generate an XML file that can be imported to tally via. import masters to do the task. NOTE: 1. KINDLY BACKUP YOUR TALLY DATA BEFORE PROCEEDING. 2. PLEASE READ THE INSTRUCTIONS IN THE ATTACHED FILE CAREFULLY BEFORE PROCEEDING. 3. While adding/removing/renaming alias names, attached sheet will ignore cells filled only with space characters (ASCII character 32). i.e. same will be treated as an empty cell, and therefore, it will remove any existing alias names against the corresponding stock item. Hope this helps those having similar problem.
Sir, I used this file and It is PERFECTLY WORKING. Able to RENAME STOCK ITEMS AND ITS ALIAS. THANK YOU SIR FOR PROVIDING SUCH A HELPFUL FILE.
Dear Mr. Naren, Indeed it's a very helpful post,need a help to change the Item Rate for Godown attach to a item. I am facing a similar situation where in need to change the rate of about 1900 item in stock. I had tried my level best to write the TDL for the same I could manage to create the new item with store but not able to modify the same.