This section describes what you need to do if you are currently using the ACCPAC EFT Direct Payroll 4.1A product, and are converting to Sage Accpac EFT Direct Payroll 5.4A:
• Deactivate the PRDIR deduction, if used
• Transfer data from EFT Direct Payroll 4.1A (optional) Deactivate the PRDIR Deduction
If, in EFT Direct Payroll 4.1A, you used the subledger type P and have added the PRDIR deduction code to Sage Accpac Payroll, you must
deactivate the PRDIR deduction and ensure that it is not actively assigned to your employees. To do so, follow all these steps:
1. From the Setup folder, open the Earnings And Deductions form. Then:
a. Select the PRDIR deduction.
b. Select the Inactive As Of box. The current date automatically appears in the next field.
c. Click Save.
This step deactivates the PRDIR deduction as of the specified date, and therefore prevents you from assigning the PRDIR deduction to new employees.
2. Change the Calculate field of any PRDIR deduction assigned to
employees to No, so that PRDIR will not be used in payroll calculation.
You can do this manually by changing the PRDIR deduction on the Pay
tab of each employee record. Or you can do this automatically for all employees by following these steps.
a. From the Employees folder, open the Update Earn/Ded For All Emp form.
b. Select the PRDIR deduction.
c. Select the Calculate field.
d. In the Type of Change field, type R to select Replace.
e. In the New Value Or Change field, double-click to select No.
f. Click Update.
g. Close the form.
3. Check all employee records after you update them, by using the Employee Information report or the Employees screen.
Transfer Data from ACCPAC EFT Direct Payroll 4.1A
If you have set up information about your employees’ banks in the EFT Direct Payroll 4.1A product, you can transfer the information to your Payroll 5.4. This saves you from manually entering the data on the EFT tab of every employee’s record in Payroll 5.4. To transfer, you first export the data from EFT Direct Payroll 4.1A as a .CSV file; then import the file to Payroll 5.4.
Export the Data from ACCPAC EFT Direct Payroll 4.1A An export utility program is provided with the Sage Accpac ERP
applications CD. Use this program to export data about employees’ banks to a .CSV-formatted file, as follows.
1. From the folder \EA54A\EXPORT\EFT41, start EFTexport.exe.
2. From the dialog box, choose the language and click OK.
The Export EFT Employee Info dialog box appears.
3. In the EFT 4.1 Company Database Location field, enter the path and file name of your EFT Direct Payroll 4.1A database (click Browse to locate it, if necessary). The file name should be COMPANY.MDB.
4. The Company field then lists all the databases created for the company you entered in the EFT 4.1 Company Database Location field. Select the database from the list. The program then displays the company name, country, and working directory of the database selected.
5. In the Export .CSV File Location field, enter the path only (not the file name) to where your file will be exported. The program automatically provides the file name CAN_EFTx.CSV, where x is the next consecutive file number assigned by the program. Note that previously generated export files are not overwritten or deleted. They remain until you remove them.
6. Click Export.
7. In the location specified in step 5, the program then creates:
a. The CAN_EFTx.CSV file. In Payroll 5.4, import this file, as described in the topic “Import the Data to Payroll 5.4.”
b. A log file called CAN_EFT.LOG, overwriting any previously
generated log files. This log informs you of any errors during the export process.
Import the Data to Payroll 5.4
To import the employee’s bank information file to Sage Accpac Payroll, follow these steps. If you need more instructions on importing data, refer to the ACCPAC System Manager User Guide.
1. Open the Employees form.
2. From the File menu, choose Import.
3. Import as a file type “Single CSV File” and choose Insert and Update (to import new records and update existing records).
4. In the File field, enter the file to be imported. You can click the Browse button to find the file.
5. Press the Tab key on the keyboard to set the status field of records to Import Ready (you can accept all records and fields shown).
6. Click OK.
7. After the import, you should review the imported information on each employee’s EFT tab of the Employees form or print the Employee Information report, choosing the EFT check box to include EFT
information. You may want to adjust employees’ EFT information to fit
Note some of the fields that are converted during the export/import:
Bank Code. This is a field that did not exist in EFT Direct
Payroll 4.1A, but exists in Payroll 5.4. The bank code assigned to institutions you import will appear in Payroll 5.4 as BANK01, BANK02, and so on.
If you wish to change the bank code (by deleting and adding it), do so before processing your first payroll. You will be unable to delete the bank code if there is history of paychecks processed by that bank code.
Percentage. The percentages set up in your EFT Direct Payroll 4.1A will be imported to Payroll 5.4 as a percentage with five decimal places, and as the calculation type Percentage (%) of Net Pay.
Start Date. The start date assigned to each bank account imported will be the session date that you entered when you opened the company.