ArcherPoint Dynamics NAV Developer Digest - vol 198
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.
Implementing AMC Bank Data Conversion Service in Dynamics NAV
Trish asks, “Does anyone have experience implementing the AMC Bank Data Conversion Service introduced in NAV 2015? A client needs to implement the exported payment format required by the National Bank of Canada, which is on the AMC supported bank list. (This format is fixed width and includes multiple payment journal records per line, which as I understand it excludes the Data Exchange Definitions as an option without modification). I've watched the AMC Banking videos (links included below), and it seems deceptively easy. Any real-world experience would be appreciated to make sure this is something we would recommend, and to provide an accurate estimate to the client. Also, can anyone confirm the AMC Bank Data Conversion Service is truly free of charge?”
Kyle adds, "Posting Exchange in 2015 is... horrible. I made it work for a Barbados ACH, but that was not fixed width. They greatly improved it for 2016+. For NAV 2015, run away."
If anyone has implemented this, we would love to get your input. Please add your response in the comment section below.
Dynamics NAV Cumulative Updates
With Microsoft constantly improving Dynamics NAV versions, it is critical to keep up with their cumulative updates. Here is the latest:
- Cumulative Update 06 for Dynamics NAV 2018 Build 22292
- Cumulative Update 19 for Dynamics NAV 2017 Build 22286
- Cumulative Update 32 for Dynamics NAV 2016 Build 50357
- Cumulative Update 44 for Dynamics NAV 2015 Build 50355
Thanks to our Sowkarthika for keeping us informed of all the latest updates!
Error Changing a Dynamics NAV Object After Restoring the Database
Tom H., “I have this crazy problem for a client. They just restored their dev database from their production database, and now when I try to change a NAV object, I get an error saying something like the following:
Microsoft Dynamics NAV Classic
The following SQL Server error or errors occurred when accessing the Object table:102,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '0xdf24'.
UPDATE "NAV-DEV"."dbo"."Object" WITH (REPEATABLEREAD) SET "Version List"='TEMPd' WHERE ("Type"=3 AND "Company Name"='' AND "ID"=50026) AND ("timestamp"<=0x000000022C93AF80)
They're running NAV 5 on 2009 R2 executables. Has anyone seen this before?”
Matt T responds, “You need to be the administrator or database owner in SQL. NAV is just the intermediary pushing table changes down to the SQL server. It's like this for every version of NAV.”
Tom H, “It looks like it's exclusively a SQL Server issue. If I take the query from the error message, and put it in SQL Server Management Studio and execute it, I get the same error. I am set up as the database owner, so that is not it. It works fine in the production DB, but not in dev. It's really weird.”
Please check out this mibuso article on SQL Error Accessing Object Table and check to see if the client has any triggers.
If you are interested in NAV development, be sure to see our collection of NAV Development Blogs.
Read the "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV.