Display Customer Payment Performance

Use the Payment History Inquiry (RPHQ) program to display a customer's payment performance, including how promptly the customer pays invoices. See Road Map for work flow.

Enter the customer's number, enter the customer's AR consolidation parent, or click the Lookup icon and use the standard lookup options to select the customer from a list.

The program displays these fields:

Field Name	Displays
Customer	The number and name of the customer you entered
AP contact	The name of this customer's AP contact
Terms	The code for the payment terms for this customer followed by the code description
AP phone	The telephone number of this customer's AP contact

The program displays these fields for each invoice:

Note
Deposits are not included. If you compare the total balance due displayed here to the total balance due in AR Inquiry (RA) be sure to exclude deposits and review your settings for including disputed invoices.

Field Name	Displays
Invoice no	The number of an invoice
Inv date	The date the invoice was entered
Due date	The date that payment was/is due For progress payments, this is the date of the final payment
Paid	The date this invoice was paid Blank: This invoice is not paid
To pay	The number of days between the invoice date and the final payment
Late	If the invoice was paid late, the number of days between the due date and the final payment; blank if the invoice is not fully paid The system calculates the due date for an invoice based on the customer's AR terms. Invoices paid exactly on time are neither early nor late.
Early	If the invoice was paid early, the number of days between the date paid and the due date; blank if the invoice is not fully paid The system calculates the due date for an invoice based on the customer's AR terms. Invoices paid exactly on time are neither early nor late.
Inv amount	The original invoice amount
Balance due	The balance to be paid
Disp	Whether this invoice is disputed
Rsn cd	If Y displays in the Disputed? field, the reason this invoice is disputed
AR terms	The AR terms code for this invoice
Prom pmt	The date the customer promised to pay
Prom by	The name of the person promising to pay by a specific date
Order type	The order type; typically sales order
Source type	The source type; e.g., sales order, return material authorization, repetitive billing

(Optional) Click Prog opts to set your options:
1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
2. Click the Sort tab to set sort order.
3. Click the Selection tab to select specific records.
4. Click the Program tab to set these program specific options:

Field Name	Type / Max Length	Action / Description
Include history?	Optional	Select to display fully paid invoices that have been moved to history with the AR Transaction Archive (REX) program or leave blank to omit them.
Exclude disputed invoices?	Optional	Select to omit invoices that are disputed or leave blank to display them.

1. Click Save to save these options for future use.
2. Click OK to apply these options or click Cancel to exit without applying them.

(Optional) Click Stats to display these fields:

Note
Credit memos and no charge invoices are not considered in payment statistics calculations

Field Name

Displays

Avg days to pay

The average number of days the customer took to pay an invoice: Total number of days to pay / Number of invoices paid in this time period

Ave days late

The average number of days the customer was late paying an invoice: Total number of days late / Total late invoices

Ave days early

The average number of days the customer was early paying an invoice: Total number of days early / Total early invoices

Weighted avg days to pay

The average days to pay based on the proportional relevance of the age of the invoice. The weighting factor depends on how current the invoice is. Recent invoices and their respective payments are considered more important than other invoices. Invoices in these days ranges are weighted:

Days	1-6	7-12	13-18	19-24	24+
Weight	+ 10	+ 7	+ 4	+ 2	+ 1

Paid invoices

The number of paid invoices excluding credits and no charge invoices

Late invoices

The number of late invoices for this customer

Early/on-time invoices

The total number of invoices the customer paid on or before the invoice due date

Last payment amount

The amount of the last payment

Last payment date

The date of the last payment

Unpaid

The number of invoices with a balance (i.e., invoices with a credit or zero balance are not considered)

% late

The percent of invoices that this customer paid late

% early/on-time

The percent invoices that the customer paid early

Number of invoices paid in

The number of invoices paid in the displayed period of months: 1-6, 7-12, 13-18, 19-24, over 24 months, and totals.

The number of invoices for which To pay is or was less than or equal to the category displayed: 1-30 days, 31-60 days, 61-90 days, over 91 days, totals, and average days to pay for these invoices.

Note
Click Close to remove this data from the display.

(Optional) Select an invoice and click Invoice to display invoice information. See Display AR Invoices. Click OK to return to this program.
Choose the appropriate options:

To	Do This
Review your options for this program	Click Prog opts. See Set Options for Reports and Inquiries.
Go to a related program	Click Jump. See Jump.
Display the selected invoice	Click Invoice. See Display AR Invoices. Click OK to return to this program.
Display the average days to pay, average days late, average days early, and the total balance due	Click Totals. Click Print totals to print this data or click Exit to continue.
Print the invoice listing	Click Print. See Print an Inquiry.
Display statistics for this customer	Click Stats. See step 3.
Exit this customer	Click Exit.

Choose the appropriate options when you click Exit:

To	Do This
Display the selected record	Click OK.
Display the previous record in the file	Click Prev.
Display the next record in the file	Click Next.
Exit the program	Click Exit.