Open Thema mit Navigation

Microsoft Dynamics GP

Accounting Index

Working Papers directly imports data from Microsoft Dynamics GP versions 8.0, 9.0, and 10.0.

If you do not have Microsoft Dynamics GP installed and you want to import data directly from that application into Working Papers, use the following procedure.

Note the following:

• The Unit Accounts are not imported into Working Papers.

Prerequisites

Before you can import the data directly, you require the following:

• The latest version of SQL Server 2005 (Express Edition) Service Pack 2 (2005.090.3054.00). It can be downloaded by visiting the Microsoft website. Select the appropriate download depending on your computer system. For more information, please refer to Imports and SQL Server.

• Two database backup files from Microsoft Dynamics GP:

• A system database backup file named DYNAMICS.BAK.

• A company database backup file with the extension BAK, for example, MyCompany.BAK.

To import Microsoft Dynamics GP data:

1. Copy the system database file (DYNAMICS.BAK) and the company database file (.BAK ) to a local folder. Both files must be in the same location.
   
   Note: The .BAK files must be placed in a local folder that the program (CWIN32.EXE) has full access rights to. For example, do not put the import files into the C:\Documents and Settings\%UserName% folder as Working Papers does not have full access rights to this directory. 

2. Select File | Import | Accounting Software.

3. In the Import From box, select Microsoft Dynamics GP.

4. From Version, select 8.0/9.0/10.0.

5. In the Import Path field, enter the path where the Microsoft Dynamics GP system and company database backup files reside. You can use the Browse button to locate the path to these files.

6. Under Import Components, choose to import either the Trial Balance or the full General Ledger Detail.

7. In the Please select a Company backup file field, select the Microsoft Dynamics GP company database file (.BAK).

8. To import period balances into the Working Papers file, select the "Period balances" check box. The program imports period balances based on the period types designated in the original file. If the period type does not exist in the client file, for example, if importing quarterly balances into a client file that does not have quarterly balances set, Working Papers automatically updates the client file for the new balance type.
   
   When importing Microsoft Dynamics GP, Working Papers sets the period date sequence to "R" (random) if the period dates in the Microsoft Dynamics GP file are not properly aligned as yearly, semi-annually, 4-monthly, quarterly, bi-monthly, monthly or 4-weekly.
   
   Imported period balances affect the Working Trial Balance only.

9. To import prior year balances into the Working Papers file, select the "Prior year data" check box.

10. To import budget data, select the "Budget data" check box.

11. To import prior year data as current year information, select "Import prior year as current".

12. Enter the server, user ID, and password if applicable.
    Server - Specify the name of the SQL Server or MSDE instance.
    
    User ID - Enter the sysadmin login ID for the SQL Server or MSDE instance. The pre-defined login ID is "sa", but this can be changed. See the MSDE readme file for more information on how to configure and log in.
    
    Password - Enter a valid password for the login specified in user ID.
    Generally, the default installation of the Microsoft SQL Server (default instance name, Windows authentication) is sufficient for most users. If that is true for you, then the Server, User ID, and Password fields can be left blank.

13. Click OK to process the import.