# Shopify POS transactions failing to interface with NetSuite
**URL:** https://connective.celigo.com/t/shopify-pos-transactions-failing-to-interface-with-netsuite/497
**Category:** Integration Apps
**Tags:** error-handling, integration-app, netsuite, shopify
**Created:** [April 1, 2023, 6:57pm UTC](https://connective.celigo.com/t/shopify-pos-transactions-failing-to-interface-with-netsuite/497 "2023-04-01T18:57:59Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@sowmiksengupta](https://connective.celigo.com/u/sowmiksengupta)
#### Post date: [April 1, 2023, 6:57pm UTC](https://connective.celigo.com/t/shopify-pos-transactions-failing-to-interface-with-netsuite/497/1 "2023-04-01T18:57:59Z")
Hi,
I have the realitime flow "_Shopify order to NetSuite sales order (add)"_ enabled. And as per my knowledge, the Shopify NetSuite integration product still treats POS orders as cash sale as long as "_Sync POS orders into NetSuite as sales orders_" is unchecked in Settings \> Order.
We went live yesterday. Since then, all our POS orders are failing. The error is very apparent - it simply says the "_Unable to create the order in NetSuite ... because 236 is an invalid custom form_". And that is correct - 236 is our internal id for Sales order form. The real time flow has 236 as the internal id. For Cash Sale, the internal id is something else. Do I need to put a Compare statement for the Form (InternalId) field in the real time mapping. The cash sale form has the right form name; but I am not sure if that is being called.
Any ideas would be appreciated.
Thanks!
---
### Author:  [@sowmiksengupta](https://connective.celigo.com/u/sowmiksengupta)
#### Post date: [April 2, 2023, 5:42am UTC](https://connective.celigo.com/t/shopify-pos-transactions-failing-to-interface-with-netsuite/497/2 "2023-04-02T05:42:17Z")
Two updates (if anyone else encounters this issue):
- I used the below compare logic for Form (internal id) and that got the POS orders flowing.
```
{{#if source_name}}{{#compare source_name '===' 'pos'}}210{{else}}236{{/compare}}{{/if}}
```
- The issue resurfaced for POS orders that are to be shipped later (Buy online, ship to customer). I understand that requires some additional logic in the compare handlebar; trying to figure that out now.
---
### Author:  [@sowmiksengupta](https://connective.celigo.com/u/sowmiksengupta)
#### Post date: [April 4, 2023, 7:39am UTC](https://connective.celigo.com/t/shopify-pos-transactions-failing-to-interface-with-netsuite/497/3 "2023-04-04T07:39:13Z")
I resolved it by improvising the above compare logic. For POS orders that require shipping; the fulfillment status is null; for the rest its fulfilled. I inserted that _else_ logic as another compare statement since traditional if...else is not supported by handlebar.
You'll also notice that I used a simplified compare instead of the earlier if & compare model. This is courtesy of the Celigo agent who attended to my ticket and suggested this from on his knowledge bases.
```
{{#compare source_name "==" "pos"}}{{#compare fulfillment_status "==" "fulfilled"}}210{{else}}236{{/compare}}{{else}}236{{/compare}}
```