RX-only: Miscellaneous Receipts Register (ARRXMTRG) Report Displaying Incorrect Functional Amounts. (Doc ID 2108178.1)

Last updated on JUNE 26, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Reports Issues

ACTUAL BEHAVIOR
---------------

The report "Miscellaneous Receipts Register" (ARRXMTRG) is displaying the "Functional Amount" as the functional receipt amount instead of the receipt amount that corresponds to the specific receipt distribution .


The report will display the "Functional Amount" field (the last field) as 110.04 for both the account distributions (D1 and D2) .

As a result , the summary total fields by currency and report display 220.08 instead of 110.04 .

The report should actually display the corresponding functional amounts that is specific to the distributions in the "Functional Amount" field instead of receipt functional amount .

i.e

011.9000.5003.703130.0000 - Functional Amount value should be 40 EUR - Converted to USD .,
011.9000.5003.703140.0000 - Functional Amount value should be 60 EUR - Converted to USD .,


EXPECTED BEHAVIOR
-----------------------
The report should show the functional amounts equal to the distributions instead of the total amount

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Create a miscellaneous receipt in EUR (Functional currency - USD) . Entered amt - 100 EUR . Functional amt - 110.04 USD
2) Create two distributions . D1 - 60 EUR ; D2 - 40 EUR .
3) Run the "Miscellaneous Receipts Register" report .



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, customer's month end reconciliation as part of the AR Close is getting delayed as the numbers do not match

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