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: Report generated from the setup