ORACLE RECEIVABLES - PROCESSING CUSTOMER DEDUCTIONS

Release 10

When you receive a payment from a customer that includes one or more deductions that are not tied to specific invoices and that do not refer to existing credit memos, use the following manual procedure to create the appropriate items in Oracle Receivables.

Prior to applying or completing the application of the payment:

1) Determine the total amount of ‘unauthorized’ deductions that the customer took, the related reference numbers and the amount and reference number for each deduction that made up this total.

2) Create ONE credit memo using the Enter Credit Memos or the Quick Transaction Entry screen for the total amount the customer deducted:

\Navigate Memo Standard (Enter Credit Memos) or

\Navigate Invoice Quick (Quick Transaction Entry)

Memo Number = CM(and the check number)

Type = Customer Deduction Credit Memo (Class = Credit Memo)

Amount = total of the deductions (negative)

Reference = CK(and the check number)

Line Type/Description = Customer Deduction

Line Amount = total of the deductions (negative)

3) Create one Debit Memo for EACH deduction that the customer took using the Enter Invoices screen or the Quick Transaction Entry screen:

\Navigate Invoice Standard (Enter Invoices) or

\Navigate Invoice Quick (Quick Transaction Entry)

Number = DM (and the customer’s reference number)

Type = Customer Deduction Debit Memo (Class = Debit Memo)

Amount = the amount of the deduction (positive)

Reference = CK(and the check number)

Line Type/Description = Customer Deduction (note that this uses the same GL account that you used for the credit memo - so this is a wash entry)

Reason = use QuickPick to select the appropriate reason

Line Amount = the amount of the deduction (positive)

4) Apply the credit you created (along with the payment received) to the invoices as indicated by the customer on the remittance advice. Use the Enter Receipts screen:

\Navigate Receipt Manual Standard

Enter or query the payment

Move to the Receipt Applications or Mass Receipt Applications zone

Select the credit memo you created in step 2

(this will increase the amount you have available in your unapplied amount)

apply the receipt and the credit as indicated on the remittance advice

 

What you have done is:

a) created items with a zero net effect on the customer balance

b) created offsetting GL entries (provided that you use the same GL accounts for the debits and the credits)

c) created separate debit memos for each deduction so you can individually research and resolve them

d) created documents (debit memos) that you can print and send to the customer to notify them that the deduction(s) were not allowed

e) paid the open invoices as indicated on the remittance advice

It is often easier to perform this process prior to starting your cash application. That way the credit will be available for use when applying the payments according to the remittance advice.

 

RELATED SETUPS:

Transaction Types (\Navigate Setup Invoice Type)

for: "Customer Deduction - Credit Memo" and

"Customer Deduction - Debit Memo" - use the appropriate Receivables Accounting Flexfield (note that this generally will be the same account for the debit memo and for the credit memo)

Standard Lines (\Navigate Setup Memo Line)

for: "Customer Deduction" - use the appropriate Clearing Accounting Flexfield (note that this is generally the same account for the debit memo and the credit memo). It is helpful to define a special account which will only be used for this type of activity. If you find an open balance for the special account -- you know that you have a problem

Reasons (\Navigate Setup System QuickCodes Receivables)

Type = Credit Memo Reason and Invoicing Reason

verify that you have defined appropriate reasons for the customer deductions

Be sure to use a Batch Source that allows manually numbering of transactions, if you do not already have such a Batch Source, you will need to create one.

NOTE: if the customer deduction relates to a single, specific invoice - you can utilize the Chargeback feature in the Enter Receipts screen to more easily accomplish this.

You can ONLY use the Quick Transaction Entry screen IF you do not need to override any of the default segments for the Receivables or clearing Accounting Flexfields, as defaulted using your AutoAccounting rules.