Credit Card Prepayment Information Flow
As you accept prepayments, information is stored in tables within JDE for later use during the sales order cycle. Below is an outline of when this information is collected and the associated tables.
When you enter a payment instrument representing credit card in the sales order it is stored in the Sales Order Header (F4201) and Sales Order Detail (F4211) tables in JDE.
When you process a credit card authorization and/or settlement the information is stored in the Prepayment Transaction (F004201), Prepayment Tag File (FQ670041), and Credit Card Information (FQ67CCIF) tables.
Credit card payments that are applied after settlement are written to the Electronic Receipts Input (F03B13Z1), Receipts Header (F03B13), Receipt Details (F03B14), and Customer Ledger (F03B11) files.
When you post a credit card payment information is written to the Account Ledger (F0911) and Account Balance (F0902) tables.
Payflow™ Payment Gateway and Web Service information holds data the Connection Settings (FQ67SYS1) and Provider Settings (FQ67SYS2) tables.
Please note that when you go directly to your gateway (PayPal, Computop, BrainTree, EBANX) and process a credit card sale directly in their system JDE will not be aware of the payment. Therefore, you will have to process the payment manually in JDE through the steps automation would have handled. This includes expiring/voiding the authorization in JDE if you perform a settlement directly.
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 PayCloud - 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