Skip to Content

Convert Tally Data

How to convert tally data into SAP B1

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    Posted on Jan 20, 2009 at 01:00 PM

    Export the Tally data into MS-Excel, and than after formatting it as per requirement, import it in SBO using Data Transfer Workbench.

    But, please be aware that if the volume of the data is high, it could be a really difficult task.

    Rahul

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Narottam Das

      Hi Manish,

      Following may of your help also.....

      Hi Ambesh,

      Have you asked the porspect(Customer) Why do he need 5 Years data in new SAP system?

      If the sole purpose is only to have access to old information, then it is advisable to keep old system available in one PC.

      I suggest to bring only master data and opening balance information from old/legacy system, you may use DTW for this task.

      Otherwise I don't think you will be able to transfer all the data through DTW.Because Tally do not have concept of Codes for master information like Busine ss Partenr Code / Item Code / GL Code / Tax Codes / Ware Houses etc. So you will have to first create BP Master,Item Maser,Chart Of Account etc. master data and then you will be require to attach all this newly defined codes in every exported transaction of Tally. This is just to give you estimate of complexity and volume of work you are looking for.

      BR

      Samir Gandhi

  • author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2009 at 01:13 PM

    Hi

    1. Transfer all the data's (document wise) from tally to Excell sheet.

    2. Then you have to use Data Transfer Work Bench.

    3. DTW has lot of XL templates. You have to use necessary template and copy from tally XL sheet to DTW XL template.

    This way is very easy to transfer all data from tally to Bone.

    If you want to transfer this way you can get all xl template guidelines from Forums.

    Congratulates

    regards

    Edited by: K. Asupathy Raja on Jan 20, 2009 6:44 PM

    Add comment
    10|10000 characters needed characters exceeded