Confessions of a Dynamics NAV Consultant

| |

Average Cost to Implement Microsoft Dynamics NAV (Navision)

Posted over 3 years ago

by Anonymous

First of all, there are no 2 businesses that are exactly the same. I don’t care if they’re in the same industry, if the owners are siblings, and/or if they live in the same household. Companies are as unique as the fingerprints of the owners...
Entering Beginning Balance for Dynamics NAV (Navision) for a New Implementation

Posted over 3 years ago

by Anonymous

During a new implementation of Dynamics NAV (Navision), most Dynamics NAV (Navision) consultants understand how to load in A/R and A/P beginning balances. However, when it comes to bank beginning balance. The subject is usually more murky. On one hand...
Dynamics NAV (Navision) in the Cloud

Posted over 2 years ago

by Alex Chow

With the introduction of the App-V technology for Dynamics NAV 2009 R2, it really introduces the concept of putting Navision into the Cloud. In case you haven’t heard of App-V, you can download the white paper here describing it in detail: https...
Why you have Negative Inventory Value with 0 Quantity - Navision 3.7b to Navision 5.0

Posted over 3 years ago

by Justin Salter
- 0 Comments
Here are a couple of reasons why you would get inventory value if you have 0 quantities when you print Inventory Valuation report and Inventory to G/L Reconcile report as of a certain date. Scenario 1: If the adjust cost is processed on 7/31/07...
How to calculate COGS on Account Schedules (The CPA Way)

Posted over 4 years ago

by Anonymous

When a purchase of inventory is made, 4 accounts are hit: Inventory A/P Purchases Direct Cost Applied When the items are sold, 4 accounts are hit: Inventory A/R Sales COGS In this case, the COGS is automatically calculated and posted to your...
How to Define SetData and GetData in RTC Reports in Dynamics NAV Navision

Posted over 2 years ago

by Anonymous

For some reason unfamiliar to me, Microsoft likes to write tutorials that does not easily teach you what you need to do to get the job done. For basic List type reports, yes, it’s quick and simple, however, when it comes to reports involving forms ...
How to Print to local printer using RDP

Posted over 3 years ago

by Justin Salter
- 0 Comments
This is a poor man’s way of having users connect remotely and allowing them to print locally. Using RDP, you will not have to spend money on an expensive product like Citrix unless you really have to. Note that Citrix is a great product, but it’s out...
Entering Beginning Inventory Balance

Posted over 3 years ago

by Justin Salter
- 0 Comments
When moving from a legacy system into Dynamics NAV (Navision), one of the areas you want to try and avoid is messing with the inventory G/L accounts. Most systems are usually pretty good with open A/R and A/P accounts, they can be transferred using the...
Future of Dynamics NAV (Navision) - Recap of Directions 2009

Posted over 3 years ago

by Anonymous

This blog post is an overview of my experience at Directions 2009. In my opinion, this is THE event to attend if you provide software or service to Dynamics NAV (Navision). Most of the sessions in Directions 2009 were about the RTC experience, upgrading...
Open Suggestions to Make Navision RDLC Reporting More Efficient

Posted over 2 years ago

by Alex Chow

Working with the new RDLC reporting for a few months now after the NAV2009 release, I thought I would like it as I work with it more. Sad to say, that hasn’t happened yet. It’s like being in a bad relationship and hoping some day that it’ll...
Why You Should Not Turn On Expected Cost Posting for Navision

Posted over 2 years ago

by Alex Chow

Overview The ERP software business is a very competitive business. If the software company does not devote a lot of their resources into research and development of the product, it becomes outdates very quickly. Therefore, when choosing to purchase an...
Navision RDLC reporting – SetData and GetData – Why It Is REQUIRED

Posted over 2 years ago

by Alex Chow

Ever wondered why there’s no tutorial on how to create a Sales Order report from scratch in the RDLC? The reason is because it takes a LONG TIME! Even for an experienced developer, it takes a long time. As I previously mentioned on my article ,...
Recap of Directions US 2010 for Dynamics NAV (Navision)

