Blog Posts | Olof Simren - Microsoft Dynamics 365 Business Central Blog

15 Jun

Activate Item Tracking for Items with Ledger Entries

Posted by Olof Simren Development, Inventory, Miscellaneous 5 Comments

A common request is to activate item tracking (lot numbers and/or serials numbers) for items that already have transactions (item ledger entries). In Microsoft Dynamics NAV you can’t really do this without going ‘behind the scenes’ and tweaking the data. What I have done a couple of times is to change the check on the item tracking code to only check for open item ledger entries. This way you can adjust the inventory out, change the item tracking code, and then put the inventory back in with the lot and/or serial numbers. This is a one line code change that […]

12 Jun

Turn Report Selections into a Selection Dialog

Posted by Olof Simren Development, General, Miscellaneous, Sales 2 Comments

Here is a small trick that I have used a couple of times to turn the report selections into a selection dialog in Microsoft Dynamics NAV. The report selection table in Dynamics NAV is used to specify what report(s) to run when a user prints a document such as an order confirmation. Part of the report selection functionality is the ability to define more than one report to print at the same time; you can for example have Dynamics NAV print three different documents when the user prints an order confirmation. This is done by listing the reports in the […]

10 Jun

Production Lead Time using Routings

Posted by Olof Simren Manufacturing 16 Comments

The production lead time if you are using routings in Microsoft Dynamics NAV is the sum of the lead times for the operations that each can have 5 different time components; queue time, setup time, run time, wait time and move time. In addition to the production lead time is the safety lead time defined on the item or stockkeeping unit card of the product being produced; this adds a slack time between the scheduled ending time for the last operation and the due date of the production order. The below illustrates the different times and how they together makes up […]

04 Jun

The Low-Level Code

Posted by Olof Simren Inventory, Manufacturing 9 Comments

Do you know what the low-level code in Microsoft Dynamics NAV is used for? And do you know how it is maintained? The low-level codes are critical for Dynamics NAV to function properly in a manufacturing environment where material planning takes place (which is in 9 out of 10 places). In addition to this, the cost adjustments in Dynamics NAV are also using the low-level codes. The low-level code is a field in the item table that represents the items lowest level of usage in the production BOM or assembly BOM structures. It is used internally by Dynamics NAV to determine […]

28 May

Custom Business Chart Add-In Example for NAV 2013 R2

Posted by Olof Simren Development, General, Manufacturing, Miscellaneous 7 Comments

Here is an example of how to create a custom chart in Microsoft Dynamics NAV 2013 R2 using the business chart control add-in that is provided by the Microsoft.Dynamics.Nav.Client.BusinessChart.dll assembly. It sounds complicated, but it is actually quite easy. The example shows how to create a work center load chart that shows available vs. allocated capacity on a day by day basis. If you have read some of my previous blog posts (the Custom Progress Bar or Interaction Between Role Center Parts) you know that I am working on a shop floor terminal role center (more for my own training) […]

22 May

Cost Roll-Up Details on the Item Card

Posted by Olof Simren Miscellaneous 2 Comments

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.

20 May

Production Order Posting to General Ledger

Posted by Olof Simren Finance, Manufacturing 12 Comments

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 […]

14 May

BOM Cost Share Distribution Report

Posted by Olof Simren Manufacturing 1 Comment

One of the new reports in Microsoft Dynamics NAV 2013 is the BOM Cost Share Distribution Report that came with the assembly functionality. It is a great looking report, and what makes it even better is that it does not only work with assembled items but also with manufactured items.

11 May

Interaction Between Role Center Parts in Dynamics NAV 2013 R2

Posted by Olof Simren Development, General, Miscellaneous No Comments

I thought it would be cool to be able to get the role center parts to interact with each-other in Microsoft Dynamics NAV 2013 R2. I wanted to see if it was possible to have a role center part to display different information based on what was highlighted in another role center part. This way the role center itself would become more interactive. To test this I wanted to have a role center part with a task list for a work center and based on what operation that was highlighted the related components from the production order should be displayed in another role center part. […]

08 May

Discrepancy Between Purchase and Direct Cost Applied

Posted by Olof Simren Finance, Inventory, Purchase 13 Comments

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.

Olof Simren - Microsoft Dynamics 365 Business Central Blog

Activate Item Tracking for Items with Ledger Entries

Turn Report Selections into a Selection Dialog

Production Lead Time using Routings

The Low-Level Code

Custom Business Chart Add-In Example for NAV 2013 R2

Cost Roll-Up Details on the Item Card

Production Order Posting to General Ledger

BOM Cost Share Distribution Report

Interaction Between Role Center Parts in Dynamics NAV 2013 R2

Discrepancy Between Purchase and Direct Cost Applied

Subscribe to My Blog via Email

Check Out Our Apps in AppSource

My Dynamics NAV Partner

Categories

Recent Posts

Categories

Subscribe to My Blog via Email

Check Out Our Apps in AppSource

My Dynamics NAV Partner

Categories

Tags

Recent Posts

Categories