Dynamics ERP and CRM Continue Together

I didn’t write a blog for a while, but these few days I’m on eXtreme 365 conference and I decided to share some observation. For some time, since there is a Dynamics 365 product family, we created a closer collaboration between ERP and CRM products. Generally, it was mostly based on technology.

But now, I see the next steps. First, more and more ERP partners try to learn more about CRM and the same situation is with CRM partners and ERP knowledge. Now, I’m at eXtreme 365 conference that was originally CRM conference, but from this year this is not only CRM conference. We have a lot of sessions about D365 for Financials, D365 for Operations, Common Data Service, PowerApps, Flow… And as I see, there are some NAV partners (and MVP’s as well J). Also, I saw announcement for Directions this year and there is a same situation, this will not be only NAV event and we will have CRM sessions as well.

IMG_1849

This is very important, because all of use started with thinking that we need to continue with both products together. And this is a huge opportunity for partners. This is opportunity for upselling and if they know both products they will be better on a market.

And about a conference. Great conference and great opportunity for networking. This is the first time I’m on some big conference that was not originally NAV conference and this is the great opportunity to see some new people, sometimes with different attitude. I also met some friends from a NAV world here and I can say this is a great mixture. I’m expecting something similar on Directions as well.

OK, in some next posts I’ll write more about some news with these products, but for sure we can expect more and more news in this world in next few months.

Advertisements

Posting Groups #27 – Deferrals in Sales

Few days ago I’ve published how you can use Posting Groups in Microsoft Dynamics NAV 2016 when you have purchase where you use Deferrals. Now, I want to show you how it looks like when you use Deferrals in sales process. In my old post, you can find everything about using Posting Groups in standard sales process. Now, I’ll show difference. One of the main difference is that system doesn’t use inventory posting groups when posts sales invoice (the same as in purchase scenario).

In the following chart, you can understand how system uses Posting Groups when we have deferrals on Sales document:

SalDefChart.jpg

When we post document and get Posted Sales Invoice, we will get the following G/L Entries. You can find completely description of them in the next table:

SalDefEntries.jpg

When you use Items and Resources, system will use Sales Account from General Posting Setup, but if you use G/L Account in the sales line, system will use this G/L Account you typed.

You can notice that we have more line amounts. Number of lines is based on number of period defined in Deferral Template. For each period, we have two lines (positive and negative). We have always first period lines, but other period lines are behind all entries, because they have not the same posting date. Their posting date is based on setup in Deferral Template.

And I’ve forgot one things in the last post. If you want to see all lines using Navigate, you have to delete Posting Date in Navigate page or if you didn’t it, you have to delete Posting Date from filters in General Ledger Entry.

Sales Quote in NAV from Outlook “after NAV 2016”

Few days ago during the WPC in Orlando, Microsoft has showed one of great news after NAV 2016. You can use NAV directly from Outlook in Office 365 with new NAV Mail Add-in. With this add-in, you will have your NAV pages and data in your mail.

Using this feature you can save your time because you will not have to change pages between your NAV and Office 365 and finding related data; you can finish all your sales process only in Outlook but using NAV data in background. Outlook can easy recognize your Outlook contacts and quickly prepare sales quote or invoice for example. We will still wait more about this great new feature, but now it look like awesome. Cannot wait Next+1 🙂 …

mpnav_nav_outlook

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.

Posting Groups #18 – FA Sales Posting

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.

FA_Sale_FwC

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:

FA_Sale_G

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

FA_Sale_L

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 #13 – Finance Charge and Reminders

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.

FWC_FinChargeMemo

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

FinChargeMemo

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.

FWC_Reminders

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

Reminders

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

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:

##1

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

##2

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

##3

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

##4

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):

##5