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.