Posting Groups #18 – FA Sales Posting

27/05/201528/05/2015 atotovic Microsoft Dynamics NAV course, depreciation, FA, Fixed Asset, learn, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Posting Group, Sales, Tips & Tricks

If we want to sale our fixed assets, it is a similar process as FA purchasing, but in opposite direction. In this situation, system uses customer posting group, VAT and general posting groups and FA posting groups.

You can see this process concept on following flowchart. One of specifics is how system determines VAT Production Posting Group. You can use it on one of following ways:

Manually choosing VAT Production Posting Group;
Inheriting from manually choosing/changing General Production Posting Group (Def. VAT Prod. Posting Group);
Inheriting from VAT Production Posting Group, configuring on Acq. Cost Acc. On Disposal on FA Posting Group;
Inheriting from General Production Posting Group (Def. VAT Prod. Posting Group), configuring on Acq. Cost Acc. On Disposal on FA Posting Group.

Other specific in FA sales process is that system uses different configuration from FA Posting Group, depending of FA sales price (higher or lower price in comparison with Book Value).

In my first example, you will see what G/L entries you will get when we sale FA with higher price:

In this example, you will see result of FA sales posting with lower price:

On both of these examples, you will see that we have the last additional G/L entry. This entry will exist as Residual caused by rounding of Additional-Currency, but only if you use Additional Currency configured on General Ledger Setup. This entry will be usually a zero amount.

Posting Groups #17 – FA Reclassification Journal Posting

26/05/2015 atotovic Microsoft Dynamics NAV course, depreciation, entries, FA, Fixed Asset, GL, learn, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Posting Group

If we need to transfer, split up or combine our fixed assets, we can do it using the FA reclassification journal. In my following example, I split up my existed FA, but everything is almost the same in other examples. Using the FA reclassification journal, system uses only FA Posting Group for G/L entries allocation.

When you Reclassify your journal, you will get lines in FA G/L Journal. After you post it, you can see this posting result in G/L entries in following table:

Posting Groups #16 – FA Depreciation Posting

25/05/201525/05/2015 atotovic Microsoft Dynamics NAV course, depreciation, entries, FA, Fixed Asset, GL, learn, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Posting Group

Depreciation is a method of allocating the cost of a Fixed Asset over its useful life. In NAV for this purpose, you can run batch job Calculate Depreciation. In this posting process, system will use only FA Posting Groups.

Assuming you checked, ‘Insert Bal. Account’ on Calculate Depreciation batch job, you will get following G/L entries as posting result:

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 Feedback

21/05/201521/05/2015 atotovic Microsoft Dynamics NAV feedback, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Posting Group

I have to share with you one feedback about my Posting Groups series. I have got this mail yesterday from one guy I really appreciate:

“I really appreciate your blog posts about the posting setups. I even took printout of them and posted in our Dynamics Team room wall (Hope you ok with it). It will be really good reading material for our new team members.”

I am really happy if my posts help to someone in his daily work :).

Posting Groups #14 – Payment Discounts

19/05/2015 atotovic Microsoft Dynamics NAV course, customer, discount, Invoice, learn, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Payment, Posting Group, rounding, tolerance

One of features in Microsoft Dynamics NAV is using of payment discount. You can configure conditions of using this functionality on General Ledger Setup. With this configuration, I mean on Appln. Rounding Precision and Payment Tolerance and types of Payment Accounts from Customer Posting Groups. More about this configuration, you can find using Help for these fields.

We can use payment tolerances and discounts in few different situations. You can see how it generally works on following flowchart:

In my first example, I have configured only payment tolerance without discounts. When we post payment some less from original amount on invoice (e.g. 2.395 instead 2.400), we will get following G/L entries:

If our payment is greater than Invoice Amount reduced by discount, we will get following entries. System will post full payment as original invoice amount plus tolerance and discount, as well:

If payment is less than Invoice Amount reduced by discount, we will get following entries. System will post full payment as original invoice amount, discount and tolerance:

Posting Groups #13 – Finance Charge and Reminders

14/05/2015 atotovic Microsoft Dynamics NAV Charge Memo, chart, course, customer, Finance, learn, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Posting Group, Reminders, Sales

When we have overdue sales invoices, we usually can use Reminders and/or Finance Charge Memos. Both of these documents increases debits of our customers. We don’t post these documents, but we issue them. But, these issued documents also can make G/L entries.

On the first flowchart, you can see how system uses posting groups on Finance Charge Memos.

Results of this issued document in G/L entries are as following:

Now, on the second flowchart, you can see how system uses posting groups on Reminder. It uses very similar as on Finance Charge Memos, but fees on Finance Charge Memos lines are based only on Terms, while fees on Reminders can be based on Terms and Levels.

Results of Issued Reminders in G/L entries are as following:

New Cumulative Updates for NAV 2013/2013R2

13/05/2015 atotovic Microsoft Dynamics NAV Application, CU, CU19, CU26, hotfix, Microsoft, Microsoft Dynamics NAV, NAV, NAV2013, NAV2013R2, NAVUG

Five days ago, I published post about new Cumulative Update for NAV 2015. Now, last two days, Microsoft also has published new Cumulative Updates for NAV 2013 (CU26) – Build 40940 and for NAV 2013 R2 (CU19) – Bulid 40941.

Both of them have also platform and application hotfixes and some local application hotfixes.

Posting Groups #12 – Payment Posting

12/05/201512/05/2015 atotovic Microsoft Dynamics NAV bank, course, currency, customer, exchange rate, learn, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Payment, Posting Group, Tips & Tricks, vendor

When we post payments, we usually have payments for customers and from vendors. In the same time, we should have bank account posting as balance accounts. Bank account is not necessary, but it is the best practice.

When we post payments from bank statement, we will get the same G/L entries, regardless we have payment in local currency or in some other. These are entries as following:

If we use non-local currency in payment process, after running Adjust Exchange Rate batch job, we will get the following G/L entries:

In previous example, you could see result if used currency exchange rate was increased. But, if exchange rate was decreased, the posting results in G/L entries would be as following:

All previous results were unrealized exchange rates gains or losses, but when we apply these payments, we will get realized exchange rates as on following table:

All postings, based on difference currency code, use posting groups and accounts as on following flow chart:

Posting Groups #11 – Prepayments Posting

11/05/2015 atotovic Microsoft Dynamics NAV course, Invoice, learn, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Posting Group, Prepayment, Tips & Tricks

Before I start with this post, I want to emphasize once again, in all my examples I use W1 database. I know that prepayments can be quite differently from country to country, but I have used only W1 examples here.

Now, when this is clear, we can continue with examples. First, I will describe purchase prepayment invoice. When we choose to create Prepayment Invoice from Purchase order, system will post document with G/L Account in line (from General Posting Setup) and with following G/L entries:

The similar situation is when we create and post sales prepayment invoice. Then, we will get these G/L entries:

If we want to post Prepayment Credit Memo, in both cases, we will get the same entries, but with opposite signs.

Totovic Dynamics 365 Blog

Month: May 2015