Understanding the Methods to Display Open Invoices for Tenants

To specify which invoices a receipt pays, you must display the open invoices in the RE Receipts Entry form. You must complete the header portion of the RE Receipts Entry form, as if you were entering an unapplied receipt, before you can select the method to display open invoices. Regardless of the method that you use to locate open invoices, the system returns the invoices that meet the specified criteria on the RE Receipts Entry form.

This table describes the methods for displaying open invoices in the P15103 program:

Display Method

Description

Load open invoices

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

  • Company

    You can specify one company, or enter * for all companies.

  • Currency code

    You can specify one currency code, or enter * for all currency codes.

  • Lease

  • Priority code application

    The system displays the invoices in order by due date unless you complete this field.

Select open invoices

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

  • Payor or Tenant

  • Company

    Specify one company, or enter * for all companies.

  • Currency code

    Specify one currency code, or enter * for all currency codes.

Additionally, you can use the query by example (QBE) row to specify additional search criteria such as lease number or bill code.

After the system displays the invoices that meet the search criteria, you select each invoice pay item to pay and click Select. The system displays a check mark next to each invoice when it is selected. To remove the selection, select the invoice and click Select again. After you select the invoices to pay, you can change the search criteria to select more invoices.

The system tracks the invoices that you select and displays the total number of selected invoices and the total amount of the selected invoices. Also, the system displays the total open amount of the invoices in the grid and the difference amount between the invoices that are selected in the grid and the total of all invoices in the grid.

When you click Close on the Select Invoices form, the system lists all the invoices on the RE Receipts Entry form in the order that you selected them.

Select open invoices by remittance

You can enter the remittance information from the bank. Enter information about the invoice, such as the invoice number, in the Invoice Reference field, and the system indicates the number of invoices that meet the search criteria. Use a separate detail line to specify different search criteria.

Note: If the invoice does not contain the information that you enter in the header portion of the form, in addition to the detail information about the invoice, the system cannot locate the invoice record.

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

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

  • Invoice number

  • Sales order number

  • Customer reference number

  • Statement number

  • Lease number

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

Regardless of the method that you use to display open invoices, the system does not retrieve RU (unapplied receipt) or R5 (deduction invoices).

Note: The system does not display invoices when the bill code is set up with a spread code value of N.

See Setting Up Bill Codes and Adjustment Reason Codes.

If you set a processing option to use a default type input code, the system populates the TI field with the value that you specified when you displayed the invoices on the form.