Selecting invoices for payment

The first step in the cash payment cycle is to select the invoices to pay. You define the dates that are used to select invoices for payment and to determine whether discounts are taken. You can change the parameters and rerun the program that schedules invoices for payment as many times as needed until the listing includes just the invoices desired. Use this procedure to select invoices for payment.

Select invoices for payment

  1. Run Cash Requirements (AP150) to schedule invoices for payment. This program creates a listing of the scheduled payments, calculates currency gains and losses, and calculates the discounts lost by vendor. When the quantity of invoices exceeds 9999 invoices, a new payment record is created.
  2. Define parameters on the Main tab.
  3. Specify this information:
    Pay Group

    Select a pay group. Pay Groups are defined in Pay Group (AP01.1) .

    Process Group

    To run this program for an entire pay group, leave this field blank. If you use process groups, select a process group and run the program once for each process group.

    Pay Through Date

    All released invoices that have a due date on or before the Pay Through Date are scheduled for payment. Select a date that ensures there is no gaps in payment. For example, if you run checks every Tuesday, pay invoices due through Monday of the next week. Invoices marked for immediate payment are scheduled regardless of their due dates.

    Payment Date

    The Payment Date is used to determine whether to take invoice discounts and to revalue non-base currency invoices. The Payment Date must be less than or equal to the Pay Through Date.

    Process Payments

    You decide whether to process AP payments, CB payments, or both (the default is AP payments). Only payments with a status of Released are processed.

    For information about processing cash ledger payments, see the Cash Management User Guide.

    Update

    You can run this program in report or update mode. You can rerun this program regardless of the update option you select. You must select Update for the final run of the program because cash payments are created only for invoices listed in the last Cash Requirements run in update mode.

    Enforce Addenda Record Limits

    Select Yes or No. Yes will enforce 9999 invoice records and 99,999,999.99 amount record limits for all payment code with an output type of T. The default value is No.

    Take All Discounts

    Select Yes to take the available discount on all invoices scheduled for payment regardless of their discount dates. If you select No, discounts will only be taken if the discount date falls between the payment date and pay through date.

    Report Options

    Select whether to sort invoices in vendor number or search name order within each process level selected.

    Edit Payment Code

    Select a valid payment code which is edited for the addenda record limits. If Edit Payment Code is populated, the Enforce Addenda Record Limits flag must be set to Y. Payment Code must be defined with Output Option = T in CB00.6

  4. Define options relating to cash codes on the Cash Code Options tab. You can select only one option (cash code, cash code group, or cash code list).
    Cash Code

    Select a specific cash code to schedule invoices assigned that cash code. You set up cash codes using Company Cash Code Relationships (CB00.3).

    Cash Code Group

    Selecting a cash code group lets you run AP150 for the cash codes referenced on the cash code group. You set up cash code groups using Cash Code Group (CB11.1).

    Cash Code List

    Selecting a cash code list lets you run AP150 for the cash codes referenced on the cash code list. You define attribute lists using List (MX10.1). List

    Override Cash Code

    Select a cash code to pay selected invoices with an alternate cash code.

  5. Define additional options on the Select Options tab to narrow your selection of invoices.
  6. Specify this information:
    Invoice Company

    To select invoices for a specific invoice company, specify or select a valid accounts payable company number.

    Process Level

    To select invoices for a specific process level, specify or select a valid process level for the invoice company.

    Payment Code

    To select invoices assigned a specific payment code, specify or select a payment code. Represents a type of cash payment. Must be a valid cash payment transaction code in Cash Management.

    Maximum Cash Outlay

    To restrict the total amount selected for payment, specify a maximum cash outlay amount. After AP150 reaches the maximum amount you define, it assigns the Maximum Payment Amount invoice hold code to the remaining invoices selected and prints a list of those invoices. This invoice hold code is temporary and is automatically removed when you run Payment Closing (AP170). If left blank, no maximum cash amount is used.

    Invoice Group

    To select invoices assigned a specific, user-defined invoice group, specify the invoice group.

    Pay Immediately Only

    Select Yes to pay only those invoices flagged for immediate payment. You can use this feature to pay just a few invoices without paying all invoices that are due. Mark specific released invoices as Pay Immediately on Payment Schedule Adjustment (AP30.3) or Invoice Hold Selection (AP40.1)

    Employee Reimbursement

    Select Yes in the Employee Reimbursement field to select employee advances and expenses.

    Invoice Currency

    To select invoices assigned a specific invoice currency, or to exclude invoices assigned a specific invoice currency, specify or select a valid currency code and select Include or Exclude in the adjacent invoice currency option field.

    Currency Option

    To select invoices assigned a specific invoice currency, or to exclude invoices assigned a specific invoice currency, specify or select a valid currency code in the Invoice Currency field and select Include or Exclude in this field.

    Vendor Classes

    To select invoices for vendors associated with a specific vendor class(es), specify or select up to nine valid vendor classes.

    Vendor

    To select invoices for a specific vendor, specify or select a valid vendor for the vendor group associated with the pay group.

    Vendor List

    Use to select invoices for the vendors referenced in the vendor list. Vendor list must have same vendor group as on the pay group specified in the Main tab. If a vendor list is specified, the Vendor must be blank.

    If you specify a vendor list where the vendor group does not match the pay group's vendor group, AP150 will run as if no vendor list is specified and will process all records.

    Special Credit Handling

    Select yes to ensure that Credit invoices are applied to debit invoices within the same AP Company. This removes the possibility of credit invoices being paid against another AP company.

  7. Select check sorting options, such as having all payments that require enclosures or countersignatures sort first, on the Sort Options tab.
  8. Specify this information:
    Sort Option 1, Sort Option 2, and Sort Option 3

    Three fields are available to select sort options for your checks. Sort Option 1 is the primary sort option. Sort Option 2 and Sort Option 3 represent additional levels of sorting. For example, you might sort first by postal code, and then within each postal code sort by vendor name.

    These sort options are used only to sort your payments; they don't impact how information is presented in the Cash Requirements report generated by this program. You will not see the results of this sort until you run Payment Forms Creation (AP155). Use the Report Option field on the Main tab to select a sequence for the Cash Requirements report.

    Amount Limit

    If you are sorting your payments by countersignature or payment amount, you can specify the maximum payment amount that does not require sorting.

  9. If the invoices selected by Cash Requirements (AP150) should not be paid, or if the invoices you want to pay have not been selected, change the parameters and run this program again. The last run of AP150 in update mode is used for payment processing.

Related reports and inquiries

To Run
List potential duplicate invoices Potential Duplicate Payments (AP221)