Background: AP Payment Register
Use the AP Payment Register (NCR) program to print the AP Payment Register and update the general ledger. See Road Map for work flow.
This topic has these subtopics:
Alternate Payments
Post Check Register Cash by Payment Number
Updates
Preview and Final Register
Alternate Payments
When you select an alternate payment batch, the AP Payment Register creates an invoice for the credit card company or electronic funds transfer processor. The next time you run Vendor Payments, you will be able to select this invoice for payment.
If you do not want to use this feature, leave the Vendor number field in the AP Payment Method Codes Maintenance (TAPM) program blank.
Post Check Register Cash by Payment Number
If you select the System Options (XM) (Accounts Payable Options) Post ck register cash by payment no? option, it will be easier to reconcile the bank account when using the GL Activity Inquiry (GTL) program instead of the bank reconciliation system.
When active, the AP Payment Register (NCR) overrides the general ledger journal detail key for the cash account only and uses the payment number instead of the vendor/invoice number. The AP transactions and the discount transactions are still in invoice number detail, to match up with the NR postings (so you see both a debit and a credit of the same amount). Note that the reference for the payment transaction still includes an invoice number; it is just the first invoice that was paid.
Updates
The program updates vendor statistical information:
Data |
Display by this program |
Year-to-date payments |
Vendor-AP History Inquiry (VMHQ) |
Last payment date and amount |
Vendor Maintenance (VM) |
YTD payments |
Vendor History Listing (VSL) |
Checks and the invoices paid by each check |
Check Inquiry (NCI) |
Check information |
1099 Inquiry (N99Q) |
Check information |
Bank Reconciliation (NBC) if you selected the Bank reconciliation system active? option in the System Options Maintenance (XM) program (Accounts Payable Options) |
Preview and Final Register
When you print the AP Payment Register, these documents print in this order:
Seq |
Document |
Comments |
1 |
Preview register |
Review to be sure that it is correct. |
2 |
Preview journal |
If these options are selected:
|
3 |
Final register |
If this option is selected:
|
4 |
Final journal |
If these options are selected:
|
The AP Payment Register includes this information:
Vendor or alternate remit-to number
Vendor name or alternate remit-to-name
GL organization code
Invoice number
Invoice date
Invoice amount due
Discount taken
1099 withholding tax
GL account number
Check number
For a credit card or EFT (Electronic Funds Transfer) payment, [Payment type]/ AP Invoice Register number or [Payment type]/[Number]Check date
Potential discount
Payment amount
Check amount
Currency
Reference for the invoice
Transaction type: BI: Billing invoice
Invoice due date
Vendor subtotals for amount due, discount taken, 1099 withholding tax, potential discount, payment amount, and check amount
If this is a 1099 vendor:
Invoice number
1099 reportable amount
Payment amount
1099 tax withheld
Totals for this batch:
Amount due
Potential discount
Discount taken
1099 tax withheld
Payment amount
Amount applied: Discount taken + 1099 WH tax + Payment amount
1099 reportable amount