Did decide to write this blog since this simple problem did take a lot of time for me to find the solution for, in the hope that it will save you from the same time eater.
The problem I did run into was that when starting the RTC client it could not connect to the service, since I had moved the service. Since the service had moved I did say “no” to the questions if RTC should try to connect again. In the address field in the “server selection window” I did type the new address into the address field. The “OK” button was now greyed out, so I could not connect to the server.
After spending some time to try to figure it out how to un grey the “OK” button I found by simple press TAB in the address field makes RTC to connect to the service and retrieve the companies on the service. Now the “OK” button was not greyed out anymore.
In part 1 of this series, I described the problem of the tax numbers in Croatia being changed. In part 2, I described how to export data that you need from NAV and use that data to request new tax numbers from customers, vendors sand contacts. In this post, I will describe how to update the data with new tax numbers and import it into Dynamics NAV.
When you receive documents with new tax numbers (OiB) from customers, vendors and contacts, you can update excel file you created in first step with it. You should update VAT Registration No. field in Excel file in Customer, Vendor and Contact worksheets.
After you're finished updating data and are satisfied with it it's time to import it back to Dynamics NAV.
First, make sure that new tax number validation rules are set in Dynamics NAV. You can do this following these steps:
1. In Microsoft Dynamics NAV, on the main menu, click Administration, Application Setup, General, Countries/Regions to open the Countries/Regions form.
2. Select Croatian record (code HR) and click Country/Region, VAT Reg. No. Formats to open HR - VAT Registration No. Formats form.
3. Verify that 2 lines containing 11 pounds (# symbols) exist in the table, as new tax number in Croatia is formatted in a way that it contains 11 numeric characters.
After this, you can proceed to importing data you prepared in excel file created in first step. You can do this following these steps:
1. Click Application Setup-> Company Setup-> Data Migration in Administration application domain to open Migration overview form.
2. Click Functions-> Import from Excel on Migration Overview form to import data from Excel file.
3. When asked, select folder and Excel file from which to import data and click Open.
4. System will import data and notify you when it's done.
5. To verify that something was really imported, verify that No. of Migration Record is different from zero in Migration Overview form.
6. If some errors occurred (like new tax number didn't comply to format set earlier), you can see this by clicking Drill Down button in No. of Migration Errors field in Migration Overview form.
7. When all errors are removed (No. of Migration Errors is zero) for all lines you need to apply migration data. Select all lines, clicking Edit, Select All to select all lines in Migration Overview form
8. Click Migration, Apply Migration Data to apply migration data
9. To verify data was applied, verify that No. of Migration Record is zero in Migration Overview form
10. Also, you may open any of your customer, vendor and contact records in the system and verify that VAT Registration No. field contains the value set in excel file.
To make sure your VAT reporting will take VAT Registration numbers correctly have a look at these KB articles which describe a small modification needed to VAT Sales Book and VAT Purchase Reports to enable this.
The Changes document for Microsoft Dynamics NAV 2009 SP1 is now available on Partnersource. With this release, we are trying out a new format and would like to hear your feedback on the following:
Add your feedback in the comments below.
You can download the document from the following location: Changes Made In Microsoft Dynamics NAV 2009 SP1. Log in to Partnersource is required.
With the recent release of Microsoft Dynamics NAV 2009 SP1 for Belgium, Norway, and Sweden, we have now released the Help source files for those countries. If you are creating a solution for those countries, you can customize the Help source files to match your solution. You can download the files here.
In addition, we have re-released the Help source files for all Microsoft Dynamics NAV 2009 SP1 countries to add a file that contains translated boilerplate text. You can download the updated source files here. Finally, we’ve re-released the Microsoft Dynamics NAV 2009 SP1 Help Toolkit with updated documentation on creating customized Help. You can download the updated toolkit here. (Note that PartnerSource access is required for all downloads.)
As always, let us know what you think about the Help, the customization process, the tools, what's missing, and what would be more helpful. Send your feedback to firstname.lastname@example.org.