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

PaulS

• March 07, 2022 18:26

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

• 

  Kate Larson Senior UX Researcher Community moderator

  • March 07, 2022 19:54
  • Edited

  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
• 

  PaulS

  • March 07, 2022 20:23

  

  

  

  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
• 

  Guy Langley Referral Partner

  • March 24, 2022 23:25

  

  Use INVENTORY PART instead of ITEM . . .

  2
• 

  Anil Kumar

  • June 25, 2024 14:22

  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
• 

  Stephen Brandt Documentation Manager Community moderator

  • June 25, 2024 14:39

  

  

  

  

  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.