SBS ARED Advanced Revenue & Expense Deferrals Setup

Use this page to set the default preferences and settings for Advanced Revenue & Expense Deferrals (ARED). The settings are effective company-wide.

Setting Up Default Preferences

To set up the general default deferral schedule preferences, follow these steps:

  1. In the General FastTab, specify general settings for new deferral schedules, such as the following: 
    • Default start date
    • Automatic general journal posting
    • Journal template and recognition batch
  2. In the Journals FastTab, select whether to update the following deferral schedule values on the recognition journal description: 
    • Description
    • Line period
    • Item number and description
    • Document number
  3. In the Posting Method FastTab, select the posting method to use for deferral transactions.
  4. If using automated numbering, complete the Numbering FastTab.
  5. In the Discount Options FastTab, select whether to create a separate deferral schedule for sales or purchase discounts or to include it on the same deferral schedule.
  6. To specify any data for informational purposes, complete the User Defined Fields Header and Lines FastTab

Change Schedule Number

To change the schedule number, follow these steps: 

  1. In the Numbering area, select the Schedule No. Series drop-down list, and at the bottom, select Advanced.
  2. In the Select - No. Series List form, find the series number you are using and look in the Last No. Used column.
  3. Select the number, which opens the Edit No. Series Lines page for the series number.
  4. In the Last No. Used column, change the number to the number you want, and select OK.
  5. Back on the Select - No. Series List form, select OK.

When you create a deferral schedule, the number of the schedule is the next number incrementally from the one you entered.

General

This FastTab contains the following fields: 

Field Description
Equal Per Period

Specify whether the number of days in a period is taken into consideration when calculating the amount in each period for a deferral schedule.

  • On: The amount for each period is the same regardless of the number of days in the period, except for partial periods (such as at the beginning or end of a deferral schedule) which will be prorated.
  • Off: The amount is calculated based on the number of days in each period. Default setting.

You can override this setting at the transaction level.

Consolidate Prior Periods

Select whether to consolidate deferral schedule lines for prior periods.

  • On: If the deferral start date is in a period before the transaction date, all amounts up to and including the period of the transaction date are combined into a single deferral schedule line. Default setting.
  • Off: The amounts from all periods are in separate deferral schedule lines regardless of the date.

If the deferral start date is in the same or a later period as the transaction date, this option has no effect.

You can override this setting at the transaction level.

Schedule from Template

Select whether the deferral schedule is created based on a template or the start and end dates of the billing schedule.

  • On: Creates the straight-line deferral schedule is based on a template.
  • Off: Creates the straight line schedule is created based on the start and end dates of the billing schedule, where the billing date is the deferral start date and the billing end date is the deferral end date. The deferral amount is divided among the billing periods based on the billing frequency selected.

You can override this setting at the transaction level.

Automatically Post General Journals

Select whether any journal entries created by ARED, such as those from recognition processing, should be automatically posted.

  • On: Automatically posts journal entries created by ARED. Default setting.
  • Tip: By selecting this option, you can avoid and prevent any accounting inconsistencies caused by manual changes to vouchers.

  • Off: Does not automatically post journal entries created by ARED. You must manually post any journals.
Summarize Recognition Journal

Select whether to consolidate recognition vouchers by default.

  • On: Creates a single voucher for all recognition lines with the same date. All lines in a voucher with the same account are consolidated into a single line.
  • Off: Creates a voucher for each recognition line. Default setting.

You can override this setting on the SBS ARED Recognition Process page.

Use Acc. Amortization for Deferred COGS

Select to which account the COGS recognized amount is credited.

  • On: Applies a credit to the accumulated amortization account for the associated COGS deferral account for the recognized amount.
  • Off: Applies a credit to the deferred COGS account for the recognized amount.
Deferral Default Date

Select the deferral default date.

  • Document Date: The deferral start date would be according to the document date.
  • Posting Date: The deferral start date would be according to the posting date.
Default Deferral Start Date

Select the rule to apply to the transaction date to get the start date for the deferral schedule: 

  • Transaction Date: Uses the transaction date as the start date. Default.
  • 1st day:  Uses the 1st of the current month as the start date. If the transaction date is the 1st of any month, then the 1st of the current month is the start date.
  • 1st day of next month: Uses the 1st of the next month as the start date. If the transaction date is on the 1st, the transaction date is used, otherwise the 1st of the following month is used.
  • Rule of 15: If the transaction date is between the 1stand the 15th, uses the 1st of the current month as the start date. If the transaction date is the 16thor later, uses the 1st of the next month as the start date.

