E1: GRID: Decimals Missing For Negative Amounts When Exporting To Excel In TR 9.2.6.3 (Release 22)
(Doc ID 2887552.1)
Last updated on APRIL 08, 2024
Applies to:
JD Edwards EnterpriseOne Tools - Version 9.2 to 9.2 [Release 9.2]Information in this document applies to any platform.
Symptoms
After upgrading to 9.2.6.3, when using Export To Excel, if there are amounts with decimals to be exported, the exported excel has incorrect data as follows:
positive amounts with 0 decimals - number format (excel shows 1,234.00)
positive amounts with 1 decimal - general format (excel shows 1234.5)
positive amounts with 2 decimals - number format (excel shows 1,234.56)
negative amounts with 0 decimals - general format (excel shows -1234)
negative amounts with 1 decimal - general format (excel shows -1234.5)
negative amounts with 2 decimals - general format (excel shows -1234.56)
STEPS TO REPRODUCE
==================
1. Open P0411 and press find. make sure you also have negative amounts in the grid
2. export to excel
3.Open exported Excel and notice that for negative amounts, the decimals are not present and the format of the cell is set to General
Changes
Tools Release upgrade to 9.2.6.3
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 |
Changes |
Cause |
Solution |
References |