• Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • Articles
  • FAQ

Olof Simren - Microsoft Dynamics 365 Business Central Blog

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • Articles
  • FAQ

About Olof Simren

I am a Microsoft Dynamics NAV and 365 Business Central Expert, I started implementing Microsoft Dynamics NAV in 2002, back then it was called Navision Attain. Throughout the years there has been many exciting implementations in different parts of the world, all of them with different challenges but with one common theme; manufacturing. As a consultant, I bring over 20 years of experience in implementing Microsoft Dynamics NAV and 365 Business Central within manufacturing and distribution companies. The services I offer includes project management, consultation, development and training. Feel free to contact me if you need help with anything related to Microsoft Dynamics NAV or 365 Business Central. I work through my company Naviona where I team up with other skilled Microsoft Dynamics NAV and 365 Business Central Experts.

Custom Filter Formula in Dynamics NAV 2013

Jul 1, 2014

One of the new features in Microsoft Dynamics NAV 2013 is the ability to enter formulas like ‘%me’ and ‘%myitems’ while setting filters. Dynamics NAV then replaces the formula with values while applying the filter. Some of the formulas that comes standard are for example; ‘%me’ and ‘%user’ will be converted in to the USERID, ‘%company’ will be converted into the COMPANYNAME, ‘%myitems’ will be converted into a string with the item numbers you listed in the My Items role center part (same goes for ‘%mycustomers’ and ‘%myvendors’). This is nice but what is great is that you can also...

Microsoft OneNote Integration with Dynamics NAV

Jun 24, 2014

I have never used Microsoft OneNote that much, never really seen a need for it (I usually just have my notes in Word). So, when Microsoft announced that there will be a OneNote integration with Dynamics NAV last year I didn’t think that much about it. But when I finally tried it out myself I was very impressed. I saw a very usable tool for both capturing comments/files related to entities NAV and for doing company specific instructions for the different parts of the application. The OneNote notes can be related to individual records or to a page in Dynamics NAV. (more…)

Connect a Customer with a Vendor

Jun 19, 2014

Sometimes a customer is also a vendor and sometimes a vendor is also a customer. It can for example be that a customer provides some components for an assembly that they have ordered or a vendor that also orders items from you. Microsoft Dynamics NAV has the option to link a customer with a vendor through the contact functionality. When you create a customer or a vendor, Dynamics NAV automatically creates a contact record for your. If you create them separately you will end up having duplicated contacts and a customer that is not linked to the vendor. The way...

Activate Item Tracking for Items with Ledger Entries

Jun 15, 2014

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...

Turn Report Selections into a Selection Dialog

Jun 12, 2014

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...

Production Lead Time using Routings

Jun 10, 2014

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...

The Low-Level Code

Jun 4, 2014

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...

Custom Business Chart Add-In Example for NAV 2013 R2

May 28, 2014

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)...

Cost Roll-Up Details on the Item Card

May 22, 2014

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…)

Production Order Posting to General Ledger

May 20, 2014

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...

  • 1
  • 2
  • …
  • 5
  • 6
  • 7
  • 8
  • 9

Subscribe to My Blog via Email

JumpStart Your ERP

ERP JumpStart

Check Out My Apps in AppSource

My Dynamics NAV Partner

Naviona, LLC

Categories

  • Assembly (3)
  • Development (35)
  • Finance (15)
  • General (29)
  • Inventory (25)
  • Manufacturing (37)
  • Miscellaneous (30)
  • Purchase (10)
  • Sales (11)
  • Warehouse (7)

Tags

.net Add-in AI AppSource Assembly Assembly BOM Business Central CAL Capacity Consumption Copilot Costs Customer Development Dimensions Excel Finance General Ledger Inventory Inventory Pick Item Item Tracking Item Tracking Lines Low-Level Code Manufacturing MRP NAV 2015 NAV 2016 Output Planning Production Production BOM Production Orders Purchase Orders Reports Role Center Routing Sales Order Security Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Pick Warehouse Shipment

Recent Posts

  • Approval Workflows in Planning Worksheet
  • ERP JumpStart: A Better Way to Get Started with Business Central
  • Quality Management in Business Central Version 28
  • Business Central Configuration Audit using Vibe Coding
  • Copilot in Planning Parameter Worksheet
  • Copilot in Planning Worksheet
  • Copilot Inventory Queries
  • Record Deletion Tool for Business Central in AppSource
  • Reopen Finished Production Orders
  • XML Buffer and CSV Buffer Tables

Categories

  • Assembly
  • Development
  • Finance
  • General
  • Inventory
  • Manufacturing
  • Miscellaneous
  • Purchase
  • Sales
  • Warehouse

Contact Us

We're currently offline. Send us an email and we'll get back to you, asap.

Send Message

Categories

  • Assembly (3)
  • Development (35)
  • Finance (15)
  • General (29)
  • Inventory (25)
  • Manufacturing (37)
  • Miscellaneous (30)
  • Purchase (10)
  • Sales (11)
  • Warehouse (7)

Tags

.net Add-in AI AppSource Assembly Assembly BOM Business Central CAL Capacity Consumption Copilot Costs Customer Development Dimensions Excel Finance General Ledger Inventory Inventory Pick Item Item Tracking Item Tracking Lines Low-Level Code Manufacturing MRP NAV 2015 NAV 2016 Output Planning Production Production BOM Production Orders Purchase Orders Reports Role Center Routing Sales Order Security Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Pick Warehouse Shipment

Recent Posts

  • Approval Workflows in Planning Worksheet
  • ERP JumpStart: A Better Way to Get Started with Business Central
  • Quality Management in Business Central Version 28
  • Business Central Configuration Audit using Vibe Coding
  • Copilot in Planning Parameter Worksheet
  • Copilot in Planning Worksheet
  • Copilot Inventory Queries
  • Record Deletion Tool for Business Central in AppSource
  • Reopen Finished Production Orders
  • XML Buffer and CSV Buffer Tables

Recent Comments

  • Olof on Business Central Configuration Audit using Vibe Coding
  • Andrew Trayfoot on Business Central Configuration Audit using Vibe Coding
  • Barrett Allen on Reopen Finished Production Orders
  • Kateryna on Business Central Configuration Audit using Vibe Coding
  • Takeshi Setoya on Reopen Finished Production Orders
  • Steve on Consignment Inventory
  • Olof Simren on Copilot in Planning Worksheet
  • Omaer Amjad on Copilot in Planning Worksheet

© 2026 · Olof Simren

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • Articles
  • FAQ