SBS MERA Revenue Allocation (Sales Invoice)

Use this page to enter the revenue allocation parameters for a sales transaction that has not been posted.

  • When this page is opened for the first time, all line items automatically appear in the Lines area of the form.
  • If any changes are made to the sales transaction, the Calculated Revenue Allocation is automatically recalculated.
  • When a line is added to an existing sales transaction where the sales invoice has been created, the following occurs:
    • If the MEA type for the item is single, the Calculated Revenue Allocation amount is automatically recalculated.
    • If the MEA type for the items is multiple, you must select the MEA number before the Calculated Revenue Allocation is recalculated.

Note icon. Note: Review the following information for invoices that have been created from ARCB

  • You cannot add or delete a sales line, nor can you edit an existing sales line. However, you can delete the entire invoice.
  • If the revenue allocation is already attached to the billing schedule, the MERA information is carried forward to the invoice.
  • All information in the Revenue Allocation page is read-only and cannot be edited.
  • The Calculated Revenue Allocation amount is the same value as the Period Revenue on the SBS ARCB Billing Detail List.
  • The Accrued Amount = (sum of Calculated Revenue Allocation) - (sum of Net Amount) per MEA number

When you open this page for a posted sales invoice from the View - Posted Sales Invoice form, all data on the page is read-only and cannot be edited.

Processes

Add revenue allocation information for a sales transaction: 

  1. Create a sales order.
  2. In the Lines, add an item, and complete all necessary information.
  3. Select the Actions tab, and then select Revenue Allocation.
  4. Select the MEA Type.
  5. Specify the MEA number.
    • If the MEA type is Single, the same MEA number applies to each line.
    • If the MEA type is Multiple, you can apply a different MEA number to each line.
  6. For each line, you can edit the SSP Origin.
  7. If SSP Origin is Amount, specify the Standalone Selling Price
  8. If SSP Origin is Percent of item, select the Actions tab, and then select Process > Enter Percent Line.
    The SBS MERA Transaction Percent Line page appears, where you specify the percentage values to calculate the amount for the standalone selling price.
  9. Select OK to return to the Sales Invoice form.
  10. Post the sales order.

Before you post the sales order, you can review the distribution: 

  1. On the Sales Invoice form, select the Actions tab, and select Posting > Preview Posting.
  2. On the View - Posting Preview form, select G/L Entry, and select Show Related Entries.
  3. Review the entries on the View - Value Entries Preview form, and close the page when you are finished.
    The amount that appears on this page is the amount from MERA.

If you had already posted the sales invoice, you can still review the distribution: 

  1. Select the Posted Documents tab, and select Posted Sales Invoices.
  2. Select the sales invoice you want, in the View - Posted Sales Invoice form.
  3. Select the Actions tab, and select General > Navigate.
  4. In the View - Selected - Posted Sales Invoice form, select G/L Entry, and select Show Related Entries.
  5. Review the entries on the View - General Ledger Entries form, and close the page when you are finished.
    The amount that appears on this page is the amount from MERA.

Fields

This page contains the following fields: 

Field Description
Document No. Displays the document number.
MEA Type

The multiple element arrangement (MEA) type for the transaction: 

  • Multiple: Select this type when some line items on the transaction are part of the MEA, or if more than one arrangement exists.
  • None: Select this type for a standard transaction without any revenue allocation.
  • Single: Select this type when all items on the transaction are part of a single MEA.
MEA Number

Displays the MEA number for a line. Available when MEA Type is Multiple.

When this value is empty, and you assign a MEA number, the SSP Origin and Standalone Selling Price are automatically updated based on the values from the SBS MERAItem Standalone Selling Price page.

Only the MEA numbers that are assigned to other lines in the sales order are available.

This field is read-only when the line has been billed.

Line Grid
Item No.

Displays the value from the sales order.

Quantity

Displays the value from the sales order.

Unit Price Displays the unit price for the item.
Net Amount Displays the Line Amount Excl. tax amount from the sales line item.
MEA Number

Displays the MEA number for a line. Available when MEA Type is Multiple.

When this value is empty, and you assign a MEA number, the SSP Origin and Standalone Selling Price are automatically updated based on the values from the SBS MERAItem Standalone Selling Price page.

Only the MEA numbers that are assigned to other lines in the sales order are available.

If these values are not set up for the item, the values are from the SBS MERA Multi-Element Revenue Allocation Setup page.

SSP Origin

Specify the origin of the standalone selling price for an item: 

  • Amount: The standalone selling price is amount greater than zero (0) that you set. The amount is converted between the functional and originating currencies as needed.
  • Base sales price: The standalone selling price is the same value as the base sales price of the item.
  • Invoice price: The standalone selling price is the same value as the invoice price of the item.
  • Percent of item: The standalone selling price is set by a percentage value and is calculated based on the price of the item. When you select this option, specify the default percent.
  • Allocate residual amount: The origin of the standalone selling price is calculated as follows: Total contract value of parent item - Total SSP of child items.
    If the calculated amount is a negative value, the amount is set to zero (0).
    Where: 
    • Total Contract Value of Parent Item is the net or billed amount
    • Total SSP of child items is the sum of the extended or contract standalone selling price of all child items, except for the child item that uses this SSP origin.
    Note icon. Note: This option can be selected by only one child item in the revenue split.
  • None: The origin of the standalone selling price is based on the child items. This option applies to items that are defined as a parent item in a revenue split template. When Revenue split is selected, this option is automatically selected and cannot be changed.
  • Percent of parent invoice price: The origin of the standalone selling price is a percent of the invoice price of the parent item. You can change the default value. Available only for child items in a revenue split template.
  • Percent of parent standard price: The origin of the standalone selling price is a percent of the standard price of the parent item. You can change the default value. Available only for child items in a revenue split template. Default option for child items.
  • When the option for a child item is changed from percent of parent standard price to invoice price (or vice versa), the calculated values are also updated.

Standalone Selling Price

Displays the standalone selling price for the line in the transaction currency.

If SSP Origin is Amount, this value is manually entered. Otherwise, it is automatically calculated.

Extended SSP Displays the extended standalone sales price for a line item in the currency of the transaction. This value is calculated as follows: Quantity * Standalone Selling Price
Calculated Revenue Allocation

Displays the calculated revenue for the line in the transaction currency. This is the amount that is posted to the revenue account for this line.

For lines that have an SSP Origin of Percent of item and have percentages specified in the SBS MERA Transaction Percent Line page, the calculated value is the sum of amounts for the lines on the SBS MERA Transaction Percent Line page.

Accruals
MEA Number

Displays the MEA number.

Accrued Amount Displays the total accrued revenue amount for the MEA number.
Deferred Contract Rev. Account

Specify the account you want to use for journal entries when a multiple element arrangement (MEA) contract invoice is created.

Available when Advanced Recurring Contract Billing is installed and used.

The default value is from the header, but you can change the value for the line.

Buttons

This page contains the following buttons: 

Button Description
Enter Percent Line

Opens the SBS MERA Transaction Percent Line page. Available when SSP Origin for a line is Percent of item.