Flow not updating vendor line in Netsuite
I have a flow that is supposed to update the vendor price in Netsuite for specific items. It is updating a regular date field, but the vendor lines are not being updated. I am not sure why because I have another flow built in the same way that does work as intended. The only difference that I noticed is that the new flow has "SuiteApp SuiteScript 2.x (Recommended)" selected while the other one has "SuiteBundle SuiteScript 1.0
To be deprecated" selected.
Here is what the mapping looks like currently
1
Comments
Matthew Gargano what does your input data look like? I can attempt to reproduce if given the sample input data.
Also, can you try to build the new flow using SuiteApp 1.0? To use SuiteApp 1.0, you would need to make a new import step and specify it prior to saving since it can't be changed after the fact.
Here is the input data, thank you for looking into it. I can try recreating it using the 1.0, ideally I would use the 2.x because I imagine that would be more future proof. (As a note, the only thing I am looking to update with this flow is the vendor price.)
{
"SYNNEXSKUNum": "3229445",
"Contract Price (With Promo/Rebate)": "161.54",
"id": [
{
"id": "52448",
"recordType": "noninventoryitem",
"Internal ID": "52448",
"Vendor": "TD SYNNEX CORPORATION",
"Vendor Code": "3229445",
"Vendor Name": "",
"Vendor Price": "116.41",
"VendorInternalID": "21"
}
]
}
Matthew Gargano try SuiteApp 1.0 and let me know how it goes. SuiteApp 1.0 will stay in place, only SuiteBundle 1.0 has current plans to be deprecated.
I recreated the NetSuite destination using the suitescript 1.0 and it looks like its working now.
Is there any specific reason that it didnt work with the 2.x?
Matthew Gargano we've seen a few behavior differences from the migration of 1.0 to 2.0 and are actively working to resolve them, so I appreciate you confirming this. I'll pass it on internally and hopefully get a resolution soon.
OK thanks again for the assistance
So I have tried both Suitescript 2.0 and 1.0 with no luck, as I have the added complication of multi-currency - any help will be appreciated.
Input:
{
"Base SKU": "OPT4321-H",
"Item Name/Number": "OPT4321-V",
"Item - Vendors 1 : Vendor": "4185 St. Regis Crystal",
"Vendor Name/Code": "OPT4321-V",
"Item - Vendors 1 : Code": "OPT4321-V",
"Item - Vendors 1 : Purchase Price": "14.47",
"Item - Vendors 1 : Preferred": "Yes",
"Item - Vendors 1 : Schedule": null,
}
Vincent Nero can you restructure you data with a transform on the export to be like this? I was just able to update and add vendor lines on another community thread. The thought I have is since "Vendors" is a sublist array, the incoming structure should match it.
{"Base SKU": "OPT4321-H",
"Item Name/Number": "OPT4321-V",
"vendors": [
{
"Item - Vendors : Vendor": "4185 St. Regis Crystal",
"Vendor Name/Code": "OPT4321-V",
"Item - Vendors : Code": "OPT4321-V",
"Item - Vendors : Purchase Price": "14.47",
"Item - Vendors : Preferred": "Yes",
"Item - Vendors : Schedule": null
}
]
}
Please sign in to leave a comment.