The C/AL keyword MODIFYALL is tempting to use when a certain value must be changed for every record matching the current filtered recordset. One may or may not be aware of the third optional parameter for this keyword: TRUE/FALSE. FALSE is the default. If set to TRUE, the OnModify() trigger is executed when the record… Continue reading Beware the Third Parameter of MODIFYALL
TableData 2000000001 does not exist.
This NAV 2013 error may result if the user is attempting to connect to a NAV database using the Developer Client and the SQL permission dbowner has not been granted for the user at the database level. This resource reports the SQL permission dbowner is required in order for a user to manage NAV… Continue reading TableData 2000000001 does not exist.
Reversing the Entire Production Order Consumption in Dynamics NAV 2013
(Without Keying in the items One by One) Occasionally there is a mistake made where Production Order Consumption is posted. It is quite easy to fix the problem if there are only one or two lines that need to be reversed, but what if the entire consumption needs to be reversed for tens or hundreds… Continue reading Reversing the Entire Production Order Consumption in Dynamics NAV 2013
Offer for Microsoft Dynamics and Lanham Associates Lapsed Customers
If you haven’t heard, Microsoft has brought back its BREP (Business Ready Enhancement Plan) Lapsed Customer offer. This promotion gives Dynamics customers that are 18 months or more lapsed on their BREP the opportunity to get back on plan at a discount. Now, Lanham Associates is following suit to enable their clients that are 18… Continue reading Offer for Microsoft Dynamics and Lanham Associates Lapsed Customers
Main Street vs the Internet – The Sales Tax Showdown Is Here
Guest blog provided by the sales tax experts at Avalara On May 6, the Senate passed the Marketplace Fairness Act by a vote of 69-27, and it will now go to the House for approval. Retailers are divided on issue, but whether you’re for it or against it, chances are it will affect your business… Continue reading Main Street vs the Internet – The Sales Tax Showdown Is Here
Virtually There
A lot of companies, ArcherPoint included, are allowing employees to work remotely. Webinars and other virtual events are more common than ever (nearly all ArcherPoint’s events are remote, and with employees throughout the country, remote communication is part of our culture). Today, both public and private high schools and colleges are offering online classes –… Continue reading Virtually There
6 More Reasons You Should Consider Upgrading NAV
The Hidden Costs of NOT Upgrading NAV Obsolete Technology It gets harder and harder to bridge the gap between old technology and new technology the further upgrading is put off.Microsoft and Add-On Software vendors create upgrade tools that support upgrading from the current version to the new version. This is called an “Upgrade Path”. Sometimes,… Continue reading 6 More Reasons You Should Consider Upgrading NAV
Sales Tax Is No Laughing Matter – But It Has Its Moments
A colleague of mine from Avalara once asked me, “Did you ever hear the joke about sales tax compliance?” “No,” I replied. “That’s not surprising,” she said. “There isn’t one.” Anyone who has ever dealt with sales taxes can appreciate that few things in business are as dull, as complex, or as important as sales… Continue reading Sales Tax Is No Laughing Matter – But It Has Its Moments
The Missing Step
I love Spring for many reasons – more daylight, warmer weather, holidays, and my poppies are starting to bloom, all of which all got me to thinking how everything in life has an order in which it happens, some natural and some imposed on nature by us, especially where business operations are concerned. I was… Continue reading The Missing Step
If I want to build a data warehouse, do I go to Home Depot?
In a couple of weeks, ArcherPoint is co-hosting a Lunch & Learn webinar with one of our partners, BI4Dynamics, on Business Intelligence. As the guy in charge of the website, it’s my job to provide relevant content around the various events we host, so I went looking for a clear, succinct overview of the high… Continue reading If I want to build a data warehouse, do I go to Home Depot?