Finding the User ID on Inventory Transactions in Dynamics NAV

There are times when you would like to know the person’s name that posted an entry to inventory. When you look at the Item Ledger Entry for the User ID, you cannot find it there. To locate the User ID for the person who posted the transaction to inventory, drill down on the Cost Amount… Continue reading Finding the User ID on Inventory Transactions in Dynamics NAV

Landed Cost when Using Dynamics NAV Standard Cost Method

There are times when a company wants to add “Landed Cost Elements” to inventory as part of the procurement process. This could be freight, duty, drayage, or storage. The setup and accounting for a provision for landed cost when using the Standard Cost Method is different than when using all of the other costing methods… Continue reading Landed Cost when Using Dynamics NAV Standard Cost Method

Specific Costing Method and Serial Number Tracking in Dynamics NAV

Dynamics NAV allows us to choose between FIFO, LIFO, Specific, Average, or Standard Costing Methods (see the related blog, Which Microsoft Dynamics NAV Costing Method Should Manufacturers Choose?) We have not encountered many companies using the Specific Costing Method, but there seems to be some misunderstanding of how the Specific Costing Method requires Serial Number… Continue reading Specific Costing Method and Serial Number Tracking in Dynamics NAV

How to Run Tables in Microsoft Dynamics NAV 2009 RTC or NAV 2013

For consultants who are not a developers, it is frustrating not to be able to “Run Tables” as we used to do from the Dynamics NAV Classic Client Object Designer. We frequently need to Run Tables for diagnostic and analysis purposes. There is a very simple solution. Example: You want to make a list of… Continue reading How to Run Tables in Microsoft Dynamics NAV 2009 RTC or NAV 2013

Can Items be Deleted in Microsoft Dynamics NAV?

The question often comes up, “Can items be deleted in Dynamics NAV?” There are two answers: If there are no item ledger entries for the item, then Dynamics NAV allows the item to be deleted without condition. But if there are item ledger entries for the item, then Dynamics NAV restricts the deletion to items… Continue reading Can Items be Deleted in Microsoft Dynamics NAV?

Breaking out Material, Labor, and Overhead for the Balance Sheet

There are companies that desire to break out Material, Labor, and Overhead for their Balance Sheet and for COGS. Unfortunately, Microsoft Dynamics NAV only has a single number available for Inventory for the Balance Sheet and COGS. Dynamics NAV has a report that will break down these numbers for all costing methods. It is called… Continue reading Breaking out Material, Labor, and Overhead for the Balance Sheet

Options for Entering Package Dimensions Using Lanham E-Ship

NOTE: This blog is part two of a two-part series. Be sure to read Part 1, Package Dimension Requirements when Shipping with Lanham E-Ship. If you are using E-Ship by Lanham Associates, there are existing setup and processing options available to assist in entering dimensional information during shipment preparation.  This blog discusses the options available for specifying… Continue reading Options for Entering Package Dimensions Using Lanham E-Ship