Importing from Accpac (Advantage Series), Sage Accpac ERP, or Sage 300 ERP
Working Papers supports imports from Accpac (Advantage series) including the Enterprise Edition, Discovery Edition, Corporate Edition, and the Small Business Edition.
Requirements
- ODBC Engine and Driver
- Pervasive SQL (Btrieve) or Microsoft SQL
- Pervasive SQL version - Refer to the preparation instructions.
- Microsoft SQL version - Refer to the export the file instructions.
Note: If Pervasive SQL Client is installed, you may need to input user name and password credentials to complete the import. Using Pervasive SQL Workgroup or Pervasive SQL Server does not prompt for a user name or password.
| Export file name | Information imported |
|---|---|
|
CSCOM.DAT or CSCOM.REC CSFSC.DAT or CSFSC.REC |
Profile information |
|
GLAMF.DAT or GLAMF.REC GLAFS.DAT or GLAFS.REC GLABK.DAT or GLABK.REC GLABRX.DAT or GLABRX.REC |
Chart of accounts |
| GLPOST.DAT or GLPOST.REC | General ledger detail (optional) |
If you are importing divisional information then the ACCPAC files have the following file extensions:
|
|
Note: For the import to work correctly using Windows Vista or Windows 7, run Working Papers as an administrator.
Prerequisites
- Ensure that account structures in Accpac contain unique sequences of account segments and different total lengths. Working Papers is unable to import the division number correctly when these two structures are not defined properly. Use the ACCPAC Account Structure Configuration window to change the structures.
- If Protection is activated, you require the File right, Import, 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 the software being used.
-
In the Version field, select the 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.
-
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.
Note: Note: If your Pervasive license has expired, you will be prompted with the error "Warning: Company Information has not been imported successfully into Engagement Properties". Renew your Pervasive license to continue.
- Complete the remaining fields of the dialog. >>Quick Reference
- Click OK to begin importing.
Results
Accounting data is imported into the client file.
Notes
- When importing recurring GL entries dated in any year other than the current one set for the import, the date for the recurring entry sets at the same period as the original entry, but the year is changed to the current one. For example, if importing an entry with the date 15/06/95, the entry date will be changed to 15/06/03 when the year to be imported is set to 2003. The original date is indicated in the journal description. This change ensures the period balances for each account in Working Papers are the same as those as in Accpac.
- The Accpac account number (acno) is hierarchical, for example aaa-bbb-ccc, with the last group ccc at the top level (bottom to top). When the importing division box is not checked, the Accpac account number is imported without change into Working Papers. When the use division box is checked, the Accpac account number acno-bb-ccc is flipped to cccbb-acno with cccbb as the division and acno as account number to follow Working Papers convention Div-acno. The result is the hierarchical structure is preserved although the order is reversed (top to bottom).
- If importing a file with adjusting entries in period outside the range set for the client file, such as entries in periods 13 or 14 into a client file, which contains only 12 periods, the entries will be assigned to period 12.
