Making GL balances positive

JanGLi

hi,

I am getting some negative gl balances when i fetch data from EBS. These accounts are of expense and liability balance type. According to my knowledge they will be moved as it is from EBS regardless of "absolute" option is selected or not. (-ve values will be -ve and +ve values will be +ve).

I am trying to create a script which will multiple column "AMOUNTX" of table "TDATASEG" with -1 if the "AMOUNTX" is less then 0.

I am getting the result what i want but the issue is my data workbench goes blank.

Screenshot:

I think this is because i have changed the "TDATASEG" table.

If this happens i won't be able to drill back to the GL accounts.

Is this the correct approach i am using?

Is this the correct column i am using; i think it is because i am getting the results i want.

Regards

USER1211

Why not just flip the sign on the specific account using out of the box Fdmee sign flip functionality via the mapping.

JanGLi

I could do that but there are thousands of accounts.

USER1211

Do you not have the list of the specific accounts? If you do you could create the explicit maps for those accounts and the issue should be solved..

Also if accounts within a certain range are to flipped you can design your sign flip by range.

Only You know your accounts so you could certainly do a more detailed review to see if you can setup a feasible solution with out of the box solutions.

let us know how you make out.