Posted over 2 years ago

by Anonymous

This is an overview of my experiences at Directions US 2010. Again, Directions US 2010 is THE place to be at if you’re interested in learning any new for Dynamics NAV (Navision). The biggest difference that I noticed on this conference is Microsoft’s...
How to Set Up Fixed Assets for Tax Purposes

Posted over 3 years ago

by Anonymous

There aren’t that many how-to documents on the Microsoft Customersource website. However, this one has to be one of the most important must-reads for all Navision (Dynamics NAV) end users and implementers wishing to setup fixed assets in Navision...
Dynamics NAV 7 and Improvements to RDLC Reporting

Posted over 2 years ago

by Alex Chow

Improvements Having made a big deal about how bad the current RDLC for Dynamics NAV 2009 (Navision 6.0) has lead me to numerous disucssions with Claus Lundstrøm. For those of you who doesn’t know, Claus is the main guy behind the new reporting...
Dynamics NAV (Navsion) in the Cloud

Posted over 2 years ago

by Alex Chow

Blog article moved here: http://www.dynamicsnavconsultant.com/2011/02/dynamics-nav-navision-in-the-cloud/
Abnormal Posting Dates

Posted over 3 years ago

by Justin Salter
- 0 Comments
Abnormal posting date entries happens when the Posting Date of the receipt/shipments of inventory is after the Posting Date of the invoice. Why does this happen? You’ll need to ask your CFO or Controller. Typically, I found this more in return orders...
How to Create Drilldown page to a custom table in RTC - NAV2009 SP1

Posted over 3 years ago

by Anonymous

This is so someone does not pull their hair out like I just did. I cannot find anywhere in the documentation where this is explained so here it is: 1. Create your custom table 2. Create the drilldown page with SourceTable to your custom table 3. Save...
How to Calculate the Current Fiscal Year

Posted over 3 years ago

by Anonymous

In Navision, there’s no function that will give you the fiscal year according to what you’ve setup on the Accounting Period table. Here’s a code that will get the current fiscal year based on the accounting period: AccountingPeriod...
Fedex API to be Discontinued for E-Ship

Posted over 2 years ago

by Alex Chow

In case you haven’t heard, Fedex will discontinue the use of their old API used by Lanham’s E-Ship module for Fedex Integration. The date that the old API will be discontinued will be May of 2012. While that’s still a couple of months...
Be Current or Not Current on the Microsoft Annual Enhancement Plan

Posted over 3 years ago

by Anonymous

Since Microsoft announced the new Business Ready Enhancement Plan Renewal Policy, talks about whether the customer should stay current has increased significantly. At 16% of your total software list price, it’s potentially a sizable recurring...
Accounting Cost vs. True Cost

Posted over 4 years ago

by Anonymous

In Microsoft Dynamics NAV, when doing costing and profitability analysis, you need to differentiate between a transaction’s True Cost and Accounting Cost. Don’t bother looking up these terms in the manual, I made them up for a lack of better...
Misconceptions about Microsoft Dynamics NAV (Navision) Implementation

Posted over 2 years ago

by Alex Chow

It’s the dawn of a new year and if you’re still reading this blog, congratulations! Why? Because you’re still in business after going through the worst economic collapse since the Great Depression. So hats off to you and thank you for...
Switching to a New Dynamics NAV (Navision) Service Provider

Posted over 1 year ago

by Alex Chow

The Disappointment… Frustrated by the long lead time? Mad at the frequent bugs received and being billed for it? Disappointed at the decisions you made based on bad advice received? Tired of not getting responses? Angry at the billing practices...
Recap of Directions 2011 for Dynamics NAV (Navision)

Posted over 1 year ago

by Alex Chow

Overview This post is an overview of my experiences at Directions 2011 – Connect Learn Execute. Again, if you don’t already know, Directions is THE single event that any partner dealing anything with Dynamics NAV (Navision) absolutely has...

Microsoft Dynamics NAV

About Confessions of a Dynamics NAV Consultant