Tally Data Migration Tool
Introduction
The Tally Data Migration Tool helps you upgrade from Tally 7.2 to Tally 9, by migrating Data and TCP (Tally Compliant Product) files. It also restores 7.2 backup files.
You can also migrate Payroll data using the Tally Data migration Tool.
Tally 7.2 data and TCP files cannot be used on Tally 9 unless you migrate them, for which you need to be a licensed user of Tally 9.
Tally 6.3 users can also use the migration tool, which will rewrite the version to Tally 7.2 and then migrate the data to Tally 9.
Tally Data Migration Tool
The Tally Data Migration Tool works with the tally 9. exe and helps you migrate Tally 7.2 company data. It also helps you migrate Tally 7.2 TCP files.
A brief explanation on Tally Data Migration and Tally 9 screen follows, as both screens open simultaneously during migration.
Migrate Company Menu
The Migrate Company menu displays the following:
Migration Messages Pane
The migration status displays in the Migration Messages Pane when the migration is in progress.
Calculator Pane
If errors occur during migration, then an error message displays in the Calculator Pane.
Quote:
Note: The Data Migration Tool is resource intensive. It is recommended that you close all other applications when you migrate Data or TCP files. If an interruption occurs during the migration process, the migrated or partially migrated data will be deleted and you have to repeat migration for the same.
Migrating Data from Tally 7.2 to Tally 9
Migrating Data from Tally 7.2 to Tally 9
For an existing 7.2 customer, the migration process takes place as explained below.
- Click the tallymigration icon to start the migration
http://gallery.techarena.in/data/516...ation_Icon.JPG
- Tally Data Migration and Tally 9 start simultaneously, in separate screens
- As soon as Tally 9 is loaded, the message 'Ready for Migration' displays in the Migration Messages Pane
http://gallery.techarena.in/data/516...ion_Tool_2.JPG
- Click the Migrate Data option to select the company whose data is to be migrated from Tally 7.2 to Tally 9
- Specify the data path in the Directory field
http://gallery.techarena.in/data/516...ion_Tool_3.JPG
- On selecting the company, the company is loaded
Quote:
Note: If you have placed the data to be migrated from Tally 7.2 to Tally 9 in the Tally 9 folder, you have to only specify the path and need not select the company.
- If the company selected has Payroll data, the following screen appears
http://gallery.techarena.in/data/516...ion_Tool_4.JPG
- To continue with the migration, press Enter
- Accept to migrate the selected company
http://gallery.techarena.in/data/516...ion_Tool_5.JPG
- In the Migration Information screen on the left hand side, you can view the Types of Masters and Vouchers to be migrated from Tally 7.2.
- During the migration from Tally 7.2 to 9, the status of the migration appears in the screen on the right hand side, which displays the number of Masters and Vouchers that have migrated to Tally 9.
http://gallery.techarena.in/data/516...ion_Tool_6.JPG
Quote:
Note: As certain voucher types and units have been removed from Tally 9, there will be a difference of 3 in the total number of Voucher Type Masters and 1 in the number of Unit Masters.
- When the migration is complete, an Information pop-up message appears as shown below.
http://gallery.techarena.in/data/516...ion_Tool_7.JPG
- On pressing any key, a Congratulations message appears as shown below
http://gallery.techarena.in/data/516...ion_Tool_8.JPG
- If errors occur during migration, they are displayed in red in the Migration Messages Pane as shown in the following screen.
http://gallery.techarena.in/data/516...ion_Tool_9.JPG
Quote:
Note: If an error “The Cost Centre 'ABC' does not belong to the Category 'XYZ' appears during migration, rewrite Tally 7.2 data with Tally Data Migration Tool using Ctrl + Alt + R and then migrate the data to 9.
- The migrated companies are saved in the Tally 7.2 data folder. The migrated data is prefixed with a '0' and appears as a 5 digit number.
- Now you can work on Tally 9 with the migrated data
Quote:
Note: The migrated data will reside in the folder where it was at the time of migration.
Caution:
If you try to migrate a company that has already been migrated from 7.2 to 9, you will get a warning message as shown below.
http://gallery.techarena.in/data/516...on_Tool_10.JPG
Changes that occur after successful migration process are:
- The Payroll Deduction ledgers created under the group Duties and Taxes in Tally 7.2, after migration will become a Pay Head grouped under Current Liabilities in Tally 9.
- The Payroll Deduction ledgers created under the group Direct or Indirect Expenses in Tally 7.2, after migration will become a Pay Head grouped under Current Liabilities in Tally 9.
- The Payroll Deduction ledgers created under the group Loans & Advances (Assets) in Tally 7.2, after migration will become a Pay Head grouped under the Pay Head Type Loans and Advances in Tally 9.
- Any Attendance Type created with unit Mth will appear prefixed with ATTD- followed by the name of the Attendance Type.
- If you have migrated data containing attendance entries for the current month, whose Payroll is yet to be processed, those entries will become Production Type Entries. So it is suggested that you re-enter the attendance entries for the current month after migration and then process the Payroll.
- After migration, by default the Attendance Types will change to Production Types and therefore the YTD details will not be retained. All migrated Attendance types will be pre-fixed by ATTD-
Follow the procedure to display the accurate YTD details in the Payslip:
- To generate a Payslip with YTD Details for any of the earlier months:
- Create/Alter the Attendance Voucher for the respective month
- Select the Employee
- To Nullify YTD details, select the ATTD- prefixed Attendance Type and enter the Cur Bal value with a negative sign in the Value field.
- Select the Employee and the Attendance type
- Enter the Cur Bal amount as the Value and Accept the Voucher
- To generate a Payslip with YTD Details from the Current month onwards:
- Create/Alter the Attendance Voucher for the previous month
- Select the Employee
- To Nullify YTD details, select the ATTD- prefixed Attendance Type and enter the Cur Bal value with a negative sign in the Value field.
- Select the Employee and the Attendance type
- Enter the Cur Bal amount as the Value and Accept the Voucher.
Migrating Group company data from Tally 7.2 to Tally 9
Migrating Group company data from Tally 7.2 to Tally 9
To migrate Group companies:
- Migrate each member individually from Tally 7.2 to 9
- On successful migration of the companies, re-create the Group company in Tally 9
Post Migration Steps for Payroll data in Tally 9
Post Migration Steps for Payroll data in Tally 9
After migrating Payroll data from Tally 7.2 to Tally 9, you have to re-configure the Pay Heads and enter the Rates against the respective Pay Heads in the salary details screen for the Employees/Employee Groups in Tally 9. By default after migration, the Calculation type for all the Pay Heads migrated to Tally 9 will change to As User Defined Value.
- Go to Gateway of Tally> Payroll Info.> Salary Details> Alter> Select the Employee/Employee Group from the List of Groups/Employees.
In the Salary Details Alteration screen, move the cursor to the Pay Head field and press Ctrl + Enter to re-configure the Pay Heads as in Tally 7.2
Consider an example where ABC Company migrates its Payroll data from Tally 7.2 to Tally 9. The Payroll is completed and processed for the previous month. To migrate data refer to Migrating Data from Tally 7.2 to 9
- Before migration, Salary Details for Employee A in Tally 7.2 appears as shown below. (Go to Gateway of Tally> Payroll Info.> Employees> Alter> Employee A)
http://gallery.techarena.in/data/516...on_Tool_11.JPG
- After migration the Salary Details screen in Tally 9 for Employee A will appear displaying As User Defined Value as the Calculation Type for all the Pay Heads specified. (Go to Gateway of Tally> Payroll Info.> Salary Details> Alter> Select Employee A from the List of Groups/Employees)
http://gallery.techarena.in/data/516...on_Tool_12.JPG
- In the Salary Details Alteration screen, change the Effective From date if required
- To alter the Pay head Basic Salary from the same screen, move the cursor to the Pay head and press Ctrl + Enter
- In the Pay Head Alteration (Secondary) screen, select the Calculation Type from the list as provided in Tally 7.2
http://gallery.techarena.in/data/516...on_Tool_13.JPG
- Accept to save the Pay Head
- Enter the Rate in the Salary Details Alteration screen, if applicable
- Similarly you can modify the remaining Pay Heads
- Accept to save the changes made
- The Salary Details Alteration screen for Employee A with the changes made in Tally 9 will appear as shown below
http://gallery.techarena.in/data/516...on_Tool_14.JPG
Quote:
Note: As the number of Pay Heads will increase after migration, if the Calculation Type is retained as provided in Tally 7.2, the Pay Heads are migrated to Tally 9 with Calculation Type As User Defined Value.
Error Occurrence during Migration of Ledgers
Dear Sir,
During the Migration i had reced. below given errors can u help me for same.
[2008-09-19 18:10:01] Error: 173: No Date given for Bill '427'!(FOR OBJECT: 'Aditya Industries')
[2008-09-19 18:10:01] Error: 1190: No Date given for Bill '18799'!(FOR OBJECT: 'Bhawa Metal Industries')
[2008-09-19 18:10:01] Errors: 2
Further following text file occured during Migration
[2008-09-19 18:09:26] *********************************************************
[2008-09-19 18:09:26] Migration start at 18:09:26
[2008-09-19 18:09:26] Initializing company data...
[2008-09-19 18:09:36] Migrating Company (Batch: 1)...
[2008-09-19 18:09:38] Migrated: 0
[2008-09-19 18:09:38] Altered: 1
[2008-09-19 18:09:38] Migrating Company (Batch: 2)...
[2008-09-19 18:09:38] Done
[2008-09-19 18:09:38] Migrating Units (Batch: 1)...
[2008-09-19 18:09:38] Migrated: 1
[2008-09-19 18:09:38] Migrating Units (Batch: 2)...
[2008-09-19 18:09:38] Done
[2008-09-19 18:09:38] Migrating Currency (Batch: 1)...
[2008-09-19 18:09:39] Migrated: 0
[2008-09-19 18:09:39] Altered: 2
[2008-09-19 18:09:39] Migrating Currency (Batch: 2)...
[2008-09-19 18:09:39] Done
[2008-09-19 18:09:39] Migrating Statutory Masters (Batch: 1)...
[2008-09-19 18:09:44] Migrated: 50
[2008-09-19 18:09:44] Migrating Statutory Masters (Batch: 2)...
[2008-09-19 18:09:51] Migrated: 34
[2008-09-19 18:09:51] Migrating Statutory Masters (Batch: 3)...
[2008-09-19 18:09:51] Done
[2008-09-19 18:09:51] Migrating Groups (Batch: 1)...
[2008-09-19 18:09:55] Migrated: 0
[2008-09-19 18:09:55] Altered: 28
[2008-09-19 18:09:55] Migrating Groups (Batch: 2)...
[2008-09-19 18:09:55] Done
[2008-09-19 18:09:55] Migrating Ledgers (Batch: 1)...
[2008-09-19 18:10:01] Error: 173: No Date given for Bill '427'!(FOR OBJECT: 'Aditya Industries')
[2008-09-19 18:10:01] Error: 1190: No Date given for Bill '18799'!(FOR OBJECT: 'Bhawa Metal Industries')
[2008-09-19 18:10:01] Migrated: 46
[2008-09-19 18:10:01] Altered: 2
[2008-09-19 18:10:01] Errors: 2
[2008-09-19 18:10:01] Migration ended at 18:10:01
[2008-09-19 18:10:01] *********************************************************
Arpit
arpit.patel@adani.in
1 Attachment(s)
Re: Tally Data Migration Tool
Can anyone help me on resolution for error attached as jpeg file??
Re: Tally Data Migration Tool
Hi Megaman100,
If you are getting "Exiting Tally" error then follow the below steps to recover the data:
- Start Tally and goto Company Selection Screen.
- Now use Ctrl + Alt + R key combination to launch the Company Rewrite utility.
- Select the corrupt company profile (usually the one you were working last) and press Enter to start the rewrite process.
This method solves 90% cases of tally data corruption.
Re: Tally Data Migration Tool
Hi einstein_007,
Just one additional query, do I have to rewrite the company in Tally 7.2 version or in Tally 9? As I am trying to migrate the file from 7.2 to 9.
Re: Tally Data Migration Tool
Quote:
Originally Posted by
Megaman100
Hi einstein_007,
Just one additional query, do I have to rewrite the company in Tally 7.2 version or in Tally 9? As I am trying to migrate the file from 7.2 to 9.
There is an easy step given on how to migrate Data from Tally 7.2 to Tally 9. Just follow the below method given properly:
- First you have to click the tallymigration icon to start the migration.
- After that Tally Data Migration and Tally 9 start simultaneously, in separate screens.
- When Tally 9 is loaded, the message ‘Ready for Migration’ displays in the Migration Messages Pane.
- After that you have to click the Migrate Data option to select the company whose data is to be migrated from Tally 7.2 to Tally 9.
- Next try to specify the data path in the Directory field.
- On selecting the company, the company is loaded.
- If the company selected has Payroll data, the following things will be displayed:
- This Company Has Payroll Feature Enabled
- Just continue with the migration, press Enter.
- Accept to migrate the selected company.
- In the Migration Information screen on the left hand side, you can view the Types of Masters and Vouchers to be migrated from Tally 7.2.
- During the migration from Tally 7.2 to 9, the status of the migration appears in the screen on the right hand side, which displays the number of Masters and Vouchers that have migrated to Tally 9.
- When the migration is complete, an Information pop-up message appears, you just need to press any key, a Congratulations message appears
- If errors occur during migration, they are displayed in red in the Migration Messages Pane.
- The migrated companies are saved in the Tally 7.2 data folder. The migrated data is prefixed with a ‘0’ and appears as a 5 digit number.
- Lastly, you can work on Tally 9 with the migrated data.