In this article

Deferral Balance

Modules > Advanced revenue & expense deferrals > Inquiries > Deferral balance

Use this page to view the balance of the deferral account for one or more deferral schedules as of a specified date. You can use this information to reconcile the balance from the General Ledger to the deferral schedules.

Each line displayed corresponds to a single deferral schedule with the totals showing at the bottom.

To see specific transactions for a deferral schedule used in the calculation, use the Audit Trail page.

If the deferral balance is zero, the deferral schedule does not appear in this form. For example, a deferral schedule does not appear when the As of date is:

  • before the deferral schedule is created
  • after all the lines have been recognized
  • after the deferral schedule is canceled with cancellation entries

Note icon. Note: The amounts on this page appear as positive numbers for debit balances and negative numbers for credit balances. The way amounts appear is consistent with how amounts appear in the General Ledger inquiries.

Tip: To create a recurring batch job to generate this report use the Deferral Balance Batch Processing page.

Generate Inquiry

To generate an inquiry, follow these steps: 

  1. Set Batch job data to No.
  2. The default As of date is the current date. Change the date if needed.
  3. Select the Select button and add data filters for the data you want on the report.
  4. Select how you want to report to Group by, select a summary or detail Report type, and select Report.

The inquiry is generated and appears on the page.

View Batch Inquiry

To generate an inquiry for the batch job, follow these steps: 

  1. Set Batch job data to Yes.
  2. Select the Select button.

The inquiry is generated using the settings from the Deferral Balance Batch Processing page and all records that satisfy the criteria appear on the page.

Fields

This page contains the following fields: 

Field Description
Select Options
Batch job data

Determines whether the inquiry data that appears on the page is based on the settings from the Deferral Balance Batch Processing page.

  • Yes: Uses the criteria as specified on the Deferral Balance Batch Processing page when running the inquiry. Only records that satisfy the criteria specified on the Deferral Balance Batch Processing appear in the list.
    When selected, the As of date is not available.
  • No: Allows you to specify the As of date and any filter criteria on this page when running the inquiry. Only records that satisfy the criteria as specified on this page appear in the list.
As of date

Specify the as of date for which you want to view deferral schedules.

Report Options
Group by

Select how the data is organized in the report. The data can be organized by the following groups: 

  • Customer
  • Item
  • Billing schedule number
  • Main account
  • Deferral account
  • None
Report type Specify the report type to generate: Summary or Detail.
Lines

Displays all records as of the specified date. The information for each lines includes: 

  • Deferral schedule number, type, and status
  • Deferral start and end dates
  • Invoice number, date and account
  • Item number and name
  • Charge code
  • Deferral account and main account
  • Original deferral amount and balance
  • Recognized amount
  • Billing schedule number, billing line status
  • Transaction type
Totals
Original deferral amount Displays a sum total of the original deferral amount for all lines.
Stubbed amount Displays a sum total of the stubbed amount for all lines.
Recognized amount Displays a sum total of the recognized amount for all lines.
Deferral balance Displays a sum total of the deferral balance for all lines.

Buttons

This page contains the following buttons: 

Button Description
Select Opens a query window, where you can add user-defined parameters to the query. When you select OK, the query is applied to the data, and the lines are updated.
Report

Generates the report for all records that satisfy the specified criteria. This report can be printed or exported to Microsoft Excel.

See also

Audit Trail