There are times when the engineering department will construct a Bill of Material for a functional part of a design, but in production the Bill of Material is never produced as a sub-assembly, but rather is built as part of the final assembly process. A Bill of Material used in this manner is called a… Continue reading Phantom Bills of Material in Microsoft Dynamics NAV
Category: How To
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
Microsoft Dynamics NAV 2013: A guide to (very) minor editing of pages
The first time I learned how to add a field to a form in Navision, I was astounded at how easy it was to do. It was the first time I had worked with an ERP database and found that the simple act of dragging and dropping fields where you wanted them on the form… Continue reading Microsoft Dynamics NAV 2013: A guide to (very) minor editing of pages
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
Rolling Up Standard Costs in Microsoft Dynamics NAV
There are times when you may want to establish or reestablish Standard Cost for Items: For all new items When you find a significant mistake in the purchased item cost, the Production BOM, and/or the Routing and want to make a correction When there has been a significant change in the cost of raw materials… Continue reading Rolling Up Standard Costs in Microsoft Dynamics NAV
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