You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Values ​​exported from Financial Reporting Studio to Excel with the wrong sign!

edited Jun 9, 2025 7:25AM in General Ledger & Intercompany

We configured a report on FRS (Financial Reporting Studio), the customer asked us to set the opposite sign on the values ​​present in the system (e.g. in the system the value "X debit" is with a positive sign, the customer asked us to transform the value with a negative sign).

Unfortunately when we export the report to Microsoft Excel the situation changes, that is, the value at sight is correct (with a modified sign and therefore negative) but inside the cell the value is with the original sign (therefore positive). See the screenshots

We should find a way to ensure that the signs are always correct even when exporting to Microsoft Excel.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!