Home | Logon | Contact | Newsletters | Search:- 

Eftpac Common Issues and Solutions - Post SDK

EFTPAC Issues & Solutions

Error: Unable to connect: incorrect log on parameters

Has been fixed in v5.5. This error can occur when running a report from EFTPAC.

If using v5.4 install the latest EFTPAC service pack.

Vendor and Customer Number Change Support

EFTPAC v5.4 and later support Vendor and Customer Number Change.
EFTPAC v5.3 and prior do not.

EFTPAC supports the Number Change and Number Combine functions but not Copy. A Copy (account only) can be done without the Number Change products via the standard Accpac Vendor and Customer screens by selecting the account to copy and overtyping the account number. You then press the tab key to exit the account number field and add the new Vendor or Customer.

Once EFTPAC is activated, open the EFTPAC Options form and press Save, then close the form.

Now try the Vendor / Customer Number Change and check that it works – on a test or sample company if possible but making sure that you have a backup of your data first in any case.

When Vendor or Customer Number change function is run, you should see the EFTPAC files being processed right at the end of the Post function if EFTPAC is installed correctly – you will need to watch carefully as this will process quickly on small datasets.

If Number Change fails, you can either change the code back to original value or make a simple data repair by adding the missing record into the NE table (i.e. NEVEN, NEVNR and or NECUS) and deleting the old record.

Using Number Change on a workstation that doesn’t have EFTPAC installed is the number one reason users have problems and will cause data integrity issues. The EFTPAC data integrity process will tell you which records don’t match up between tables e.g. NEVEN and APVEN, NEVNR and APVNR and NECUS and ARCUS.

If you are having issues check the following:

1. EFTPAC is installed on all workstations i.e. NE5?A folder exists e.g. NE56A.

2. Under the Accpac shared data folder in the 3rdParty folder , check that spdll.ini exists and has Eftpac=NEVENCODECHANGE.DLL under the [3RDPARTY_DLL] section.  Also check srdll.ini exists and has Eftpac=NECUSCODECHANGE.DLL under the [3RDPARTY_DLL] section.  Note: These lines are added automatically when you open the EFTPAC Options UI.

3. Make sure users have full privileges to the <Accpac shared data>\3rdParty folder.

4. Make sure the 3rdParty folder has the 9 files NE5*A???.DI1, NE5*A???.DI2 and NE5*A???.DI3 (where 5* is version e.g. 56 and ??? is CUS,VEN and VNR)

For example, if you are using version 5.6 the files would be:

NE56ACUS.DI1, NE56ACUS.DI2, NE56ACUS.DI3, NE56AVEN.DI1, NE56AVEN.DI2, NE56AVEN.DI3, NE56AVNR.DI1, NE56AVNR.DI2 and NE56AVNR.DI3

5. Make sure the 3rd party folder has the files NEVENCODECHANGE.DLL and NECUSCODECHANGE.DLL.

Error: Cannot invoke GLJPST when a transaction is active

When the AP G/L Transaction setting is set to “Creating and Posting a New Batch” an error "Cannot invoke GLJPST when a transaction is active" is received when reversing a cheque in bank services. This results in a data corruption by leaving BKCHK in a bad state. If someone then tries to post a bank rec, a message is displayed saying the cheque has already been reversed and sets the RECSTATUS to -4.   This issue does not occur if the AP G/L Transaction setting is set to "Creating a New Batch".

Solution is to install the latest EFTPAC v5.4 service pack.

Bank Services v5.4 activation fails - System Manager Service Pack Required

This issue only occurs if you are upgrading Accpac to v5.4 and have EFTPAC v5.3 installed. If this is the case you must install the latest Accpac Service Pack for System Manager v5.4 BEFORE upgrading your Accpac data.  (Previously you needed to install hotfix number 16927 - but this is now included in the latest SM service pack).

