Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Change Consol Operator for FCCS_Total Liabilities/Equity and Expense

edited Mar 18, 2021 11:50PM in Financial Consolidation and Close 3 comments

Summary

Change Consol Operator for FCCS_Total Liabilities/Equity and Expense

Content

Have anyone have tried to change the Consol opeartor for FCCS_Total Liabilities,  FCCS_Total Equity and Expense from "subtraction" to "addition"? I can see on metadata validation, it will show error if doing this, and also the Journal posted cannot be net to 0 on balance sheet.

There is an ask from one of the customer to see the same sign as Oracle Cloud GL. As the number coming from ERP as:

Asset: + / Liability - / Equity - / Revenue - / Expense +

To keep the sign as it is, the consol operator will need to be "addition" to make the balance sheet net to 0. However, the Journal posted won't work as it required to have "subtraction" to make the balance sheet to 0. Also I cannot put negative on the Journal in FCC. Are there any setting I have missed I can change on the Journal how it adds up the numbers?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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