18 Process Automatic Debits

This chapter contains the topic:

18.1 Processing Automatic Debits

Navigation

From Accounts Receivable (G03), choose Manual Receipts Entry

From Manual Receipts Entry (G0312), choose Other Receipts Entry Methods

From Other Invoice & Receipts Entry Methods (G03111), choose an option under the Automatic Debiting heading

Businesses in the United Kingdom can automatically debit a customer's bank using electronic funds transfer (EFT). Transfers must adhere to the standards set by the BACS (Bank Automated Clearing System). Businesses can send transfer information to the bank via modem, tape, or diskette.

To process the automatic debit, the BACS processing date and the expiration date of the debit must be actual work days. In addition, it is common business practice to:

  • Send statement reports to the customers regarding the debit

  • Sequentially number each debit that is processed

You can use J.D. Edwards standard automatic debit process to meet the requirements of the United Kingdom. When you use the automatic debit process, the system:

  • Identifies those customers who have agreed to the automatic debit process

  • Selects the customers' invoices that are due

  • Validates the processing and expiration dates against a work day calendar

  • Assigns each debit a sequential number, based on the Accounts Receivable Next Auto Debit number in the Next Auto Debit Number file (F7460)

  • Generates debit information in the BACS format

  • Generates statement reports for applicable customers

  • Updates customers' accounts after collecting the appropriate funds

18.1.1 Before You Begin

Note:

When you run the Automatic Debiting program to process UK BACS, you must specify program P03575BT in processing option 10. The program generates a bank file that adheres to the BACS banking standards for automatic debits.

18.1.2 Proof Mode

When you run the program in proof mode, the system:

  • Verifies that you have specified an existing work day calendar in the processing options. If not, the system issues a warning message stating that no calendar was found.

  • Verifies that you have entered a valid BACS processing date in the processing options. The system issues a warning message to indicate that the day you entered is not a work day.

  • Prints a report that identifies the invoices that will be included in the automatic debit process.

  • Does not update the A/R Ledger file.

18.1.3 Final Mode

When you run the program in final mode, the system:

  • Validates the BACS processing date against the work day calendar that you specify in the processing options. If the date is not a work day, the system searches for a valid work day based on the work day calendar that you specify in the processing options, incrementing the date by one day until it reaches the next valid work day.

  • Numbers each debit, based on the bank information for the invoice

  • Updates the selected invoices as paid

  • Creates a batch to post receipts to the Account Ledger file (F0911)

  • Prints statements of the invoices being debited for the customer

  • Prints a final report of processed invoices

  • Creates a file (F03575BT) in the accepted BACS format for the United Kingdom

Caution:

If you do not setup and specify a work day calendar, the system uses your BACS processing date without performing the necessary validation.

After you process automatic debits in final mode, you can review and approve them before posting them to the general ledger.

18.1.4 What You Should Know About

Action Explanation
Excluding invoices You can exclude invoices from the automatic debiting process using Speed Status Change. To do this, change the payment status to hold. Then, verify that the data selection and processing options for Automatic Debiting program are set to only select invoices with an approved status.
Calculating the BACS expiration date The system calculates the BACS expiration date based on the value that you enter in processing option 11 for the Automatic Debiting program. To calculate the expiration date, the system uses the BACS processing date that is written to the BACS file and then adds the number of days you specify in the processing option.
Processing credit amounts You can include credit amounts in your BACS file so that you can collect outstanding amounts from your customers and make refunds in the same run. Use processing options for the Automatic Debiting program to specify minimum and maximum credit and debit amounts.

If you specify minimum and maximum credit and debit amounts, use the following guidelines:

Specify values in the currency of the bank account

The system compares the values to the total value of the invoices for each customer per date.

Running the Automatic Debiting program twice The system prevents you from running the same version of the Automatic Debiting program until you copy the tables that were created by the version to diskette. This protects the information from being overwritten by a new version before it is saved.
Adjusting the entries in an automatic debit batch After you run the Automatic Debiting program in final mode, you can use the standard Cash Receipts program to:

Reverse, void, or identify as non-sufficient funds (NSF) a transaction after the automatic debit batch has been posted

Delete a transaction from an automatic debit batch before posting