Posting Groups #22 – Item Purchase for Job

If you want to purchase items directly for some Job, you can do it using e.g. Purchase Order and posting it. Flowchart of posting groups usage is the same as in post I already wrote about item purchase posting. There is only one additional step in comparison with standard item purchasing; you have to choose Job No. and Job Task No. in each line on Purchase Order.

This is not currently real example of Job Posting Groups using, but it still has some specifics when you have purchasing for Job. When you post this document, you will get both of posting documents – Purchase Receipt and Purchase Invoice, as well. But when you look in Purchase Receipt, you will see that you have two Item Ledger Entries for each line in document. One of them is Purchase, but second in Negative Adjmt. with the same quantity. It actually means that in the same posting process, system post item purchase (as usually) and item consumption for Job purpose. This posting also creates one Job Ledger Entry for each line in document with Usage Entry Type for each Negative Adjmt. line in ILE.

When you look at G/L Entries, you will see the following result of this posting:

ItemPurchJob

Advertisements

Using Jobs and Resources in NAV

In 2013, I was wrote series about using Jobs in Microsoft Dynamics NAV. Reason for this was that Microsoft have added several enhancements to jobs and project management features.

One of them was improvement of using work in process (WIP) to make monitoring this process easier and to improve the interaction with financial reporting. From Microsoft Dynamics NAV 2013, we have got the following enhancements:

  • You can create and define a job WIP method, to supplement the five system-defined choices.
  • Jobs setup has been expanded to include options to control the treatment of WIP in all jobs. For example, you can specify that a WIP method that you have defined be the default for your organization.
  • Users can now track and perform WIP calculations in a new location. From here, you can calculate and post WIP to the general ledger and show any warnings if there are problems with a WIP calculation. For more information, see Job WIP Cockpit on my previous blog post.

Because, I already posted about that, I makes compilation of these posts and put them on one place, because this can be very useful in following posts about using of Job Posting Groups. This will not be a manual for using of Jobs module, but it can be helpful in some areas.

Job WIP Cockpit

As the most of projects are jobs performing usually several months (or several years), WIP calculation is very important part of Job Management. Now, we have new functionality for WIP calculation in Jobs – the WIP cockpit.

The WIP cockpit provides a complete overview of costs, revenues, and profits generated by the project in particular period. In a single place, we can see the amounts that will be posted to company ledgers, and see how these amounts were calculated, with details of the underlying transactions that caused them just another click away. In addition, the WIP cockpit displays WIP warnings, which enable users to see if the underlying collected data is in line with what is defined by the WIP method and if all prerequisites for recognizing costs and revenues are met before posting WIP to a company’s balance sheet.

The Job WIP Cockpit is the central location to track WIP for all of your projects. Each line contains information about a job, including calculated and posted WIP.

How WIP cockpit work?

You can find WIP cockpit page on Jobs->Tasks->Job WIP Cockpit.

The window has two parts, and supports easy access to the typical tasks and routines needed to ensure that WIP compliance stays on track. In the upper part of the window, for any job listed, you can select it and perform the following actions:

  • Calculate WIP: On the Home tab, in the Process group, choose Calculate WIP. The results are displayed in the Job WIP Totals section of the window.
  • Post WIP to G/L: On the Home tab, in the Process group, choose Post WIP to G/L. Job WIP totals are posted to the general ledger.
  • Show Warnings: On the Home tab, choose Show Warnings to see the Job WIP Warnings list. From there, you can see the warning message, and make any adjustments that are necessary, if the WIP Warnings field is set to Yes.
  • Entries: On the Analyze tab, you can review WIP entries and WIP general ledger entries, if there are any, as well as job ledger entries associated with the job.

In the lower part of the window, you can see details about calculated WIP for an individual job and use the information provided there to analyze your results.

Calculate WIP

It is necessary to position on required job on top part of window. After that you need to start function “Calculate WIP…”. NAV will make calculation and fill lines based on Job Tasks on bottom part of window, related with top job line. You can see calculated WIP values at bottom part of window.

If you made mistake, you can delete this WIP entries by starting function “Delete WIP Entries”. This function will delete bottom line related with required job line on top part of window.

If system find some problem, NAV will marked with Yes field “WIP Warnings”. You can open page from this field with warning comments.

Post WIP to G/L

If you want to post calculated WIP values to G/L Entry, you need do start function “Post WIP to G/L…”. System will post all WIP entries to G/L entries and move value from “Recog. Costs Amount” field to “Recog. Costs G/L Amount” field on top part windows, as delete WIP entries in bottom lines. You can see all transaction using report “Job WIP To G/L”. Also, you can analyze G/L entries using function “WIP G/L Entries” and using Navigate from that table.

Creating Jobs

I do not want to describe complete process of creating new Job. If you need it, you can find complete manual here. But I want to emphasize few things:

It is important to choose Job Posting Group on the Posting tab. Job posting groups determine which G/L Accounts we post to. The Job Posting Group that you set up on the Job Card will be used as default Job Posting Group on the Job Tasks, but you can change this posting group on each Job Task.

It is also important to set WIP Posting Method. It indicates whether ‘WIP Posting Method’ is per job or per job ledger entry. When we select ‘Per Job’, NAV uses total WIP costs and sales to calculate WIP. When we select ‘Per Job Ledger Entry’, NAV uses the accumulated values for WIP costs and sales. The default value is Per Job:

  • Per Job: Default. If there have been no general ledger or WIP entries, you can modify this field. You can also modify this field if all existing entries are reversed.
  • Per Job Ledger Entry: WIP is posted per job ledger entry. This option can be selected only if there are no existing WIP entries or WIP G/L entries, or if all WIP G/L entries have been reversed.

