Has anyone ran into a challenge with a created/loaded search(SS2.0) with multiple txt formulas and the use of formula: "{memo}" ? i get a Parsing XML error entity "M" only with the use of {memo}... I changed the formula to see if it was problem with duplicate text formulas but, it wasn't... I was able to load more than one txt formula with no errors. I'm stumped. I'm pulling the transactions edited item line description is what im trying to do. i'm getting weird results with just a number or null when its a result on a loaded saved search...

you might want to try limiting your results to one single transaction to see if one of your memo's is breaking netsuite

it's interesting that you say that. I tried other formula results such as {item.description}, didnt work. Tried column joins and im getting null values. I limited the results to one opportunity listing all the quotes, same result. then just quote same result, one line 😞 and it worked...

thats what the error suggests

Thanks! the xml errors are a little miss leading. It ended up being an & sign... i used . replace and that sorted the challenge out. Is there a more robust method that used? I can imagine that this would be challenging with multi language which im diving into next.

Sounds reasonable. The 5 predefined xml entities are ",&',<, and>