This is something that I did some days ago and I thought it was creative enough to be worth a blog post. The task was to do a onetime mass update to the item records. There were more than 85.000 items in the company and they all had two production bin fields that needed to be updated according to a table with some rules provided in Excel. For items starting with ’10’ the two fields should be ‘RAW’ and ‘RAW’, for items starting with ‘11’ the two fields should be ‘TREATED’ and ‘CUT’, etc. like the below table, nothing strange. (more…)
Here is a small tip (some of you might already know it): the GETURL together with the HYPERLINK can be used to run objects in NAV 2013 (even tables 🙂 ). I am working on a tool to delete records from a database (to ‘clean’ a company from transactional data for example). Part of this tool is a function to view the data in the tables, and for this I needed a way to run a table from the NAV 2013 windows client (not the development environment). This turned out to be quite easy using the GETURL and HYPERLINK functions. (more…)
For those of you that are reading my blog posts you probably know that I have been working on a Shop Floor Terminal role center for Microsoft Dynamics NAV (mostly for my own training, kind of how I learn). I have finally got some time to finish it (was stuck at Tampa airport for 3 hours before a 3 hour flight, more or less an entire work day in transit), so here it is! The concept with the Shop Floor Terminal role center is to provide an interface for a terminal in the production where the operator can see upcoming...
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...
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…)
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...
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...
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)...
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…)
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....
