Rename Multiple Stock Items

Discussion in 'Tally.ERP 9' started by naren1234, Aug 31, 2017.

    
  1. naren1234

    naren1234 Member


    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
     


  2. rishabhexp

    rishabhexp New Member


    KINDLY PROVIDE UR MAIL ID .
    I CAN HELP IN THIS
     


  3. naren1234

    naren1234 Member


    Hi Rishabh, Thanks for the reply.
    You can reach me at: narendra.ca <at> gmail <dot> com
     


  4. mpal2311

    mpal2311 Active Member



    Has the work done?
     


  5. naren1234

    naren1234 Member


    No, not yet.
    Thanks for checking the status.

    No further response from anyone. Will appreciate help in this matter.

    Thanks.
     


  6. mpal2311

    mpal2311 Active Member



    Done or not.
     


  7. naren1234

    naren1234 Member


    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
     


  8. naren1234

    naren1234 Member


    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.
     

    Attached Files:

    Last edited: Apr 25, 2018
    Anuranjan likes this.


  9. Anuranjan

    Anuranjan New Member


    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.
     


  10. naren1234

    naren1234 Member


    You're welcome.
    I am glad the file was helpful.
     


  11. Vinay Girotra

    Vinay Girotra New Member


    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.
     


  12. alamin

    alamin New Member


    Dear sir
    it is awesome and helpful is it possible to change item or ledger group at a time?
     


Share This Page