Microsoft Dynamics Nav Uganda, Microsoft ERP Solutions Community East and South Africa

The Difference Between Microsoft Dynamics NAV and AX Microsoft Dynamics offers a variety of ERP solutions. You might say there is a solution for every purpose and every industry. Two of the offerings,  Dynamics NAV  and  Dynamics AX (now part of  Dynamics 365 ) share some of the same features so you might wonder: ‘what are the differences and which is right for my organization?’ Both ERP solutions are highly customizable, available in and adaptable to many languages and currencies used around the world. The two solutions can also be employed in a central location or across diverse satellite locations and are designed to grow as a business grows. Their industry-specific functionality can assure compliance with local and regional requirements. In short, both solutions could rightly be described as comprehensive and well equipped to manage complex requirements of supply chain and inventory. So, what is the difference? Is one better than the other for your particular organiz

Microsoft Dynamics NAV 2018 Enhanced Financials Microsoft’s continued commitment and development of Enterprise Resource Planning Systems (ERP) has resulted in the release of  Microsoft Dynamics NAV 2018 .  NAV 2018 is an end-to-end robust business management solution designed to help organizations achieve greater efficiency, streamline business processes, and empower employees to react quickly to changing business needs with intelligent insights-anywhere and on any device.  Microsoft Dynamics NAV 2018 Enhanced Financials, along with its core financial management features, give companies a vast array of accounting and financial capabilities for small to medium sized companies. New Financial Accounting Features: In financial accounting, dimension filters can now be applied to all dimensions. These are available, among others, in the chart of accounts, general ledger, accounts payable and receivable. Out-of-the-Box Microsoft Excel Report Templates such as Trial Ba

Project Management in Microsoft Dynamics NAV 2018 Microsoft Dynamics NAV 2018  has been recently enhanced with new features and deeper functionality into its’ core application including updates to Project Management in Jobs.  Jobs are a way for you to schedule the usage of your company’s resources and to keep track of the various costs associated with the resources on a specific project. Jobs involves the consumption of employee hours, machine hours, inventory items, and other types of usage that you may want to track as a job progresses.  Jobs has some new functionality and simplified features. Enhanced Project Management in Microsoft Dynamics NAV 2018 has resulted in a streamlined experience in Jobs, to help you manage your projects better. By using the new Jobs setup wizard allows you to set up jobs, enter time sheets, and Job Journals more easily, and use the updated Project Manager role center to quickly access common tasks, new charts, and a new “M

Why is VirtualBox only showing 32 bit guest versions on my 64 bit host OS? I experienced an extremely nettlesome problem after swapping out my traditional hard drive for a faster Solid State Drive ( SSD ).  I installed Windows 8.1 from scratch using the Product Key , copied over all my software ( I probably should have used Ninite  but I was too lazy) and then mindlessly enabled a bunch of options that I never enabled before. But Alas! Stupidity has a cost and in my case it cost hours of discomfiting nights scouring Google for a solution. Today I want to save you the pain I encountered by showing you how to fix a problem I experienced in VirtualBox.  This post is going to be succinct and to the point. Even though my Host OS is a 64-bit version of Windows 8.1 , VirtualBox categorically refused to display any 64-bit guest OSes in the  Create Virtual Machine dialog box. This was super annoying because all my ISOs were 64-bit therefore I couldn’t use the

I got this issue with Visual Studio 2015 Enterprise Edition.  Every time I open a Dynamics NAV report layout in Visual Studio, RDLC is rendered as XML file instead of visual layout with all the fields and tool boxes.  How the report layout looks:  FIX : In order to fix the issue you need to install  "Microsoft SQL Server Data Tools" .  To install "Microsoft SQL Server Data Tools" you need to go to  Control Panel   ->  Programs and Features  - >  Microsoft Visual Studio <Edition>  -> Change Or you can re run the installation setup.  From the features list, enable "Microsoft SQL Server Data Tools" option and proceed.  Once the installation is completed you are good to go. This time report layout will open in correct design layout.  Hope this helps you to resolve the issue. happy designing.  Please provide your feedback with a comment.  Thank you and Regards, +256775120005 Kairo Okello Dan ERP Solutions Consultant

