Mapping error CELIGO,

Avatar
Fernanda Vega

Can anyone help me whit this

I created two flows to integrate Invoices from a software to Netsuite

One is to integrate them by sales order id

and the other one is by internal Sales order

the error thar popped is this one

The SO is shown as created but pending to bill, the SO is 

 A mapping error occurred. Could not find a match for "["externalid","is","Service-order-SO-2662"]" for the record type "Service Order".

 

The Flow is this one:

 

SELECT 
    sales_order.shipment_id AS id,
    'SO-' || CAST(sales_order.id AS TEXT) AS sales_order
FROM sales_orders as sales_order
WHERE sales_order.status = 3
AND sales_order.id = 
AND DATE(sales_order.updated_at) >= CURRENT_DATE-1

 

 

0

Comments

1 comment
Date Votes
  • Avatar
    Tyler Lamparter
    Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Fernanda Vega can you try using the "External ID (Text)" field instead of "External ID"? 

    0

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post