30 Load Bank Tapes

This chapter contains the topic:

30.1 Loading Bank Tapes

Navigation

From Accounts Receivable (G03), choose Automatic Receipts Processing

From Automatic Receipts Processing (G0313), choose Load Bank Tape - Custom

If you receive payments directly from a customer's bank on custom bank tapes (lock box), you must load the information from the bank tape to the Accounts Receivable system to apply them to the customer's account.

When you load a bank tape, the system:

  • Reads the tape from the bank

  • Creates a Bank Tape Worktable (F03551) to store the information from the tape

  • Converts the information in the worktable to the Batch A/R Cash Application table (F0312)

The following graphic illustrates how the system processes bank tape information.

Figure 30-1 Bank Tape Information Processing

Description of Figure 30-1 follows
Description of "Figure 30-1 Bank Tape Information Processing"

After the system converts the information in the worktable to the Batch A/R Cash Application table, it applies the receipts to the appropriate customer accounts in the A/R Ledger table (F0311). The system stores those items that it cannot process in the Batch A/R Cash Application Worktable until you rework and process them. Then it applies the reworked items to the A/R Ledger table.

30.1.1 Before You Begin

  • Set the appropriate processing options for the version you want to run. You must access the processing options from the menu before you choose the Load Bank Tape - Custom program. Once you choose this program from the menu, you cannot change the processing options.

  • Ensure that the bank tape program is customized based on the information provided by your bank.

  • Activate Auto Cash on accounts receivable constants.

  • Ensure that the following information is set up in the customer master record for each customer eligible for bank tape processing:

    • A bank transit account number, as well as an account number

    • An auto receipt value

    • An auto cash algorithm

To load the bank tape

  1. Choose the Load Bank Tape - Custom program from the menu.

  2. Respond to the warning message.

  3. Install the bank tape on a tape drive, if you have not already done so.

  4. Respond to the prompts that the system displays.

30.1.2 What You Should Know About

Topic Description
Releasing the lock on the system If you press exit at the Load the tape prompt, the system locks up. To release the lock, choose 4 in the Option field and press Enter.
Journal entry creation Do not enter detail and summary records in the same batch. Instead, create a separate batch for each type of record. The mode (detail or summary) in which you enter transactions from the bank tape affects later processing.

When you process batch receipts, you must use the corresponding version (detail or summary) to process the batch. For example, if you enter receipts from the tape in summary mode, you must later process them in summary mode. If you enter them in summary mode and then try to run the detail version when processing batch receipts for the same receipts, the system cannot process them


See Also:

30.1.4 What You Should Know About Processing Options

Topic Description
Journal entry creation (3) Do not enter detail and summary records in the same batch. Instead, create a separate batch for each type of record. The mode (detail or summary) in which you enter transactions from the bank tape affects later processing.

When you process batch receipts, you must use the corresponding version (detail or summary) to process the batch. For example, if you enter receipts from the tape in summary mode, you must later process them in summary mode. If you enter them in summary mode and then try to run the detail version when processing batch receipts for the same receipts, the system cannot process them.


30.1.5 Data Selection

The versions for Process Batch Receipts include the correct data selections. Do not change this information.