Had a client go-live today with a custom Salesforce Order to NetSuite Sales Order Integration - had some major issues with in-map NetSuite dynamic lookups for Customers, Employees, and Items. The Snip below shows the original configuration for one lookup.
When processing the lookup in the Preview function - the Internal ID is retrieved correctly. When the flow executes, the following error is returned.
I attempted to resolve this with the following methods.
- Deleted the lookup and re-created from scratch.
- Created a new Sales Order Insert operation and recreated the map.
- Modified the map to lookup without the use of the handlebar expression.
Overall, this same error was returned for every in-map NetSuite dynamic search. In order to let my client go-live, I had to add separate operations to look up the Customer, the Employee Record for the Sales Rep, and an One-to-Many search for Items. These changes enabled me to map the Internal Id for each mapping, which has been working.
Has anyone else experienced this issue recently?