In this article

SBS ARED Deferral Schedule Reconciliation Inquiry

Use this page to view the balance of the deferral account for one or more deferral schedules at 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.

This page contains the following fields: 

Field Description
Reconciliation Option

Select the Option as Revenue or Expense.

Display the sign in the Deferred Revenue :

  • Recognition Type Credit: the same sign for the amount as on the schedule

  • Recognition Type Debit: the opposite sign for the amount than on the schedule

Display the sign in the Deferred Expense:

  • Recognition Type Debit: the same sign for the amount as on the schedule

  • Recognition Type Credit: the opposite sign for the amount than on the schedule

Customer Select the customer that you want to appear.
Vendor Select the vendor that you want to appear.
As of Date Enter the date which shows all ARED schedules which have been created as of that date.
Item No. Select the item number you want to appear.

 

 

 

Fields

This page contains the following information: 

Line / Fields Description
Source Document No. Displays the source document from where the deferral schedule was created.
ARED Schedule No. Displays the deferral schedule number.
ARED Schedule Status Displays the status of the schedule (Active, On Hold, Cancelled, Completed, Archived).
Source Document Date Displays the Invoice/Document Date.
Deferral Start Date Displays the Start Date of the Deferral Schedules (from version 41.2 onwards).
Deferral End Date Displays the End Date of the Deferral Schedules (from version 41.2 onwards).
Invoice Line Displays the line number of the source document line.
Department Code(Global dimension) Displays the Department code.
Customergroup Code

Displays the Customer group code.
Customer/Vendor No.

Displays the Customer/Vendor Number.
Customer/Vendor Name

Displays the Customer/Vendor Name.
Schedule Type Displays the Schedule type Template (straight line or event based)
Recognition Type Displays the Recognition type as Debit or Credit as defined on the ARED Schedule.
Transaction Type Displays the transaction type (sales invoice, purchase invoice, general journal, Billing schedule).
Item Type Displays type as item or GL Account.
Number Displays Item or GL Account Number.
Item Description Displays Items or GL Account Description.
ARCB Schedule Number Displays the ARCB Schedule Number if the invoice with deferral item starts from an ARCB schedule.
Original Document Number Displays the original document number.
Original Document Type Displays the original document type.
Original Deferral Amount

Displays the original deferral amount.
Original Deferral Amount (A)

Displays the original deferral amount.
Original Deferral Discount Amount

Displays the original discount amount.
Original Deferral Discount Amount (B)

Displays the original discount amount.
Original Net Deferral Amount (A-B)  
Original Deferral COGS Account  
Original Deferral COGS Amount (C)  
Recognition Account  
Recognition Amount (D)  
Discount Recognition Account  
Discount Recognition Amount (E)  
Net Recognition Amount (J) = (D-E)  
COGS Recognition Account  
COGS Recognition Amount (F)  
Adjusted Revenue Amount (G)  
Adjusted Discount Amount (H)  
Adjusted COGS Amount (I)  
Deferral Amount Balance (K) = (A-D-G)  
Deferral Discount Balance (L) = (B-E-H)  
Net Deferral Amount (K-L)  
Deferred COGS Balance (C-F-I)