Credit Card AR Settlement Report - RQ6704209
The credit card AR open invoice settlement batch report (RQ6704209) selects all open accounts receivable invoices containing a payment instrument with special handling code ‘1SCR’ at the accounts receivable invoice line level in table F03B11. All invoice lines selected not having been previously settled will sum the open amount (RPAAP) net of any available discount (depending upon processing option setup) by invoice document number (RPDOC), invoice document type (RPDCT), invoice document company (RPKCO) and invoice document pay item line (RPSFX) and charge (perform a sale transaction) the customer’s credit card.
The credit card charged by the report will be selected based on the sales order associated to the invoice line item and fetched from the future payments and/or prepayment table. If an associated sales order does not exist or a credit card record does not exist in the prepayment table (F004201) then the report will fetch the credit card from the credit cards on file table (FQ67CCIF) based on the processing option setup. In credit cards on file you can designate a credit card for specific use with the AR open invoice settlement batch report and if not specifically assigned then the everywhere designated credit card will be used.
If a successful settlement charge is obtained a payment record will be written to the automatic receipts processing (F03B13Z1) and prepayment (F004201) tables for clearing of the accounts receivable invoice pay item line(s). Please refer to the Recording Settled Credit Card Transactions in Financial System section of this manual for more information.
This report requires the creation of a new payment instrument. The actual value for the new payment instrument does not matter but the special handling code assigned to the new value must be ‘1SCR’. The new payment instrument must exist in UDC 00/PY and table FQ67RYIN. It must also be represented in the FQ67SYS1 and FQ67SYS2 tables. Please see the Credit Card Processor Connection Settings section of this manual for more information. It might also be necessary to adjust data selection on any reports to include the new payment instrument.
This report should run in a single threaded queue.
This Section Also Contains
- Credit Card Prepayment Information Flow
- Credit Card Prepayment Flow
- Credit Card Prepayment Setup
- Entering Sales Orders
- Updating Credit Card Prepayment Information - PQ670041
- Clearing Multiple Accounts Receivable Invoices with Credit Card Payment - PQ670042
- Uploading Customer Credit Cards on File - PQ670043
- Work with Future Dated Receipts - PQ670313
- Auto Invoice Payment Rules - PQ670315
- Authorize by Message Status Application - PQ674236
- Pay Invoice by Message Status - PQ674237
- Work with Companies by Store - PQ679912
- Credit Cards on File - PQ67CCIF
- Apply AutoPay Rules - RQ670315
- Surcharge Errors - PQ67SUER
- Batch Authorization of Credit Card Transactions - RQ6704201
- Settling Credit Card Transactions - RQ6704202
- Recording Settled Credit Card Transactions into Financial System - RQ6704203
- Credit Card Prepayment Analysis Report - RQ6704204
- Authorized Credit Card Expiring Report - RQ6704205
- Clearing Sensitive Card Holder Information - RQ6704208
- Credit Card AR Settlement Report - RQ6704209
- Deposit Settlement Report - RQ6704210
- Renew Credit Card on File - RQ6704212
- Credit Card Reconciliation - RQ6704213 & RQ6704214
- Credit Card Surcharge Fee Batch Report - RQ6704215
- Authorize by Email Automated Process - RQ6704216
- Create Invoice Payment by Email Process - RQ6704217
- Pay Invoice by Email Process - RQ6704218
- Update JDE Payments to Payment Processing Console (PPC) - Email Payment Document - RQ6704219
- Change Invoice Email Status to Expired - RQ6704220
- Credit Card Future Payments Process - RQ670429F
- Import Credit Card on File Information from Cloud - RQ67CCIF