Calculation Review

The calculation review summarizes the revenues and costs of a project or business. Thus, the calculation review is a simultaneous calculation. This chapter covers everything you need to know about the calculation review. It has been divided into the following sections:

Accessing the Calculation Review

To access the calculation review of a service item, please proceed as follows:

  • Use the quick search (ALT+Q) to find the page Service Items.
  • A list containing all service items is displayed.
  • Open a service item card.
  • Click Item > Calculation Review in the menu bar.
  • The calculation review for the selected item will be displayed.

Note

You can also access the calculation review of a service item via the Calc. Review List. Use the quick search (ALT+Q) in TRASER DMS 365 to find said page and then click on Calculation Review.

The calculation review page is divided into three tabs. The following sections describe these tabs in greater detail.

‘Service Item’ tab

This tab shows detailled information regarding the selected service item. Via the Date Filter you can select a date for the calculation review.

‘Details’ tab

This tab shows the values of the calculation review. The following table shows the values than can be viewed in the calculation review:

Category Value
Purchase Current Asset Expected Unit Cost, Estimated Cost, Act. Standard Cost, Components
Fixed Asset Act. Standard Cost (Asset), Components, Purchase Price Sum
Costs/Discounts Purchase Discounts, Purchase Fright, Purchase Charges, Additional Costs, External Services, Rental Purchase, Calc. Subsidies, Other Revenues, Expected Purch. Cash Discount, Purchase Cash Discount, Unit Cost Sum
Service Exp. Internal Labor, Exp. Internal Parts, Exp. Internal Additional Costs, Exp. Internal Services, Act. Internal Labor, Act. Internal Additional Parts, Act. Internal Additional Cost, Act. Internal Services, Internal Services, Unit Cost Sum incl. Service
Financing Calc. Interests, Leasing, Financing (Repayment etc.), Calculated Unit Cost Sum
Rental External Rental Revenue, Counted Rental Income, Internal Rental Revenue, Unit Cost Sum for Commission
Sales Current Asset Exp. Sales Price Sales Price, Rental with Sales Option
Fixed Asset Act. Sales Price (FA), Rental with Sales Option
Costs/Discounts Sales Discounts, Sales Freight, Sales Charges
Payment Expected Sales Cash Discount, Sales Cash Discount

‘Sums’ tab

This tab shows the sums.

Assigning Lines to a Service Item

This section describes how to assign lines to a service item in documents. You can assign item lines, resource lines as well as item charge lines to a service item. The bookings of these lines will then be taken into account for the calculation review. At present, you can assign lines to service items in the following documents:

Area Document Type
Service Service Shipment, Service Invoice, Service Credit Memo
Purchasing Purchase Order, Purchase Invoice. Purchase Credit Memo, Return Shipment
Sales Sales Invoice. Sales Shipment, Sales Credit Memo, Return Receipt
Accounting FA Journal, General Journal, Item Journal

To assign lines to a service item in documents, please proceed as follows:

Note

This example describes how to assign a line to a service item on a purchase order. However, the process works analogously for the documents listed above.

  • Use the quick search (ALT+Q) to find the page Purchase Orders.
  • A list containing all purchase orders is displayed.
  • Either create a new purchase order or open an existing purchase order with the status open.
  • The purchase order card is displayed.
  • Navigate to the Lines tab.
  • Add a line of the type Item, Resource or Charge (Item) and fill in all relevant fields.
  • Navigate to the Allocate to Service Item No..
  • Enter the number of the service item you would like to assign the line to.
  • Navigate to the Allocate to Trade No..
  • Enter the trade number of the service item. If the service item has only one trade number, this field will be filled in by the system.
  • Navigate to the Allocate to Calculation Entry Type.
  • Select the entry type for the booking of the line. For more information on calculation entry types, click here.
  • You can now release and book the document.

When the document has been released and posted, the value of the item, resource or charge line will be listed on the calculation review.

Manually Registering Costs and Revenues for the Calculation Review

This section describes how to manually add and register costs and revenues to a service item in TRASER DMS 365. These costs and revenues will then be taken into account for the calculation review. This functionality proves valuable in scenarios where you want to add costs to a service item after a document has already been posted. Please proceed as follows:

  • Use the quick search (ALT+Q) to find the page Service Items.
  • A list containing all service items is displayed.
  • Open the service item you would like to manually register costs for:
  • In the menu bar, click on Related > Other > Allocated Costs/Revenues.
  • The page Allocated Costs/Revenues is displayed.
  • To add costs to the service item, click Add in the menu bar.
  • A new dialog window opens.
  • Fill in the following information:
Field Description
Service Item No. This field will be filled out by the system with the number of the selected service item.
Trade No. This field will be filled out by the system with the trade number of the selected service item.
Effective Date Enter the effective date for the added costs.
Calculation Entry Type Choose the type of costs you would like to add. You can find more information on calculation entry types here.
Description Enter a clear description for the added costs.
Sales Unit Price Enter the amount of the costs.
Quantity Enter the quantity.
Amount This field will be filled out by the system.
  • Now, click on Add to add the costs.
  • The page Allocated Costs/Revenues will display a new line for the added costs. The status of the line should be Not Registered.
  • Select the line and click on Register in the menu bar.
  • A dialog window will be displayed.
  • Click Yes to confirm the dialog window.
  • The line will be registered. The status of the line will change to Registered.

The registered costs should now be listed on the calculation review page of the selected service item. To check if this is the case, please proceed as follows:

  • Close the page Allocated Costs/Revenues to return to the service item card.
  • Click Item > Calculation Review in the menu bar.
  • The calculation review for the selected item will be displayed.
  • Navigate to the Details tab.
  • The registered costs will be listed here. The place where the costs will be shown depends on the type of cost you have registered. For example, if you have registered costs of the type Additional Costs, the amount will be shown under Costs/Discounts in the Additional Costs field.
  • Click on the number to open the drilldown menu for the value.
  • The registered costs will be displayed in the Allocated Costs/Revenues tab.

You have successfully added and registered costs for the calculation review.

Approving Calculation Review

To approve the calculation review, please proceed as follows:

  • Use the quick search (ALT+Q) to find the page Service Items.
  • Open the service item card for the item that you would like to approve the calculation review for.
  • Click Item > Calculation Review in the menu bar.
  • The calculation review for the selected item is displayed.
  • In the menu bar, click on Approve.

The calculation review has been approved. Now, you can view the approved calculation sums via the Approval Log action in the menu bar.

Note

You can also access the calculation review of a service item via the Calc. Review List. Use the quick search (ALT+Q) to find said page and then click on Calculation Review.

Exporting Calculation Review

You have the option of exporting the calculation review as an Excel file. Please proceed as follows:

  • Use the quick search (ALT+Q) to find the page Service Items.
  • A list containing all service items is displayed.
  • Open a service item card.
  • Click Item > Calculation Review in the menu bar.
  • The calculation review for the selected item will be displayed.
  • Click on Approval Log in the menu bar.
  • The page Approved Calc. Review Sums is displayed.
  • Click on Export Calculation Review in the menu bar.
  • An Excel file with the calculation review is downloaded to your computer.

You have successfully downloaded the calculation review.