Electronic Fund Transfer > Transaction Processing > EFT Payments Extract

EFT Payments Extract

You use this program to extract Accounts Payable and Cash Book EFT (Electronic Funds Transfer) transactions into batches for payment by the bank.

Accounts Payable and Cash Book transactions can be combined and extracted into a single batch if required.

This program:

  • creates the XML file if required (EFT Bank Control).
  • activates the After EFT payment extract trigger, if selected (Trigger Program Setup).
  • automatically generates the EFT Completed Payments list.

Toolbar and menu

Field Description
Save Select this to save your selections in the transactions listview.
Bank Indicate the bank code for which to extract the EFT payments.
Select All

Select this to mark all transactions displayed in the Transactions listview as selected for extraction into the EFT batch.

To select individual entries, you use your mouse pointer to place a tick in the check box at the beginning of the transaction line you want to select.

Deselect All

Select this to remove all ticks from the check boxes at the beginning of each line in the listview. No lines remain selected for extraction into an EFT batch.

To deselect individual entries, you use your mouse pointer to remove the tick in the check box at the beginning of the transaction line.

Delete AP entry

If you enabled the option Total posting for Cash book integration (Banks) then this function enables you to delete individual AP entries from the EFT system.

When you select this function, the entry that is highlighted in the listview is deleted.

See Notes and warnings - Delete AP entry.

The Module column in the listview displays the wording AP for those transactions created in the Accounts payable module. The EFT no column contains duplicate EFT reference numbers if you selected the bank setup option Total posting for EFT and detail posting for checks (Banks).

If you selected the bank setup option Detail posting for check and EFT (Banks) then you cannot use this function to void the AP transactions from the EFT files. Instead, you use the Payment Cycle Maintenance program to reinstate the invoice against the supplier and to simultaneously remove the EFT transactions from the EFT transaction file.

Print selection

Select this to print a list of all the transactions you selected for extraction.

You use this report to check that all required transactions have been selected prior to creating the payment batch and the XML file (if required - EFT Bank Control).

You can only access this option if you have access to the EFT Selected Payments program.

Create file

Select this to create a batch consisting of all the transactions marked for extraction (i.e. all selected transactions). If required, an XML file containing details of these transactions is also created.

A unique batch number is assigned to the transactions extracted and the transactions are moved to a status of Paid.

When an extract is performed, the system refers to the Suppliers and Browse on EFT Cash Book Beneficiaries files to extract the current banking information for suppliers and cash book beneficiaries respectively.

Action date

This indicates the date on which the transactions must be paid by the bank.

This date cannot be earlier than the current date.

OK Select this to create the batch, and the XML file if required (EFT Bank Control).
Cancel Select this to return to the listview without creating the file.

Bank Info

Information for the selected bank is displayed in this pane.

Extract Info

Column Description
XML file directory

This indicates the directory in which the XML file will be stored once created.

This is the directory defined against the bank (EFT Bank Control).

Location

This indicates whether the XML file directory is located on the client machine or on the server.

This location is defined against the bank (EFT Bank Control).

Last file name This indicates the previous name of the XML file created the last time an EFT payments extract was run.
XML detail type This indicates the XML output structure of the XML file as defined against the bank (EFT Bank Control).

Transactions

This listview displays the EFT transactions processed in the Accounts Payable and Cash Book modules which have not yet been extracted to a batch (i.e. EFT transactions not in a status of Paid).

Column Description

Checkbox

This enables you to select/deselct the batch for extraction. A tick in this column indicates that the batch is included for extraction.

You can use the Select All and Deselect All functions to apply a tick or remove the tick from all lines listed.

Module This indicates the module in which the transaction originated. AP indicates the Accounts payable module and CB indicates the Cash Book module.
Supplier This indicates the code of the supplier you are paying via this EFT batch.
Name This indicates the name of the supplier you are paying.
Date This indicates the date on which the EFT was created.
EFT no

This indicates the EFT number of the batch.

If the batch was created in the Accounts payable module, then you can select the batch number to use the EFT Invoice Details program to view the A/P invoices associated with the highlighted transaction.

Payment amount This indicates the EFT amount in the currency of the supplier or bank.
Currency This indicates the currency of the supplier or bank.
Local equivalent This indicates the EFT amount in your local currency.
Check register or C/B key

This indicates the check register in which the EFT was created if the payment originated in the Accounts Payable module.

For an EFT payment which originated in the Cash Book module, this indicates the key for the transaction created in the Cash Book Transaction Detail table/file.

Hints and tips

  • You can use the EFT Payments Re-extract program to re-extract a batch of payments.

Notes and warnings

Restrictions and limits

  • Payment extract transactions are not created for Accounts Payable EFT payments if you set the option Check print requirement to Not required (Accounts Payable Setup).

  • You can only extract transactions for a single bank and a single currency at a time.

Delete AP entry

This function only removes the selected transaction from the EFT system so it is excluded from the payment batch which is extracted.

It does not reinstate the invoices in the Accounts Payable module. You need to use the Payment Cycle Maintenance program to reinstate the invoices against the supplier.

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the eSignature Setup program.

eSignature Transaction Description
EFT Payments extract control

Controls access to the extraction of payments in the EFT Payments Extract program.

EFT Payments extract details

Controls access to the details of payments extracted in the EFT Payments Extract program.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.