Importing from Great Plains Dynamics (WIN)
The instructions in this topic are for importing from Great Plains Dynamics (WIN) into CaseWare Working Papers. If you are importing from Great Plains (DOS), see Importing from Great Plains (DOS).
Requirements
- Prepare the files for import.>>How Do I?
- Great Plains Dynamics ships with two different file formats and you can choose the file format when installing Dynamics.
- Pervasive SQL (also known as Btrieve). All data files have extension BTR. For more information, see this special note about Pervasive SQL and Windows XP.
- C-Tree Plus. All data files have extensions DAT.
The required Dynamics folder includes:
| Name | Location | Containing... |
|---|---|---|
| SY02100.BTR or SY02100.DAT | Dynamics | List of companies |
The required system folder files include:
| System folder file name | Location | Containing... |
|---|---|---|
| SY01500.BTR or SY01500.DAT | Dynamics\System | Company information |
| SY00302.BTR or SY00302.DAT | Dynamics\System | Account number structure |
The required company sub-folder files of a particular client:
| Sub-folder file name | Location | Containing... |
|---|---|---|
| SY40101.BTR or SY40101.DAT | Dynamics\<Client directory>\Company | Accounting period dates |
The required financial sub-folder files of a particular client folder:
| Sub-folder file name | Location | Containing... |
|---|---|---|
| GL00100.BTR or GL00100.DAT | Dynamics\<Client directory>\finance | Chart of accounts |
| GL00105.BTR or GL00105.DAT | Dynamics\<Client directory>\finance | Account numbers |
| GL00201.BTR or GL00201.DAT | Dynamics\<Client directory>\finance | Budget balances |
| GL10110.BTR * or GL10110.DAT * | Dynamics\<Client directory>\finance | Trial balance & prior period balances |
| GL20000.BTR or GL20000.DAT | Dynamics\<Client directory>\finance | GL details (optional) |
- <Client Directory> is the folder of files for the client you wish to import.
- * The GL10110.BTR or DAT file may not exist in a new company. In that case, the import will be conducted using the general ledger data automatically.
When specifying the import folder, Working Papers will automatically determine which version of the import to use based on the file extension of the Dynamics files.
Prerequisites
- If Protection is activated, the File permission "Import" is required to perform this operation.
Procedure
-
Open the client file in which you want to import.
-
On the Engagement tab, in the Data group, click Import | Accounting Software.
-
In the Import From field, select Great Plains and in the Version field, select the Great Plains Dynamics version that you want to import.
Note: Click here to see all accounting software supported versions.
-
In the Import Path field, type the exact path where the file you want to import resides or use Browse to locate the file manually.
- If there is more than one client on the Great Plains system, Working Papers prompts you to select the company information from the list of path names. Choose the path name that you wrote down in when preparing the file. Working Papers will help you by listing the company name associated with each path.
-
Under Import Components, choose to import either:
- The Trial Balance (Opening Entries) or,
- The General Ledger Detail.
-
To import client information, click Import Client Information. This information will be displayed in the Engagement Properties dialog.
- Complete the remaining fields of the dialog. >>Quick Reference
- Click OK to begin importing.
Results
Accounting data is imported into the client file.
