NetSuite ARM Revenue Reallocation Automation

Advanced Revenue Management “ARM” in NetSuite automates revenue forecasting, allocation, recognition, reclassification, and auditing through a rule-based event handling framework. NetSuite ARM is also compliant with the ASC 606 revenue standard. With Advanced Revenue Management, a business can defer revenue across future periods according to the rules you configure.

While this is standard functionality in NetSuite, there are times when a business needs to execute a reallocation of revenue. This often occurs if the business creates revenue and then realizes that the allocation utilized the wrong Fair Value Statement or needs to reallocate the revenue on a given contract.

Having the ability to fully automate this process will greatly improve productivity of your team.

Manual Process

Normally a user would have to navigate to the Revenue Arrangement record in question. Once the record is loaded Select Edit, uncheck the “Compliant” box, and Click Save.

sample revenue arrangement

Finally, ensure that all revenue Fair Value Statements are updated, then click “Allocate” on the Revenue Arrangement record. With native NetSuite, this process must be completed on every Revenue Arrangement record individually and can become quite tedious with large data sets.

allocate button
allocate button

Scripted Solution to Automate

To automate this process, take advantage of the N/action module and its list of executable actions on certain supported record types. A list of record types and their supported action operations at the time of this writing are as follows:

Available actions
Available actions for N/action module

(To find a full list of currently supported record types and actions, please refer to SuiteAnswers or the NetSuite Help Center documentation under the “N/action Module” and “Supported Record Actions”.)

Using the Revenue Arrangement’s “allocate” action within a script allows for automation of the process.

The code below is a snippet from the User Event deployed to the Revenue Arrangement record.

This code automatically runs the Revenue Arrangement’s allocation function after submit on record save. This function runs on every record save to ensure that any changes made to the arrangement will impact the FV allocations.

If you have any NetSuite customization needs,  PLEASE FEEL FREE TO CONTACT US!

About ABACI:

ABACI is a premier NetSuite Solution Provider.  That provides deep knowledge; in both business process and technology architecture. Our team is passionate about NetSuite and has an exclusive commitment to NetSuite. We pride ourselves on providing the highest level of system expertise on its full suite of cloud-based business management applications.