Feature - Payment History Inquiry

Release Date: 7/18/19

Version: 8.2 and Up

This feature allows the user to see a customer's payment history summarized by date and payment document number.  This is beneficial for accounts receivable and sales departments to easily view the payment history for a customer.  

The Global Setup option Acct-> A/R Global Control-> field 29. Number of Days for Payment History Inquiry has been added to limit the amount of data shown in the inquiry screen.

  29. Number of Days for Payment History Inquiry - The default value is zero. A value between zero and 9999 can be entered. If set to zero  or 9999, all payment records will be displayed. 

The new Payment History Inquiry application is available on the Special Functions menu for the following applications:

• Customer Account Inquiry
• Customer Account Summary
• Cash Receipts Change Mode
• Customer File Maintenance
• Order Entry
• Copy/Consolidate Order
• Customer/Vendor Labels
• Order Inquiry and Order Inquiry Drill Down 
• Ship-To File Maintenance
• Invoice Inquiry By Customer Referral
• Invoice History Inquiry By Invoice
• VICS Bill of Lading
• Cancel Pick Ticket
• Fill Back Orders
• Print One Invoice
• Release Held Orders
• Sales Desk
• Stock Status Inquiry

Users must have rights to access either Customer Account Inquiry or Customer Account Summary to have access to the Payment History Inquiry.

If the user has access, the Payment History Inquiry will be available from the Special Functions menu of the applications listed above.

This will launch the Payment History Inquiry application.

The top list contains payment information summarized by the document number (Pay No.) and payment date. The list is shown in descending order by payment date. 

Pay No. - payment document number

Payment Date - payment date

Type - type of payment 

• CS = Cash
• CK = Check
• GC = Gift Certificate
• CC = Credit Card
• WR = Wire Transfer
• AC = ACH

Reference - payment reference

No. Docs - the number of documents paid

Total Payment - the total payment amount

The Edit List button will print a report with the selected payment summary line and the corresponding detail lines.

Users can press the right mouse button while highlighting a line in the option list. This will pop up a menu with the following options:

Customer Notes - This gives the user access to the customer's note. If there are notes on file for the customer, a check mark is shown.

Customer Attributes - This gives the user access to the customer's attributes. If there are attributes on file for the customer, a check mark is shown.

Customer Links - This gives the user access to the customer's links. If there are links on file for the customer, a check mark is shown.

Customer Contacts - This gives the user access to the customer's Contacts. If there are contacts on file for the customer, a check mark is shown.

Print Edit List - This will print the edit list show above.

The This List - This will give the user the option to print the selected line from the top list with or without the detail records.

Cancel - This will cancel the popup menu.  

The bottom list contains all of the items that were paid with the payment document that is selected in the top list.

Doc No. - document number that was paid

Type - document type 

• I = Invoice
• D = Debit Memo
• F= Finance Charge

Doc Date - document date

Apply To - document apply-to number (payment records that are applied to zero are shown in the detail area and the apply-to will be shown as Open)

Due Date - due date for the document

Amount-1 

Amount-2

Doc Total - Amount-1 + Amount-2

Amt Paid - payment amount that was applied to the document

Reference - document reference

Age - number of days between the document due date and the payment date (A negative age indicates that the document was paid before the due date. A positive age indicates that the document was paid after the due date.)

New Programs: SYTABPAY, SYPAYGUI, SYPAYGUI.GDF, TABPAYMT.GDF, PAYMHIST.WS, PAYMHIST.PL

Programs Modified: NSCTLFIL.FD, NSCTLFIL.W33, NSCTLINI, NSCTLMN2, ARACTINQ, ARACTSUM, ARCSHCNG, ARCUSMNT, CP0101, CP0102, CP02S5, CP0400, CP1001, CP1705, CP1713, CPBOLMNT, CPBOLUDS, CPCNLPIC, CPFBCBYI, CPONEINV, CPORDINQ, CPRESORD, CPSLSDSK, IM0500, IM0500Q, IMINVINQ

CLS

• Related Articles

• ARACTINQ Accounts Receivable Customer Account Inquiry

  Customer Account Inquiry Application Overview This feature Customer Account gives you a quick and easy procedure to display a customer's account by both Open Item and previously purged records in the Open Item History File. Inquiry views include ...

• AP0400M Accounts Payable Vendor Account Inquiry

  Inquiry Vendor Account Inquiry Application Overview Whenever you need information on a particular vendor's account or a particular invoice, Vendor Account Inquiry is the application to use. This application displays the vendor's name, terms, invoice ...

• AR Aging Report - What's the Difference Between Py and Px Payment Type ?

  Q - Our accounting staff has noticed that in the V8 AR Aging reports, payments are tagged with both a "Py" and a "Px." The "Px" seems to be new as of V8. See sample from the AR Aging Report below: 355747 08/06/15 C 355901 08/06/15 5.82- .00 356330 ...

• ARSRCMNT Accounts Receivable Payment Source File

  Payment Source File Application Overview This feature allows you to assign G/L accounts for various payment codes used in Elliott and the Elliott Shopping Cart. Additionally, you can set up and post to accounts for credit card surcharges and ...

• AR Payment Dispute Management with Reason Code

  Release Date: 08/13/2021 Version: 7.x & Up Q - In the AR Open File the Reason Cd field exists. See sample screen below: We are looking for a better way to track payment disputes and issues. What built-in options are available to track disputes and ...