Hello,
I just need help flipping a sign on a final report.
Here is the data:
Here is the report (there is a negative sign in front of the number insert):
And here is what my OneStream is showing:
I went into transformation rules and flipped the sign on those 2 accounts, but that did not help:
Does anyone have any suggestions? Thank you!
My first question is, what do you have as your account type for 30001 and 30002 in OneStream? Assuming those are type: Revenue, and that when the data comes in from an ERP it is naturally a credit balance, you will want to flip the sign of those 2 (or any revenue or liability) accounts in your transformation rules so that they show in OS as positive.
This is because OS is a reporting tool, not a ledger tool so revenue and liabilities in OS naturally show as positive, even though in the ERP they are natural credits.
After flipping the sign in transformation rules and reloading your data, you will then want to consolidate.
If you follow those steps those 2 accounts (or any revenue or liabilities) will show as positive on OS reports.
If you are trying to create a trial balance view with debits and credits, you can write a dynamic U8 calculation that will flip your OS type revenue and OS type liabilities on reports back to show credit balances. But that is typically done via a dynamic U8 as shown below:
