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:

  • The Restrict Visibility To box is empty for the customer or vendor—that is, the customer's or vendor’s visibility is not restricted.
  • A branch, company, or company group is specified in the Restrict Visibility To box for the customer or vendor, and your user account is assigned to the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the branch, or the Company Details tab of the Companies (CS101500) form for the company or a company within the company group.
Status

The status of the schedule.

The system automatically assigns the following statuses:

  • Open: The deferral schedule has at least one transaction with the Open status.
  • Closed: All the transactions for the deferral schedule have been posted.
  • Draft: The deferral schedule has not been released.
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:

  • The Restrict Visibility To box is empty for the customer or vendor—that is, the customer's or vendor’s visibility is not restricted.
  • A branch, company, or company group is specified in the Restrict Visibility To box for the customer or vendor, and your user account is assigned to the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the branch, or the Company Details tab of the Companies (CS101500) form for the company or a company within the company group.
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:

  • If the document and business account are not selected, this setting is copied from the base currency of the branch to which you are signed in, and the box is unavailable for editing.
  • If the document is not selected and a business account for which a currency is specified is selected, this setting is copied from the business account's currency, and the box is unavailable for editing.
  • If a business account without a currency specified is selected, this setting is copied from the base currency of the branch to which you are signed in. The box is available for editing and you can selected the base currency of any branch to which you have access.

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.

Table 1. Components Table Toolbar

The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.

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.
Table 2. Components Table Columns
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.
Table 3. Transactions Table Columns

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Note: You can edit the settings of the generated recognition transactions while they are not posted.
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.

Table 4. Components Table Columns
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.

Table 5. Table Columns
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.