Oracle AR Credit Card Issue Setups

Oracle Orac le Champions http://www.oraclechamps.com CREDITCARD PAYMENT SETUPS

The purpose of this Document is to provide credit card set up steps for Oracle Account Receivables (AR) module. Oracle Receivables allow customers to use a credit card to remit payments for open debit items. The procedure for processing credit card payments in receivables is similar to the procedure for creating automatic receipts. Automatic receipts allows you collect payments according to a predefined agreement with your customer by transferring funds from the customer’s bank account to yours on the receipt maturity date. By providing a credit card number as payment, your customer expects that the credit card issuer will transfer funds to your bank account as payment for their open debit items. The following steps are required to process credit card payments in receivables: Flag transactions to be paid by credit card. Create a batch of automatic receipts to close transactions flagged for credit card payment. Approve the automatic receipts batch to reserve the payment mount from the card holder’s account. Create and approve a remittance batch to request transfer of funds from the credit card issuer to your bank. · ·

·

·

Following Are The Key Set Up Considerations In Credit Card Set Up . Step-1 Define Remittance (Internal) Bank Account Step-2 Define Receipt Class Step-3 Create and Assign Document Sequence for Automatic Receipts Step-4 Verify Verify That T hat the I paym payment ent Serve r URL Is Defin De fined ed Step-5 Create Create In Invoice voice and Flag F lag for Credit Ca Ca rd Processing Proces sing Step-6 Run Automatic Automatic Re ceipts For Approva Approvall Step-7 Run Automatic Remittances for Capt Capture ure

Below Are The Steps In Detail: Step-1 -----Define Remittance Bank ->Setup->Receipts->Bank

Oracle Orac le Champions http://www.oraclechamps.com The customer's credit card number is defined as an account number under a central 'credit card' bank and branch. The expirati expirat ion date is the inact inactive ive date. date. a credit cred it card receipt class and payment method are also defined with the user's remittance bank. Step-2 -----Define Receipt Class Setup->Receipts->Receipt Class Name: Receipt_Class_Name Creation Method: Automatic Remittance Method: Standard Clearance Method: By Matching (If You Are Using Cash Management) By Automatic Clearing (If Cash Management NOT In Use) Payment Method Zone Name: Visa (Example) Automatic Receipts Zone Number Of Receipts Rules: One Per Invoice Receipt Maturity Date Rule: Earliest Automatic Print Programs: Print Receipts Program Payment Type: Credit Card Lead Days: 35 Merchant ID: 12345 (this is the number that you have defined as your merchant or payee id in ipayment) To verify the merchant id value in release 11.5 Select Name, Payeeid, Mpayeeid From Iby_Payee; ·

Merchant ID selected in AR should exist in i-payment Iby_Payee . Payeeid Attach Your Remittance Bank To The Payment Method. Click Bank Accounts Button Bank Name: Bank_Name Branch Name: Bank_Branch Account Name: Bank_Account_Name Minimum Receipt Amount: 100.00 (Example) GL Accounts entered in the remittance bank should populate.

Oracle Champions http://www.oraclechamps.com

Step-3 -----Login As Sysadmin. A) Application->Document->Define Name: Credit_Card_Sequence Application: Oracle Receivables Type: Automatic Initial Value: 1 ACCESS ZONE AT THE BOTTOM OF THE FORM Oracle Username: AR, APPS SAVE

B) Application->Document->Category Application: Oracle Receivables Code: Visa (This Must Be Exactly The Same As Your Payment Method) Name: Credit_Card_Category Table Name: AR_CASH_RECEIPTS_ALL SAVE

C) Application->Document->Assign Application: Oracle Receivables Category: Credit_Card_Category Set Of Books: Vision Operations(Example) Method: Automatic Assignment Tab Start Date: 19-Aug-2009 (Example) Sequence: Credit_Card_Sequence

Oracle Champions http://www.oraclechamps.com SAVE

Step-4 -----In Sysadmin Profile->System Check Site Level Query Profile: ICX: Payment Server URL Verify that your base URL for the ipayment server is populated. There is not a lov on this field you must enter the value.

Step-5 -----(For Manual Invoices) Transactions->Transactions Enter invoice and populate the paying customer alternate region. Enter the paying customer, and location Enter the visa payment method from LOV Enter a valid credit card number or test number provided by the credit card vendor. Complete. Save. Step-6 -----Receipt -> Batches Provide appropriate values for Automatic Receipts Payment Method Receipt Class Click Create Button Enter criteria to determine eligible transactions; if you have defined a payment method for each credit card you can limit your criteria by credit card number range. Select Create, Approve

Oracle Champions http://www.oraclechamps.com Click OK Button Review the log and output file to see that there receipts were created and approved. This program creates and authorizes the receipts via the ipayment server.

Step-7 -----Receipts->Remittance Choose the batch that you created and run automatic remittances. This program captures (settles) the funds via the ipayment server. Review the log and verify that there are no errors.

To check the data in ipayment. select tangibleid,reqdate,reqtype from iby_trxn_summaries_all where TANGIBLEID in ('106011_ONT','AR_94585')---This are the Payment Server Order Number..


New Creditcards addition Setup


Oracle Champions http://www.oraclechamps.com (Funds Capture)Payment Process profile setups



Oracle Champions http://www.oraclechamps.com Payment System & Payment system Accounts






\






Oracle AR Credit Card Issue Setups

Recommend Documents