Financial Data Migration Tips and Tricks

  • by Dusmanta Kumar Choudhury, Chartered accountant of the November 2001 batch
  • June 4, 2012
Management
Learn functional and technical tips for migrating data as part of a business consolidation strategy.
Key Concept

Data migration may involve moving data from a legacy SAP system to another SAP system or transferring data entered under one company code to another company code. Another type of data migration involves merging data pertaining to two company codes into a third company code. These types of data migration aim to merge two or more trial balances to create a new trial balance leading to a consolidated financial statement. The various challenges include volume of data, source data structure, vernacular languages in the line items, reconciliation of the source to resulting data, and above all, maximum system downtime allowed to complete the entire task.

I discuss a project in which I was involved – that is, a merger of two separate independent entities (e.g., A, Inc. and B, Inc.) to form a single entity (C Combined, Inc.). This business consolidation involves the merger of the financial figures along with other data. I concentrate here on three important components of the trial balance: Accounts Receivable (AR), Accounts Payable (AP), and the General Ledger (GL) data.

This example project provides detailed functional and technical approaches to data migration. Although it is based on a classic GL environment, conceptually the same logic can be extended to an SAP General Ledger or New GL environments.

The functional part covers the solution approach that an FI functional team can follow. The technical part is a guide for ABAP developers and also the functional consultants to build the program logic.

Dusmanta Kumar Choudhury

Dusmanta Kumar Choudhury is a chartered accountant of the November 2001 batch. After working for about four years with M/s Larsen & Toubro Limited and SSA Global Technologies (BaaN) Pvt Limited, he joined Infosys Limited in August 2005 as an SAP FI/CO consultant. He was selected as a speaker for the America’s SAP Users Group (ASUG) meeting in Dallas, Texas, on October 2008, where he presented a paper titled “SAP System Appreciation Study-FI/CO.” He is currently working as a lead consultant-SAP FI/CO with Infosys’ Consulting and System Integration unit and is based out of Singapore. He has been involved in SAP (core and IS retail) implementation, upgrade, and production support projects for clients across the USA, EMEA, and APAC.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.