Create Accounting: Receipts Are Note Getting Posted in Cash Basis Secondary Ledger

(Doc ID 1503031.1)

Last updated on NOVEMBER 07, 2012

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

You are doing Adjustments of type 'TAX' on AR invoices.  When you apply a receipt against this invoice, the receipt is not getting posted in the Secondary Ledger, which has Subledger Accounting Method = Cash Basis.

Applied patch 14309408:R12.AR.B - R12.1:RECEIVABLES RECOMMENDED PATCH COLLECTION (RPC), AUG 2012.

Steps to Reproduce:
Responsibility
:  Receivables Vision Norway
Navigation:  Transactions > Transactions
Create Invoice Number = 40003 for 20 NOK.  Invoice was created with TAX lines, but deleted them to have the same data as the customer.
Run Create Accounting. 
The invoice posted successfully.

Navigation:  Setup > Receipts > Receivable Activities
Create a Receivable Activity as follows:

Name = TEST_MCK_TAX_ADJ
Type = Adjustment
GL Account Source = Activity GL Account
Tax Rate Code Source = None
Activity GL Account = 2705.8600701200.000.000.50

Navigation:  Control > Adjustments
Create Adjustment Number = 25551 as follows:

Activity Name = TEST_MCK_TAX_ADJ
Type = Tax
Amount = .31

Run Create Accounting.
The adjustment posted successfully.

Navigation:  Receipts > Receipts
Create a Receipt - receipt_number = Test KO CB V (cash_receipt_id = 136268) for 20.13
Run Create Accounting in Draft mode.  Table xla_ae_lines shows the following for the secondary ledger (which is a cash basis ledger):

ae_header_id   ae_line_num  accounting_class_code    entered_dr    entered_cr
=====================================================================================
4970603            1              CASH                20.13-------------------
4970603            2             REVENUE               ----------------20------
4970603            3              UNAPP                0----------------------

The accounting entries are unbalanced.  The difference is the amount for which the tax adjustment was created.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms