Getting the Most out of NAV by Creating On-the-Fly List Reports or Saved Views

In this blog, we will explain how to create saved views to help in your daily work process. When you think of how to make your day more efficient, think about what data or groups of data you need to see on a regular basis. Inside of NAV you can have different list views – the… Continue reading Getting the Most out of NAV by Creating On-the-Fly List Reports or Saved Views

Microsoft Dynamics NAV – Adding Favorites to the Home Page

In the more current versions of Microsoft Dynamics NAV you are able customize your Home page similar to the old ‘Shortcuts’ in earlier versions of NAV. One of the appealing attributes of Dynamics NAV is the ability to personalize your user experience. Customizing, or personalizing, the home screen is easy to do, making your work… Continue reading Microsoft Dynamics NAV – Adding Favorites to the Home Page

Database Normalization in Dynamics NAV

Anomalies and Database Normalization The three most common types of database anomalies include insertion, deletion, and update. These anomalies come from poor database design and can cause errors and other frustrations. This article will explain all three of these common database irregularities and provide solutions. For this article to provide real value, a basic understanding… Continue reading Database Normalization in Dynamics NAV

Using NAV Item Journal to Issue Items to Different Expense Accounts

Scenario: You would like to Debit different General Ledger Expense Accounts when you issue stockroom material using the Dynamics NAV Item Journal. For instance, if the engineering department uses stock room inventory for a project, you would like to debit the Engineering Expense Account for the cost of the inventory. Without doing any additional setups,… Continue reading Using NAV Item Journal to Issue Items to Different Expense Accounts

LS Nav – Importing Image Files into the Retail Image Table

Hello again everyone! All of my obsessive Tomamaniacs may have noticed that this entry is on the retail blog instead of the normal ArcherPoint blog. Officially, I’ve joined the ArcherPoint Retail team to do development. In practice, that means that I deal with the retail customers and the specifics of LS Retail’s LS Nav product… Continue reading LS Nav – Importing Image Files into the Retail Image Table

New and Changed Item Setups for MRP Planning in Dynamics NAV 2013

The MRP planning functionality beginning with Microsoft Dynamics NAV 2013 has some changes from the previous versions of NAV to be aware of when setting up items for MRP planning. If we look at the Planning Tab of an Item Card, we can see the following new fields: Dampener Period Dampener Quantity Lot Accumulation Period… Continue reading New and Changed Item Setups for MRP Planning in Dynamics NAV 2013

Which GL Account Will Purchase Receipts and Invoices Post to?

The other day, the question came up about how to determine which Dynamics NAV General Ledger Accounts are posted to for a Purchase Receipt and Invoice. First, we need to find our way to the Item Ledger Entry for the receipt you want to analyze. Figure 1 – Item Ledger Entry showing the receipt to… Continue reading Which GL Account Will Purchase Receipts and Invoices Post to?

Purchasing Lead Time in Microsoft Dynamics NAV

There are actually two Purchasing Lead times in Dynamics NAV. If we look at the Replenishment and Planning Tabs of a Dynamics NAV Item Card or SKU Card, we see Lead Time Calculation and Safety Lead Time. The Lead Time Calculation is what most people would call Purchasing Lead Time. The reason it is called… Continue reading Purchasing Lead Time in Microsoft Dynamics NAV

A Brief Definition of Time in Microsoft Dynamics NAV Manufacturing

In order to set up Routings in Dynamics NAV and understand their Cost Accounting effects, one needs to know how time is defined. In a Routing there are ‘Value Added Times’ and times just for scheduling purposes.  Value Added Times Setup Time – The time to set up a machine or to get ready to… Continue reading A Brief Definition of Time in Microsoft Dynamics NAV Manufacturing

Optimizing SQL Server Through the Parallelism Feature

There are many default values within SQL Server’s instance level properties that allow it to function well out of the box without extensive modification. Tweaking these values to your specific environment/workload can provide optimization and a deeper understanding of your system. Two features in particular, with slight modifications, can make a significant impact on your… Continue reading Optimizing SQL Server Through the Parallelism Feature