This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I asked this in `#beginners` but this might be a better channel.
How is the `RevenuePlan` connected to transactions or sales orders? I cans find the connection in the records catalog.

it's been a while since i played with ARM module, but the circumstances i've played with it, the item on the sales order will create a revenue element, and the revenue element is what cause the actual revenue plan for posting.

So its not one revenueplan for the SO, its each item in the SO will create a revenue-element?

1 SO, 3 Items &gt; 1 Revenue Arrangement &gt; 3 Revenue Elements &gt; 2 Revenue Plans (1 actual, 1 forecast)

<@UHFES4MQQ> should that be 6 revenue plans? Actual and forecast per element?

<@U01JXRLAFU4> the transaction relating to a revenue plan is on the element but it's stored as text unfortunately not a link. `revenueElement.source` is the document id and `revenueElement.referenceid` holds the internal id but it's in the format `&lt;RecordType&gt;_&lt;InternalId&gt;`

In SuiteQL I use `SUBSTR(revenueElement.referenceid, INSTR(revenueElement.referenceid, '_') + 1)` to extract the internal id for a join

<@U29QCJQF3> you're right, i stand corrected it should be 6, although there could be more forecasts!

and potentially more
<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4351787245.html>

Yup or no forecasts at all if you've turned them off like us :smiley:

for us too, the actual revenue plan has pretty good info about what it's going to post already!

Do any of you <@UHFES4MQQ> or <@U29QCJQF3> know how the revenue-plan gets generated? I guess its a scheduled script, but I cant find it. I would like to trigger it manually

<@U01JXRLAFU4> on mobile at the moment but if you type "Update Revenue Plans" into global search the page should come up

It's an accounting preference if this runs automatically or not

Do you know if it is possible to trigger it from a script?