Square Netsuite with multiple addresses

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.