Line item schedules

Line item schedules allow you to add data that is not predefined into input accounts. Line item schedules are useful for planning corporate expenses such as travel and projects where multiple transactions need to be captured to build a total amount.

 Example:  If you are required to input individual planned travel expenses at the account level, you can use line items to break down the expenses into a schedule by event, by journey, or by employee.

 Tip:  Line item details can also be imported through the Import Line Item Details process.

Show indicators

When schedule indicators are turned on, a cell with a schedule shows a blue triangle at the bottom right corner.

  1. In View Indicators, click .
  2. Click

Add a schedule to a cell

  • Click in the cell and select Supporting Details > Line Item Schedule.

See what member is selected

  1. Click .
  2. Click Pages.

See member definition

  • To see the member definition for a dimension, click > Member Definition.

Add a line item

  1. Type values for the line item, for any period, and type a description in the Total column.
  2. When you have added all the line items, click Save.

Paste values from a spreadsheet

You can paste data from a spreadsheet provided enough rows are available.

 Example:  To paste a 3x3 grid of cells, the line item schedule must show a grid of cells of at least 3x3.

Move a line item

  1. Select the row by clicking the row header.
  2. Select Tools > Move Up or Move Down.

Sort the line items based on a column

  1. Click the column header (for example, Line Total).
  2. Select Tools > Sort Ascending or Sort Descending.

Use spreading

  1. In a non-leaf cell, type the value, and press Tab.

    The Time Spread Method dialog opens.

  2. Select a spreading option and click OK.

Turn on spreading

  • If spreading is not available, select Edit > Spreading.

Edit a schedule

  1. Click in the cell.
  2. Select Supporting Details > Line Item Schedule.

Delete a schedule

  1. Open the schedule.
  2. Select Edit > Delete All Rows.
  3. Click Save.

FAQ

Where are line item schedules available?

You can use them in Ad Hoc Analysis and in templates in data-entry mode.

Can I see them in reports?

Yes.

How many line items can I add?

You can add an unlimited number of line items for any input account to which data can be entered. When you finish entering the line items, their total is included in the main model. Data in the main model can change even if that data is associated with a line item schedule.

How does a line item schedule treat dimensions?

The Time dimension can only be used in columns, and always represents a leaf member. The Measures, Time Perspective, and Currency dimensions cannot be used with line item schedules.

Can I get reports for all this line item data?

Yes. Administrators can create custom line item reports.

What is an Unexplained Balance line?

When the total value of the line items does not equal the member value stored in the model, an orange-colored Unexplained Balance line, with Justification as System-generated, appears as the first row of the schedule. The value in the row's Line Total is the difference between the model value and the total of the line item values.

After you close the schedule, the orange line is saved as another row in the schedule. The next time the schedule is opened, that previous Unexplained Balance line appears as another normal row. Furthermore, if a difference still exists between the schedule's total value and the value stored in the model, a new orange-colored Unexplained Balance row appears as the first row.

What if I have an Unexplained Balance line?

Replace Unexplained Balance with an appropriate description for the value in the line.