Warning
EFTPAC Version 5.5 is only for use with Sage Accpac ERP 5.5
NOTICE IF UPGRADING FROM EFTPAC v5.3 OR PRIOR
|
If upgrading from ACCPAC v5.3 or prior, ensure you enter the Credit Card Charges
Account for the Banks before activating EFTPAC or else Error 2
will result. [more info] |
VITAL NOTICE TO AVOID DATA LOSS IF UPGRADING FROM EFTPAC v5.2 (OR PRIOR)
When upgrading from EFPAC v5.2 or prior, you must perform the upgrade steps detailed below
before upgrading Accounts Payable to version 5.5 or
all optional fields data including your Eftpac
vendor bank information will be deleted as part of
the upgrade process from Accounts Payable version
eg 5.2 to 5.5.
Make sure you take a full backup of your ACCPAC
data before upgrading to version 5.5.
See step 2 in the "Installing and setting up EFTPAC"
section of the manual for full instructions on
converting / transferring your Eftpac 5.5 data to
version 5.5.
Briefly, if upgrading from Eftpac 5.2 and prior you
will need to run both the data transfer macro
(eftpacex.avb in the Eftpac installation directory)
and the Transfer option in the EFTPAC options screen
to transfer all Vendor and Vendor Remit To Location
bank account and lodgement reference information
from the old Accounts Payable version 5.2 optional
fields to the new EFTPAC 5.5 tables.
Overview
This product will be in 30 day demonstration mode
until you enter an activation code supplied by Modulo Software (received after purchasing). In demonstration mode the product can be used on any company for 30 days.
Please click here to view a comparison chart (pdf) of EFTPAC with other similiar products.
Please click
here
to find out how you can purchase this product.
After purchase, you will receive an activation code that
you can enter into the Options form to activate the demonstration product.
EFTPAC 5.5 contains the following enhancements:
Eftpac 5.5 is compatible with Sage ACCPAC ERP version 5.5
1. EFTPAC now supports batches of payments to be made to accounts payable Vendors via BPAY.
2. An improved Data Integrity checker now verifies EFTPAC views and checks for and reports on any
orphan records found in Eftpac tables which subclass corresponding Accpac tables.
This is useful when an issue arises, where the Vendor Finder doesn’t show all vendors. This is
caused by adding or deleting a vendor from a workstation that does not have EFTPAC installed. The
same applies for customers. The Integrity Checker now identifies which vendor and customer records
are missing from EFTPAC tables. Once identified, you can add or delete the appropriate vendor or
customer record(s) in the NEVEN, NEVNR or NECUS tables to make sure that they match the APVEN, APVNR
and ARCUS tables. Please see the knowledge base on www.modulo.com.au for more information.
3. Added New Bank Formats:
- Papua New Guinea Westpac
- United States ACH Standard
- Singapore DBS
- HSBC CPA (1464)
- Barclays Bank Standard Input File (SIF)
- Citibank UK ACH BACSTEL
4. Improved EFTPAC Data Activation. Modulo have enhanced error reporting in the EFTPAC Data Activation screen. For example, Error 2 can sometimes be reported if there is a data integrity issue found on activation. Tracking down the cause of the error was often time consuming. EFTPAC now gives a more specific error description, enabling faster rectification of the issue. Please see the knowledge base (Error 2) for further information.
5. Handles multiple bank formats better on the Maintain Bank Accounts screen. The Vendors default bank formats are now automatically selected for each vendor.
6. EFTPAC now supports Sage ACCPAC ERP Options products Customer and Vendor Number Change. 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.
7. A new Audit Logger and reporting function has been added to log all changes to Vendors, Customers, Vendor Remit to Locations and Miscellaneous accounts. Any time an account is added, modified or deleted, the changes are logged and can be reported on at any later stage using the Bank Records Audit report. The audit logger works on all EFT related ACCPAC data entry screens, as well as where changes are made via ACCPAC imports or macros.
8. EFTPAC now allows automated customer receipt batch creation based on the AR Aged Trial Balance report.
This streamlines EFT processing for accounts receivable customers.
The general idea is, you can set up a group of customers who prefer to have their accounts debited by EFT.
So during the month, invoices are created for the customers as normal in ACCPAC. At the end of the
month (or as required), you create a receipt batch using the “EFTPAC AR Receipt Creation” function.
Having created the batch you can proceed to the EFT creation stage, if all customers have previously
provided written direct debit permission for periodic EFT payments from their bank accounts. Otherwise
you send an email requesting confirmation that the payment be made. Modulo Software’s document delivery
solution Mailpac, can be used to send these emails i.e. Mailpac delivers a direct debit confirmation
request using a modified version of the ACCPAC Receipt Advice. Any customers who do not approve the
payments are then deleted from the AR Receipt Batch. The “EFT Creation” function is then used to create
the EFT file for processing by the bank.
In version 5.5 of EFTPAC, the AR Receipt Creation function, is not compatible with invoices created by
Project and Job Costing. When creating the receipts batch, AR Receipt Creation will ignore any
invoices created by PJC that show on the Aged Trial Balance report.
9. AR Receipt Batch Import
EFTPAC now allows customer receipts batches to be downloaded from a bank and imported into ACCPAC.
This function currently supports the Bank of America format although other banks can be added on request.
EFTPAC matches the transit and account numbers in the file to a customer's bank account details in EFTPAC.
Having established the customer number, the check amount is applied to the customers invoice as detailed
in the file
10. EFTPAC Bank setup now allows definition of a separate Bank ID number for Accounts Receivable and Accounts
Payable. This is particularly relevant for EFT transactions created using the Australian Bank File Format.
System Requirements
- Sage Accpac ERP 5.5 and Accounts
Payable or Accounts Receivable 5.5
- Either Pervasive.SQL 9.6 (or later),
Microsoft SQL Server 7 (or later), IBM DB2
version 8.1 (or later), Oracle 9i (or
later)
- Internet Explorer 6 or above if using browser interface
-
Microsoft Windows ME, NT, or 2000, XP or above
- Note: EFTPAC does not provide modem
communications software or bank specific file
submission software
Instructions
Click the
Download button in the
upper right-hand corner of this page to start
the download and save the file to your computer.
1. Unzip the downloaded files.
2. Run the setup.exe application to install.
Thank you for choosing EFTPAC
Modulo Software