My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.