Sales order syncing between two NetSuite accounts
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
Comments
Hi Rosemol Joe
Please make sure the below things are properly configured in your flow
1. Netsuite Lookup Additional Search criteria - here you need to add a filter to return the line items of a specific sales order received from the export. you can set like {{{id}}} (where id holds salesorderId in exports data) in search value to use the sales order id received from exports in lookup filters
2. NS Results Mapping - Here you have set as data.0 where it exports only the first item. if you need to export all line items of a specific sales order then you can simply set them as data.
Please let us know if you still face the issue, Thanks!
Yes, now I have changed the data.0 to data in result mapping.
Now the problem is for all the sales orders synced in the Touchstone account are showing all the items from the Lookup search.
The screenshot of Import mapping is this
The screenshot of the lookup is like this:
The output preview of Lookup search is like this
{ "page_of_records": [ { "record": { "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", "Shipping Address": "Warroad Shopify Orders\nNew York\nValley hills\nNew York NY 123456\nUnited States", "Shipping Address 1": "New York", "Shipping Address 2": "Valley hills", "Shipping Addressee": "Warroad Shopify Orders", "Shipping Country": "United States", "Shipping State/Province": "NY", "Shipping Zip": "123456", "eTail Order Line Id": "111" } }, { "record": { "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", "Shipping Address": "Warroad Shopify Orders\nNew York\nValley hills\nNew York NY 123456\nUnited States", "Shipping Address 1": "New York", "Shipping Address 2": "Valley hills", "Shipping Addressee": "Warroad Shopify Orders", "Shipping Country": "United States", "Shipping State/Province": "NY", "Shipping Zip": "123456", "eTail Order Line Id": "222" } }, { "record": { "id": "2396", "recordType": "salesorder", "Amount": [ "50.00", "50.00" ], "Item Rate": "", "Quantity": "1", "Item": "WR120", "Internal ID": "3328", "Ship Date": "7/6/2023", "Shipping Address": "", "Shipping Address 1": "", "Shipping Address 2": "", "Shipping Addressee": "", "Shipping Country": "", "Shipping State/Province": "", "Shipping Zip": "", "eTail Order Line Id": "56789" } }, { "record": { "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", "Shipping Address": "", "Shipping Address 1": "", "Shipping Address 2": "", "Shipping Addressee": "", "Shipping Country": "", "Shipping State/Province": "", "Shipping Zip": "", "eTail Order Line Id": "98765" } }, { "record": { "id": "2397", "recordType": "salesorder", "Amount": [ "2560.00", "2560.00" ], "Item Rate": "128.00", "Quantity": "20", "Item": "WR270 : WR270_NVY_L", "Internal ID": "2322", "Ship Date": "7/6/2023", "Shipping Address": "", "Shipping Address 1": "", "Shipping Address 2": "", "Shipping Addressee": "", "Shipping Country": "", "Shipping State/Province": "", "Shipping Zip": "", "eTail Order Line Id": "" } }, { "record": { "id": "2397", "recordType": "salesorder", "Amount": [ "1920.00", "1920.00" ], "Item Rate": "128.00", "Quantity": "15", "Item": "WR270 : WR270_NVY_M", "Internal ID": "2323", "Ship Date": "7/6/2023", "Shipping Address": "", "Shipping Address 1": "", "Shipping Address 2": "", "Shipping Addressee": "", "Shipping Country": "", "Shipping State/Province": "", "Shipping Zip": "", "eTail Order Line Id": ""} }, { "record": { "id": "2397", "recordType": "salesorder", "Amount": [ "1280.00", "1280.00" ], "Item Rate": "128.00", "Quantity": "10", "Item": "WR270 : WR270_NVY_2XL", "Internal ID": "2321", "Ship Date": "7/6/2023", "Shipping Address": "", "Shipping Address 1": "", "Shipping Address 2": "", "Shipping Addressee": "", "Shipping Country": "", "Shipping State/Province": "", "Shipping Zip": "", "eTail Order Line Id": "" } } ] }
Here we can see the sales order with id 2397, the items are WR270 : WR270_NVY_L, WR270 : WR270_NVY_M, WR270 : WR270_NVY_2XL. But after syncing the items for this sales order become WR018, WR105, WR120, WR470 : WR470_HEABRG_L, WR270 : WR270_NVY_L, WR270 : WR270_NVY_M, WR270 : WR270_NVY_2XL.
This issue is happening same for all the sales orders created on the destination account
Rosemol Joe
As mentioned in the previous comment, please modify the NS lookup filter criteria to export only corresponding sales order line items
Please sign in to leave a comment.