Convert Tally Data

[CRVMANISH]

How to convert tally data into SAP B1

[former_member196647 · Accepted solution]

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

[CRVMANISH · Accepted solution]

Hello sir

We want to transfer tally 7.2 data to SAP B1 , but there is no tool in tally 7.2 to convert into excel sheet

can u please help us out

[Former Member · Accepted solution]

Hi

Yes you can do,please Contact tally knowing person i think they will help you.

regards

[former_member196647 · Accepted solution]

Hi,

I think in Tally 7.2 also, you can export a report to a text file. You can than use that text file to create an excel file. Or otherwise you can use ODBC to create a report directly in Excel, using Tally's ODBC facility.

Rahul

Edited by: Rahul Jain on Jan 21, 2009 5:51 PM

[Former Member · Accepted solution]

Dear Manish Meshram,

You may do as follows (its very simple) u2013

1. Open Tally ->

2. Open your desired company (from where you want to export data into SBO) ->

3. Open MS Excel ->

4. In Menu select Data ->

5. Import External Data ->

6. New Database Query ->

7. Choose Data Source -> Databases -> Select Tally_ODBC ->

8. Select your desired tables and columns -> Next ->

9. Do filter (if required) -> Next ->

10. Do sorting (if required) -> Next ->

11. Return Data to Microsoft Office Excel -> Finish ->

12. Now you will have your desired data in the excel sheet with the proper and relevant column name. ->

13. Now open the relevant DTW template ->

14. Copy the whole column (except the column header) as you required from the tally data ->

15. Paste the copied data in the relevant column of the DTW Sheet (by leaving the tow rows on top of every column of the DTW templates) ->

16. Repeat copy / paste till your entire desired tally data has gone into your DTW Sheet. ->

17. Please fill up the key / record identity columns of the DTW Sheet (generally these are the mandatory fields in any DTW template) ->

18. Here we assumed that you are importing all relevant master data or maintained the data dependency hierarchy at the time import (i.e. first import the top level independent data then import the dependent data, e.g. for items : item group first and then the item details. Please go through the DTW guides for foreign key / or parent u2013 chilled linking files data types and source) ->

19. Save the excel file (the filled DTW sheet) in Tab-Delimited text format. ->

20. Go to DTW -> Import the data by selecting the prepared Tab-Delimited text file prepared above. -- Thatu2019s all.

N.B. For better data management and getting the foreign-key / parent u2013 child linking keys easily you may import the excel files (with the tally data) into the SQL Server database tables (please make the field labels of the excel sheet proper before import to SQL Server). And then do the required data maintenance by SQL queries (may be directly with the SAP B1 company database). After all data maintenance do a simple query like select * from sql_table_name and copy the whole data from the sql query result window (just like we copy a whole excel sheet). And finally paste the copied data into a temporary excel sheet and then copy / paste the relevant columns by columns from the sheet (with tally data) to the DTW excel sheetu2026..thatu2019s all. From the SQL Server data tables you may directly insert / update / delete data of your SBO company database tablesu2026. Its very simple but be careful by observing the other sample company database before any insert / update or delete activity directly form SQL Server Management Studiou2026.Fine nau2026??

Another final but not the last advice is that that try to avoid importing transactional data. Import only master data into SBO. Itu2019s better to have manual entries of the transactional data into the SBO companies.

[Former Member · Accepted solution]

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

[Former Member]

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

[CRVMANISH]

Hello sir,

Can u send me any document or link which may help me out in transffering tally data to SAP B1 .

I will be very helpful to u