Upgrading EFT Processing Key Steps

Install and Activate

After installing the new version of Sage 300 System Manager and relevant modules (for the version you are upgrading to):

Step 1: Run the EFT Processing installation program for the same version as the System Manager version.

Step 2: Refer to Installing EFT Processing

Example: If you upgrade from Sage 300 version 2021 to version 2022, you need to install EFT Processing version 2022. This will create EL69A folder in your Sage program directory.

Step 3: Follow the prompts to confirm the file location of the Sage 300 programs and shared data directory (these should be defaulted from the earlier Sage 300 System Manager installation).

Step 4: Activate the new version in Sage 300 Administrative Services.

Step 5: Enter the Serial Number and Activation Code in the EFT Processing License Screen.

Step 6: Refer to EFT Processing License Screen for details on each module.

User formats

Step 1: Transfer the custom format to the new version (or new server):

Locate the userformats.ini file in the Sage 300 programs directory, or customization directory, in the previous version or old server;

Copy it over to the EL69A directory in the programs directory (or customization directory if you are using customization directories).

Example: If you are upgrading from version 2021 to version 2022, you need to copy the files from EL68A to the EL69A folder.

Step 2: Generate a test EFT File and compare the output to a file generated with a previous version. Investigate discrepancies.

Tip:

If there is no userformats.ini file, then the customization must have been done in the formats.ini file. In prior versions, it was possible although not recommended as changes can be overwritten when installing a product update.

In the latest product updates, the formats.ini file includes a hash calculation to ensure the file is not tampered with. If the file is amended in anyway, it cannot be used in Create EFT File and you will receive an error message.

In this case:

  • Open up the old formats.ini file

  • Locate the file format used by your client (e.g. CAN_RBCACH)

  • Copy the format section into a new text file called userformats.ini

  • Save this file into the EL69A program (or customization) directory as required

Custom Forms

If you use Custom Forms for remittance advices, copy them to the new ELxxA>ENG folder or the customization directory.

Test the custom layout.

Tip: Test sending emails. If the upgrade is done on a new server, you may need to adjust the details used to send emails.

Payroll upgrade tips

In addition to the steps above, we recommend you test the emailing payslip process based on the latest C/P or U/P report.

In the test database:

  • Copy the previous payslip report to the new version's directory (or redo changes based on the new default Sage 300 report.

  • Export a range of EFT Employee email address

  • Import a tester's email address

  • Run the Print Payroll Payslip process.

  • Check the email subject and body , the attached PDF Content.

  • Confirm that the PDF password matches the formula/employee password

  • Re-import the EFT Employee email address