#96 | NetSuite Mapping Revenue Recognition Field

Mapping revenue recognition fields can be tricky at first. It requires advanced knowledge of NetSuite to set the preferences correctly, so that the result of the mapping procedures will work as expected.

In this guide, we will discuss the following:

• Overview
• List of Target Fields
• Supported Source Transaction Form Types
• Steps in Mapping Revenue Recognition Fields

I suggest you watch the video. It’s easier to understand if you are a visual/audio learner. The content below is the same as the video. It’s for those who learn by reading.

Overview

With advanced revenue management, custom and standard fields can be mapped from source records to custom, and some standard, transaction column fields in revenue arrangements.

Two things to remember:

• Both body and column fields on the source can be mapped.
• Only column fields are supported for the target revenue arrangement.

List of Target Fields

Here is a table showing the target fields and their corresponding source field types.

Target Field	Source Field Type
Start Date	date
End Date	date
Forecast Start Date	date
Forecast End Date	date
Reference ID	free-form text
Create Revenue Plans On	custom list/record
Revenue Allocation Group	custom list/record
Term in Months	custom integer number
Term in Days	custom integer number
Alternate Quantity	decimal number

When it comes to Target Fields, it is important to remember the following:

• Mapping is not required when the source and the target revenue arrangement form include the same custom column fields.
• An added mapping rule using a different source field for the target will override the default mapping.
• In the Applies to subtab, be sure to clear the Revenue Arrangement box for any custom field that should not be included in revenue arrangements.

Supported Source Transaction Form Types

When dealing with supported source transaction form types, remember the following:

• When Project Management and Charge-Based Billing features are enabled, the Project Revenue Rule is also a Source Record Type.
• Revenue Recognition field mapping can be performed by roles with the Revenue Recognition Field Mapping permissions such as:
  • Administrator
  • Revenue Manager
  • Revenue Accountant

Steps in Mapping Revenue Recognition Fields

Creating Custom Column Fields

• Step 1: Go to Customization → Lists, Records, & Fields → Transaction Column Field → New.You will need to create custom transaction fields:
  • Custom Rev Rec Start Date
  • Custom Rev Rec End Date
  • Custom Forecast Rev Rec Start Date
  • Custom Forecast Rev Rec End Date
• Step 2: Set the following for each of these fields.
  • Label: Custom Rev Rec Start Date
  • Type: Date
  • Store Value: True (with a check mark)
  • Applies To: Sale Item
• Step 3: Click Save to create the custom field.
• Step 4: Click New to create the next custom column field.Repeat steps 2 to 4 to create the three remaining custom column fields.
• Step 4: In the Currency field, select the currency you want to use for this transaction. The customer’s primary currency is selected by default.

Creating Custom Source Transaction Forms

• Step 1: Go to Customization → Forms → Transaction Forms.
• Step 2: Click Edit next to the custom Sales Order form or click Customize next to the standard Sales Order form.
• Step 3: On the Custom Transaction Form, click the Screen fields tab then the Columns
• Step 4: Tick the Show checkbox next to the 4 custom fields.
• Step 5: Rename the transaction form on the Name
• Step 6: Click Save.

Mapping the Revenue Field

• Step 1: For Administrators, go to Setup à Accounting à Revenue Field Mapping in the Revenue group to open the Revenue Recognition Field Mapping page.For Revenue Managers, go to Revenue à Setup à Revenue Field Mapping.
• Step 2: Fill up the Revenue Recognition Field Mapping

The table below will set as a guide on how page was filled.

Source Record Type	Select a record type for the source. For this example, “Transaction Line” is selected.
Source Field	Select a field from the list. For this example, select the 4 related custom column fields.
Target Field	Select a field from the list. Custom and standard column fields used on custom revenue arrangement forms are included in the list. For this example, the selected standard column fields are: Start Date End Date Forecast Start Date Forecast End Date
Description	Add an optional description that will help you identify the source form for ease of reference.

Setting Accounting Preferences

In this part, you will need to set the accounting preference to use the custom revenue arrangement form that contains your target fields.

• Step 1: Go to Setup → Accounting → Accounting Preferences.
• Step 2: Click the General subtab, and scroll to the Revenue Recognition group of the preferences.
• Step 3: Select your custom form from the Default Revenue Arrangement Form
• Step 4: Click Save.

After setting the preferences, the Sales Order form should look like this with custom column fields added at the lower right.

Those custom column fields will be mapped to standard column fields of the Sales Order’s Revenue Arrangement.

Summary
You just learned the overview and the step by step process of mapping revenue recognition fields. To quickly go back to the main sections of this tutorial, click on the links below.

• Overview
• List of Target Fields
• Supported Source Transaction Form Types
• Steps in Mapping Revenue Recognition Fields