Updating Revenue Arrangements

Revenue arrangements and revenue elements can be updated automatically or manually depending on the setting of the accounting preference Revenue Arrangement Update Frequency. When you select the automatic option, the system updates revenue arrangements every 3 hours. The update incorporates changes to sources that affect revenue management.

Administrator permissions are used for automatic updates, and all revenue arrangements and elements are updated regardless of subsidiary restrictions. If you use Multi-Book Accounting, the accounting book status is ignored.

The following table lists fields for which changes from the source cause updates in the revenue element. Sources include transactions, projects, and subscriptions. Items records are not sources for revenue element updates.

Source Field	Revenue Element Field
Date	Source Date
Item – Add or remove only. Change in the source is not permitted.	Item
Quantity	Original Quantity
Exchange Rate	Exchange Rate
Amount	Sales Amount Original Discounted Sales Amount
Class, Department, Location, Custom Segment with G/L impact	Class, Department, Location, Custom Segment
Customer	Customer

Source Field

Revenue Element Field

Date

Source Date

Item – Add or remove only. Change in the source is not permitted.

Item

Quantity

Original Quantity

Exchange Rate

Amount

Sales Amount

Original Discounted Sales Amount

Class, Department, Location, Custom Segment with G/L impact

Class, Department, Location, Custom Segment

Customer

You can update revenue arrangements manually between automatic updates or use the Revenue Arrangement Update Frequency accounting preference to turn off automatic updates. When you update revenue arrangements manually, your subsidiary restrictions automatically determine which revenue elements and arrangements are updated. Your role must include the Revenue Arrangement permission.

You can use filters for date range, record type, and accounting book (Multi-Book Accounting) to reduce the number of revenue arrangements that are updated. However, you cannot select a single revenue arrangement to update.

The Status subtab list on the Update Revenue Arrangements and Revenue Plans page displays all update processes run for its selected date range. Processes are run only when eligible sources are identified for the update. If no eligible sources are identified, no processes are run or listed.

If the accounting preference Create and Maintain Revenue Element Upon Closed Order box is clear, NetSuite discontinues updates for closed sales orders and closed sales order lines.

When revenue arrangements and elements are updated, a line is added in the Revenue Arrangement Message subtab for each updated revenue element. The value in the Process column is Auto Update.

Note:

Custom segments do not support sourcing or filtering for revenue arrangements. For more information, see Setting Up Filtering for a Custom Segment and Dynamic Default Value Sourcing for Custom Segments.

To update revenue arrangements manually:

Go to Financial > Other Transactions > Update Revenue Arrangements and Revenue Recognition Plans to open the Update Revenue Arrangements and Revenue Plans page.

Revenue managers and revenue accountants can also use the Update Revenue Arrangement link on the Revenue dashboard or access the page through the Revenue menu. The Update Revenue Arrangements link begins the update process immediately, bypassing steps 2 and 3. If you want to use the filters in step 2 before you begin the update process, use the Status link to access the page.
Set the filters on the top of the page if desired.
- Use the Source From and Source To date filters to select a date range for the source records from which the revenue arrangements are created. By default, these fields are blank. With the default settings, NetSuite creates and updates all revenue elements and arrangements as needed, including those for sources with future dates.
- Accounting Book – This filter appears only when the Multi-Book Accounting feature is enabled. When the filter is blank, revenue elements and arrangements are created and updated as needed for all accounting books. When you select an accounting book in this filter, revenue elements and revenue arrangements are generated only for that accounting book.
- Source Record Type – This filter appears only when at least one of the additional features that the source records depend on is enabled. When the filter is blank, revenue elements and arrangements are created and updated as needed for all source record types. When you select a record type in this list, revenue elements and revenue arrangements are generated only for that source record type.
  
  The source record options and feature dependencies are as follows:
  - All – No filter is applied. This option is the default.
  - Project Revenue Rule – Available only when Charge-Based Billing is enabled.
  - Subscription Line – Available only when SuiteBilling is enabled.
  - Third Party – This option is available only when the limited release Revenue Management Plug-In is enabled.
  - Transaction Line – This option is always available when the filter is displayed.
Click Update Revenue Arrangements.

The initial process, Revenue Arrangement Management, identifies the revenue elements and arrangements that the system needs to update. This process starts additional processes to update revenue elements and revenue arrangements as needed.

Note:
If you click Update Revenue Arrangements again with overlapping filter settings before the first process finishes, you may receive an error message. NetSuite checks for overlapping date ranges and matching filter values within the previous seven days to determine whether the update process can proceed.
Click Refresh until any revenue element and revenue arrangement processes display Complete in the Submission Status column.
Click the Complete link to open a page with a link to the revenue arrangement or elements.

For the Revenue Arrangement Management process, Complete is text only, not a link.

To update revenue arrangements manually:

Related Topics