EGL9.1: Argentina Localization - Spreadsheet Journal Import is Creating Incorrect Amounts (Multiplied By 100) When Decimals <> 00 (Doc ID 2185520.1)

Last updated on NOVEMBER 29, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger Argentina - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
--------

While importing Journal using spreadsheet journal import, if amounts for which the decimals are not "00" the amount is multiplied by 100 when imported into PeopleSoft.

Steps to Replicate:
---------------------

1. Make sure Decimal symbol is set to , (Comma). No. of digits after decimal is 2 and Digit grouping symbol is . (dot).
2. Open JRNL1.xlsm and define journal header and journal lines (note different amounts for each line).
     Line 1 amount 1000,01
     Line 2 amount -1000,00
     Line 3 amount -0,01
3. Import journal.
4. Verify results in PS_JRNL_LN.

Actual Behavior:
---------------------  

Amount for line 1 is 100001 (1000,01 is multiplied by 100). Same is happening for line 3. Amount is -1 (0.01 is multiplied by 100). Only line 2 is correct. Amount is -1000

Expected Behavior:
---------------------

All amounts should be imported correctly regardless of the decimals used.

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