Hi, When using Square with Netsuite. We Travel all around the country and wanted the address on the Netsuite Transaction to match the address that the Transaction took place.
For a little while I was hard coding the location field in the Celigo mapping. But with the help from Celigo Support. Was able to use a Dynamic: Netsuite search That looks at the Netsuite location record and pulls the address from Netsuite to post on the Cash Sale.
the look up filter I am using is
["formulatext:CASE WHEN {internalid} = "ns location internal id" THEN 'square location ID' WHEN {internalid} = "ns location internal id" then 'square location ID' END","is","{{{location_id}}}"]
I hope that this might help another Netsuite user.