Negative Consumption to Account for By-Product Production It is quite common in Process Manufacturing for a By-Product to be produced at the same time the primary product is produced. A good way to handle that in Dynamics NAV is to set up an item for the By-Product and give it a costing method of Standard.… Continue reading Manufacturing Process Software
Do What You’re Doing
We have a saying around the Britt household, “Do what you’re doing”. When you sit down to eat supper with your family, you are sitting down to eat supper with your family. You aren’t watching television, you aren’t texting, you aren’t reading; by golly, you are sitting down to eat supper with your family! You… Continue reading Do What You’re Doing
Understanding the Order Reordering Policy in Microsoft Dynamics NAV
We are given the following choices for Item Reordering Policy in Dynamics NAV. The choice affects how the Planning Worksheet (MRP) plans for replenishment of the item. Blank Fixed Order Quantity Maximum Quantity Order Lot-for-Lot Figure 1 – List of choices defining how the Planning Worksheet (MRP) plans for replenishment of an item If we… Continue reading Understanding the Order Reordering Policy in Microsoft Dynamics NAV
Circular Reference in Microsoft Dynamics NAV Production BOM
A client called the other day and said that they were getting an error, “Max Levels in BOM Structure on 50 is too high”, when trying to ‘Certify a Dynamics NAV Production BOM’. This is caused by what is known as a circular reference or an item used on itself. Figure 1 – Error displayed… Continue reading Circular Reference in Microsoft Dynamics NAV Production BOM
When Do You Need to Upgrade Microsoft Dynamics NAV?
As time passes by, everything gets upgraded. Do you remember the old computers running Windows 98, with 256 MB of Ram and 10 GB of hard disk space? The only way to share information back then was by using unreliable floppy disks. But as we progressed through the years, we have had to keep pace… Continue reading When Do You Need to Upgrade Microsoft Dynamics NAV?
Item Category and Product Group Code in Microsoft Dynamics NAV
There was a question recently on a Dynamics NAV Forum asking, “What is the Product Group Code on the Item Card used for?” If we look at an Item Card in Dynamics NAV, we see the field for Product Group Code. Above it, there is a field for Item Category Code. Figure 1 – Item… Continue reading Item Category and Product Group Code in Microsoft Dynamics NAV
How to Block a Location in Microsoft Dynamics NAV
We have seen some questions on the various Dynamics NAV Forums about how to ‘Block’ a location in Dynamics NAV. Unfortunately there isn’t a current method to do so, so we offer this work-around. It is not the perfect solution, but it works. NOTE: This work-around is to not create (or remove) the Inventory Posting… Continue reading How to Block a Location in Microsoft Dynamics NAV
Storing Purchase Documents in Dynamics NAV 2016
It can’t be that easy … But with Microsoft Dynamics NAV 2016, it can be! I just ran across a feature that really amazed me because of how easy it is, so I want to tell everyone. The feature is storing documents attached to Purchase Orders and Invoices. In previous blog, I demonstrated how to… Continue reading Storing Purchase Documents in Dynamics NAV 2016
Utilizing Lanham’s Duplicate PO Check in NAV 2016
Lanham introduced functionality within their mapping tool to check for duplicate POs when importing Sales Orders via EDI in version SE060. This new functionality looks at posted and unposted Sales Orders to determine if the External Document Number sent in on a Sales Order already exists. It allows you to specify the amount of history… Continue reading Utilizing Lanham’s Duplicate PO Check in NAV 2016
Microsoft Dynamics NAV Manufacturing Balance Sheets
We frequently encounter clients with an unexpected Manufacturing WIP Balance. In some cases, the WIP balance is below zero. In the screen shot below, we can see that the WIP account has a negative balance, which in the real world we know cannot be true. Figure 1 – WIP account shows a negative balance, reflecting… Continue reading Microsoft Dynamics NAV Manufacturing Balance Sheets