Job Costing in Microsoft Dynamics NAV 2016

The Job Costing module provides a flexible and efficient way for managing projects in Microsoft Dynamics NAV 2016. It provides a comprehensive picture of job profitability and progress.

The budgeting and costing feature ensures efficient management of item consumption, time usage (timesheet) and general costs; as well as resource allocation against jobs.  The invoicing feature allows customer invoicing against jobs based on time and materials or at job completion. And the Work in Progress (WIP) feature allows accurate cost reflection at GL on job progress.

In this blog, I will take you through some of the key features of the Job Costing module in Microsoft Dynamics NAV.

Setups
1. Job Card
The job card needs to be created first. You need to define the bill to customer, WIP method, posting groups etc. just naming the few key fields.

Job costing in Microsoft Dynamics NAV 2016 im1

2. Job Task.
At least one task needs to be defined for the job. It is a mandatory field. This is essentially different phases of the project.

Job costing in Microsoft Dynamics NAV 2016 im2

 

3. Job Planning Lines
Here you specify the resources, items, and general ledger expenses associated with a job task. The jobs budget and invoicing details are specified on this table. This is differentiated by line type tags.
– Schedule: Provides estimated usage and costs for the job. Planning lines of this type cannot be invoiced.
– Contract: Provides estimated invoicing to the customer, typically in a fixed price contract.
– Both Schedule and Contract: Provides scheduled usage equal to what you want to invoice.

Job costing in Microsoft Dynamics NAV 2016 im3

 

4. Job prices
Here you define the agreed/contract prices for the job against the resource, items and GL. The set prices (as well as the costs) defaults on job (g/l) journal and invoices, maintaining data entry integrity for accurate costing.

Job costing in Microsoft Dynamics NAV 2016 im4

 

Process
1. Record Usage
You can record the usage from the job planning line page using the ‘Create Job Journal Line’ function. The planning lines will get automatically updated with the usage details; showing quantity transferred and quantity remaining to be transferred.  Usage can also be posted straight away using a job journal or job g/l journal.

Job costing in Microsoft Dynamics NAV 2016 im5

 

Usage details can also flow in from timesheet lines entered against jobs.

2. Invoicing
You can invoice the customer from job task page using the ‘Create Sales Invoice’ function.
After executing this function, you will need to open the created sales invoice and post it.

Job costing in Microsoft Dynamics NAV 2016 im6

 

3. Work in process (WIP)
You can track the work in progress at gl level throughout the project life. You can create a Job WIP method that reflects the needs of your organization. After you have created it, you can set it as the default Job WIP calculation method that will be used in your organisation.

Job costing in Microsoft Dynamics NAV 2016 im7

 

4. Job Completion
Once a job is complete, you can change the status on the job card to complete and then run WIP for the last time to post the completion entries.

Job costing in Microsoft Dynamics NAV 2016 im8

This post was written by Elvin Narain, Microsoft Dynamics NAV Developer/Consultant at EBS.

If you have out-dated business software that’s limited in its reporting and analytical capabilities – then you should to talk to EBS about a powerful business management software solution – Microsoft Dynamics NAV. To find out more about Microsoft Dynamics NAV and other Microsoft business management software solutions, please call Dick Preiss at EBS for an obligation free discussion on 1300 303 973.

Microsoft Dynamics NAV is global enterprise resource planning (ERP) software that helps more than 100,000 companies worldwide manage their accounting and finances, supply chain, and operations. Start with what you need now, and easily adapt as your business needs change. In the Microsoft cloud or on your servers—the choice is yours.

Evolution Business Systems (EBS) is a Microsoft Gold ERP Partner and business management software specialist that equips its clients with software designed to achieve their business goals. EBS offers a complete, fully featured, whole of business system that can meet their needs: Microsoft Dynamics NAV, Microsoft Office 365, Microsoft Dynamics CRM and Microsoft Power BI.  It’s available for deployment on Microsoft’s own Cloud servers – Azure – and packaged at an affordable monthly subscription price. EBS works alongside its clients to understand their business and vision, and offer solutions to support these both now and into the future.

Subscribe here to get our free EBS monthly enewsletter to get valuable blog articles from EBS and the latest updates on the Microsoft Dynamics product suite.

 

One Response to “Job Costing in Microsoft Dynamics NAV 2016”