Briefly, when activating Bank Services an error occurs when recalculating balances (about 80% of the way through the process) and the activation of Bank Services fails. An error message is not displayed, but you can see that the Bank Services activation failed because it remains in the Data Activation list of modules. This is an issue with the Accpac v5.4 Data Activation screen. Accpac have released hotfix 16927 that corrects this issue which is now included in the System Manager Service Pack 2.

Before upgrading Accpac, firstly install the system manager service pack. After the service pack is installed, you can then proceed with the upgrading of your Accpac modules (including EFTPAC).

If you had already tried to activate Bank Services without the service pack (and the error occurred) then download and install the service pack. Then try the Bank Services activation again. The activation should continue from where it failed and be successful this time.

Error 1020 on EFTPAC data activation

For example, you might receive the message "Error creating view AP0018 - Error:1020" when running the data activation for EFTPAC.

This is generally a data integrity issue (Error 1020 means the specified record is not found on table). Do a data integrity to see what the problem might be. eg The above error might occur if there is a Vendor Remit-To location for a Vendor that doesn't exist.

Once the data issue has been corrected the EFTPAC data activation should complete successfully.

Error 2 - occurs on data activation

On Data Activation, Error 2 is returned.  A service pack for EFTPAC v5.3 and v5.4 has been released to provide more specific errors.  Install the latest service pack and retry the data activation to find out the specific issue.  Error 2 is a data validation issue and can be caused by one or more of the following:

1) The Credit Card Charges Account field on the Bank Services Banks screen is blank. This is a new field in v5.4. After activating Bank Services and General Ledger v5.4, but before activating EFTPAC, make sure that you enter the Credit Card Charges Account for the banks. (The error message refers to BK0001)

2) There are inactive GL accounts attached to a Vendor. Solution is to remove or temporarily activate the GL accounts in question.

3) There are inactive GL accounts attached to old/unused GL bank accounts in Bank Services (the error message refers to BK0001). Solution is to remove or temporarily activate the GL accounts in question.

Missing vendors in Vendor Finder

The Vendor Finder does not show all vendors, but only the first portion of the list.   This can occur if you add or delete a vendor from a workstation that does not have EFTPAC installed. The same applies for customers. 

Note: EFTPAC must be installed on each workstation that uses AP Vendors, or AR Customers.


EFTPAC uses sub-classed tables (NEVEN, NEVNR and NECUS).  If  a new Vendor is added on a workstation without EFTPAC installed then the NEVEN table will not be updated, and a data integrity issue results.   Solution is to run the data integrity checker provided with the latest service pack of EFTPAC v5.4.  This will display which vendor(s) are missing from the NEVEN table, or NECUS table if customers is the issue.  Note: If you are using EFTPAC v5.3 you will need to determine which vendors are missing manually by creating and running a query.  Once the missing records are identified, manually add the record into the NEVEN table using your database software.  Or, alternatively, delete the vendor and then, with EFTPAC installed on the workstation this time, recreate the vendor. This issue can also be caused by deleting a vendor (where the record was not deleted from NEVEN), so if this is the case make sure the vendor has also been removed from the NEVEN table.

Generally the vendor causing the problem is the vendor that comes AFTER the last vendor displayed in the finder.

Error 2 - licence file does not exist

Occurs when trying to activate EFTPAC using the Options form.  You will receive this error if you are using EFTPAC v5.3 with Accpac System Manager 5.3B.  Install the latest EFTPAC v5.3 service pack.

This issue has been fixed in v5.4.

Error Activating Accpac Data Source

The following error is received when trying to open the Maintain Bank Accounts screen. All other screens open without error.


This can occur when Accounts Receivable is activated within a company but the computer using EFTPAC does not have Accounts Receivable installed.  For example, Sample Company Inc has AR activated but if you try and open the Maintain Bank Accounts screen without AR installed the error will occur.

