Dynamics GP - How to copy / migrate an AFA Financial Report from one company to another

1. Find the next available AFA Report ID in the new company
1. select * from AF40100
2. The next id is the next available number
2. Copy all data from the following tables
1. AF40101, AF40102, AF40103, AF40104, AF40105, AF40106, AF40107, AF40108, AF40200, and AF40201
3. Replace the report id with the new report ID in the new company
1. update af40101 set reportid = [newid] where reportid = [oldid]

You can export the data from pervasive by browsing to each table and exporting to a data files.
However, pervasive will export an additional column of 0's before each actual column of data.
After cleaning, the first column from pervasive is not needed.
you must clean the data and remove these columns to import the data into SQL.
Once cleaned, you can copy and paste directly into the AFA tables.


See original solution here
http://support.microsoft.com/kb/863224