Flow not updating vendor line in Netsuite

Comments

8 comments

  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    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.

    0
  • Matthew Gargano

    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"
        }
      ]
    }

    0
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    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. 

    0
  • Matthew Gargano

    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?

    0
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    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.

    0
  • Matthew Gargano

    OK thanks again for the assistance

    0
  • Vincent Nero

    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,
    }

    0
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    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
        }
      ]
    }
    0

Please sign in to leave a comment.