78 - Posting Groups in Dynamics NAV 2017 - Part 1
Today I wanted to talk about posting groups, we were actually attending the NAV user group last week, and had four speaking sessions, and I highly recommend that you guys attend the NAV user group summit if you get the chance to, It's an excellent venue to learn and see things. And somebody walked up to me and said, hey you haven't done anything about posting groups and that is absolutely true, I have not covered posting groups which is kind of funny because its fairly essential to the system so now I am sitting down here, the first session after the user group and I'm going to dive straight into posting groups.
Posting groups are a huge topic in NAV and so as I do usually I chop things up into like bite-size meals so I’m expecting to have several videos on this one, but I’m going to start out just very simply.
Posting between two accounts
I’m logged in as the accounting manager and if I go into journals here, and go into edit journal, actually I want to go into the general journal right here.
When I’m posting something between two accounts, I can post from GL account to GL account, so let's say for example if I post from sales account here, sales retail; and I think I did this in one video; Let's say -50,000 and the balancing account is in other receivables and now I’m posting from GL to GL it's not going through a customer or anything like that. It's fairly straightforward, this does not include any posting groups, there are no posting groups needed for this, this posting just goes straight through GL to GL.
Posting a sale to a customer
Now if we try to do something different, if I go over here and say, Actually I am going to post a sale, but my balancing account it's not going to be GL account, it's going to be a customer, and I’m going to pick a customer, so lets say I’m going to the cannon group.
Now I know which GL account is going to hit here on the left-hand side, but on the right-hand side which Gl account it's going to hit? It should hit accounts receivables since it's going to a customer, but I’m specifying a customer, I'm not specifying an account receivable account. So let's dive a little bit into what happens when I post something like this.
If I go into the customer 10,000 and I hit advanced and go into edit, now I’m looking at the customer card; which has become very pretty with pictures and everything; and If I go in here into invoicing I can see that the customer posting groups (there are two posting groups: general business posting group and customer posting group) the customer posting group is the one that I'm actually concerned with in this example and the customer posting group is setup as domestic.
If I drill into that and click advanced I can see that the customer posting group domestic is tied to a receivable account 13100 so, when I actually post the transaction I was posting before or setting up before, it will go to 13100 because those are tied together through the posting group and that’s the customer posting group.
So that is how posting groups play a role in giving you sort of an abstraction where you can select the customer instead of selecting the GL account. If I post it like that you can see that it goes straight through. And if I go into the customer list and I look for my customer 10,000, right here, and then I Look at the ledger entries for that, I can see that I posted here sales retail, comes up like that for 50,000 and If I hit navigate which means that I can now take a look at all the GL entries that happened and I drill into that. I can see that it hits 13100 and that was because of the posting group.
So I hope that actually enlightened you on posting groups work, I know it’s the beginning of that, I get much much more complicated as we go into the posting group time and so like I said I intend to create more.