Conditional Mapping or Invoke Standard Integration

Userlevel 2

Hello folks,

Wanted to see if this was remotely possible.    But i have an import mapping setup that work in the following manner on the SALES ORDER entity in Commerce Connector:


As you can see this will look for the “MISC” tag and if it exists it will map the customerID to my “ECOMGUEST” customer.  If FALSE, it maps to the C0000011 customer.  

What I would LIKE to occur is that on the FALSE result of the IIF statement that it reverts to actually using the native connectors logic to either use the existing shopify customer or create a new one. 



4 replies

Userlevel 7
Badge +6

@kkeating24 , that’s the limitation I bump into all the time. I didn’t find a solution. It would be nice to have a special command for the default behavior. For example, add a DEFAULT keyword. Subscribing to this thread.

Userlevel 7

Hi @kkeating24 were you able to find a solution? Thank you!

Userlevel 2

Hi @kkeating24 were you able to find a solution? Thank you!

Nope, open ticket with ACU escalated to DEV. 

Userlevel 5
Badge +1

@kkeating24 , we have noticed this requirement already, we have created a ticket to fix it by following the developement plan.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved