EAR9.0+: Rounding Suspense Account Entry Created for Online Items With Amounts Ranging Between -1 and 1 (Doc ID 985619.1)

Last updated on SEPTEMBER 22, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 17-Jun-2011***
***Checked for relevance on 20-Nov-2013***

Symptoms

Issue / Errors
----------
When Item Amount on the Receivables > Online Items > Group Entry page is entered equal to "1" or less than "1", the accounting entries of the Group always has an unidentified Rounding Account Entry.
This results in a Sub-System Journal that is out of balance because there are two debits created (User and Rounding) for the same amount and one credit (AR Control).

Environment
----------
Issue happened in FMS Release 9, Bundle 10 Demo

Expected Result
----------
Rounding Account Entry should not be created in the scenarios where the Item Amount is equal or less than '1'. In this scenario, there is also no currency transaction involved.
If system doesn't create any rounding account entries for amounts with more than '1' Base Currency, it should behave the same for the amounts equal or less than '1' Base Currency meaning that the accounting entries of the Group must NOT have any Rounding Account Entry.

What is Working
----------
As long as the item amount is more than '1' Base Currency, system creates the correct accounting entries without any Rounding Account Entry.

Business Impact
----------
This results in a Sub-System Journal that is out of balance because there are two debits created (User and Rounding) for the same amount and one credit (AR Control). It has to be manually adjusted.

Steps/Sequence of Event
----------

  1. Set Up> Product Related > Receivables > Payments > Item Entry Type.
    • Entry Type: IN
    • Entry Reason: SALES
    • Entries Must Balance TICKED
    • and also
    • Entry Type: IN
    • Entry Reason: SERVICE
    • Entries Must Balance NOT-TICKED
  2. Receivables > Online Items > Group Entry. Enter an Online Item with an amount less or equal to "1" USD.
    • Amount: 0.80 Base Currency
    • Entry Type: IN
    • Entry Reason: SALES
  3. Create Accounting Entries. As expected, no problems.
    • User Type Credit Chartfield: -0.80
    • AR Type Debit Chartfield: 0.80
  4. Go back and change the Reason Code to SERVICE.
    • Amount: 0.80 Base Currency
    • Entry Type: IN
    • Entry Reason: SERVICE
  5. Create Accounting Entries.
    • User Type Credit Chartfield: Blank
    • AR Type Debit Chartfield: 0.80
    • Rounding Type Chartfield: Blank

Try it with an amount higher than 1 USD for both Entry Reasons with Entries Must Balance TICKED which is SALES, and not-TICKED which is SERVICES.
Works fine without Rounding Accounting Line created for the amount higher than 1 USD.

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