Data Migration Using Assisted Setup

Click here to view all NAV related blog posts.

With Microsoft Dynamics NAV 2017 you can use assisted set up to perform certain set up tasks based on the wizard. The data migration is one of these tasks. This is what we call the data migration using assisted set up. This is based on a wizard.

You can import from Excel, but you can also import from other finance solutions, for example QuickBooks. This is using the extension management in Microsoft dynamics NAV, which means that in real life you can use these extensions and also build extensions to use other finance software applications.

Click Departments/Administration/Application Setup/General/Assisted Setup.

Select Migrate Business Data and Start Setup. Follow the instructions:

The import process is the same as using Rapid Start. The only difference is that here we are working with a wizard.

Enabling Outlook Add-in for NAV 2017

This article discusses the steps required to Enable Outlook Add-in for Microsoft Dynamics NAV 2017.

Prerequisites

To enabling Outlook Add-in, you must have:

Create User

In this example we are creating a user with SUPER permission and following credentials:

Username: DemoUser

Password: Pass@Word1

For more information, you can refer to the topic How to: Create Microsoft Dynamics NAV Users on MSDN.

Create a New Service Instance

We will create a new service instance for the user:

Server Instance: NAV2017

Ports: 6020,6021,6022 and 6023

For more information, you can refer to the topic How to: Create a Microsoft Dynamics NAV Server Instance on MSDN.

Update Service Tier

Update the Service Tier with the following information:

Credential Type: NavUserPassword

Certificate Thumbprint: <The SSL Certificate Thumbprint>

Update Configuration File for Windows Client

Edit the ClientUserSettings.config file, usually located at the following location:

C:\Users\<user name>\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\100

Update the following parameter:

ClientServicesCredentialType : NavUserPassword

Update Configuration File for Web Client

Edit the web.config file, usually located at the following location:

C:\inetpub\wwwroot\DynamicsNAV100

Update the following parameters:

ServerInstance : NAV2017 (check the settings above)

ClientServicesCredentialType : NavUserPassword

ClientServicesPort : 6021 (check the settings above)

Add Certificate to Web Client

Open the inetmgr command.

This will open the Internet Information Services (IIS) Manager. Do the following:

  • Select Microsoft Dynamics NAV 2017 Web Client.
  • Click Bindings action.
  • On the Site Bindings window click Add.
  • On the Add Site Bindings window, select Type : https and select the SSL Certificate from the drop down menu.
  • Click Ok.

Update Service Tier With URLs

Edit the following parameters in the new Service Tier (NAV2017):

Web Client Base URL : https://<Certificate Name>:443/DynamicsNAV100/WebClient/


SOAP Base URL : https://<Certificate Name>:6022/DynamicsNav/WS/


ODATA Base URL : https://<Certificate Name>:6023/DynamicsNav/OData/

NOTE: Replace the <Certificate Name> with the name of the certificate and also confirm the Port number as per your settings. Enable SSL for SOAP and ODATA. Restart the Service.

Assisted Setup: Set up Outlook for Financials

Open Microsoft Dynamics NAV using the user credentials created earlier.

Open Assisted Setup page (Departments/Administration/Application Setup/General/Assisted Setup) and start Set up Outlook for Financials.

Follow the instructions in the wizard:

The status should change to Completed.

Check your Outlook Client

Open your Outlook client. On the ribbon two new Add-Ins are introduced under Home tab:

You can add Contacts to NAV from Outlook:

You can have Existing NAV contact insight from within Outlook:

You can create new documents from Outlook, such as Sales Quote, Sales Invoice, etc.

Enjoy working with Outlook for Financials 🙂

Payment Registration

What are the benefits of using Payment Registration?

Simplicity:

  • All processes are brought together on one page to efficiently handle registration of incoming documents.
  • Ability to accommodate various ways of doing payment registration.

Productivity:

  • Easy overview of open entries.
  • Easy sorting and filtering across open entries.
  • Less data entry.

Ease of Use:

  • In common scenarios, the user only has to mark entries and post, and then is done.
  • Totals to show that all registrations are made.
  • Users can define payment registration setup according to responsibilities and processes.

What do we see in Payment Registration?

  • All outstanding payments for all customers.
  • This is everything that customers need to pay.
  • You can also see positive as well as negative amounts.
  • Also, credit memos are included here.

What are the useful features?

  • You can easily search for customers using the Search Customers action.
  • You can easily filter on the certain customer. Right-click on a customer and click Filter to This Value (Att+f3).
  • You can sort on specific columns by clicking on the column.
  • You can also Search Documents based on different filters.

Setup

Go to Departments/Financial Management/Cash Management.

Open Payment Registration. If you are opening it for the first time, the system will populate the Payment Registration Setup page.


If not already specified, you will have to specify the journal template and batch you want to use for the payment registration and also the balancing account type, for example in which bank account would you like to balance the incoming payments? You can choose to use the account as default and also if you want the date received to be filled automatically.


So once this setup is done, we are already up and running and we can start using the payment registration function.

Post Payments

All we need to do is to go to specific line, for example in this case we select customer Selangorian Ltd. (Invoice 103002).

Suppose that the customer has already paid the invoice. So all we need to do is select the Payment Made checkbox.

You will notice that the system automatically fills in the Date Received, based on the Work Date and also the Amount Received is entered.


Post Lump Payments

Suppose multiple documents have been paid by a customer; that’s what we call lump payment.

In the following example we can see couple of documents from John Haddock Insurance Co., so we select the relevant documents that the customer paid.

Now instead of using Post Payments action, we can now use Post as Lump Payment action.

NOTE: Once the full payment has been posted, the relevant lines are removed from the Payment Registration window.


Result:

Go to customers.

Here we select customer John Haddock Insurance Co. (30000), for which we had posted the lump payment and open the Customer Ledger Entries.

Here you can see the payment line, no remaining amount anymore and in the fact box you can see that there are two applied entries.

When you check the applied entries, you can see the two invoices that we have posted to (remember during the lump payment the two invoices that we had selected). Basically, that how the payments have been posted.

Customer Ledger Entries


Applied Entries


Search Customers and Documents

It could be interesting to search for customers using the Search Customers action. So we can search for customer 10000 (The Cannon Group PLC) for example and go to the ledger entries to look for detailed information.


Once that we decide that this is the customer that we would like to use in the Payment Registration, you can also choose to start filtering on the customers.


You can also perform Sorting by clicking on the columns. For example, sort the records in the Payment Registration based on Due Date. By clicking on the column you can sort the records in ascending or descending order based on the column value (note the arrow key beside the column name when you sort).


You can Search Documents and apply various filters.


Let us enter a document number 101022 (sales order number). Let’s say, this is the reference that we see on the bank statement, that is provided by the customer.

Click Search and now we see that there indeed is a sales order.


Click Show to open the sale order. If we check the order, we see that there is no shipment or invoice. But let’s say based on an agreement the customer has paid in advance on this sales order.

Post Payments Manually Without a related Document

So let’s go back to payment registration window and click General Journal. This will allow us to directly enter advance that we received from the customer. So in this example, we received the Payment from Customer MEMA Ljubljana d.o.o. (38128456) for -1200/-.


We can now simply post the payment. This is now added as an open payment in the payment registration overview.

Create a Finance Charge Memo from the Payment Registration Page

If we sort on the Due Date, we can see that some invoices are overdue.

We can select the invoice, and now we can see that the payment is overdue and you can calculate interests.


So before posting the payment we can let the system create the Finance Charge Memo. So maybe the customer paid quiet late and based on the general conditions we will charge interest.

Click on Finance Charge Memo. Fill in the customer details, click Suggest Fin. Charge memo Lines. This will create the lines showing the amount (interest) the customer need to pay. Click Issue and Ok.


Now you can post the payment on the payment registration as the customer has paid.

As a result, you will see that a line has been added, because now a Finance Charge Memo is also due by the customer. So they have to pay the interest.

Test E-Mail Setup for NAV SMTP Mail Setup

 

  1. Open the SMTP Mail Setup window.
  2. Click Apply Office 365 Server Settings (if you have access to Office 365 account). You can ask your administrator for these settings or for testing you can lookup SMTP setting for various email service providers (such Hotmail, etc.).
  3. Choose Authentication as Basic.
    NOTE:When you send email messages multiple times by using an SMTP mail server, you may encounter the following error message: “Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.”  To resolve this issue, use NTLM or Basic authentication, instead of Anonymous authentication.
  4. Specify your User ID and Password.
  5. Optionally select Secure Connection if your SMTP mail server setup requires a secure connection (such as SSL).
  6. Click Test Email Setup. Select an option in the dialog that pops up and click OK.
    SNAGHTML3a00d93c
  7. You will get a confirmation, if the mail was sent successfully.
    SNAGHTML3a030d72 
  8. Check the result in your mail box.
    image