Solution is to either install Accounts Receivable or, if you do not use AR, make sure that it is not activated within the company data.  To do this open your Database Software and open the CSAPP table.  Locate the Accounts Receivable row (the row where the selector field is AR) and delete the row from the table. Re-open the ACCPAC company and try again.

Importing Vendor data if already upgraded AP to 5.3 or higher

An important procedure must be followed to upgrade EFTPAC to version 5.3 or higher (from EFTPAC v5.2 or prior). This involves exporting the Vendor Information BEFORE upgrading Accounts Payable. This is required because EFTPAC version 5.3 and higher uses its own set of tables. Therefore a procedure must be followed to transfer the data from the AP Vendor optional fields into the new tables. This procedure is detailed in the EFTPAC documentation.

If you do not have the optional fields module and you have activated Accounts Payable 5.3 without running the EFTPAC transfer macro then you have lost your vendor account information.  This is because the optional fields have been deleted.  You will need to restore from a backup and run the EFTPAC transfer macro on the pre-5.3 data, or manually type in the account information using EFTPAC.

If, however, you have activated Accounts Payable 5.3 (or higher) without running the EFTPAC transfer macro AND you have the optional fields module and you ran the optional fields conversion utility on upgrading to 5.3 (or higher), all is not lost. You can follow the manual procedure outlined below to retrieve your vendor bank information:

1.
Create two csv files that can be imported using the Transfer button on the Options form. You can follow the links below to download template files to use as a basis.

The specifications of the two csv import template files that EFTPAC expects are listed below. They need to be in the ACCPAC shared data path directory. If you have multiple companies then do one at a time, renaming the files as appropriate.

EFTPAC_VendorExport.csv
download blank template


Has five columns with the following headings:-
Column1 = VENDORID
Column2 = LODGEREF
Column3 (AP Vendor Optional Field 4)= BSB
Column4 (AP Vendor Optional Field 5)= ACCOUNT
Column5 (AP Vendor Optional Field 6)= ACCNAME
Note: If lodgement reference is not used just leave the column blank

EFTPAC_VendorRemitExport.csv
download blank template


Needs to have six columns with the following headings (Note: if don't have remit to info then just have single row of headings and leave rest blank).
Column1 = IDVEND
Column2 = IDVENDRMIT
Column3 = LODGEREF
Column4 (AP Vendor Remit Optional Field 4)= BSB
Column5 (AP Vendor Remit Optional Field 5)= ACCOUNT
Column6 (AP Vendor Remit Optional Field 6)= ACCNAME
Note: If there are no vendor Remit-To locations then this can be a blank file with a single header row.

2.
Populate the csv files with data exported from the optional fields tables - ie APVENO and APVNRO

3.
In EFTPAC on the options form, choose the transfer button. This will overwrite any existing EFTPAC BSB and ACCOUNT information for the vendors. The tables populated are NEVEN and NEVNR

4.
Remove the optional fields BSB, Account and Accname that you may have had set up in AP Vendor and AP Vendor Remit-To.  These fields will no longer be used by EFTPAC

Record has been modified by another program

The following error is received:

"Eftpac Banks. Record has been modified by another program"

This can occur when someone is entering bank reconciliation information and either the same user or another user at the same time does some processing such as posting an AP or AR batch.

To duplicate this problem do the following:
  • In Bank Services, open the Bank Reconciliation form, choose a bank and press calculate.  Do not press save at this point and leave the form open
  • In AR, Open the Receipt Entry form.  Create a new receipt for the same bank.  Save the receipt and post it.
  • Go back to Bank form and choose save.  The message appears: “Eftpac Banks.  Record has been modified by another program”

Solution: Install the latest v5.3 Service Pack.

This issue has been fixed in v5.4

Trailing zero truncated

An amount ending in zero has the trailing zero truncated - applies only to the HSBC and NZ Bank formats.

Solution: Install the latest v5.3 Service Pack.

This issue has been fixed in v5.4

Modulo Software