Project
Project built-in reporting and monitoring in Business Central: Project Reports and the Report Explorer, work-in-process (WIP) calculation and posting to the general ledger, and recording consumption or usage of project resources and items. It answers questions about analyzing project activity, valuing ongoing projects, and logging usage.
Path: Analytics, business intelligence, and reporting > Built-in reports > Project · tier official · system projects · narrative reviewed (checked by Opus)
Overview
This section covers how project professionals analyze and monitor projects in Business Central. Project Reports offers reporting tools for reviewing current and past project activity and project management analytics. Its listed features include the Report Explorer.\n\nThe WIP page explains how to estimate the financial value of ongoing projects in the general ledger. You define a WIP method, calculate WIP, post it to G/L, and track the results in WIP fields on the Project Card. The page also touches on project task grouping and completion entries. The consumption page covers how usage of resources and items is recorded through project journals and planning lines, including creating inventory and warehouse picks.\n\nStart with Project Reports for an overview of the available reporting. Then go to the WIP page for financial valuation, or the consumption and usage page for how actual usage reaches the project.
Key points
- Project Reports gives project professionals tools to analyze current and past project activity and project management analytics.
- Project Reports features include the Report Explorer and project analytics.
- WIP estimates the financial value of ongoing projects in the general ledger.
- WIP methods listed: cost value, sales value, recognizable cost, percentage of completion, and completed contract.
- WIP is calculated, posted to G/L, and monitored through WIP fields on the Project Card.
- Consumption and usage of resources and items is recorded through project journals and project planning lines.
- Usage-related features include Apply Usage Link by Default, Qty. To Transfer to Journal, Create Project Journal Lines, and budget and billable lines.
- Inventory and warehouse picks can be created for project items.
Learn pages
- Monitor project progress and performance: Describes how you can create a work in process (WIP) method and calculate WIP to estimate the financial value of projects while they’re ongoing.
- Project Reports: See which project reports are available in the standard version of Business Central so that you can keep track of your business.
- Record Consumption or Usage of Project Resources and Items: This article describes how to record the consumption or use of items or resources for projects in project management.
Business Central pages and reports
The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.
- Page 89 “Job List” · captioned “Projects” · on Table 167 “Job”
- Page 92 “Job Ledger Entries” · captioned “Project Ledger Entries” · on Table 169 “Job Ledger Entry”
- Page 1010 “Job WIP Methods” · captioned “Project WIP Methods” · on Table 1006 “Job WIP Method”
- Report 1006 “Job - Planning Lines” · captioned “Project - Planning Lines”
- Report 1007 “Job - Transaction Detail” · captioned “Project Task - Transaction Detail”
- Report 1008 “Job Analysis” · captioned “Project Analysis”
- Report 1009 “Job Actual To Budget” · captioned “Project Actual To Budget”
- Report 1010 “Job WIP To G/L” · captioned “Project WIP To G/L”
- Report 1011 “Job Suggested Billing” · captioned “Project Suggested Billing”
- Report 1012 “Jobs per Customer” · captioned “Projects per Customer”
- Report 1013 “Items per Job” · captioned “Items per Project”
- Report 1014 “Jobs per Item” · captioned “Projects per Item”
- Report 1015 “Job Register” · captioned “Project Register”
- Report 1016 “Job Quote” · captioned “Project Quote”
- Report 1017 “Job Task Quote” · captioned “Project Task Quote”
- Report 1101 “Resource - List”
- Report 1103 “Resource Register”
- Report 1105 “Resource Statistics”
- Report 1106 “Resource Usage” · captioned “Resource Utilization”
- Report 1107 “Resource - Cost Breakdown”
Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.