Hi All, I am working on a Celigo flow to create a work order in NetSuite. Successfully, I was able to create the work order on NetSuite based on the information I received from the source system. Upon creating the work order, the external ID appears as a real number or decimal value, such as (1.0, 2.0), despite the source system's value being an integer.

What does the json data look like from your source?

"record": { "workOrderHeader": { "workOrderHeaderID": 1, "workOrderNum": "12345", "woStatus": "Built", "legalEntityID": 2, "assemblyID": 1, "locationID": 4, "scheduledOn": "2024-04-24T223641.29", "productionStartDate": "2024-04-24T223641.29", "productionEndDate": "2024-04-24T223641.29", "headerNotes": null, "outputFTPItemID": 58, "outputItemQty": 1, "outputItemCost": 8.97, "outputItemLotNo": "M07769" }, "workOrderItems": [ { "workOrderItemID": 1, "inputFTPItemID": 5, "inputItemQty": 2, "notes": null, "workOrderItemsInventory": [ { "inventoryID": 273102, "inputItemLotNo": "M07767260324", "inventoryQty": 1 }, { "inventoryID": 273103, "inputItemLotNo": "C04053260324", "inventoryQty": 1 } ] },

Can you add a transformation 2.0 rule on your source export that changes the data type from number to string?

Tried that one as well also I have tried to change the data type using NetSuite SuiteScript still not working.

Would you ever have work orders from elsewhere? Maybe would be better to have the external id like "source-1", "source-2" etc where source is the name of the current source system feeding work orders and the number is the header id

Seems like that is the only option, thanks.