Hi Experts,
We are have a script that updates on upload the interco dimension for example, if the user loads I_CoA 100 then I_NONE is updated for 100. Problem is that when the user loads I_NONE (incorrectly) instead of the I_CoA value, the script then overwrites I_NONE to be zero. We want to include a filter to prevent the script from executing in this situation.
Below is the script we are trying to run without success. In testing, each 2nd time we enter a zero value in I_coA the script updates I_NONE to zero incorrectly.
Any ideas as to correct the script / modify our logic?
Thanks in advance for your help.
Regards,
Eyal
//copy all the interco values entered for I_x to the I_NONE for (Loans_and_other_liabilities.xlt) - Maayan Golan Ness Sept 12
*XDIM_MEMBERSET ACCOUNT=<ALL>
*XDIM_MEMBERSET FLOW=<ALL>
*XDIM_MEMBERSET AUDITID=INPUT
*WHEN ACCOUNT.WRITEI_NONE
*IS "Y"
*WHEN AUDITID
*IS INPUT
*WHEN FLOW
*IS *
*WHEN INTERCO.Group
*IS "INTER"
*WHEN SIGNEDDATA
*IS <>0
*REC(INTERCO="I_NONE")
*ELSE
*WHEN SIGNEDDATA
*IS <>0
*WHEN INTERCO
*IS "I_NONE"
*REC(EXPRESSION=%VALUE%/1,INTERCO="I_NONE")
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT