Enhancing Deferred Revenue Reports
This topic applies to the Revenue Recognition feature. Revenue Recognition is the key feature of NetSuite classic revenue recognition. Classic revenue recognition features are not available in new NetSuite implementations. Classic revenue recognition (also called legacy revenue recognition) is still supported for customers who previously enabled it. NetSuite currently offers the Advanced Revenue Management (Essentials) feature to automate revenue deferral and recognition. For information about the current feature, see Advanced Revenue Management (Essentials) and (Revenue Allocation).
You can customize the following deferred revenue reconciliation reports to identify the original source of the transaction by adding fields from the Transaction Dimension group:
-
Deferred Revenue By Customer
-
Deferred Revenue by Item
-
Deferred Revenue By State
-
Revenue by Customer
-
Revenue By Item
-
Revenue By State
-
Deferred Revenue Reclassification Activity
-
Deferred Revenue Reclassification
-
Revenue Reclassification Summary
-
Revenue Reclassification Detail
-
Purchase Order History
-
Sales Tax Analysis
-
A/P Payment History by Payment
-
A/P Payment History by Bill
-
A/R Payment History by Payment
-
A/R Payment History by Invoice
There are four fields in the Transaction Dimension group that reference the source document for the transaction. You can add them in Edit Columns, Filters, and Sorting. The fields are:
-
Source Rev. Rec. Document Number – The transaction number of the original source
-
Source Rev. Rec. Document Type – The transaction type of the original source
-
Source Rev. Rec. Start Date – The revenue start date in the source document
-
Source Rev. Rec. End Date – The revenue end date in the source document
When you add these fields to the columns in the report, you can identify and drill down to the original source. The following table shows how the source document type is derived from transactions.
|
Transaction |
1st Level Parent |
2nd Level Parent |
Source Document Type |
|---|---|---|---|
|
Manual journal entry |
Journal |
|
Journal |
|
Rev. rec. journal entry on manual invoice |
Invoice |
|
Invoice |
|
Rev. rec. journal entry |
Invoice |
Sales Order |
Sales Order |
|
Rev. rec. journal entry |
Revenue Commit |
Sales Order |
Sales Order |
|
Reclassification |
Sales Order |
|
Sales Order |
|
Invoice |
Sales Order |
|
Sales Order |
|
Credit Memo |
Invoice |
Sales Order |
Sales Order |