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
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
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
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
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