Variable Account Update Map Runs but does not update data
are you trying to update the user defined string 1 field to be empty? or a different value?
I ask because I have seen this and have found that for whatever reason there is code in the Microsoft eConnect node so that it won’t set the value to an empty string (for whatever reason).
I would consider just using a table destination on the GL00100 and then set the field directly in SQL.
Normally I wouldn’t suggest this because you don’t know the “business logic” behind the field but this is a user defined field and there wouldn’t be any business logic meaning that it is safe(er) to set it directly.
We are trying to change the existing value I believe Direct to Table will have to be the solution.
If you would like to submit an answer or comment, please sign in to the eOne portal.