Advanced Revenue Management: Rev Rec Start Date and End Date on Sales Transactions

There are instances where users want to map the Revenue Recognition Start Date and End Date manually in their Sales Order/Invoice lines.

In Advanced Revenue Management Start Date and End Date is not available in Sales Order and Invoice’s line section (If you are not using the Revenue Recognition feature before). You will have to resort to mapping a custom transaction line and use Revenue Recognition Fields Mapping functionality.

Here is an illustration:

create a Custom Transaction Line Field

1.) Navigate to Customization > Lists > Records & Fields > Transaction Line Fields > New

2.) Set the following values:

Name: Rev Rec Start Date

Type = Date

Store Value = True

Applies To: Sale Item

3.) Save

4.) Do the same for Rev Rec End Date

Revenue Field Mapping:

1.) Go to Set Up > Accounting > Revenue > Revenue Field Mapping

2.) Add the values for the following fields:

Source Record Type: Transaction Line

Source Field: Rev Rec Start Date

Target: Start Date

3.) Save

By setting these, users will now be able to set the Rev Rec Start Date/End Date in the Sales Order/Invoice and the Revenue Element will follow these dates. Users can also map custom transaction line fields to multiple target fields, please check SuiteAnswers ID: 49355 | Mapping Revenue Recognition Fields

Revenue Recognition Rule

In order for the dates to reflect the Revenue Elements’ start date/end date in Revenue Plans, users must set the REV REC START DATE SOURCE to Revenue Element Start Date and REV REC END DATE SOURCE to Revenue Element End Date. Please check SuiteAnswers ID: 49208 | Revenue Recognition Rule Field Reference

Leave a comment

Your email address will not be published. Required fields are marked *