Creating cash payment tapes

You can create cash payment tapes in the Automated Clearing House (ACH) or Bankers Automated Clearing System (BACS) format. You can use cash payment tapes to pay the scheduled invoices for vendors that accept payment by cash payment tape.

To create a cash payment tape, follow these steps:

  1. Access Payment Tape Creation (AP160).
  2. On the Main tab, specify this information:
    Pay Group
    Select a pay group as defined in Pay Group (AP01.1).
    Payment Code
    Select the cash payment as defined in Bank Transaction Definition (CB00.4).
    Note: You must run this program for each cash code and payment code combination defined for tape output and processed by the most recent run of Cash Requirements (AP150) in update mode.
    Process Group
    To process payments concurrently and balance the load, select a process group.
    Cash Code
    Select a cash code from which to create a payment tape.
    Note: You must run this program for each cash code and payment code combination defined for tape output and processed by the most recent run of Cash Requirements (AP150) in update mode.
    Cash Code Group
    To create a payment tape for the cash codes referenced on the cash code group, select a cash code group.
    Cash Code List
    To create a payment tape for the cash codes referenced on the cash code list, select a cash code list.
    Note: You must first define the cash code list using List (MX10.1). See List.
  3. On the Select Options tab, specify additional values for the payment tape:
    Payment Date

    Specify the payment date that is assigned by Payment Closing (AP170) to general ledger transactions created for payments.

    Effective Date
    Specify the date that the funds are transferred from the bank account.
    Starting Number
    Specify the starting transaction number. If you leave this field blank, then the starting number is assigned based on the starting document number defined for the cash payment format.
    Note: If you select a cash code group or cash code list, then you cannot specify a starting number.
    Print Remittance
    Select whether to create remittance advice forms along with the payment tape. If you select Yes, then you must define the cash code and payment code for remittance forms.
    Create Prenotifications
    If you are creating a payment tape for Automated Clearing House, then select whether to create pre-notification entries along with the payment tape.
    BACS Serial Number
    If you are creating a Bankers Automated Clearing System (BACS) payment tape, then specify the serial number.
    Document Currency
    Select to create payment forms in the currency of the bank account (cash code) or the currency of the invoices.
    Print Comments
    Select to print comments.
    Use AP150 Sort Options
    Select to sort payment records in the sort order displayed on Cash Requirements (AP150). The default value of this field is N.
    Electronic Transfer Bank Type
    If you select 0, then the leading spaces in the electronic transfer bank you define in Cash Code (CB00.2) are replaced with zeroes. If you select Other, then the electronic transfer bank is reformatted.
  4. If you are recreating a tape, then specify the parameters on the Rerun Options tab:
    Recreate Tape
    To recreate a payment tape, select Yes.
    Serial Number
    Specify the serial number assigned to the tape to recreate.
  5. On the File Name tab, specify a tape file name or a receipt file name.
    Note:  If you leave the Tape Filename and the Remit Filename fields blank, then the existing file names are used.
  6. On the Output Options tab, define the format options for the tape output file. Specify this information:
    Create Labels
    Select to include headers and footers in the ACH tape output file.
    Format
    Select to produce ACH tape output file in these formats:
    • CCD
    • PPD
    • IAT
    • CTX
    Balanced Tape
    Select whether to create a balanced or unbalanced tape file.
Related topics