And finally, we have to set WIP Method. It contains the name of the work in process (WIP) calculation method that is associated with a job. Work in process (WIP) is used to match expenses with revenues. Microsoft Dynamics NAV supports multiple ways to calculate WIP and recognition of sales and costs (see the Job WIP Methods).

We should create a new Job WIP methods that reflects the needs of our company. After we have created it, we can set it as the default Job WIP calculation method that will be used in our company.

NAV supports multiple ways to calculate WIP and recognition of sales and costs:

  • Completed Contract: No sales or costs are part of the calculation.
  • Cost of Sales: Recognizes WIP when the customer is invoiced.
  • Cost Value: Recognizes WIP when the customer is invoiced.
  • Percentage of Completion: Recognizes costs as they are reported.
  • Sales Value: Recognizes costs as they are reported.

In addition, it is possible to create our own formula for calculating the WIP associated with a job, but not now about this.

Create a code for the method, add a description, and then select the appropriate values for the ‘Recognized Costs’ and ‘Recognized Sales’ fields. By design, the ‘System Defined’ check box is not selected, but three others are selected. There are next fields:

  • WIP Cost: For this field, the following applies: Cost Amount (WIP) = Usage (Total Cost) – Recognized Cost. For system defined WIP methods, the ‘WIP Cost’ field is the default and is checked. For WIP methods that we create, we can only clear the check box if we set ‘Recognized Costs’ to ‘Usage (Total Cost)’. When we do this, ‘Job Costs Applied’ and ‘Recognized Costs’ are not posted to the General Ledger.
  • WIP Sales: For this field, the following applies: Sales Amount (WIP) = Contract (Invoiced Price) – Recognized Sales. For system-defined WIP methods, the ‘WIP Sales’ field is the default and is checked. For WIP methods that we create, we can only clear the check box if we set ‘Recognized Sales’ to ‘Contract (Invoiced Price)’. When we do this, the contract (invoiced price) is not posted to the general ledger.
  • Valid: Indicates whether a WIP method can be associated with a job when we are creating or modifying a job. If we select this check box in the Job WIP Methods window, we can then set the method as a default WIP method in the Jobs Setup window. Once set, we cannot clear this check box if the WIP method has been specified as the default WIP Method in the Jobs Setup Window.
  • System Defined: Indicates whether a Job WIP Method is system-defined. We cannot change the contents of this field.

I think, it is enough to understand following posts about usage of Job Posting Groups… maybe more than you really need, but… If you still need more, you can find it here. More about Job planning and similar topics, you can find here.

Posting Groups #21 – FA Disposal Posting

When you want to post disposal of Fixed Assets, you can do it using FA G/L Journals. You must choose Disposal as FA Posting Type. In my examples, I post this journals with marked Depr. until FA Posting Date field.

You can get two different types of G/L entries, depends of setup in Depreciation Book. You can choose Net or Gross method on Disposal Calculation Method field.

In my first example, I have used net method. In this example I used FA with already posted some depreciation and write-down entries.

FA Disp Nm

In my second example, I have used gross method. In this example I used FA with already posted some depreciation and appreciation entries (entries can be different, depends your FA has had appreciation or write-down).

FA Disp Gm

All of these posting results depend only of FA Posting Type.

Posting Groups #20 – FA Write-Down and Appreciation

When you want to change Fixed Asset value, you can do it on few ways. In this post, I will show you how you can do it using Write-Down and Appreciation in what will be results of these postings in G/L entry, based on posting groups you use.

Both of these posting types, you can do using FA G/L Journals. Posting depends on FA Posting Type.

In my first example, I will use Write-Down FA Posting Type. If we do not mark Depr. until FA Posting Date field, the result will be as following:

FA WD 1

But, if we mark this field, result will with some difference (system will post depreciation in the same register):

FA WD 2

In my second example, I will use Appreciation FA Posting Type. Again, in my first posting I will not mark Depr. until FA Posting Date field and result will be as following:

FA App 1

If we however mark Depr. until FA Posting Date field, the result will be as following:

FA App 2

But, we have common fact with all of these examples. In all of them, system only uses FA Posting Groups and manually configured Balance Account No.

Easy Deployment of the Latest NAV 2015 Version

Today, Microsoft has published new article about easy deployment of the latest version of Microsoft Dynamics NAV on their blog. It is important to know that Microsoft always publishes the latest cumulative update (currently it is NAV 2015 with cumulative update 7). You can use this image to test the newest NAV 2015 version or to use as efficiency demo environment on Microsoft Azure.

I have also wrote about this image in my older posts and I can remind you about them:

I will prepare few more articles about this image, very soon.

Posting Groups #19 – FA Sales Credit Memo Posting

It is usual to have possibility to post Credit Memo for any item you sold. You can also make Credit Memo for Fixed Assets you sold. Generally, you can use the same flowchart about using of posting groups, as I published for FA Sales Posting.

But G/L entries will not be the same (with opposite sign) as you got in FA sales posting process. You will get the following G/L entries:

FA_Sales_CrMem

Entries are a bit different in comparison with posted invoice. Entries in FA Ledger Entries also will be the different. You will get only Gain/Loss FA Posting Type entries in FA Ledger Entries with Credit Memo Document Type. That means, you must create additional Acquisition and Depreciation entries manually, if you want to have Fixed Asset again in your system.