NetSuite Saved Search Not Returning Revenue Arrangement Data

Integrator.io
1

Hi everyone,

I’m working with a Sales Order that contains lines which may have an associated Revenue Arrangement. In Celigo I want to check whether the lines have an existing Revenue Arrangement against them.

I created a Sales Order saved search and added fields from a Revenue Arrangement dataset, expecting to see the related revenue arrangement information. However, even though the Sales Order does have revenue arrangements linked to it, the revenue-related fields are showing up blank in Celigo.

This makes me wonder:
Is NetSuite restricting Revenue Arrangement data from being returned via REST API saved searches?
I found this NetSuite documentation on supported records and wondered if it may be related:

Additionally, I created a Revenue Element saved search, but in Celigo’s NetSuite Lookup, I don’t see Revenue Element as an available record type—so I’m unable to query it directly.

Has anyone run into this before?
Any advice on how to pull Revenue Arrangement / Revenue Element data through Celigo or NetSuite searches?

image
image1671×368 67.8 KB

2

Hi Nuri,

Currently, the export feature for NetSuite doesn't include "Revenue Arrangement" as an option in the dropdown for record types. As a result, selecting a Revenue Arrangement search from the saved search list or using a private ID won't work by default.

To make this work, you need to set the recordType field to revenuearrangement using our APIs. I recommend using the Zangabox Chrome extension to simplify this process, eliminating the need to use Postman for fetching the resource and making a PUT request.

Steps:

  1. Open your NetSuite export in Celigo.

  2. Launch the Zangabox Chrome extension.

  3. Edit the recordType field, setting it to revenuearrangement.

  4. Click PUT to save your changes.

Once updated, you'll be able to export Revenue Arrangement from NetSuite. Keep in mind that you may encounter UI errors since the interface isn't designed for this scenario, but the export will run successfully.

3

Hi,

I tried your solution and it worked :blush:

I also tested an alternative approach. It turns out the Revenue Element join was restricted when accessed via the NetSuite API/RESTlet, even when using the Administrator role.

The key step was creating (or in my case updating) a dedicated custom role and granting it full permission to Lists → Revenue Element. After assigning this updated role in NetSuite I updated t Sales Order transaction saved search with this formula.

CASE 
    WHEN {generatedrevenueelement.internalid} IS NOT NULL 
    THEN 'HAS REVENUE'
    ELSE 'PENDING'
END

Now I could get this data in Celigo.

1 Like