Deferral Schedule
Form ID: (DR201500)
On this form, you can view the schedules the system has automatically generated for documents whose lines have deferral codes assigned. You can also use the form to create custom schedules to defer recognizing revenue or expense amounts for already-released documents. This functionality may help you during system initialization, when all documents are imported "as is" without associated deferral schedules, or if the decision about deferral has been made after the documents were released.
For details on custom schedules, see Custom Deferral Schedules.
Form Toolbar
The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.
Button | Description |
---|---|
View Document | Navigates to the document entry form, such as Invoices and Memos (AR301000) or Bills and Adjustments (AP301000), to view the details of the document to which the deferral schedule is linked. |
Release |
Releases the deferral schedule. Once the schedule is released, the recognition transactions are ready to be posted when it comes due. In the released schedule, the summary information and the component details (in the Components table) cannot be edited. You can still edit the details of the generated transactions in the Transactions table (those transactions that are not posted yet). Note: No GL transactions are generated when you release a deferral
schedule.
This button appears on the form for manually created deferral schedules only. |
Recalculate |
Updates the reallocation pool on the Reallocation Pool tab and the component data on the Details tab by using the recent data from the Sales Prices (AR202000) form and the data from the invoice lines. If the deferral schedule was overridden, the system displays a confirmation message before recalculation. This button appears on the form only for AR documents if the Revenue Recognition by IFRS 15/ASC 606 feature has been enabled on the Enable/Disable Features (CS100000) form. |
Summary Area
You use the elements in this area to select a custom or system-generated schedule and to view its summary information. Also, you can select a released document by its type and reference number and create a custom deferral schedule for it.
Element | Description |
---|---|
Schedule Number |
The unique number of the schedule, which is automatically generated by the system by the numbering sequence that is specified in the Deferred Schedule Numbering Sequence box on the Deferred Revenue Preferences (DR101000) form. For a new schedule, the <NEW> string is displayed, indicating that a new number will be generated. Select a schedule to view information about it. The list of values may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form, and based on the visibility of the business account. If the feature is enabled, the Restrict Visibility To box appears on the Financial tab of the Customers (AR303000) and Vendors (AP303000) forms. You can select a schedule of a customer or vendor, if one of the following is true:
|
Status |
The status of the schedule. The system automatically assigns the following statuses:
|
Date |
The date that determines the period when the first recognition transaction should be recognized and posted. In the deferral schedules generated automatically for documents with the deferral codes specified, this is the document date specified by the system by default. In the custom deferral schedules, you define this date manually. You can enter only a date that corresponds to a financial period that has been generated on the Master Financial Calendar (GL201000) form. If the date that you enter belongs to a financial period that has not yet been generated in the system—for example, for a date in the distant future or past—the system will display an error message, and you will not be able to save the document. |
Doc. Type | The type of the original document for which the schedule is displayed or is being created. |
Ref. Nbr. | The reference number of the original document. |
Net Tran. Price |
The net transaction price of the original document. This box appears on the form for AR documents if the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form. |
Doc. Currency | The currency of the original document. |
Business Account |
A business account (which can be, for example, a customer or a vendor) associated with the original document for which the schedule is displayed or is being created. The list of customers and vendors available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Customers (AR303000) and Vendors (AP303000) forms. With the feature enabled, a customer or vendor is available for selection if one of the following is true:
|
Location | The location of the customer or vendor. |
Line Nbr. |
The line in the AR or AP document for which you can create and view the deferral schedule. Note: In the Line Nbr. selector, the amount
displayed for a line in the Amount column
can differ from the line amount of the original document,
because it does not contain some discount amounts or inclusive
tax amounts that have been applied to the document (if any).
Thus, this is the amount to be recorded to the corresponding
sales or expense account (depending on the document type), and
to be deferred. The amounts are shown in the base currency,
which can differ from the currency of the corresponding
document.
This box appears on the form only for AP documents. |
Currency |
The currency of the schedule. If the schedule is created automatically from a document, this setting is copied from the base currency of the branch to which you are signed in. This box is unavailable for editing. If the schedule is a custom one or is created manually, this setting is specified based on the following rules:
This box appears on the form if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form. |
Line Amount |
The original amount for the specified document line. This box appears on the form only for AP documents. |
Project/Contract |
The project or contract with which the document is associated, or the non-project code if the document is not associated with any project. The box appears on the form if at least one of the Project Accounting and Contract Management features is enabled on the Enable/Disable Features (CS100000) form. |
Project Task |
The project task with which this document is associated. This box is cleared and unavailable if the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form. |
Override |
A check box that indicates (if selected) that the data on the Reallocation Pool tab is cleared and the data in the Components table on the Details tab becomes available for editing. This check box appears on the form for AR documents if the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form. |
Comp. Total |
The component total calculated as the sum of total amounts of all components of the schedule. In other words, it is the total revenue that either has been already recognized or is still deferred and will be recognized in future. This box appears on the form for AR documents if the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form. |
Comp. Deferred |
The component deferred calculated as the sum of deferred amounts of all components in the schedule (the deferred revenue summed up by all components). This box appears on the form for AR documents if the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form. |
Term Start Date |
The date when the process of recognition of deferrals should start; this date should be specified for the item for which the deferral code based on the Flexible by Periods, Prorate by Days or Flexible by Days in Period recognition method is assigned. If the Revenue Recognition by IFRS 15/ASC 606 feature is disabled on the Enable/Disable Features (CS100000) form, this box appears on the form for AP and AR documents. If the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form, this box appears on the form for only AP documents. |
Term End Date |
The date when the process of recognition of deferrals should finish; this date should be specified for the item for which the deferral code based on the Flexible by Periods, Prorate by Days or Flexible by Days in Period recognition method is assigned. If the Revenue Recognition by IFRS 15/ASC 606 feature is disabled on the Enable/Disable Features (CS100000) form, this box appears on the form for AP and AR documents. If the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form, this box appears on the form for only AP documents. |
Details Tab
The Details tab includes the Components and Transactions tables. For each component specified in the Components table, the tab shows in the Transactions table the recognition transactions that were generated for the component according to the deferral code selected for the component. For documents that were released without deferral codes assigned, you can manually create deferral schedules for each component.
Button | Description |
---|---|
Generate Transactions |
Generates recognition transactions for the branch specified in the Branch column of the Transactions table for the selected component (that is, the component you clicked before invoking this action). Note: You cannot regenerate transactions for a component for which
one or more transactions have been already posted.
|
Column | Description |
---|---|
Component ID |
The component of the line item, if the line item is a package; otherwise, the item, by its inventory ID. For details about packages, see Managing Recognition for Packages. |
Deferral Code |
The code that has been assigned to the line of the selected document or that has been specified manually for a component in the custom deferral schedule. This code is used for generating recognition transactions to defer the amount specified in the line. The Deferral Code lookup table which opens from this column shows only the deferral codes that have the Active check box selected for them in the Summary area on the Deferral Codes (DR202000) form. Note: This box can be edited for the components that have the
Draft status (those components for which the deferral
schedules have not been released yet) in the custom deferral
schedules.
|
Deferral Account |
The account to hold the amount to be deferred. The account selected in this box should be configured as a control account for the deferred revenue subledger. That is, for this account, DR should be selected in the Control Account Module column on the Chart of Accounts (GL202500) form. For more information on control accounts, see Control Accounts: General Information. |
Deferral Sub. | The corresponding subaccount to be used with the account. |
Account | The sales or expense account to which the transaction amount is posted or will be posted. |
Subaccount | The corresponding subaccount. |
Term Start Date |
The date when the process of recognition of deferrals should start. If the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form, the system populates this column with a value from the corresponding invoice line. In this case, the Line Number, Line Amount, Project Task, Term Start Date, and Term End Date boxes in the Summary area become cleared and unavailable. |
Term End Date |
The date when the process of recognition of deferrals should finish. If the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form, the system populates this column with a value from the corresponding invoice line. In this case, the Line Number, Line Amount, Project Task, Term Start Date, and Term End Date boxes in the Summary area become cleared and unavailable. |
Project Task |
The project task with which this document is associated. If the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form, the system populates this column with a value from the corresponding invoice line. In this case, the Line Number, Line Amount, Project Task, Term Start Date, and Term End Date boxes in the Summary area become cleared and unavailable. |
Total Amount | The amount on the original document or document line. |
Deferred Amount | The amount yet to be recognized. |
Line Total | The total amount to be recognized. This amount is calculated automatically as the control sum of transaction amounts if the transaction amounts were edited manually. |
Post Period | The financial period to which the original document was posted. |
Branch |
The branch ID of the source document line. For automatically generated deferral schedules, this column is always unavailable, even if the source document has not been released. For manually created deferral schedules, this column is unavailable if a particular document line has been selected in the Summary area (in the Line Nbr. box), and is available only if this schedule has been created for a business account (that is, if the Ref. Nbr. and Line Nbr. boxes in the Summary area are empty). For manual schedules, the system displays branches whose visibility is not restricted for the business account selected in the Business Account box. This column appears in the table if the Multibranch Support feature is enabled on the Enable/Disable Features (CS100000) form. |
Status | The status of the transaction. |
Column | Description |
---|---|
Tran. Nbr. | An integer that indicates the order of the recognition transaction in the schedule. |
Status | The status of the transaction. |
Rec. Date | The date that determines the period when the transaction amount should be recognized and posted. This date can be changed manually. |
Tran. Date | The date when the GL batch is created. |
Amount | The amount to be recognized. This amount can be edited manually. |
Account | The sales or expense account to which the transaction amount is posted or will be posted. This account can be changed manually. |
Subaccount | The corresponding subaccount. The subaccount can be changed manually. |
Fin. Period | The financial period when the transaction amount should be recognized and posted. |
Branch | The branch in which the transaction was created. This read-only column displays the branch that is used in the generated transactions. |
Batch Nbr. | The reference number of the batch that posts the recognition transaction. Click the number to view the batch details. |
Reallocation Pool Tab
The table on the Reallocation Pool tab displays columns specified in the data model of the reallocation pool. The table rows correspond to the document selected in the Summary area. The columns and rows are read-only, you cannot delete or modify the data in the table. The columns on this tab are empty for manual schedules and for manually edited schedules.
Table Toolbar
The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
Column | Description |
---|---|
Branch | The company branch copied from the document line. |
Inventory ID | The inventory ID of the item copied from the document line. |
Document Line Quantity | The quantity copied from the document line. |
UOM | The UOM copied from the document line. |
Currency Ext. Price | The extended price of the item in the document currency, which is copied from the document line. |
Currency Amount | The amount in the document currency, which is copied from the document line. |
MDA Component ID |
The MDA component of the reallocation pool, which is used for revenue recognition. For invoice lines, the value is copied from the Inventory ID column on the Deferral tab of the Stock Items (IN202500) form. |
MDA Component Quantity |
The quantity of the MDA component. For invoice lines with the MDA deferral code, the value is copied from the Quantity column on the Deferral tab of the Stock Items (IN202500) form. For invoice lines with a non-MDA deferral code, this value is always 1. |
MDA Component UOM |
The UOM of the MDA component. For invoice lines, the value is copied from the Quantity column on the Deferral tab of the Stock Items (IN202500) form. |
Deferral Code |
The deferral code of the revenue component. For invoice lines with the MDA deferral code, the value is copied from the Deferral Code column on the Deferral tab of the Stock Items (IN202500) form. |
Fair Value Price | The fair value price used for revenue reallocation, which is copied from a sales price on the Sales Prices (AR202000) form. If no applicable sales price is found, the system displays a warning message, and such a document cannot be released. |
Discount Percent |
The percent of the deferred revenue discount, which has the Apply to Deferred Revenue check box selected on the Discount Codes (AR209000) form, applied to a discountable fair value price of the component. The fair value price without a discount is shown in the Fair Value Price column. The Effective Fair Value Price column displays the prorated fair value price after the deferred revenue discount has been applied. This column is read-only and appears on the form if the Revenue Recognition by IFRS 15/ASC606 and Customer Discounts features have been enabled on the Enable/Disable Features (CS100000) form. |
Effective Fair Value Price |
The effective fair value price used for revenue reallocation. If the selected sales price has the Prorated check box selected for it on the Sales Prices (AR202000) form, this value is calculated as the fair value price multiplied by (Term End Date - Term Start Date + 1 day) / 365. |
Fair Value Currency | The currency of the fair value price. |
Share | The share of the revenue component in the package calculated according to the algorithm. For details, see Recognition of Revenue from Customer Contracts. |
Total Amount | The amount calculated as the net transaction price (in the base currency) * the component share. |
Line Nbr. | The line number copied from the document line. |
Reference Nbr. | The reference number of the document. |
Original Schedules Tab
The table on the Original Schedules tab displays any schedules associated with the selected schedule. For example, if the schedule is based on a credit memo, the tab will display the schedules generated for the original invoice.
Table Toolbar
The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
Column | Description |
---|---|
Schedule Number | The unique reference number of the deferral schedule in the system. If you click this link, the system displays the details of the schedule created for the associated document. |
Transaction Descr. | The status of the schedule associated with the original document. |
Doc. Type | The type of the original document. |
Ref. Nbr. | The reference number of the document. |
Fin. Period | The period to which the document transactions are posted. |