- OracleApps Epicenter - http://www.oracleappshub.com -

Managing receipts for credit card or ACH transactions

Today world credit cards have become part in the our daily life. Not only have credit cards and different electronic payment options,changed the way that consumers manage their personal finances, these have also enabled companies to reduce the risk associated with receivables and improve their cash flow, and reduce the product delivery timeline.Specially in some sectors where there is direct interaction with Consumer , it is important to manage and do the efficient credit processing and recording hundreds of credit card/ACH remittances in Receivable area.

During in implementation, many times it requires the ability to more efficiently manage receipts for credit card or ACH transactions, therefore this post will brief you on the seeded functionlity offered within EBS.

The Importance?

Oracle Receivables integrates with any feeder system, such as Oracle Order Management, to automatically record and process customer payments made before the delivery of goods or services , such of business Scenario that have company companies who is selling there product through internet channel, which is very similar as buying a Dell laptop from internet and paid most of time credit card transactions or Internet banking. Oracle in there EBS environment refers to these transactions as prepayments.

How ?

Oracle receivables creates prepayments as receipts before the related invoices are created. Later, a business event from your feeder system triggers the invoicing process in Receivables, and an AutoInvoice postprocess matches the prepaid receipts to their related invoices.

When you determine that a prepayment is required, you record the payment information in your feeder system, and the information is passed to Oracle Receivables.

What is expected in the setup side is , in Oracle Order Management, if an order is to be evaluated for prepayment, the underline order must utilize both a Payment Term (Collect Credit Card Prepayment check box) at the order level that enables prepayments and a Payment Type of Credit Card, payment terms for an order line are ignored. At the time of order booking, Order Management will determine if the order is Prepaid and make a call to the Oracle Receivables Receipts API for receipt creation.

The Oracle Receivables Receipts API creates a prepayment receipt in Receivables, and processes the receipt using the payment information provided.

Receivables immediately applies all prepayment receipts against the Prepayment application type, and records accounting according to a special prepayment receivables activity. Receivables reserves these receipts for subsequent reapplication to the invoice or invoices that are eventually generated for the order.

When the order is later sent to Receivables for invoicing, AutoInvoice creates an invoice that is marked as prepaid . Additionally, AutoInvoice initiates a postprocess matching program to identify any open prepaid invoices and search for matching prepayment receipts.

Prepayment matching occurs when a prepayment receipt is created from a feeder system such as Order Management. When the subsequent order is shipped and an invoice is created in AR, the AR Automatic Receipts program automatically creates an application of the prepayment against the Transaction. This ONLY occurs if the Prepayment and Transaction stem from the SAME ORDER. If the order is different then a manual application is required to apply the prepayment.

The other functionality for AR Prepayments is , you can also be modified or cancelled for the orders processed. You can:

What's the difference between Deposits and pre-payments?

In reality , it looks very similar kind of process...

A prepayment is payment in advance of the delivery of goods or services.As discussed above , receivables creates prepayments as receipts before the related invoices are created. Later, a business event from your feeder system triggers the invoicing process in Receivables, and an AutoInvoice postprocess matches the prepaid receipts to their related invoices.

On the other hand Deposit a payment/receipt made against a Transaction or Invoice in advance.

How does a Receipt applied to a Credit Card Prepayment that is created and captured in Oracle Order Management get applied to the Invoice once it has been interfaced via AutoInvoice?

The matching of a Credit Card Prepayment Receipt and the associated Invoice is completed when the Invoice is interfaced into Oracle Receivables via AutoInvoice. The AutoInvoice process will look for all Invoice marked as 'Prepaid'. Once it finds one, it will then unapply the Prepayment from the Receipt that was created via the API AR_PREPAYMENTS_PUB.create_prepayment, and apply the Invoice.

6 Comments (Open | Close)

6 Comments To "Managing receipts for credit card or ACH transactions"

#1 Pingback By ACH briefing.. On December 31, 2007 @ 2:07 am

[…] briefing..Managing receipts for credit card or ACH transactionsRSS News/BlogCredit Card functionality within i-expenseLet’s Talk About ‘Security […]

#2 Pingback By Managing receipts for credit card or ACH transactions – Part II On January 2, 2008 @ 2:10 am

[…] for credit card or ACH transactions – Part IIHappy New Year 2008 I wish You ALL !ACH briefing..Managing receipts for credit card or ACH transactionsThe ABCs of PaymentsRSS News/BlogCredit Card functionality within i-expenseLet’s Talk About […]

#3 Comment By hi gurus On April 11, 2008 @ 11:07 pm

hi,

please post some standard reports related to ap,ar,gl,invand om

this help is appreciates

thx
shaik

#4 Comment By Vidyutkumar Desai On April 2, 2009 @ 9:54 am

It is not clear how much amount is adjusted in 1st shipment ,second shipment etc. I want to apply proportionate prepayment amount to Invoices generated.How do I achieve this?

#5 Comment By John On August 27, 2010 @ 4:08 pm

This is very crisp n clear. tx

#6 Comment By shwalk On October 10, 2010 @ 11:17 pm

How is an invoice marked prepaid?