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

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

Journey into Mystery! Working with RecordRef Variables in Microsoft Dynamics NAV The RecordRef and FieldRef variable types are used in Microsoft Dynamics NAV to handle working with a record and fields in a record when you don’t necessarily know which record or fields you’ll be handling. In this blog entry, I’ll write about how to work with them. NOTE: These instructions should apply to all versions of Dynamics NAV from version 3.7 up to and including Dynamics NAV 2013 and Dynamics NAV 2013 R2. Writing code around Microsoft Dynamics NAV, you may have seen the RecordRef, FieldRef, and KeyRef variable types. If you’ve never gotten to use them, you probably don’t quite know what they are or how they work. These three variable types are used when you know that you need to work with a record or set of records, but you don’t know exactly which table you’ll need to access. Generally, I’ve used RecordRef variables under two different circumstances. Either I needed to do the same operatio

How to Use “Item Type” for Non-Stock Items One of the least known features in NAV is the “Type” field on the item card. This is a new field that provides some functionality that did not previously exist in NAV. Most of us aren’t aware of this field because you don’t see it on the item card page. You can identify an item as a “Service” item in the Type field. A “Service” item can be purchased and sold, but can’t be used in any other “Inventory Reference” such as production orders, or Item Journals. Some of the interesting features of a SERVICE item are: Item ledger entries are created, but they do not carry an inventory value. You can see the quantity of that item on hand. You can Purchase a Service Item You can ship a Service Item on a Sales Order. Some things you can’t do with a SERVICE item. Produce via a production order. Consume on a production order. Use on an Item Journal Perform physical inventory counts. Let’s take a look at where you might want to use it

Dynamics NAV Developer Digest  The NAV community, including the ArcherPoint technical staff—is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful. As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media...so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.