Invoices in Project Madeira via Outlook

Few days ago, I wrote article about working with contacts in Project ‘Madeira’ via Outlook. Now,  want to show something more about integration with Office and Outlook.

What if you get an e-mail with invoice number in mail body? Outlook will underline this number and make link to your actual invoice in NAV if you just click on it. Beautiful.

MadeiraInvoice1.jpg

If invoice with this number doesn’t exist, system will offer you to search document in all your sales and purchase documents. You just need to choose type of documents, and you will get list of your documents as bricks. Impressive.

MadeiraInvoice2.jpg

But what when you find your documents? First, you can continue to work with this document in your mail body or you can choose to open it in new window for a better visibility. And then, you can choose a lot of actions, everything from your e-mail (you don’t need to open your Madeira client during all these actions).

MadeiraInvoice3.jpg

If I choose the first option (Send), system will just make a reply mail with this Invoice in PDF as attachment with the basic details about this invoice in a mail body.

MadeiraInvoice4.jpg

But you can make a different actions as well. Maybe you need to correct this posted document (system will automatically create and post Credit memo and create new document) or you want to create a Credit memo or change your payment service… Everything of this is possible, but only if this contact is connected with your customer.

There are still more possibilities, but in some other article… Currently we can say, Project ‘Madeira’ promises a lot.

New Extensions for Project Madeira

When I run Project ‘Madeira’ for the first time, I found only three extensions there:

  • QuickBooks Data Migration
  • PayPal Payments Standard
  • Envestnet Yodlee Bank Feeds

All of them were created by Microsoft. But now, we can find eight of them (one new from Microsoft and few of them by ChargeLogic and Sana Commerce).

MadeiraExtensions.jpg

It looks nice to see new extensions here from other vendors. I hope we will have a hundreds of them in few months as well.

But I’m afraid about their visibility when we have a hundreds or thousands of them. I use brick view for the best visibility, and yes – search works fine, but I think we have to have some additional tags. Minimum I need is Category tag, because we will have a lot of completely different types of extensions (data migration, notifications, integrations, payment, some specific vertical or horizontal solutions, localisations,…). Also, it will be fine to have Market tab because some of extensions are for global market, but some of them will be only for some specific countries.

I expect to have some kind of rating as well. We will have a lot of similar extensions, and we need something for differentiation. I think these ideas can improve ‘Madeira’ experience. But it look it will be a great product.

Contacts in Project Madeira via Outlook Client

In the last few articles about Project ‘Madeira’, I wanted to show how to configure it and some basics about usage and limitations. Now, I want to show you how we can use Project ‘Madeira’ using our Outlook. First, just to know, to do it we need Exchange Online (I’m using O365).

In this example, I’ve got an e-mail from unknown person. If we use a small icon on the top on e-mail, system will as us what to do with this contact.

MadeiraOut1.jpg

If I choose to add this contact as a contact in my Project ‘Madeira’, I can associate this contact with some of the companies… And everything without leaving my Outlook. If we don’t know how to use some of the fields, we need just to click on this field caption and we will get a small help.

MadeiraOut2.jpg

Now if we want to edit this contact, we can do it using “Edit” button. Or if this is not so comfortable to you, you can choose “Pop Out” button to open this contact in independent window. We also can run some other processes, eg. creating opportunity, creating interaction, checking or creating a quote… or run statistic or send some of the reports (in file format you want).

MadeiraOut3.jpg

If you run e-mail from this person some other time, system will recognize her as a contact. If this contact is not connected with a company, system will offer you this possibility. And everything is a live with your ‘Madeira’ database. You don’t need to leave your Outlook page.

Project Madeira Universal App

If you want to try Project “Madeira” on your devices (phone or tablet for example), you can download this App from App Store or from Windows Store.

When you run them, you will see that system requires Activation Code. This is not the same as you use App for Dynamics NAV (you don’t need to put it URL). You can find this Activation Code if you open “Get The App and Activation Code” page (you can find it using search pane).

MadeiraAC1.jpg

You need to type this Activation Code in your App.

MadeiraAC2.jpg

After that system will require to confirm your email as account with password and just wait few seconds. After that, everything will be fine. I’ve checked it with Windows Tablet and Windows Phone and with iPhone, as well. It looks fine.

Posting Groups in Project Madeira

When you create a new company in Project Madeira, you will get the new Chart of Account by default. This Chart of Account is created in this case by US legislation (this version is only for US); I hope it will contain for all countries as we will have localisations.

The same thing is with all posting groups. We have these posting groups already created from the beginning, and we need to use them in data migration process. Of course, if you need more posting groups, you need to add new and setup them as well. By default, we have limited set of posting groups:

  • Customer/Vendor Posting Groups: DOMESTIC
  • Gen. Business Posting Groups: DOMESTIC
  • Get. Product Posting Groups: NO TAX, RETAIL and SERVICES
  • Bank Account Posting Groups: CASH, CHECKING and SAVINGS
  • Inventory Posting Groups: RESALE

And when you open Inventory Posting Setup for your existed group, you will see that we can add GL accounts, but is has not Locations.

MadeiraIPG.jpg

That means we have not locations in the Project “Madeira”. This is not connected only with setup; that also means we cannot use locations in inventory process. You also cannot find fixed assets in Project “Madeira”.

It also means setup is not so hard, but it still requires some specific knowledge about the main thing of system and we cannot expect from client to configure it by himself.

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.

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.