Confessions of a Dynamics NAV / Navision consultant. A blog about my experiences being a Navision consultant and developer. Confessions of a Dynamics NAV / Navision Consultant
Jan 26, 2010 18:22

Implementing NAV (Navision) through a 3rd party Consultant

Rarely in a NAV implementation that the problem you get stuck on is techincal. As we all know, Dynamics NAV aka Navision is simple to implement and simple to customize. It’s one of the reason why it’s the dominate mid market ERP today. Most of the challenges you’ll face are with people. And one of the toughest challenges when implementing Dynamics NAV is working with 3rd party consultants the end user company hired to help them implement a new system. Perhaps, this is one of the...
Posted by Alex Chow with 3 comment(s)
Jan 14, 2010 11:34

How to Create Drilldown page to a custom table in RTC - NAV2009 SP1

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 the page and REMEMBER THE ID 4. Go to the table property on the table you created in step 1 5. TYPE IN the Page ID in the DrillDownFormID property in step 4 6. Save and test your work. In the table designer, there's no place to specify the Drilldown...
Posted by Alex Chow with 2 comment(s)
Nov 16, 2009 10:16

Future of Dynamics NAV (Navision) - Recap of Directions 2009

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 to RTC, getting partners to buy into RTC. Instead of posting a session summary ,which doesn't really do the presenter justice with a few paragraphs, I just decided to write some highlights that stuck out for me during this event. Numbers: Now...
Posted by Alex Chow with 8 comment(s)
Oct 5, 2009 14:36

How to Calculate the Current Fiscal Year

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 is a record variable to table 50 Date1 and Date2 are date variables AccountingPeriod.RESET; AccountingPeriod.SETRANGE("New Fiscal Year",TRUE); AccountingPeriod."Starting Date" := WORKDATE; AccountingPeriod.FIND('=<'); Date1 :...
Posted by Alex Chow with 3 comment(s)
Sep 1, 2009 14:35

How to setup Fixed Assets for Tax Purpose

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 . The article is titled - "How to Set Up Modified Accelerated Cost Recovery System (MACRS) Depreciation in Fixed Assets" and can be found here: https:// mbs . microsoft . com / customersource /documentation/ howtodocuments / msd _ navsetupmacrsforfa...
Posted by Alex Chow with no comments
Aug 19, 2009 17:27

The source of all evil?

I noticed this when I did a search on Google using the keyword Dynamics NAV or Dynamics GP (or AX or SL, or whatever). http://thesource.ofallevil.com/dynamics … rview.aspx It seems random, on top search results it displays www.microsoft.com . On the later pages, it displays thesource.ofallevil.com. The source of all evil? Is this a Microsoft joke? Or did Google intentionally do this?
Posted by Alex Chow with 4 comment(s)
Jul 24, 2009 17:30

Entering Beginning Balance for Dynamics NAV (Navision) for a New Implementation

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, you need to put in the bank balance so it shows up on the bank ledger, on the other hand, if you put in just a lump sum, doing the first bank reconciliation will be a nightmare. The goal when entering a beginning bank balance, is to update the bank...
Posted by Alex Chow with 6 comment(s)
Filed under: , ,
Jun 26, 2009 11:29

Product Suggestions for Microsoft Dynamics

Got a suggestion to make the product better? Go here to log your suggestions (or complaints, rants, raves, etc). It's about time Microsoft has something like this. https://connect.microsoft.com/dynamicssuggestions Make your voice count! Microsoft is listening!
Posted by Alex Chow with 1 comment(s)
Filed under:
Jun 25, 2009 16:57

Average Cost to Implement Dynamics NAV (Navision)

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 that run them. As such, no 2 implementations are exactly the same. This is because the people that work inside the companies are unique. They live the company culture that are defined by their managers. And the company culture are as unique as the personalities...
Posted by Alex Chow with 1 comment(s)
Filed under:
Mar 16, 2009 13:44

How to calculate COGS on Account Schedules (The CPA Way)

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 COGS account. The COGS posted by NAV is ALWAYS correct. Don't assume otherwise. Typically, when a CPA (Certified Public Accountants) report COGS, it's calculated and displayed based on the following formula: Beginning Inventory + Purchases - Inventory...
Posted by Alex Chow with 4 comment(s)
Filed under: , , ,
Dec 2, 2008 17:30

Dynamics NAV (Navision) Can Solve All of Your Business Pains!

Dynamics NAV (Navision) can do anything for your business. Yep, you heard it right. Implementing Dynamics NAV (Navision) can solve all of the problems for your company. It's true! Since working with Dynamics NAV (Navision) in 1999, I have never encountered a business problem that cannot be solved in Dynamics NAV. Compliance? No problem. Reporting? No problem. Unique business processes? No problem. AND! Implementing Dynamics NAV will solve your company's problems within a reasonable budget...
Posted by Alex Chow with 11 comment(s)
Filed under: , , , , , ,
Aug 27, 2008 17:22

Accounting Cost vs. True Cost

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 terms. To better explain the difference between True Cost and Accounting Cost, we will use this example: 8/15/08 - Item A was received at 10 pieces for $2.00 each. 8/30/08 - 6 pieces of item A was sold for $5.00 per piece 9/1/08 - The vendor invoice for...
Posted by Alex Chow with 1 comment(s)
Filed under: ,
Jun 25, 2008 14:59

Where do you put the Customer PO No.?

In Dynamics NAV 5.0SP1, the caption for Your Reference has been changed to Customer PO No. For us, we've always used External Document No. to store the Customer PO No. on the sales order. It's obvious that the change in 5.0 SP1 was done due to partner requests. I just want to get your opinion on where you put the Customer PO No. when entering a sales order. Please vote here: http://dynamicsuser.net/forums/t/23238.aspx
Posted by Alex Chow with 3 comment(s)
Filed under: , , ,
Apr 21, 2008 15:15

My Microsoft Conundrum

First of all, let me state that I'm a amateur investor in the stock market. I have a discipline when it comes to stock investing in that I look for companies with good products and/or strong management. One of the major holdings I have is Microsoft (MSFT), in fact, my Microsoft stocks takes up about 20% of my portfolio. As an investor, I want to see the stock shoot up and demostrate increased sales of the product quarter after quarter. Likewise, I want to see the profit increase quarter after...
Posted by Alex Chow with 6 comment(s)
Filed under: , , , , ,
Feb 15, 2008 10:09

Etiquette for Contractors Dealing with Solution Centers and Vice Versa

Just thought I post some etiquette for Solution Centers (NSC) and contractors when dealing with each other. For Contractors: 1. There's no such thing as job security when you're a contractor. If you want security, find a full time position at a NSC. 2. Do not set your rates based on how much the NSC charges their customers. Figure out a market rate for your skillset and make it fixed. 3. Contractors are used only for the short term. If you want long term, find a full time position at a NSC...
Posted by Alex Chow with 8 comment(s)
Filed under: , , ,
More Posts Next page »