Cost Event - Line Items

The following columns are displayed in every Display Column option:

• Applied Expense Amount: The current expense amount being applied for the line item. Proliance determines this amount based on the expense column furthest to the right in the grid with a non-zero value. In other words, Adjusted Expense has the highest priority, followed by Quoted Expense, Revised Expense, then Preliminary Expense. If all the expense columns to the right are empty, then Applied Expense is zero.
  
  Proliance always fully allocates the Applied Expense amount in the Cost Account Allocation Grid. Proliance identifies the column used for determining the applied expense in the Expense Applied From Type column.
  
  You cannot edit the Applied Expense column, but you can override the calculation rule and select the column to be used in the Applied Expense column by setting the calculation rule to Manual.

• Book Type: Select the book type for this line item. The book type determines who can see this information when they view the budget and cost management information for the workspace. This column appears only if BCM integration has been enabled for the cost event.
  
  To change the book type after it has been set, see "Changing the Book Type of a Cost Event Line Item".
• Calculation Rule: You can specify whether to use the system default rule to automatically process line item calculation or to manually select the type of value used in the Applied Expense or Applied Revenue column. Auto and Manual are two available options. The default can be selected as a cost event setting. The Calculation Rule can be selected for each line item.
  
  Auto is used if you want to apply the default calculation rule. The default calculation rule determines the current expense amount being applied for the line item. Proliance determines this amount based on the expense column furthest to the right in the grid with a non-zero value.
  
  Manual allows you to select the column in the Applied Expense or Revenue from Type columns to be carried forward to the ACR. The manual selection  overrides the automatic default calculation rule.
  
  When the line item is Both, then both the Expense and Revenue Applied From Type field will be editable. If the line item is Expense, then the Expense Applied From Type field will editable. If the line item is Revenue, then the Revenue Applied From Type field will be editable.
  
  The Default Calculation Rule allows you to control the value of Applied Expense or Revenue Type for each line item.
• Category Code: You can choose a category code for the line item from the drop-down list. The category code is useful for grouping, sorting and summarizing the line items on the Schedule of Values according to a hierarchy that is meaningful within your workspace. You can have up two three levels within this hierarchy. For more information about setting up the list of category codes, see "About Lookup Lists" in the Proliance Local Admin online help. This value is copied to a contract or change order during hand-off.
• Custom Code [1, 2]: Select a value that someone in your workspace has defined specifically for your workspace's documents. This value is copied to a contract or change order during hand-off.
• Delivery Information: Optionally add a note specifying delivery instructions for the line item. This value is copied to a contract or change order during hand-off.

• Expense Applied from Type:This identifies the column that Proliance is currently using to supply the Applied Expense value. For line items that do not have an expense component, 'Not Applicable' is displayed in this column instead.
  If the Calculation Rule for the line is set to Auto, this field is not editable.
  If the Calculation Rule for the line is set to Manual, this field is editable and you can select the column the system applies to the ACR.
• Item Classification: Select a workspace information code from the drop-down list. An example of a common code system for Plan-Build workspaces is the MasterFormat™ system of the CSI. This value is copied to a contract or change order during hand-off.

• Item Description:Optionally type a brief description of the cost account associated with this line item.
• Item Notes: Optionally type a short note that provides more information about the line item. This note can go into more detail than the Description. This value is copied to a contract or change order during hand-off.

• Item Number: Type a string of characters that uniquely identify this line item from the other line items in the cost event.

• Item Type: The item type defaults to the type specified under Line Item Type Settings on the Settings page of the cost event. You can change the line item type at a later time if necessary.  
  
  Expense: Use only the expense portion of the cost event line item. The revenue portion is deactivated. Expense line items cannot have any revenue allocations.
  
  Revenue: Use only the revenue portion of the cost event line item. The expense portion is deactivated. Revenue line items cannot have any cost allocations.
  
  Both: Both the expense and revenue portions of the cost event line item are active. With this line item type, Proliance automatically synchronizes the revenue allocations.

•  Revenue Applied from Type: This identifies the column that Proliance is currently using to supply the Applied Revenue value. For line items that do not have a revenue component, 'Not Applicable' is displayed in this column instead.
  
  If the Calculation Rule for the line is set to Auto, this field is not editable.
  
  If the Calculation Rule for the line is set to Manual, this field is editable and you can select the column the system carries forward to the ACR.
• Specification Section: Select the section of the workspace specifications manual which details the specifications for the line item. This value is copied to a contract or change order during hand-off.

In addition to the columns described under 'Both', the following columns are visible and shown in yellow when the Display Columns setting is 'Expense':

• Preliminary Expense ($):

  Optionally enter a preliminary estimate for the expense of the cost event line item. How Proliance treats this value depends on the cost event line item type.

  • If the type is 'Expense' or 'Both', Proliance will use this value as the Applied Expense if no other expense column further to the right contains a value.
  • If the type is 'Revenue', Proliance will not use this value as the Applied Expense. The value will be for informational purposes only.
• Revised Expense ($) :Optionally enter an expense amount that overrides the amount of the cost event line item quoted in an expense quotation. How Proliance treats this value depends on the cost event line item type:
  If the type is 'Expense' or 'Both', Proliance will use this value as the Applied Expense.
  If the type is 'Revenue', Proliance will not use this value as the Applied Expense. The value will be for informational purposes only.
