Revenue Plan ‘Creation Triggered By’ codification
We’re leveraging custom Revenue Recognition Events. We will have numerous plans generated (each with their own Revenue Event) for a given revenue element. I’m looking to tie the plan record to the event.
The highlighted field appears to ‘special’.
If you load the plan record (ala: record.load) you’ll see the internal id of the revenue plan.
If you try an indirect lookup (search.lookupFields or N/query) you get back the textual representation. ie: “Revenue Recognition Event”
In the UI, we get a fancy link to an endpoint that redirects us to the appropriate event: https://XXXXXX-sb2.app.netsuite.com/app/accounting/revrec/revenueplansource.nl?id=29127429
Anyone have a clever way to achieve the lookup by this endpoint? The best i can manage is correlating these based on order of creation and double comparing the amounts, but it’s an awful lot of “work” for each event.
What does this redirect you to?
https://XXXXXX-sb2.app.netsuite.com/app/accounting/revrec/revenueplansource.nl?id=29127429
It depends on the trigger ‘type’, but in the case of a custom revenue event, it redirects to the instigating revenue event record instance, ie: https://XXXXXX-sb2.app.netsuite.com/app/accounting/revrec/billingrevenueevent.nl?id=2234840 In the case of ‘Fulfillment’ triggers, the field display (via indirect lookup) gives you a string ala: “Item Fulfillment #IF1307028” and redirects to https://XXXXXX-sb2.app.netsuite.com/app/accounting/transactions/itemship.nl?id=113939312
