This might be ‘the oldest trick in the book’ but it is still a frequently asked question and therefor I thought it was worth a small blog post. The question is how do you block/prevent users from posting something in Microsoft Dynamics NAV? (more…)
This is the third post in a series of subcontracting blog posts, and it starting to get a bit tricky. The topic is how to handle transport charges for subcontracting operations. In other words if you have a vendor that handles parts of the production process and you receive an invoice from a shipping agent/transportation company for the transportation of products either to and/or from the subcontractor. If you haven’t read part 1 and part 2 it might be a good idea to read those first, this post assumes you know the basics of subcontracting and uses the same items...
Here is a super simple, but very useful modification for displaying the rolled-up costs on the item card in Microsoft Dynamics NAV. The item table has 10 standard fields that contain the rolled-up costs that are calculated during a regular standard cost roll-up. Those fields are not by default added to the item card; just adding them is quick and adds lots of values to the users that are looking at the costs shares of items. (more…)
How Microsoft Dynamics NAV posts into the general ledger from production orders is something that you must know when implementing it in a manufacturing environment. It is critical in order to get the posting groups and their related accounts correctly defined. This blog post will focus on the general ledger accounts and the amounts, for details about what dimensions that are used, see my previous post; Dimensions on Production Orders. The examples that are described are using the expected cost posting (setup in the inventory setup), which to me is the preferred way to setup Dynamics NAV. Without the expected cost posting...
In school we where told that when you invoice (voucher) received inventory you get a debit transaction against the inventory account and a credit transaction against the accounts payable. Well, in Microsoft Dynamics NAV you also get two transactions in the P&L, a debit against the purchase account and a credit against the direct cost applied account. What are those used for? Wouldn’t they always be the same and net each-other out? Not necessarily. There is a special case to consider where the two transactions in the P&L are not the same and therefore a discrepancy between the two accounts will occur....
The dimensions involved in posting production orders are a bit interesting. It is interesting since there is a slight difference between on how they behave compared to other parts of Microsoft Dynamics NAV (like the sales and purchase orders). It can be argued what is right and wrong, but knowing how it works in standard Dynamics NAV is requirement for setting a system that is easy to work with and provides correct reportable and understandable data. As an example; if you have default dimensions on the items and set them up with the ‘Value Posting’ equal to ‘Same Code’ and...
Can Dynamics NAV handle statistical (unit) accounts in the General Ledger? Yes, it can! Although there is nothing in Dynamics NAV called statistical accounts, so the main thing is to make sure you are not mixing them into the regular g/l accounts. (more…)
Dimensions are great in Dynamics NAV and one of the things that makes it great is that you can control the required dimensions for each type of posting into the general ledger by setting dimensions as mandatory on the general ledger accounts. Most people that work with Dynamics NAV knows this. But surprisingly many people does not know that you can also specify what dimensions that are mandatory for each account type by using the ‘Account Type Default Dimension’ setup. (more…)