Time and Cost Tracking

Get an overview of posted consumption on Work Orders

Introduction

You can get an overview of posted Work Order consumption registrations (Items, Resources, Expenses) in Ledger journals. You can also track costs on individual Assets and Work Orders and create consumption reports.

Prerequisites

Consumption registrations have been created and posted on Work Orders.

Audience
Maintenance Manager

Work Order Ledger Entries

On your role center, select Work Orders > Work Order Ledger Entries to see a list of all consumption registrations on open and closed Work Orders.

Select a registration line and select Process > Show Document to see the related Work Order.

Select a registration line and select Process > Connected Ledger Entry to see details based on the registration type:

  • Item registration opens the Item Ledger Entries list
  • Resource registration opens the Resource Ledger Entries list
  • Expense registration opens the Expense Ledger Entries list

In Work Order Ledger Entries, you can get an overview of the dimensions related to a ledger entry, and you can create dimension filters to see a list of ledger entries using the same dimensions. Refer to the Dimensions section to learn more.

Consumption Report on Work Orders

From the Work Order Ledger Entries list, you can create Work Order Consumption Reports for financial reporting regarding Asset and Work Order registrations and related costs.

You can create reports showing all consumption registrations and costs, or you can create reports for specific consumption types: Resource, Item, Expense.

Use the Send to... button in the report dialog if you want to select a specific output for your report. Available file types:

  • PDF Document
  • Microsoft Word Document
  • Microsoft Excel Document
  • Schedule

Use the "Schedule" output type to set up automatic update of a Work Order Consumption Report, for example, on a daily or weekly basis.

  • When you have created a scheduled report (described in a test case below), you find the report in the Report Inbox, which is standard D365BC functionality.
  • For information on the general setup and use of reports in D365BC, refer to Microsoft documentation: Reports Overview - Business Central | Microsoft Docs.

To delete a report schedule that is no longer required

  1. Search for and select "Job Queue Entries".
  2. Select the entry with the following data: Object ID to Run "70479540", and Object Caption to Run "Consumption on Work Orders".
  3. Select Delete and confirm deletion.

Refer to the Test Cases below for step-by-step procedures on how to

  • Create a Work Order Consumption Report - Excel file
  • Set Up a Schedule for a Work Order Consumption Report

The screenshots below show the setup of a consumption report, and the Excel file generated from that setup. In the example, the report includes registrations and actual costs for four Assets (A000002-A000005).

Example: Setup of a Consumption Report
Example: Setup of a Consumption Report
Example: Report generated from the setup
Example: Report generated from the setup

Create a Work Order Consumption Report - Excel File

Data Requirements

  1. At least one consumption registration is posted on a Work Order.

Steps 7

  1. On your Role Center, select Work Orders > Work Order Ledger Entries, or search for and select Work Order Ledger Entries to open the list.

  2. Select Report > Consumption on Work Orders.

  3. In the Type field, select "All" to generate a report showing all consumption types: Resource, Item, and Expense.

  4. Select the toggle buttons Show Fixed Asset and Show Actual Cost Amount to include that data in the report.

  5. Select the Send to... button.

  6. In the Choose file type pop-up, select "Microsoft Excel Document".

  7. Select OK. The Excel file is downloaded on your device.

Expected

The user can create a report showing all consumption registrations of all types (resource, item, expense) on Work Orders.

Note: If required, you can use filters to generate reports for specific Assets, Work Orders, Work Order Plans, and more.

Set Up a Schedule for a Work Order Consumption Report

Data Requirements

  1. At least one consumption registration is posted on a Work Order.

Steps 15 expand

Expected

The user can create a report schedule for the Work Order Consumption Report, which updates the report for the selected interval, for example, daily or weekly.

The user can find the report in the Report Inbox, which is part of standard D365BC functionality.

Posted Work Orders

On your role center, select Work Orders > Posted Work Orders to see a list of closed Work Orders (and closed Round Orders if you use the Rounds module in EAM-BC).

Select a link on a line to see detailed information. For example, select the link in the No. field to open the Posted Work Order card or Posted Round Order card, or select the link in the Asset No. field to open the Asset Card.

Select a Work Order and select History > Ledger Entries to see the consumption registration for the Work Order.

On an Asset Card, select History > Posted Work Orders to see the list of closed Work Orders related to the Asset.

Copyright Dynaway A/S