Deferred Revenue Rollforward Transaction Detail Report
This topic is for the Advanced Revenue Management report. For the classic revenue recognition context, see Deferred Revenue Rollforward Transaction Details. The topics are similar, but the related reports are different.
If you have a large number of transactions, schedule this report to run in the background during off-peak hours and alert you when finished. For information, see Scheduling a Report.
The Deferred Revenue Rollforward Transaction Details report adds Source Document Type and Source Document Number columns. The other columns shown are the same as in the Deferred Revenue Rollforward Customer Summary Report. This report is grouped by Source Document Number, Customer, and Deferred Revenue Account.
For the classic revenue recognition features, return authorizations appear on separate lines from their related sales orders and invoices. Credit memos are also displayed on different lines than their related invoices.
Any line labeled Unassigned in this report includes transactions with items that do not have an associated deferred revenue account.
You can identify the source document type in the report and drill down to the original source. The following table shows how the source document type in the report is derived from transactions.
Transactions |
1st Level Parent |
2nd Level Parent |
3rd Level Parent |
Source Document Type |
---|---|---|---|---|
Sales Order |
Sales Order |
|
|
— |
Invoice created from a Sales Order |
Invoice |
Sales Order |
|
Sales Order
Note:
The source document type is the sales order if you have not updated the revenue arrangement. |
Revenue Arrangement created from a Invoice and Sales Order |
Revenue Arrangement |
Invoice |
Sales Order |
Revenue Arrangement |
Return Authorization |
Return Authorization |
|
|
— |
Credit Memo created from a Return Authorization |
Credit Memo |
Return Authorization |
|
Return Authorization |
Invoice |
Invoice |
|
|
Invoice
Note:
The source document type is the invoice if you have not updated the revenue arrangement. |
Revenue Arrangement created from a Invoice |
Revenue Arrangement |
Invoice |
|
Revenue Arrangement |
Journal Entry |
Journal Entry |
|
|
Journal
Note:
The source document type is the journal entry if you have not updated the revenue arrangement. |
Revenue Arrangement created from a Journal Entry |
Revenue Arrangement |
Journal Entry |
|
Revenue Arrangement |
Credit Memo |
Credit Memo |
|
|
Credit Memo
Note:
The source document type is the credit memo if you have not updated the revenue arrangement. |
Revenue Arrangement created from a Credit Memo |
Revenue Arrangement |
Credit Memo |
|
Revenue Arrangement |
Cash Sale |
Cash Sale |
|
|
Cash Sale
Note:
The source document type is the cash sale if you have not updated the revenue arrangement. |
Revenue Arrangement created from a Cash Sale |
Revenue Arrangement |
Cash Sale |
|
Revenue Arrangement |
Cash Refund |
Cash Refund |
|
|
Cash Refund
Note:
The source document type is the cash refund if you have not updated the revenue arrangement. |
Revenue Arrangement created from a Cash Refund |
Revenue Arrangement |
Cash Refund |
|
Revenue Arrangement |
To view this report:
-
Go to Revenue > Revenue Reports > Deferred Revenue Rollforward > Detail.
-
Adjust the values for Date, To, and From.
-
Select a single subsidiary value (not consolidated) in the Subsidiary Context filter if you have a OneWorld account and access to multiple subsidiaries. When you run a consolidated report, the calculation of the Variance column is different.
-
Select a value in the Accounting Book filter if you are using Multi-Book Accounting and have access to multiple accounting books.
-
Click Refresh to apply your filters.
Report data is truncated when the number of transactions in the report period exceeds 100,000.