This content has been marked as final. Show 6 replies
This is possible via a conditional mapping script. Us an In mapping specify 32100 as the source value and #Script as the target. Then in the Expression/Sctipt box write a script that checks the the Vlaue field in the varValues array to see if it is a positive or negative number and set the target member as appropriate.1 person found this helpful
Thanks for your suggestion.
Could you please help me out how write a script.
The script which will go in the script section of the mapping would be:
If Left(varValues(9),1) = "-" Then
Result = "1000"
Result = "2000"
I've made the assumption that debit is negative, if not simply swap the Result line values.
Thanks for your help,
But still I want some clarification.
My Trail balance Negative values with closed brackets like (567984001) not with minus symbal -567984001.
I hope your script will works if the value is -567984001, but our Trail balance values is (567984001).
Could you please help me out what needs to be done in this scenario.
Hi Try to replace the "-" sign with smaller than zero and bigger than zero. Example If <0 then accounts receivable. If >0 then accounts payable.
Replace the search for the '-' character with '('