You can override this setting at the transaction level.

Default Journal Template Specify the default journal template.
Recognition Journal Batch Specify the default batch for the recognition journal.
Short-term Deferral Method

Select the short-term deferral method: None (default), Rolling periods, or Fixed year.

For information on how these settings work, see Short-Term Deferral Calculation.

 

Multiple Deferral Schedules on Multiple Shipments

A new toggle button has been added in version 41.2: Create Multiple Deferral Schedule on Multiple Shipments. This switch is set to OFF by default.

  • If this Toggle button is turned ON, then multiple deferrals can be created for new Sales orders. More specifically, a deferral schedule will be created for a partial ship and invoiced. Existing Sales Orders that are partially shipped and invoiced will not be affected.

  • If this Toggle button is turned OFF, then the deferral schedule will be created only when the Total Sales Lines Quantity is Invoiced

Button: Create Multiple Deferral Schedules on Multiple Shipments

 

 

Journals

This FastTab contains the following fields: 

Field Description
Recognition Journal Description

Select which deferral schedule values appear on the recognition journal description on the General Journals page.

  • Deferral schedule description
  • Line billing period
  • Number and description of the item or General Ledger
  • Document number

The values are added to the description in the order as it appears in this list.

Posting Method

This FastTab contains the following fields: 

Field Description
Deferral Posting Method

Select the method used to create deferral transactions: 

  • Balance Sheet: Uses the balance sheet posting method to create deferral transactions. Default option.
  • Profit & Loss: Uses the profit and loss posting method to create deferral transactions.

Numbering

This FastTab contains the following fields: 

Field Description
Schedule No. Series Specify the prefix for the deferral schedule series. Required.

Discount Options

This FastTab contains the following fields: 

Field Description
Deferral Discount (Sale)

Select whether separate deferral schedules are created for the discount and the sales order amounts:

  • Defer Discount Separately: Discount amount is kept separate from revenue amount.
  • When a sales order is created and then posted, two deferral schedules are created, and the discount and revenue amounts are posted to different deferral accounts.

  • Include Discount in Net Revenue: Discount amount is combined with revenue amount. One deferral schedule is created and both the discount and revenue amounts are posted to the same deferral account.
  • When a sales order is created and then posted, one deferral schedule is created and both the discount and revenue amounts are posted to the same deferral account.

Deferral Discount (Purch)

Select how discount deferral options appear on a purchasing invoice: 

  • Discount Separately: Discount amount is kept separate from purchase amount.
  • When a purchase transaction is created and then posted, two deferral schedules are created, and the discount and purchase amounts are posted to different deferral accounts.

  • Include Discount in Net Direct Cost:  Discount amount is combined with net direct cost amount. One deferral schedule is created and both the discount and direct cost amounts are posted to the same deferral account.
  • When a purchase transaction is created and then posted, one deferral schedule is created and both the discount and purchase amounts are posted to the same deferral account.

User Defined Fields Header and Lines

This FastTab contains the following fields: 

Field Description
User Defined Fields Header
User Defined Field

If you require user-defined field boxes for saving additional information, specify the name of the field box that you want to add. These field boxes appear in the header section when you add a billing or a deferral schedule. The available formats for the user-defined field boxes are as follows: 

  • Text field boxes 1 to 5 and 9 to 13
  • Date field boxes 6 and 14 to 17
  • Integer field boxes 7 and 18
  • Boolean field  boxes 8 and 19

The user-defined fields for billing schedules are independent and unrelated to the user-defined fields for deferral schedules.

User Defined Fields Lines
User Defined Field

If you require user-defined field boxes for saving additional information, specify the name of the field box that you want to add. These field boxes appear in the lines section when you add a billing or deferral schedule. The available formats for the user-defined field boxes are as follows: 

  • Text field  boxes 1 to 5 and 9 to 13
  • Date field boxes 6 and 14 to 17
  • Integer field boxes 7 and 18
  • Boolean field boxes 8 and 19

The user-defined fields for billing schedules are independent and unrelated to the user-defined fields for deferral schedules.

If you specified the names for any user-defined fields, only the user- defined fields that are specified appear in the header or lines section on the following pages:

Note icon. Note: If a customer has multiple deferral schedules and the invoice is created using a consolidation option, information from the user-defined fields of only the first deferral schedule appears on the consolidated invoice. The information for the user-defined fields of the other deferral schedules does not appear on the invoice.