Adding Line Item Detail

In a data grid, you can enter line item detail for accounts for which line item detail is enabled. This option is available only for base-level accounts and scenarios (valid intersections) that accept line item detail (where the member attribute UsesLineItems is selected). Line item detail is used as the lowest level of detail for you to enter information for that account. For example, you might have an account for travel expenses and want to detail the amount by type of expense, such as gas, tolls, or parking. To enter the information for the travel expense, you must first enter the amount for each line item detail. After you save the detail, the system calculates the total amount for the travel expense account.

You can enter line item detail only in the base frequency defined for the scenario. For example, if the scenario is Monthly, you cannot enter line item detail in “Quarter1.”

Note:

Line item detail cannot contain single quotation marks ( ‘ ), and the maximum length for the description is 80 characters.

Line item detail applies only to the Entity Currency Value member, or to the default currency.

In a data grid, after you enter the line item detail for the cell, a blue border is displayed to indicate that there is line item detail associated with the cell.

  To add line item detail:

  1. Open a data grid.

  2. Select the cell for which to add line item detail.

  3. Right-click and select Cell Line Item Detail.

  4. Click New Entry.

  5. Enter a Description and Value for the line item detail.

  6. Enter line items, and click Enter or select a different cell to see the change.

    Tip:

    To clear line item detail, enter zero as the value to clear the amount.

  7. Click Save to save the line items.

  8. Click Close.