Create NetSuite Listener for Items - add, change, or delete

Avatar
PaulS
Celigo University Level 1: Skilled
Awesome Follow-up
Engaged

I have been trying to create a listener in NetSuite that uses the "User Interface" execution context to export records that meet the execution context of "Create, Edit, Inline Edit and Delete.  The overall goal is to pass any items that have been added, deleted, or changed up to Celigo for integration into a point-of-sale system via that system's  REST APIs in virtual real time (hence the listener).  My problem is that when I try and select the "Record Type" of "Item" from the Celigo drop-down list, I get "Error occurred" under the  "sublist to include" record type dropdown.  Then is if click on the "Preview" button, I get an "SSS_INVALID_RECORD_TYPE: item" error.  I have run through all the "item" and "inventory" drop-down picks to see if any would provide the data I need and none of them have the "item detail"   If someone knows how to get around the error message I receive when I select the "Item" value, that will probably get me in the direction I need to go.

0

Comments

5 comments
Date Votes
  • Avatar
    Kate Larson
    (Edited )
    Senior UX Researcher Community moderator

    Hi PaulS, thanks for posting this to the Community. I think it's a good idea for Support to take a look at it as well, so I have created a ticket (110712) containing the information you included. 

    1
  • Avatar
    PaulS
    Celigo University Level 1: Skilled
    Awesome Follow-up
    Engaged

    Thanks, Kate.  I can't imagine anyone doing the same type of sync that I am trying to do hasn't had the same problem!

    -1
  • Avatar
    Guy Langley
    Referral Partner
    Engaged

    Use INVENTORY PART instead of ITEM . . .

    2
  • Avatar
    Anil Kumar

    Kate Larson We are facing same issue when adding the item record in the integration. When we tried using INVENTORY PART instead of ITEM it worked as expected. Do you have a solution for this on ticket you referenced above?

    0
  • Avatar
    Stephen Brandt
    Documentation Manager Community moderator
    Celigo University Level 4: Legendary
    Engaged
    Great Answer
    Top Contributor

    Anil, your mileage may vary, but here is the complete solution that worked for that customer's configuration:

    1. Select Specific Item records if you wanted to go with Listener as an export. That would mean, you will be creating multiple exports specifying that Item type of record (non-inventory, inventory part and similar).
    2. I would suggest using a batch flow and setting your source as Delta export. Then, choose  the "Item" record type, since you can use it only with a query.
    3. Next, create a saved search that would return items that you possibly want to import and use Last Modified as delta search fields.
    4. Lastly, set the flow to run on a scheduled basis, probably every 15 or 30 minutes.

    By doing this setup, you will be pulling all item records that were created/edited/modified from the last time the flow ran.

    0

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post