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. GoRead more
Author Archives: Alex Chow
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 postingRead more
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);Read more
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) DepreciationRead more
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 didRead more
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 bankRead more
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!
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 exactlyRead more
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?Read more
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 whereRead more