Update:
So finally we decided to create an event Jython script and in the script, we will retrieve the target members' "Account Type" property. We flip the sign if the member s Account Type in HFM is Revenue or Liability.
I have two questions:
1. Should this happen on "AfterValidate"?
2. How can i get the HFM Account type property in Jython?
Many thanks!!
Cheers,
H_Ww
--------------------------------------------------------------------------------------------------
Account dimension 1 to 1 mapping with mapping script to flip the sign
Hi all,
I recently have a new requirement about Account Mapping.
-1 to 1 mapping
-if account starts with 2, 4 or 5, flip the sign by mapping script.
As "Explicit" doesnt not support mapping script, i moved all the mapping to LIKE. The thing is how can I do the 1 to 1 mapping AND change the sign in LIKE?
As the rule name 30 and 40 in the screenshot, the source account map to a target account without flip the sign then use rule name 30 and 40's script to change the sign.
account=fdmRow.getString("ACCOUNT")
amount=float(fdmRow.getString("AMOUNT"))
if(account[0:1]=="2"):
fdmResultMap["AMOUNTX"]=amount * -1
elif(account[0:1]=="4"):
fdmResultMap["AMOUNTX"]=amount * -1
elif(account[0:1]=="5"):
fdmResultMap["AMOUNTX"]=amount * -1
else:
fdmResultMap["AMOUNTX"]=amount * 1
However this does not work. I also tried to change the order, put the 30 and 40 as 10 and 20, then 10 and 20 change to 30 and 40. No luck.
Or, if i do not use 2* and 4*, then I need to indicate the 1 to 1 mapping in the code like:
if(account[0:6]=="220727"):
fdmResult="202996"
fdmResultMap["AMOUNTX"]=amount * -1
...for each account.The code will be too long..
Any one can help?
Thank you!