Sie befinden sich hier: Alle Hilfethemen > Verwaltung der Mandantendatei > Dateivorbereitung > Accpac (Advantage Series)

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: .dap .dfe *.eap

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

Öffnen Sie die Mandantendatei, in die Sie importieren möchten.
Klicken Sie in der Registerkarte Engagement in der Gruppe Daten auf Importieren | Finanzbuchhaltung.
In the Import From field, select the software being used.
In the Version field, select the version that you want to import.

Hinweis: Klicken Sie hier, um alle unterstützten Versionen der Buchhaltungsanwendungen anzuzeigen.
Geben Sie im Feld Import-Pfad den genauen Pfad an, wo sich die zu importierende Datei befindet, oder klicken Sie auf Durchsuchen, um die Datei manuell auszuwählen.
Wählen Sie unter Import-Komponenten entweder:
- Hauptabschlussübersicht (Eröffnungsbilanzsalden) oder
- Kontenfortschreibung.
Klicken Sie zum Importieren von Mandanteninformationen auf Mandanteninformationen importieren. Diese Informationen werden im Dialog Mandantenstammdaten angezeigt.

Hinweis: Wenn Ihre Pervasive Lizenz abgelaufen ist, erhalten Sie folgende Meldung: "Warnung: Firmeninformationen wurden nicht erfolgreich in die Mandantenstammdaten importiert." Erneuern Sie Ihre Pervasive Lizenz, um fortzufahren.
Complete the remaining fields of the dialog. >>Quick Reference
Klicken Sie zum Starten des Imports auf OK.

Results

Buchhaltungsdaten werden in die Mandantendatei importiert.

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.