We are creating a custom flow to sync sales orders from the Warroad Netsuite account to the Touchstone Netsuite account.
We have created 2 transaction searches in the Warroad account. One to fetch the details of body fields of sales order and the other to fetch the item line fields of sales order. The body field included search is fetched on the Export side and the item line field search is included on the Lookup.
And also provided a result mapping and the screenshot of this is:
On the Import side, we have provided a mapping.
By using this custom flow 2 sales orders are created in the Touchstone account (destination). Because here we are fetching only 2 sales orders from the Warroad account. Each sales order record includes different items.
But the issue is, for the sales orders created in the destination account have the same items. The items of 1st sales order are displayed in the item fields of created 2nd SO. The debug log also shows the same issue.
Here I am providing the lookup's preview also, which includes different items for different SOs
{
"page_of_records": [
{
"rows": [
{
"id": "2392",
"recordType": "salesorder",
"Amount": [
"2.00",
"2.00"
],
"Item Rate": "2.00",
"Quantity": "1",
"Item": "WR018",
"Internal ID": "3322",
"Ship Date": "7/10/2023",
"eTail Order Line Id": "111",
"dataURI": "https://8974838.app.netsuite.com/app/accounting/transactions/salesord.nl?id=2392&compid=8974838"
},
{
"id": "2392",
"recordType": "salesorder",
"Amount": [
"3.00",
"3.00"
],
"Item Rate": "3.00",
"Quantity": "1",
"Item": "WR105",
"Internal ID": "3323",
"Ship Date": "7/10/2023",
"eTail Order Line Id": "222",
"dataURI": "/app/accounting/transactions/salesord.nl?id=2392&compid=8974838"
}
]
},
{
"rows": [
{
"id": "2396",
"recordType": "salesorder",
"Amount": [
"50.00",
"50.00"
],
"Item Rate": "",
"Quantity": "1",
"Item": "WR120",
"Internal ID": "3328",
"Ship Date": "7/6/2023",
"eTail Order Line Id": "56789",
"dataURI": "https://8974838.app.netsuite.com/app/accounting/transactions/salesord.nl?id=2396&compid=8974838"
},
{
"id": "2396",
"recordType": "salesorder",
"Amount": [
"32.00",
"32.00"
],
"Item Rate": "32.00",
"Quantity": "1",
"Item": "WR470 : WR470_HEABRG_L",
"Internal ID": "2895",
"Ship Date": "7/6/2023",
"eTail Order Line Id": "98765",
"dataURI": "/app/accounting/transactions/salesord.nl?id=2396&compid=8974838"
}
]
}
]
}
Here the items WR018 and WR105 are in the sales order with ID 2392. These items are showing in the sales order with ID 2396 after syncing, instead of showing WR470 : WR470_HEABRG_L and WR120