At our shop, we were doing a real big upgrade – Classic NAV (no SQL) all the way up to 2018. We hit a weird error message about the Locked and Locked By fields missing when trying to modify any records: Since our upgrade lead hadn't seen "Invalid column name 'Locked'" before, and neither had … Continue reading Object Table – Locked Missing
Tag: Dynamics NAV
Ah, the NAV Web Client of forever unhelpful error messages: It's not too hard to get things set up with it correctly once you've done it a few times. I ran into an interesting challenge this week, however. I needed to setup different build versions of the WebClient on the same box. A customer was … Continue reading Multiple NAV Builds of Web Clients
It's pretty easy to run Microsoft Dynamics NAV (RTC or otherwise) as another user while you're inside the domain (shift right click on most Windows machines to find a "Run as another user" option, if you did not know). We had a situation come up where, for training purposes, it was necessary to use a … Continue reading NAV Tip: Access Domain NAV from Non-Domain Computer
This is not so much a training document as outlining how I had to troubleshoot a weird error. I think the process taught me a variety of things, so I wanted to share the process of finding the answer. I was trying to setup a new Dynamics NAV 2016 service tier in a test environment … Continue reading Dynamics NAV – Credential Type NavUserPassword Gotcha
In Microsoft Dynamics NAV, every Date has a corresponding "Closing Date". What are they and what are they used for? Let's take a look. You may see entries in your system like this: Notice the peculiar Posting Date? C12/31/2009? That's a Closing Date. NAV handles them as a special date that is after 12/31/2009 but … Continue reading NAV Concept: Closing Date vs Normal Date