ArcherPoint Dynamics NAV Developer Digest - vol 110
The NAV community, including the ArcherPoint technical staff—is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful.
As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media...so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.
Issue with Avalara AvaTax and NAV2009 R2
Denise Blaisdell: BEWARE... NAV2009 and R2 require you to uninstall and re-install the .exe for Avalara on the server as well as local workstations. For clean installs, rebooting the server/workstations after install is required. For server/workstations already installed with an old version, the uninstall leaves registry remnants causing the new version install to fail causing automation server errors when calling the AVA code.
HELP! Has anyone seen this before and more importantly does anyone know how to clean up the registry so that the new version .dll will take effect?
Kyle Hardin: It is possible for us to figure out how to remove the orphaned registry entries, but it will be difficult. If Avalara can tell us what the registry remnants are, then this will be much easier.
Denise: This is the official resolution from Avalara: There are couple of ways you can uninstall old AvaTax NAV 2009 connectors that will remove the .dll from the registry.
Option 1: Run the old setup.exe. You will have an option to uninstall the old connector.
Option 2: Go to Add / Remove Program. There you will find an entry for AvaTax NAV connector. Uninstall that.
You can also search registry for any AvaTax entry after that. That will make sure that you do not have any AvaTax related entries in the registry.
We normally do not recommend any manual action in the registry as this may cause some system issue.
Kyle: Ask them to give you details on the manual registry removal, just in case the old setup.exe doesn't clear everything out.
Denise: The official resolution did not resolve the issue. Neither did the not recommended resolution. We have to keep in mind that the client is trying these resolutions on their own, and we have no idea if they are missing anything. Therefore, we are scheduling a conference call with Avalara's support guys this afternoon to review the workstations issue.
I do not recommend any manual change in your system registry.
SOLUTION: You need to RUN INSTALL AS ADMINISTRATOR! Yes, it is really this simple.
If you install as administrator then you can register the .dll manually by going to the Command Prompt.
Go the directory where the bat file is
cd:\Program Files (x86)\Avalara\Avatax Connect Adaptor\Bin\
then type in Register.bat
C:\Program Files (x86)\Avalara\Avatax Connect Adaptor\Bin\Register.bat
Avalara Issue with Partial Invoicing
PARTIAL INVOICING - AVA-CL issue where total order tax is included in the Credit Card settlement if using ChargeLogic. A simple one line change will add the tax per line invoiced instead of the total order tax. CU 140728335 EFT Source Doc Mgt. in the GetSalesAmountsForcombineShip function. IF i<>2 THEN.......where the 2 is for Invoicing (1 is ordered and 3 is shipping).
TotalSalesLine[i]."Line Amount" - TotalSalesLine[i]."Inv. Discount Amount";
IF i<>2 THEN //SFI0003A
VATAmount[i] := TempSalesTaxLine1.GetTotalTaxAmount * ExchangeFactor;
IF SalesHeader."Prices Including VAT" THEN
TotalAmount2[i] := TotalSalesLine[i].Amount
TotalAmount2[i] := TotalAmount1[i] + VATAmount[i];
EXIT(TotalAmount2[AmountType + 1]);
Disk Usage 100% in Windows 10
From Saurav Dhyani: If anyone is facing an issue of Disk Usage at 100% in Windows 10 like me, please follow the steps in this article in the Microsoft Community.
There are additional to steps for Skype or Lync. For Google Chrome disable. Use a prediction service to load pages more quickly and protect your device from dangerous sites.
Harvard Business Review has some nuggets of wisdom for us as usual:
Want to be kept abreast of what's new in the Microsoft Dynamics NAV community and at ArcherPoint? Subscribe to our monthly newsletter, Better Business, by completing the form in our Resource Center.
If you are interested in NAV development, check out our collection of NAV Development Blogs.