Understanding the Methods for Displaying Open Invoices

To specify the invoices that a receipt or draft pays, you must display them on the payment entry form. Regardless of the method that you use to locate open invoices, you specify search criteria on one form, and the system returns the invoices that meet the criteria specified on the receipt or draft entry form.

The system provides these methods for displaying open invoices that you want to pay:

Method

Description

Load Invoices

The system displays all the open invoices for the specified payor that meet the additional search criteria specified:

  • Company: You can specify one company or enter * for all companies.

  • Currency Code: You can specify one currency code or * for all currency codes.

The system displays the invoices in order by due date.

Select Invoices

The system displays all the open invoices that meet the search criteria that you enter:

  • Payor or Customer

  • Company: You can specify one company or enter * for all companies.

  • Currency Code: You can specify one currency code or * for all currency codes.

Additionally, you can use the QBE row to specify additional search criteria, such as the document type or statement number.

The system displays the invoices that meet the criteria that you specified. You then select each invoice pay item that you want to pay. After invoices are selected, you can alter the search criteria and select more invoices. The system returns all the invoices selected in the order that you selected them on the payment entry form.

Select Invoices by Remittance

You use this method to enter the remittance information from the bank. You enter information about the invoice, such as the invoice number, in the Invoice Reference field, and the system indicates the number of invoices located that meet the criteria that you specified. You use a separate detail line to specify different search criteria.

Processing options enable you to set up a default search order that the system uses to locate the invoices based on the value entered in the Invoice Reference field. The system can locate open invoices by:

  • Invoice number (DOC)

  • Sales order number (DOCO)

  • Customer reference number (VR01)

  • Statement number (CTL)

  • Shipment number (SHPN)

With the exception of statement number, the system uses the invoice reference to locate invoices from the F03B11 table. The system locates invoices using the statement number from the A/R Notification History Detail table (F03B21).

Regardless of the method that you select to display open invoices, the system does not retrieve these types of invoices:

  • RU (Unapplied receipt)

  • R1 (Drafts)

  • R5 (Deductions)

  • NP (Partial NSF)