ArcherPoint Dynamics Developer Digest - vol 106
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.
Regardless of NAV Version, Test Your 1099 ReportsÂ
From Jon Long:
Run any of the 1099 reports and they have peculiar calculation issues. When you run the reports in pre-2013R2, then run them in 2013 or above, you will get different numbers. For instance, our client is getting one total of 1099 payments in the year 2014 when running the reports in 2013R2. And when using the same exact data and filters running the reports in the pre-2013R2 dB (i.e., 6.01), they get a whopping $236,000 difference. There are zero customizations involved and the reports are virtually unchanged from old to new versions.
I think this bug was introduced around 2013 rollup 7, but haven’t vetted that out yet.
I’ve fixed this issue temporarily by simply rolling back the function in Codeunit 10202 “Entry Application Management.” The function that has changed, and is causing the issue, is called GetAppliedVendEntries. It appears that changes were made for performance reasons. No business logic should have occurred. There is no logical reason that the numbers should be different. I’ve researched all Rollups through the initial release of 2015. It appears that this issue still exists in 2015, but, I haven’t tested, just compared the code. The issue seems to impact only certain vendors, perhaps due to only certain scenarios, as some vendor totals were correct. On a few that were incorrect that I analyzed, one contained voids, which were not handled properly in the new code. One had several payments which were paying for invoices from two years prior, so that was odd, but not handled by the new code. At least, not the same as the old code.
It is important to note that this issue still exists in 2016. I’ve re-submitted a ticket to Microsoft. Michael Wong is working on a solution for 2016, as it requires a different solution than 2015, or 2013R2. The fix noted here is valid for 2015 and 2013R2.
Any customer that pays 1099 vendors will potentially be impacted. The only way to test is to run the 1099 report before and after applying the fix. The balance should match to the penny. If it doesn’t, the fix is necessary.
Update from MS: No official fix yet. Workaround above is the only option at this point (i.e., roll back Codeunit 10202 to 2013 Rollup0 version.) It looks like an inadvertent change was added to Codeunit 10202 that was meant for a non-NA (North American) version. That Codeunit has only twofunctions: GetAppliedVendEntries and GetAppliedCustEntries. These functions are called for more than 1099 info, so this bug may cause discrepancies in many areas of NAV. This workaround is a must for any company that uses Customers or Vendors. Clients can contact ArcherPoint support for help with the fix.
Dynamics 365 Update
More details are coming out about Dynamics 365. This article has links to additional information including roadmap and licensing. If you want to hear about Dynamics 365 from the horse’s mouth, come to NAVUG Summit in October. Microsoft will be presenting a keynote to kick off the event, and Dynamics 365 will be a big part of that message.
Dynamics NAV for Small Business Configuration
Microsoft MVP Saurav Dhyani shares via YouTube a video showing how to set up Dynamics NAV for small business.
Productivity Tool – Office Tabs Plug-In
One of our interns shares a plugin he uses with Microsoft Office called Tabs. Essentially, instead of having multiple windows in Word, Excel, and PowerPoint this plugin will create browser-like tabs. It’s a huge time saver for someone who always has a million Office windows open.
If you are interested in NAV development, check out our collection of NAV Development Blogs.
For step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV, see our collection of NAV How-To blogs.