• Quoted Expense ($): Optionally enter an expense amount representing the amount of the cost event line item included in an expense quotation. How Proliance treats this value depends on the cost event line item type:
  If the type is 'Expense' or 'Both', Proliance will use this value as the Applied Expense if the Adjusted Expense column does not contain a value.
  If the type is 'Revenue', Proliance will not use this value as the Applied Expense. The value will be for informational purposes only.
• Adjusted Expense ($): Optionally enter an expense amount that overrides the amount of the cost event line item quoted in an expense quotation. How Proliance treats this value depends on the cost event line item type:
  If the type is 'Expense' or 'Both', Proliance will use this value as the Applied Expense.
  If the type is 'Revenue', Proliance will not use this value as the Applied Expense. The value will be for informational purposes only.
• Final Expense ($): The amount that has been handed off to the expense contract or change order related to the line item, or the amount that has been finalized. If there is no value in this column, that means the line item has not been handed off or finalized yet. Proliance automatically inserts this value and you cannot edit it.
• Expense Target Contract: When the expense portion of the cost event line item has been handed off to a committing document, the name of that document is shown here. You can click on the name to view detailed information about the document, but you cannot edit the document link.
• Expense Committing Document:

  When the expense portion of the cost event line item has been handed off to a committing document, the name of that document is shown here. You can click on the name to view detailed information about the document, but you cannot edit the document link.

• Expense Committing SOV Item Number:

  When the expense portion of the cost event line item has been handed off, the Line Number of the Schedule of Value entry in the committing document is shown here. You cannot edit the line number reference.

• Expense Committed Amount:

  The value of the Schedule of Value line item created for the cost event line item. This value is displayed only if the expense portion of the line item has been handed off to an expense committing document.

  If there is more than one cost event line item linked to the Schedule of Value line item, then Proliance prorates the expense committed amount for the cost event line item based on the line item's current Applied Expense amount.  

   

The following columns are visible and shown in blue when the Display Column option is 'Both' or 'Revenue':

• Expense Markup Percentage: Enter a markup percentage that will be used to calculate the revenue from the Applied Expense amount. For example, to enter 8.5%, enter '8.5' and not '0.085'.  
   
• Calculated Revenue: Updated whenever the Applied Amount (Exp) changes, or the Expense Markup (%) changes. The Workspace Currency Precision is applied to the resulting calculation. If the line item type is 'Revenue' or 'Both', Proliance calculates the revenue amount as follows: Applied Amount (Exp) * (1+ Expense Markup (%).  
   
• Manual Revenue:

  Optionally enter your own revenue amount. How Proliance treats this value depends on the cost event line item type:

  • If the type is 'Revenue' or 'Both', Proliance will use this value as the Applied Expense if no other revenue column further to the right contains a value.
  • If the type is 'Expense', Proliance will not use this value as the Applied Revenue. The value will be for informational purposes only.
• Quoted Revenue:

  Optionally enter a revenue amount representing the amount of the cost event line item included in the revenue quotation. How Proliance treats this value depends on the cost event's line item type:

  • If the type is 'Revenue' or 'Both', Proliance will use this value as the Applied Expense if the Revised Revenue does not contain a value.
  • If the type is 'Expense', Proliance will not use this value as the Applied Revenue. The value will be for informational purposes only.
• Revised Revenue:

  Optionally enter a revenue amount that overrides the amount of the cost event line item included in a revenue quotation. How Proliance treats this value depends on the cost event's line item type:

  • If the type is 'Revenue' or 'Both', Proliance will use this value as the Applied Revenue.
  • If the type is 'Expense', Proliance will not use this value as the Applied Revenue. The value will be for informational purposes only.
• Final Revenue:

  If the line item type is 'Revenue' or 'Both', Proliance will update Final Revenue with the Applied Revenue amount when you finalize the revenue for the selected line item. If there is no value in this column that means the line item has not been finalized yet.  

  If the line item type is 'Expense', optionally enter a final revenue amount. This value will not affect the Applied Revenue.

   

• Revenue Target Contract:  

  The contract associated with the cost event line item.

  If the revenue portion of the cost event line item has not been handed off, click the Magnifying Glass icon and select the target revenue contract for the line item. Proliance lets you choose from pre-commit revenue contracts that are in any state other than Closed or Cancelled.

  If the revenue portion of the cost event line item has been handed off to a revenue committing document, Proliance selects the target contract based on the following:

  • If the committing document is a change order, the target contract is the same contract as one associated with the change order.
  • If the committing document is a contract, that contract also becomes the target contract.  

  You cannot change the selected target contract once the revenue portion of the cost event line has been handed off.

   

• Revenue Committing Document:

  When the revenue portion of the cost event line item has been handed off to a committing document, the name of that document is shown here. You can click on the name to view detailed information about the document, but you cannot edit the document link.

   

• Revenue Committing SOV Item Number:

  When the revenue portion of the cost event line item has been handed off, the Line Number of the Schedule of Value entry in the committing document is shown here. You cannot edit the line number reference.

   

• Revenue Committed Amount:  

  The value of the Schedule of Value line item created for the cost event line item. This value is displayed only if the revenue portion of the line item has been handed off to a revenue committing document.

  If there is more than one cost event line item linked to the Schedule of Value line item, then Proliance prorates the revenue committed amount for the cost event line item based on the line item's current Applied Revenue amount.