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
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
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 existOccurs 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
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
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.
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
If lodgement reference is not used just leave the column blank
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
If there are no vendor Remit-To locations then this can be a blank file with a single header row.
Populate the csv files with data exported from the optional
fields tables - ie APVENO and APVNRO
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
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
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
This issue has been fixed in v5.4