Microsoft Dynamics Business Central
Project Management

Microsoft Dynamics Business Central provides for common project management tasks, such as configuring a job and scheduling a resource, as well as providing the information needed to manage budgets and monitor progress

Microsoft Dynamics Business Central
Project Management

Project Management

In Microsoft Dynamics Business Central, you can perform common project management tasks, such as configuring a job and scheduling a resource, as well as providing the information needed to manage budgets and monitor progress. You can track machine and employee hours on the project by using time sheets. As a project manager, you have a good overview, not only of individual jobs, but also of the allocation of employees, machinery and other resources being used in all projects.

Before you can use Business Central to manage projects, you must set up resources, time sheets, and jobs.

Typical Functions supported:

  • Create jobs, assign job tasks, and prepare job planning lines
  • Allocate resources to jobs and manage resource prices
  • Create a time sheet with integrated job task and planning lines and post time sheet lines to a job journal.
  • Budget for resources to be used in jobs and compare actual item and resource usage to budgeted usage to improve the quality and cost efficiency of future projects.
  • Review and record usage on various parts of your job, which is automatically updated as you modify and transfer information from job planning lines to job journals or job invoices for posting.
  • Purchase supplies for a job, either on purchase orders or invoices, and record item and time usage.
  • Learn about WIP (Work in Process), a feature that ensures correct financial statements and enables you to estimate the financial value of jobs that are ongoing.
  • Post the consumption of materials, resources, and other expenses of job work in process (WIP) to monitor its financial value and to maintain correct financial statements even though you post job expenses before invoicing the job.
  • Record job costs for resource usage, materials, and job-related purchases on an on-going basis and invoice the customer, either when the job is finished or according to an invoicing schedule.
Watch video

How to set up a Job in Microsoft Dynamics Business Central

When you start a new project, you must create a job card with integrated job tasks and job planning lines, structured in two layers.

The first layer consists of job tasks. You must create at least one job task per job because all posting refers to a job task. Having at least one job task in your job enables you to set up job planning lines and to post consumption to the job.

The second layer consists of job planning lines, which specify the detailed use of resources, items and various general ledger expenses.

The layer structure enables you to divide the job into smaller tasks, and therefore use more specific details in budgeting, quotes, and registration. In addition, it gives you insight into how a job is progressing. For example, you can track whether you are meeting designated milestones or if you are on target to meet budget expectations.

Watch video

Working with Dimensions in Microsoft Dynamics Business Central

To make it simpler to perform analysis you can use dimensions. Dimensions are attributes and values that categorise entries so you can track and analyse them. For example, dimensions can indicate the project or department an entry came from.

For example, instead of setting up separate general ledger accounts for each department and project, you can use dimensions. This gives a rich opportunity for analysis, without creating a complicated chart of accounts. For more information, see Business Intelligence.

Another example is to set up a dimension called Department, and use this dimension when you post sales documents. This will let you use business intelligence tools to see which department sold which items. The more dimensions you use, the more detailed reports you can base your business decisions on. For example, a single sales entry can include multiple dimension information, such as:

  • The account the item sale was posted to
  • Where the item was sold
  • Who sold it
  • The kind of customer who bought it

Free Initial Assessment

Book a free initial assessment with us where we understand your business problem and suggest a solution which suits you best and ensures growth for your business.

Book Your Solution Workshop
Request More Information