Posting Groups #22 – Item Purchase for Job

08/06/2015 atotovic Microsoft Dynamics NAV course, GL, Job Task, Jobs, learn, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Posting Group, purchase, Tips & Tricks, usage

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:

Posting Groups #15 – FA Purchase Posting

22/05/2015 atotovic Microsoft Dynamics NAV Acquisition, course, entries, FA, Fixed Asset, GL, learn, Maintenance, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Posting Group, purchase

In my first post about posting groups, I show you what results are when you post item purchase. I also show how looks like when we post Item Charge purchase. Now, in this post, I will describe some difference when you want to purchase Fixed Asset. Generally, it is a similar process, but it still has some difference. Some posting groups will not be used, but we also have one new posting groups – FA Posting Group. On this setup, we can configure all accounts in relation with fixed assets processes.

Process of using all posting groups in FA purchase process is shown on following flowchart:

Depending on the FA Posting Type on Purchase Line, we can get two different results. If we want to buy new fixed asset, we will choose Acquisition Cost type and we will get following G/L entries:

But, we can also choose Maintenance FA Posting Type to post maintenance for some existing fixed asset. In this situation, we will get following G/L entries:

In previous example, I didn’t use discounts, because I have already showed it when I described item purchase. In this case, everything is the same.

Posting Groups #10 – Item Returns Posting (Sale & Purchase)

10/05/2015 atotovic Microsoft Dynamics NAV adjust, chart, course, inventory, learn, mic, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, opossite, Posting Group, purchase, return, Sales, Tips & Tricks

In my earl posts about posting groups, I have showed purchase and sales processes. But both of these processes have its opposite processes.

If our customer wants to return items to us, we can use the Sales Return Order for this. When we finish posting, we will get Return Receipt and Sales Credit Memo as result.

On other side, if we want to return items to our vendor, we can use the Purchase Return Order for this. As result of posting, we will get Return Shipment and Purchase Credit Memo.

I will not prepare flow chart about using posting groups, because we can use the same schemas as we already have in Item Sale Posting and Item Purchase Posting posts.

First, I will describe sales return process. When we post Return Receipt, we will get only these G/L Entries:

But, when we finish posting and post Sales Credit Memo, we will get more G/L Entries:

The similar situation is in purchase return process. When we post Return Shipment, we will get again only these G/L Entries:

But, when we post Purchase Credit Memo for this item, we will get more G/L Entries:

And, on the end when we run Adjust Cost – Item Entries batch job, we will get the following G/L Entries (variance between expected and actual cost):

Posting Groups #1 – Item Purchase Posting

25/04/201504/05/2015 atotovic Microsoft Dynamics NAV chart, course, inventory, learn, Microsoft Dynamics NAV, NAV, Posting Group, purchase

When we want to post item purchase, we can do it in one step (posting receipt and invoice in the same time) or in two steps (posting receipt in the first step, and then posting invoice). In my example, I have used second example. In my example, I also use line and invoice discounts, for better example.

But, in any case, we have some rules about posting groups. Some posting groups are used from document header, and other from document line. In following chart, you can see how system uses posting groups on documents.

When we finish posting of receipt, we will get only two entries in G/L Ledger. These are only entries about inventory:

When we post invoice related with posted receipt, we will get more entries in G/L Entries. You can find completely description of them in next table: