Project Madeira and Power BI

If you have demo Project “Madeira”, you can also try to use Project “Madeira” automated Power BI. You need to use the same credentials and log to powerbi.com

Then, you need to run Services and choose Project “Madeira” package:

PowerBiMadeira1.jpg

Choose “Connect” and put your OData Feed URL. You can find this URL in your Project “Madeira”. You need to find Web Services page using search and copy OData URL until your company name, as the following model:  https://[navserver]/[instance]/OData/Company(‘Sample%20Company’).

Wait some time and type your credentials, using the basic authentication method. You need to use your O365 username, but as your password, you need to use your “Web Service Access Key”. To create your “Web Service Access Key”, go to the your User card in Project “Madeira” and use “Change Web Service Key” command to generate your “Web Service Access Key”.

PowerBiMadeira2.jpg

After that, you need to continue with logging to your PowerBI. You don’t need to take care about certificates and similar; everything is already prepared. When you finish, you will get page similar as my. Then, you can check and try to make it funny…

PowerBiMadeira3.jpg

Pretty easy. Enjoy.

Advertisement

Project Madeira – The Final Configuation

In few previous articles, I’ve already wrote about configuration of our new product “Project Madeira”. Now I want to finish with configuration.

I’ll continue with Office Add-Ins set up. When we start wizard, first we can choose to set up only our mailbox or completely organization. Then, system will ask us to fill our exchange online credentials (email and password). If we choose My organization, then we have to have an administration rights.

Madeira1.jpg

After that, we just need to click on Finish and everything is finished. Then, I’ll continue with setting up approval workflow. After reading of small manual, we can chose to activate Purchase Invoice Approval or Sales Invoice Approval; or both of them. We need to choose approver person and amount limits.

Madeira2.jpg

After that, just click Next > Next and Finish. Very easy (of course, if you know and understand what you actually want to configure and use). And finally, we can configure email logging. We can set up Exchange public folders and rules, so that system processes incoming and outgoing emails to create Interactions. Just fill your Exchange Online administrator credentials. After we finished with this, system will create a few public folders:

Madeira3.jpg

After that, system will ask to create and activate incoming and outgoing email rules.

Nothing else. Your “Project Madeira” is configured. Of course, we can do some additional work, but about this in some other articles.

Project Madeira – Tax and Email Setup

OK, in previous mails, we’ve already made the basic configuration and data migration, but now we need to continue with “Madeira” setup. The next step is Sales Tax Setup.

When we start wizard, the tax group of TAXABLE is created. Then, we need to add sales and purchase tax accounts:

ProMad11.jpg

After that, we need to set up city tax rate, county tax rate and state tax rate. And, finally we need to choose for whom we want to add these tax areas.

You can notice, I speak only about taxes and not about VAT. This is because this “Preview” is only for US area.

After we configure taxes, we will continue with email configuration. We can choose between O365 or some other providers. If we choose O365 option, we just need to fill our User ID and password. But if we choose other, we need to fill more details: Authentication, SMTP Server and SMTP Port and of course, our credentials:

ProdMadeira12.jpg

After we configured this, we can send test email from the wizard. And this will be all about configuration of tax and email. Very easy, right?

Project Madeira – Data Migration

As you already used wizard to make some primary configuration, you can continue with using of few another wizards to finish complete setup of your company. You can find a small Assisted Setup to see what you need to finish.

ProMadS1.jpg

When you open a Migrate Business Data, you will continue with the wizard. And first, you can see what extensions you already have. Yes, you hear fine; you can use different extensions as apps. By default, you have three of them: Envestnet Yodlee Bank Feeds, PayPal Payments Standard and QuickBooks Data Migration (just click on Open Extension Management and you will see). It looks fine:

ProMadS2.jpg

Then, you can choose to import from Excel or from QuickBooks (because you have an extension). Than, you can download all templates and fill them. When you fill them, you need to configure Settings to set default templates and import this Excel file after that.

ProMadS3.jpg

You will see the numbers of your main data (Customers, Vendors and Items) and if this is correct, just apply them. If you have errors, you can see them with all details. On the end, you need to finish process and import is completed.

It is easy, but I think it will not be possible to be finished without some support from partners. Client without standard NAV knowledge will not be in situation to import and configure everything they need. This is still job for partners.

Project Madeira – Configuration

When you open “Project Madeira” for the first time, you will get access to the Cronus demo company with a Business Manager role center. Of course, you can this change role center, but you have not all role centers as you can find in standard Dynamics NAV solution. There are “only” five role centers:ProMadeiraRCs.jpg

But for this kind of software, it is more then enough. It is really everything what you actually need. Of course, you can create your really company. When you open My Setting, you can find how to change companies. You can choose Cronus as you actually use and “My Company”. When you choose “My Company”, you need to log-out and log-in, and you will get the wizard for company configuration. When you click “Next”, you will see the standard configuration questions. These questions are very simply and everybody can finish this questionnaire (the basic company data, bank data, accounting period… and that’s it):

ProMadeiraQues.jpg

You will get your production environment for your company. This wizard is simply and excellent and the most important, on this way you’ve just got your company in SaaS. You can continue your work.

This is just small intro about configuration. You can expect more soon.

April 2016 CU’s for Dynamics NAV

Few days ago, Microsoft has been published new Cumulative Updates for Microsoft Dynamics NAV 2016, 2015, 2013R2 and 2013. This time, there were only few platform hotfixes (four for NAV 2016 and two per all other versions). They also include some application hotfixes and regulatory features that have been released for these NAV versions:

  • NAV 2016 – Cumulative Update 6 (Build 45480)
  • NAV 2015 – Cumulative Update 18 (Build 45483)
  • NAV 2013R2 – Cumulative Update 30 (Build 45478)
  • NAV 2013 – Cumulative Update 37 (Build 45477)

update-1170x630

You can check all hotfixes and download these cumulative updates on the following links:

NAVUG European Congress

This year, we will have NAVUG Congress in Europe for the first time. This congress is the amazing idea and it is intended for NAV users. Stuttgart in Germany will be a host of this conference. The conference is scheduled at the beginning of May (9-10 May).

Stuttgart.jpg

It will be the great opportunity to meet your colleagues all around the Europe and a lot of really good experts as well. Lot of them will be speakers and I hope you will learn something new. Unfortunately, I’ll not be on this conference because of other obligations, but I hope I’ll be there next year.

What about FEFO and Costing

After my the last article, I’ve got comments about FEFO. First, thanks for reading my blog :), and then yes, it deserves to write a few sentences about it, because it is very useful feature in NAV.

But first, what actually FEFO means? It is First-Expired-First-Out method. What is the first we have to notice about it? FEFO is a picking method, but it is not a costing method. This method is important for a lot of very specific industries (pharmacy, food…), but it is just one specific way how to configure your location.

FEFO.jpg

If you want to use FEFO, your items have to have configured a serial or/and lot numbers. In additional on each item tracking code setup, the SN-Specific Warehouse Tracking field or the Lot-Specific Warehouse Tracking field must be selected. And now, we can conclude that FEFO actually uses Specific Costing Method. It is FEFO, but it is nothing more then Specific method. Everything is the same as in all other Specific Method types, but when you select FEFO on your location, system will take care about picking order using expiration date.

SpecificFEFO.jpg

You can find more about FEFO on MSDN here or in Mark Brummel Application Design book.

Calculating COGS in NAV

Generally COGS (Cost of Goods Sold) is an unknown parameter that must be recorded and calculated. We have (or we can have) exactly information about Beginning Inventory and Net Purchases, but COGS depends of Costing Method:

cogs.jpg

This is because it is connected with fluctuations over time in the unit acquisition costs of inventory items. COGS will be an unknown value until we choose costing method for each item.

The choice of a costing method has two consequences. It determines which purchase entries and sales entries will be applied to each other when you post a document. This is the application method part of the costing method and I’ve already wrote about it. It also influences the unit cost calculation, which is itself used for posting to the general ledger. This is the cost flow assumption part of the costing method. I’ve already wrote basically about costing methods in Microsoft Dynamics NAV.

And do not forget, regardless of what costing type you use, all of them have minimum one common thing. When the quantity on inventory is zero, the inventory value must also be zero.

Now I want to give you some examples how system uses different costing methods.

1-FIFO.jpg

When we use FIFO method, system will post quantity decreasing every time based on the first input. If we use LIFO method, situation is totally opposite; quantity decreasing is based on the last input.

1-LIFO.jpg

When we use average costing method, posting of quantity decreasing however, determined by calculating a weighted average of the remaining inventory at the valuation date of the inventory decrease.

1-Average.jpg

In situation when we use standard costing method, system doesn’t use purchase cost from posted invoices. System will use Standard Cost for all inventory postings (increase and decrease).

1-Standard.jpg

And at the end, when we use specific costing method, system is not based on some time order. If we use this costing method, it means we have assumption that individual units of items can be physically identified, typically with serial and/or lot numbers. Every time when we want to post inventory decreasing, we have to choose what exactly inventory unit we want to consume/sale.

1-Specific.jpg

 

Costing in NAV – Inventory Posting

Costing methods usually differ in the way that they value inventory decreases. But, regardless of what costing type you use, all of them have minimum one common thing. When the quantity on inventory is zero, the inventory value must also be zero. The next common thing is way of the posting all incoming and outgoing entries. This posting results entries as quantity and as value. Quantity posting describes the change in quantity on inventory and this transaction is stored in Item Ledger Entries. Value posting describes the change in inventory value and this transaction is stored in Value Entries. Each entry in Value Entries table is linked with entry in the Item Ledger Entries table. More entries in the Value Entries table can be applied with the same entry in the Item Ledger Entry.

Each Item ledger entry is applied against each other. All these applications between incoming and outgoing quantities in the Item Ledger Entries are stored in the Item Application Entry table as links between inventory increase and inventory decrease in an Item Ledger Entry. NAV records the entry number of the Item Ledger Entry corresponding to the inventory increase in the Inbound Item Entry No. field and the entry number of the Item Ledger Entry corresponding to the inventory decrease in the Outbound Item Entry No. field. The program also reduces the Remaining Quantity fields in the corresponding item ledger entries by the applied quantity.

Based on the Inventory Posting Setup, system will post all these entries to the General Ledger Entries.

InventoryPosting.jpg