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

DM - Mapping accounts according sum value

edited Aug 4, 2020 4:04PM in Financial Consolidation and Close 7 comments

Content

Hello,

Does anyone know if it is possible, in Data Management, mapping members according the sum of the data? I need to create the following mapping:

If the sum of the accounts 19950, 19951, 19952 >0 then the account 19950 is mapping for the member 19950, the account 19951 is mapping for the member 19951 and the account 19952 is mapping for the member 19952. If the sum of the amounts <0 then the account 19950 is mapping for the member 29950, the account 19951 is mapping for the member 29951 and the account 19952 is mapping for the member 29952. 

Can someone help me please?

Thanks in advance.

Carolina Silva

 

Version

20.07.57

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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