| I need to set up EFT to run from both Accounts Payable and Cashbook |
| I need to re format my PC. Is there a quick way to restore EFT or Debit Orders from a backup |
| I installed EFT or Debit Orders on a server and it works fine from the workstation from where it was installed. It gives an error if run from any other workstation. |
| I have attempted to activate EFT or Debit Orders but receive an "Unauthorised Activation Code" message. Is there a way to fix this problem without uninstalling the product and re installing all over again. |
| I need to set up EFT or Debit Orders for multiple companies |
| I need to upgrade a client from EFT Pervasive to MS SQL. Do I need a full product ? |
| I need to generate cashbook payments in detail - IE, I don't want to use the cashbook single reference batch feature with the seamless interface to EFT |
| Can EFT Advantage pay funds into a bond or savings account. |
| Can I move the default EFT directory to someplace else |
| Can I rename the default EFT directory (or folder) |
| Is EFT Advantage compatible with older versions of Accpac |
| I have EFT 5.3 and need to run it with Accpac AP 5.1 I therefore want to use the EFT 5.3 features such as user defined fields |
| I use Nedbank Nedinform and I need the vendor names to appear in the upload batch file. |
| Accpac and EFT compatibility |
I need to set up EFT to run from both Accpac Accounts Payable and Peresoft Cashbook ?
With the release of Version 5.3, a Data Manager has been included to handle most of the following functions
I need to re format my PC. Is there a quick way to restore EFT from a backup ?
EFT directories are entirely self contained. IE, Apart from the Borland Database Engine (BDE) that needs to be installed on every EFTWin PC, the actual EFT directory can be copied or moved virtually anywhere. For older EFT products (2,3 years old), you will still need the original CD. For later products, check to see whether you have a subdirectory named wssetup below \eftwin1, for example \eftwin1\wssetup. If you have wssetup, you do not need the original CD, as \wssetup contains the BDE.
1. Backup the entire EFT directory structure, EG, \Eftwin or \Eft2000
2. After re formatting the hard drive, do one of the following :
1. If you cannot find eftwin1\wssetup, Install EFT from the original CD to the default directory \eftwin\eftwin1
2. Now restore your previously backed up EFT straight over the top , replacing the existing (newly installed) files.
3. If you were able to locate \wssetup, skip step 1 above and restore your EFT to the newly formatted hard drive first, then simply run \wssetup\setup.exe to install the BDE.
3. Add the required EFT shortcuts to the desktop and you will be up and running.
I installed EFT on a server and it works fine from the workstation from where it was installed but It gives an error if run from any other workstation.
Each workstation or computer used for EFT needs the Borland Database Engine (BDE) to be installed locally. When the product is initially installed, the BDE will be automatically installed on the local PC from the CD. To install the BDE on any other PC that will access EFT from the server, you must run the workstation client setup which can be found in the eftwin1\wssetup directory on the server. If you are using an older EFT product and cannot locate the workstation client setup, simply install EFT from the original CD onto each workstation. This install will of course create icons pointing to the new local EFT installation. You will need to modify the shortcut properties to point to Eftwin.exe on the server.
I have attempted to activate EFT but receive an "Un authorised Activation Code" message. Is there a way to fix this problem without uninstalling the product and re installing all over again.
This is generally the result of finger trouble, (sometimes on our part as well).
1. Using Explorer, browse to \eftwin\eftwin1 directory and open the file named Eftwin.lic. (Preferably use Notepad)
2. The first line will contain the registered company name. Ensure that the name is 100% correct (including spaces and brackets etc) according to the activation document that you received. Place your cursor somewhere in the middle of the name and press the [END] key on your keyboard. Ensure that the cursor moves to a position immediately after the last letter of the name. IE, you are checking to make sure that there is not a space after the last character. If there is, simply delete the space.
3. Line 15 contains the serial number. Check it carefully and correct if necessary.
4. If you have made changes, save the file and close it,
5. Still using Explorer, browse to \eftwin\eftwin1\data and using Notepad, open the file named bdesdd.idx
6. This file contains only one line consisting of the activation code. Check, correct and save. EFT will now start.
I need to set up EFT for multiple companies
With the release of Version 5.3, a Data Manager has been included to handle most of the following functions
The default installation directory structure is Program Files\Eftwin\Eftwin1 (or EFT2000\eftwin1 for older products). Where you require separate EFT programmes for each module or for multiple companies, simply run them from from multiple directories.
1. First install EFT to the default directory \eftwin1
2. Register, activate and setup the product for the 1st company.
3. Now copy the entire \eftwin1 directory to \eftwin2. This will save you having to re register the product. (If using Version 5.2 or higher, use the supplied Data Manager)
4. Add a new shortcut or menu item, pointing to the 2nd directory (2nd company) , \eftwin2
5. Run setup, ( \File\Setup Housekeeping) from within the new EFT and enter the 2nd company's details
Tip : \eftwin1 and \eftwin2 etc can be renamed to anything, EG, \eft_Comapny1 and \eft_Company2. Remember to setup the required details in both AP and CB before using the product. See the User guide for details. Directories can also be nested.
For example, you may have:
c:\ Program files\Eftwin\ Company1 \eft_ap,
c:\ Program files\Eftwin\ Company1 \eft_cb
c:\ Program files\Eftwin\ Company2 \eft_ap,
c:\ Program files\Eftwin\ Company2 \eft_cb
c:\ Program files\Eftwin\ Company3 \eft_ap,
c:\ Program files\Eftwin\ Company3 \eft_cb
Remember to set up separate shortcuts pointing to each company.
I need to upgrade a client from Pervasive EFT to MS SQL - What product do I need ?
As from 1 November 2004, EFT 5.3 has been shipped as a single product catering for any platform using ODBC Crystal reports. Simply upgrade to the latest version of EFT.
I need to generate cashbook payments in detail - IE, I don't want to use the cashbook single reference batch feature with the seamless interface to EFT.
This feature is not supported in EFT, however, a Crystal report has been supplied for those users who wish to pursue this option. The report called CBEFTPAY.rpt needs to be set up within the bank accounts table as a cheque form, advice lines 100. The form MUST NOT be called EFT. Rather call it EFTC or EFTFrm. Should you call it EFT, cashbook will only allow you to create a Single reference batch.
Once you have captured a payment batch, you must proceed to Forms and print / export the report to file, \eftwin1\data\eftpaymt.txt BEFORE posting the batch. The file must be exported as a CSV file, even though you are pointing to eftpaymt.TXT . You will need to consult with your Accpac or installing dealer. Data Support Software does not support this method.
Can EFT Advantage pay funds into a bond or savings account.
EFT Advantage can only deposit funds into a Current or Cheque account. This is a low key security feature to disallow the payment of corporate funds into a private savings account.
Can I move the default EFT directory to someplace else
Yes but you must follow these rules
1. If moving to another directory on the same PC, simply drag the entire directory to the new location and remember to change the shortcuts.
2. If moving to another PC, you will need to install the Borland database engine. Follow this thread for more details
Whatever you do, you must not change the sub directory structure in any way or rename the sub directories . IE, you can rename the default directory eftwin1 but the data directory must remain where it is.
Can I rename the default EFT directory (or folder)
Yes you can rename the top level folder, eftwin1 to anything you like. As long as you do not rename any of the subfolders. Further explanation is given in the multi company thread . Follow this thread for more details
Is EFT Advantage compatible with older versions of Accpac
EFT Advantage is downward compatible with all versions of Accpac. The only interface between the two products is a crystal report, apeftpay.rpt which is used to generate the payments for export to EFT Advantage. This means that is you are running an older version of Accpac, you may have to modify the crystal report to accomodate the new fields in EFT such as user defined fields etc. Older versions of Crystal are available on this site for download and modification
TIP
Simply download the current crystal report for 5.3 and compare the fields to the older report, then make the necessary changes
I have EFT 5.3 and want to run it with Accpac AP 5.1 and want to use the EFT 5.3 features such as user defined fields
As mentioned in the previous question, the only interface between Accpac and EFT Advantage is a Crystal report . Therefore, you will need to start with an EFT 5.1 report (available on this website). The report shipped with EFT 5.3 contains two formula field, @Branch and @VendRef. You will need to change the 5.1 field called "Branch" into a formula called "@Branch" . Similarly, the 5.1 never used a field called VendRef. You will therefore have to add this as a formula field to the 5.1 report. At the end of the day, all you are doing is modifying the 5.1 report to include the 5.3 fields that EFT Advantage uses
I use Nedbank Nedinform and I need the vendor names to appear in the upload batch file.
Vendor names can only be included in the Nedinform Free-Format upload batch file. If Nedinform Pre Format is used, vendor names cannot be included in the upload batch file, as the vendor names and details are already stored on the Nedbank mainframe . This is a Nedbank ruling and not an EFT limitation.
Accpac and EFT Compatibility
The latest version of EFT is 5.3, build 5.3.0.28. This version is compatible with Accpac Version 5.4 and Cashbook 5.4 (SDK version). The latest Crystal reports are available for download from this site and will work will all versions of Accpac from 5.2. For older versions of Accpac (downward compatibility), see the FAQ above, " Is EFT Advantage compatible with older versions of Accpac " More.....
Data appears damaged when viewing payments.
When performing a Payment enquiry, the screen may appear to contain indecipherable information. This will generally be caused by damage to the text database file, EFTPAYMT.TXT. You may even recognise that a batch listing or posting journal has been printed to this file in error
The most common cause of this is due to a report or other data printed or saved to this file between the time the file was generated and the time the file is imported into EFT & viewed. This is more common when using AP or CB for DOS as more users have possible access to the print file, (F3, Printer Setup, Destination). This is particularly prevalent when many Accpac users have access to the same start list.
Prevention (Accpac and Cashbook for Dos (Plus series)
Ensure that the person who generates the EFT payments has their own Accpac Plus start list and checks the print destination prior to generating any reports to file or, Backup the file EFTPAYMT.TXT immediately after creating it.
( c:\ Program Files\Eftwin\Eftwin1\data\eftpaymt.txt )
Missing Data
Payments appear to be generated successfully but when imported into EFT, either contain old data (previously paid data) or no data at all.
This is generally caused by printing the information to the wrong print file when generating the payment run from within AP or CB (Dos).
Check that the print destination in system manager, (F3, Printer Setup, Destination) is set correctly and the filename is EFTPAYMT.TXT If this is found to be the problem, make a note of the incorrect filename that appears on the screen. Chances are that your correct data can be found in the "wrong" file. Use a text editor to check the file contents but, DON’T CHANGE ANYTHING IN THE FILE. By simply renaming the file to EFTPAYMT.TXT and copying it into the correct directory you may be able to import it into the EFT programme successfully.
Payment details appear in a CSV ( Comma Separated Value) format when viewed in EFT
EFT uses two formats for the importing of data from eftpaymt.txt
Peresoft Cashbook for Windows and Accpac Accounts Payable exports payment data to eftpaymt.txt in a CSV format, while the CB and AP for dos, (Accpac Plus) generates the file in fixed format. EFT will select the correct format, depending on the interface chosen (Dos or Windows) during the EFT setup procedure.
The import format is determined by the file type, eftpaymt.sch, which resides in the .......\data directory.
The source file for "fixed import format" is located in the directory ..........\data\SchFix, while the source file for "varying" (or CSV) format is located in ............\data\SchVar.
Simply by copying the correct file into the \data subdirectory and re importing will eliminate this problem.
FNB PACS deletes the first 10 characters of the user reference name.
The 30 character username field in PACS uses the first 10 characters as a "short name". This has been corrected in build 5.0.0.45 which can be downloaded.
‘ ‘ is not a valid integer, followed by I/O Error 32
This error may occur when creating the Nedbank bank output file, "Payment.upl" .
This can be caused by a number of reasons.
a) Missing or incorrect data as explained below
The User Debit line number ( represents the users’ bank account number with Nedbank that will be debited ) is entered incorrectly - Must be 10 characters in length and may have been entered as less than 10 characters. Obtain this from Nedbank
The Nedbank seed number may have been entered as less than 32 characters in length.
The vendors branch number may have been entered as less than 6 characters.
An alpha character may have been entered in an account number or branch number field in error.
b) Accpac Payment batch damage. Posting in progress ...........................................
For whatever reason, when posting the Accpac payment batch, you may receive a posting in progress error . One assumes that by resetting the batch status to open or deleted will solve the problem ( See Accpac documentation ). This may not be the case. The crystal report used by EFT to extract the payment data , (apeftpay.rpt) uses data from two tables, namely BKREG and APADV. Entries may have been posted to these tables during the original posting before the batch "hung" and deleting or resetting the batch status will not remove them. You will need to access the two tables and delete the duplicate entries.
You may notice this occurrance by seeing extra blank lines in the file exported from Accpac. (Look carefully at the enquiry screen for missing characters or extra blank lines)
Nedbank uses all these fields when encryping the file and if it finds a character missing or a blank line, it cannot continue.
If you find blank lines, delete them from the eftpaymt.txt file (CAREFULLY) and re import. You should try and establish where the blank lines have come from, so the problem can be solved for future runs.
File is locked: Table ...........\data\Eftcurr.db is in use
This usually occurs when another user is viewing the payment enquiry screen while another user is attempting to import fresh data.
Error occurred while attempting to initialise the Borland Database Engine (error xxxxx) and, or
Previous database in use – Cannot be emptied
There are three possible reasons for this error message.
(1) Installation was probably done to a Server and the user is attempting to access the program from an "un" configured workstation. Solution: Run Workstation Setup, "Wssetup", which is found in ......... \Eftwin1\Wssetup. This will install the Borland Database Engine, (BDE)
(2) Security rights. If installing on a Windows 2000 platform, Windows NT or Terminal Server, the programme must be installed under administrator rights or else the Borland Database Engine will not be installed. An easy test to try is to go to Control Panel and run the BDE Administrator. If you double click on the icon and nothing happens, the BDE has not been installed.
(3) EFT uses 2 database files, namely EFTCURR.db and EFTPREV.db. When data is imported from the csv file eftpaymt.txt, EFT makes a copy of the current data found in EFTCURR.db and places it in EFTPREV.db. A simple fix is to copy EFTCURR.db into a temporary folder, rename it EFTPREV.db and copy it back in to the data directory.
Importing into EFT Fails (Accpac AP and Cashbook Plus series (Dos)
An issue has been brought to light where EFT imports incorrect numbers from the eftpaymt.txt file after posting from either Accpac AP Plus or CB Plus.
Solution :
Check that the currency in the System Toolbox has been set up to use comma’s as thousand separators. If spaces or periods are selected as thousand separators, the import will fail.
AP macros perform incorrectly
EFT ships with Accounts Payable 6.5 macros as default. AP 6.1 macros may be found within a directory on the CD called AP61. If using AP6.1 with EFT , the correct macros must be copied to Program Files\eftwin\eftwin1\eftdos from this directory.
I/O Error 104 when starting EFT
When selecting OK, EFT continues to load as "Unregistered". This is either caused by lack of rights where EFT is unable to read the information from the " ini " file eftwin.ini or the file is damaged or simply not there.
1. Check that the user has the rights to the eftwin1 directory, or
2. Re register the product.
Delete eftwin.lic from the eftwin1 directory
Delete bdesdd.idx from the .........\data sub directory.
Re install the product.
Re enter all the activation details.
All the correct files will then be re created
Programme crashes, GPF's or simply disappears when importing into EFT
When importing the payment details from the eftpaymt.txt file, (after posting and printing in Accpac), programme either crashes and causes a GPF, or it simply disappears.
1. Open the eftpaymt.txt file with a text editor, (Wordpad or Dos edit) and check the contents.
You will generally find that the AP remittance advice APEFTADV.RPT has been selected and sent to this file instead of the correct payment data APEFTPAY.RPT. IE, A whole bunch of names and addresses have gone into the file instead of the cheque payment information.
You can see clearly that this is remittance advice information.
Unfortunately, the only solution is to restore and start over.
Previous run's payment data keeps importing into EFT. Current month appears to be missing
This invariably happens because the data has been printed to the wrong filename.
When creating the payment file, (printing payments to file from AP), using the report spec APEFTPAY.RPT, Crystal does two annoying things.
1. It assumes you will print to a file named APEFTPAY.CSV and
2. It also assumes that you are going to print to a file with a "CSV" extension. It doesn't even give you the choice of selecting file types "ALL". Bearing in mind that you need to write to a "TXT" file. As a result, your payment data is possibly residing in the eft data directory in a file named apeftpay.csv . If this is the case, simply rename eftpaymt.txt to "old" and rename apeftpay.csv to eftpaymt.txt. Re import and your current data should appear.
You may of course have saved it to a totally wrong destination, in which case search all drives for eftpaymt.txt or apeftpay.csv, or even apeftpay.txt Simply copy it back to the eft data directory and re import.
To eliminate writing to a filename with "CSV" extension, when searching for the file in AP, enter *.* on the filename field and you will see ALL files in the window, as opposed to only "CSV" files.
Table does not exist
This is in fact telling you the truth. The table from where EFT or Debit Orders imports it's data has been deleted.
This message appears when attempting to import payment data into EFT or Debit Orders from Accpac AP 5.1 or 5.2
This generally happens when there is a crystal version problem. If you first print to screen, you will probably receive one of the following messages: " Unable to load dll" or Unable to load report" . These messages do not appear if printing directly to file. When printing to file, once selected, the file eftpaymt.txt is first deleted before being re created with the new data. If there is a crystal problem as mentioned above, the file will be deleted but NOT re created.
Solution. Download the two crystal report specs for Accpac version 5.1
The other reason may simply be that the file was deleted in explorer or similar.
Numbers appear truncated at thousand separator, EG 127426 shows as 127 and 426 shows in next field
This occurs when a comma has been set as the group separator in regional settings for numbers. Because the industry standard CSV, Comma separated values is used for importing into EFT, each comma is seen as a field separator and splits the field at that point.
Solution. Remove the group separator altogether. ie, numbers should show as 123456789 and not 123,456,789
tblcurrent: Field 'BatchNum' not found - After importing Vendor payments or Debit Orders
When importing the data from Accpac, the data is imported from an ascii database, (text file) doimport.txt
When selecting this file from within Accpac, you may have selected the schema file by mistake, IE the edoimport.sch file. This will damage the schema file, (because it is now populated with Debit Order payment information). On import, Debit Orders does not know what to do with the data and therefore cannot find the tables.
Solution. Restore the edoimport.sch file from backup or reinstall the programme from the CD to a temporary directory and copy the schema to the existing or old directory.
The following 4 error messages are all ODBC related
Unknown database: Alias 'xxxxxx' when connecting to Accpac ODBC to edit bank details
Driver not known to system: Alias 'xxxxxx' when connecting to Accpac ODBC to edit bank details
General SQL Error when connecting to Accpac ODBC to edit bank details
Table does not exist when connecting to Accpac ODBC to edit bank details
EFT Advantage and Debit Orders 5.3 makes use of the ODBC feature in Accpac 5.2 and higher, by linking into the APVEN vendor masterfile table and ARCUS, customer masterfile table.
The user is required to enter the Accpac database ID, for example SAMINC, whereby EFT or Debit Orders will then search for the correct table, APVEN or ARCUS.
You may have either entered the wrong database id, the database does not exist, selected the SYS database which doesn't contain the tables APVEN or ARCUS or you may have even left it blank by mistake.
Older versions of Accpac, 5.1 and earlier did not use ODBC connections. However, if you have access to the ODBC Datasource Administrator you may create a local DSN connection and still get access to the tables using the Pervasive interface. You may have to create the Pervasive ODBC engine first on the server before you can see it from the workstation.
Hash Totals do not Agree - A Nedbank message when uploading the EFT file into Nedinform
Nedinform uses file encryption by adding various fields and generates a hash total based on a 32 character "Seed" number. The seed number stored in EFT must match the seed number allocated by Nedbank. ( View EFT System Info to determine the seed number stored in EFT Advantage).
If the seed number is correct, look very closely at the vendor account and branch numbers. You may find an account number with a blank space or maybe a "o" (letter O) has been entered instead of a numeric Zero "0". This will cause a problem when the hash total is calculated. You may also find a branch code that is less than 6 characters long.
When selecting the Payment Processing icon, absolutely nothing happens.
When user selects the Payment processing icon or the menu item, the program does not respond. (Nothing happens). User is able to import, view, print and perform all other functions.
Check the eftwin.ini file that can be found in the programme directory, usually \eftwin1. The file is either write protected, read only or corrupt. Restore the file from backup or simply check the rights. The file must not be restricted. (Use Notepad to view)
When generating payments from Cash book (Print) forms screen, you receive the message "Location for bank account xxx does not exist. Use bank account maintenance to add the form location"
The forms section of the bank account maintenance either does not have an entry for "EFT" or ONLY one entry, being EFT. There must be more than one forms entry if EFT is entered.
Unlike Accpac, Cashbook does not use a Crystal report to generate the payment file. The file is created directly from within Cashbook, (hard coded). Cashbook needs to know where to find the EFT raw data file eftpaymt.txt. This is entered in the forms section of the bank account maintenance as "EFT". However, more than one form entry must exist, (I.E. EFT and one other will work, even if the second one is a dummy entry pointing at a system cheque report.)
This OS is not adequate to run EFT Advantage
Error occurs when installing EFT on a Windows 2003 Server. EFT Advantage no longer supports Windows 95 or 98 platform. Microsoft appears to have the same OS "signature" in Windows 2003 Server as Windows 95 or 98. There are two solutions. (1) Install to the Windows 2003 Server from a workstation running W2000 or XP. EFT looks at the local operating system and not that of the server.
(2) EFT Advantage files on the installation CD are not compressed. Files can be copied manually, however, this is tedious and subject to error. This restriction was removed from EFT Advantage install script with version 5.3 build 5.3.0.23
Certain creditors appear in the payment batch but do not appear in EFT. They also do not appear if the report apeftpay.rpt is printed to screen before exporting to EFT
or
Creditors banking details (branch and account info) are missing from within EFT, but they are in the Accpac vendors master file
This occurs when Vendor " Remit To" locations are used. The Remit to location take precent over the Vendor master file
Solution : Either remove the Remit to locations if they are not required or enter the banking details into the remit to locations
Unknown Database: Alias EFTData - Occurs when running EFT for the first time after installing, followed by ( if you continue ) tblProfile: Cannot perform this operation on a closed dataset.
This occurs usually immediately after installation and indicates that either the Borland Database Engine did not install or only partially installed, or rights were insufficient. This error is prevalent on Windows 2003 Server platforms and is generally associated with rights.
Possible Solutions :
1. Re Install the Borland Engine by running the EFT Client / Work station setup which can be found within \Eftwin\ eftwin\wssetup. Filename to run is WSSETUP.EXE. You must install as server Administrator or as administrator of the local machine
2. Check in the control panel for the BDE Administrator icon. If it is visible, double click on the icon to open the Administrator. You will see a list of various databases. EFTData should be in the list. If not, right click on Databases ( top of the list ), select New, Select STANDARD. Rename immediately (it will allow you too while in an edit frame) to EFTData.Within the right window, you will notice the PATH field is blank. Click on the browse button, ( ... ) and browse to \Eftwin\eftwin1\data. Tab out of the field to close and close the BDE Administrator.
EFT Payment report displays 2 columns reflectiing "Unknown function" ACCTYPE and CHQNO
This is due to the inclusion of a new format called FNB FACS which requires two additional fields. To correct, using Windows Explorer,
open the folder eftwin\eftwin1\data\schfac.
Copy the file EFTPAYMT.SCH from this directory into the data directory and re import your raw data from Accpac, (eftpaymt.txt) .
Network Initialisation failed. File or directory does not exist. File c:\pdoxusers.net. Permission denied
or
Vista ACL problem. Unable to run EFT due to Vista security
EFT ( or rather the BDE, Borland Database Engine ) needs to create a file called PDOXUSERS.NET on the root directory ( c:\ ). This message is received when the user does not have the rights to the root directory. To solve the problem, open the BDE Administrator in the control panel. Select Configuration, drivers, native, paradox. (Refer to the graphic below ). On the top line, right hand side, select the three dots (...) and change the directory path to wherever EFTWinxxx resides, or simply point it to a folder that the user has rights to. (EFTWin1 xxx is safer, as you will know where it is)
Previous entries appear in EFT Payment Enquiry screen TOGETHER WITH current payments
You may spot this in one of two places. Either when you preview the payments on screen when posting the AP payment batch or in the EFT Payment Enquiry screen. There are variations. You may notice that the number of entries in the batch has increased, sometimes exactly double. You may also notice that the vendor code and vendor name do not match. IE the name maybe from one vendor and the vendor number, may belong to another. This generally means a corrupt or damaged BKREG table . The BKREG table is only populated once "PRINT/POST" has been selected on the payment batch list screen. Once the payment batch has been posted, the BKREG table is cleared. In other words it should always be empty.
Solution. Backup the data and delete all rows in the BKREG table. If using Pervasive, you may be able to find an old backup copy of the table BKREG and simply copy it into the DAT folder.
Crystal CSV export file to eftpaymt.txt creates multiple identical transaction from Accpac AP 5.5
This is caused by an error in the Crystal runtime that was shipped with Accpac 5.5. Exporting to PDF is correct, but of course useless to EFT. What is actually happening is that the number of repeated transactions depends on the number of invoices being paid in the run. To solve the problem (until Accpac corrects the issue) is to tick the 2 boxes, "Isolate Report/Page sections" and "Isolate Group sections ", as per example below. This will then export correctly, one record at a time.
This generally occurs when a BDE (Borland) lock file is not released after use. When EFT Advantage is in use, it creates a lock file called PDOXUSRS.NET, and at times various lock files with the extension *.LCK. Simply do a search, track them down and delete them. Obviously, there must be no EFT users on the system when this is done. Search in the root of the users PC or in the EFTWin\, EFTWin1\, or EFTWin\data directories.