Applying One(1) Cash Receipt/Payment entry to Multiple Invoices Answering one of these Questions will definitely add to your knowledge Dictionary: Within the same Cash Receipt Journal Batch (or even when using different Batches), is it possible to  apply multiple Invoices to the Receipt? First Solution: When I use the "Apply Entries" button, if I try to apply multiple Invoices to the same Invoice, and click the set "Applies-to ID"  one each of the Invoices from the page,  and a combined Amount computed from the combination of the applied Invoices  Second Solution: Just not apply the deposits to the invoice directly in the deposit ticket but leave them unapplied. Then they go into the customer afterwards - into the cust ledger entries & use apply entries to apply them all together.

Applying Multiple Cash Receipt/Payment entries to 1 Invoice Answering one of these Questions will definitely add to your knowledge Dictionary: Within the same Cash Receipt Journal Batch (or even when using different Batches), is it possible to partially apply the Cash Receipt's multiple "Payment" entries to the same Sales Invoice? When I use the "Apply Entries" button, if I try to apply multiple Payments to the same Invoice, it will only remove the previous "Applies-to ID" from the page, before subsequent payments can be applied to the invoice, which result in ONLY ONE payment can be applied. (If I use the "Applies-to Doc. No." then I was able to select one Invoice for multiple payments, BUT I was unable to partially apply the Payments to the invoice. If I were to use this page, then I need the capability to Partially apply the payments) First Solution:  Is this how NAV is designed? So that unless the Payment Entries are posted, yo

Lot and Serial Tracking in Microsoft Dynamics NAV Clarified Dynamics NAV provides for very robust Serial Number and Lot Number Tracking. When we advise clients about Serial and Lot Tracking, we say, “Only do it if you have to, as it adds additional user effort to record a transaction.” There are situations where you must use serial or lot tracking. These situations are primarily in the life science industries, where you might be producing medicines or if there is a human safety aspect to your product. Another situation is where you are subject to recalling defective products. To accommodate most of the lot and serial number tracking scenarios that we find in manufacturing and distribution, Dynamics NAV gives us setup screens to pick and choose what we want to track. In the screenshots below from NAV 2013, we see that there are two columns—one for inbound to inventory item transactions and one for outbound item transactions. We can also see under the ‘General’ section a che

Purchases and Direct Cost Applied Accounts in Microsoft Dynamics NAV When working on new Dynamics NAV implementations (and for that matter, existing NAV solutions), we get a lot of questions about the Purchases and Direct Cost Applied Accounts—namely, what are they used for? We were trained in accounting that, when an inventory purchase receipt is invoiced (vouchered), we would debit the Inventory Account and credit the Accounts Payable Account and be done with it. Dynamics NAV doesn’t handle it that way. When we look at the General Posting Setup in Dynamics NAV 2013 (see below), we see that there is a column for the Purchases Account and the Direct Cost Applied Account. Figure 1 - General Posting Setup in Dynamics NAV 2013 When a purchase receipt is invoiced (vouchered) in NAV, we get the following General Ledger entries: Dr Purchases Account for the Actual Invoice Amount Cr Accounts Payable Account for the Actual Invoice Amount Dr Inventory Account for the Ac

How to Determine Who Has a Table Locked in Microsoft Dynamics NAV I recently fielded a support call from a frantic customer that went something like this: “Help! Nobody can post anything! All we get is a message that Item Ledger Entry is locked by another user! AAAAAAHHH!!!” Very useful. The system knows enough to realize there is a block, but won’t bother to tell you which user is causing the problem. The usual fix is to restart the service tier, SQL service, or to reboot the whole SQL server. Why yes, as a matter of fact, everyone would love to stay an extra 20 minutes late today because of a server reboot. Awesome! If you’re looking for a better alternative, there are two ways of figuring out who has the lock. You can do so from inside of NAV depending on the version, or you can tell from SQL regardless of the version. Finding the Guilty Party from Inside NAV If you are using Version 4.0 through 2009 R2 (it went away in 2013), then you can use Database Sessions. (

You Must Defeat Lookups to Stand a Chance: Programming Lookups Using Pages  Often in NAV development, we have times on pages when we need to do a lookup into a table, find a record, and return it to our original page. There are some super-easy ways to do this that come with constraints, and some less-easy ways to do this that are significantly more robust. I’ll try to talk about them, since I don’t see any good tutorials out there on “el Google”. (You may believe that “el Google” is Spanish for “the Google”, but that’s incorrect. It’s actually Spanish for “the chupacabra”; I use some unusual methods for web searches.)  Setting up a Lookup into a Table: Easy Way The first super-easy way to set up a lookup into a table comes when you have a table field that relates to another record. If you set the TableRelation property on a table field, and the related table has a LookupPageID property assigned, and you then add the field to a page, NAV will automatically give you a drop-down bo