@patrickACA  would you like to not sync such orders (Pending Approval) at all?

I think you can try export filtering by the order status.

@smarenich We want the order to sync, but the status in Acumatica hasn’t changed.  It is the fact that it is waiting for approval that is triggering a status change in BC.  We want that to not trigger a status change and ignore approval status entirely.

@patrickACA what status do you expect to have in BC when order is Pending Approval in Acumatica?

By the way, another way to block this is to set Order Sync Direction to Import Only. In this case change of order status Acumatica won’t cause anything in BigCommerce

@smarenich If an order status is changed to ‘Pending Approval” we want to ignore the update to BigCommerce, or if we can’t do that, set it to Awaiting Fulfillment.

@patrickACA add this mapping:

Please note that you have to type StatusId in the field, it wont give you selection. Field is case sensetive.

Formula:

=Switch(
/SalesOrder.Status]='Back Order', 3,
/SalesOrder.Status]='Cancelled', 5,
/SalesOrder.Status]='Completed', 2,
/SalesOrder.Status]='Credit Hold', 12,
/SalesOrder.Status]='Hold', 1,
/SalesOrder.Status]='Open', 11,
/SalesOrder.Status]='Pending Approval', 11,
/SalesOrder.Status]='Shipping', 9,
/SalesOrder.Status]='Rejected', 6,
/SalesOrder.Status]='Invoiced', 11,
11)

11 here means Awaiting Fulfilment Status

Thank you @smarenich! 

@smarenich 

There is an extra “,11” at the end of the string before the closed parenthesis.  Is that necessary? 

=Switch(>SalesOrder.Status]='Back Order', 3,>SalesOrder.Status]='Cancelled', 5,>SalesOrder.Status]='Completed', 2,>SalesOrder.Status]='Credit Hold', 12,>SalesOrder.Status]='Hold', 1,>SalesOrder.Status]='Open', 11,>SalesOrder.Status]='Pending Approval', 11,>SalesOrder.Status]='Shipping', 9,>SalesOrder.Status]='Rejected', 6,>SalesOrder.Status]='Invoiced', 11,11)

I am getting occasional errors in the commerce sync of

“The system failed to convert value to type Int32 during the mapping processing. Please make sure that custom field mappings are correct.”