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 2023 to version 2024, you need to install EFT Processing version 2024. This will create EL71A 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 ELXXA directory in the programs directory (or customization directory if you are using customization directories).

Example: If you are upgrading from version 2023 to version 2024, you need to copy the files from EL70A to the EL71A 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 EL71A 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.

Note: It is often a good idea to redo customisations to the Crystal Report forms (such as adding your company logo) based on the latest version of the sample remittance advice reports as new versions and product updates often include updates to the Crystal Reports. Some updated Reports include new parameters that need to be included in your custom reports.

Emailing

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

It is recommended to send a test email in EFT Options and test the emailing process.

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