Reports join different views of data in one place. You design reports in Microsoft Dynamics NAV 2013 using the Microsoft Dynamics NAV Development Environment and Microsoft Reporting Services.
For Microsoft Dynamics NAV 2013, we have created report design guidelines to help you take advantage of the power of Microsoft Reporting Services.
The basis for the design guidelines is twofold: They should benefit the customer using a report and they should help the partner designing a report.
For customers to be effective using reports in Microsoft Dynamics NAV 2013, the design of the reports should be such that the reports are:
To help partners in designing reports, we have based the principles of the report design guidelines for development on:
All reports in Microsoft Dynamics NAV 2013 can be classified as one of three types:
Document Reports: Sales Invoice
Simple list reports: Resource Usage
Grouped list reports: Customer – Detail Trial Bal.
The following shows the Microsoft Dynamics NAV 2013 report design guidelines, wrapped in a checklist. It is divided into three sections: canvas, header and body.
Example of a Document Report Design
For more information, see Report Design Guidelines on MSDN.
Back when we released Microsoft Dynamics NAV 2009 and transformed all our classic reports to RDLC reports, dataset field names were auto-generated and were also used in the RDLC definition of the report object. This solution did a great job ofmaking the reports work with RDLC, but the auto-generated names were not meaningful.
For Microsoft Dynamics NAV 2013, we have therefore cleaned up the reports to gain better maintainability and compatibility with the latest version of RDLC. The project actually went further than that, and we included a visual update of external reports, such as document reports, using new user experience (UX) report guidelines.
In summary, we have:
The result of all this work is that Microsoft Dynamics NAV 2013 has reports that are easy to maintain and that bring additional value to customers and partners.
In NAV 2013, the out-of-the-box experience shows how RoleTailoring makes a difference.
All 21 pre-defined user profiles have been updated to include configuration of individual pages to fit the work of each user profile. This affects the list places in the navigation pane, all associated ribbons, and the majority of list places in the departmentpage.
Benefits for customers include:
Benefits for partners and super users at customers include:
In order to understand how the final user interface has been built up for Microsoft Dynamics 2013 RTM, a short description of the three stages of the delivery is described below. The same sequencing is recommended for partners that want to integrate their solution in Microsoft Dynamics NAV 2013.
In summary, the 3 stages are:
Stage 1: Changes in the Page Object Actions (ActionItems, RelatedInfoItems, Reports)
The recommended changes are:
Example of a giant ribbon action group in the Navigate tab (the “Item” group has 22 actions/dropdowns):
Example of a “giant” ribbon action group (the “General” group has 20 reports):
Examples of new action groups created to avoid Giant groups. This work is not carried into the Home tab. To promote action is considered as a configuration task.
Example of a quick entry implementation on Sales Order page where only No.; Sell to Customer No.; Requested Delivery Date; and External Document No.; are "mandatory" to pause by or amend when using the Enter key. Skipping 6 fields in W1. In the following illustration, the QuickEntry property is set to FALSE on Sell-to-Customer Name. In general all fields that have a defaulting mechanism (the various dates on sales order) or are retreived by master record are skipped.
Stage 2: Establish a Configuration Baseline with a New “Master Page” Concept
To provide the most flexibility in configuration, Microsoft Dynamics NAV 2013 allows pages to be configured differently dependent on how a page is opened. For example, a list used for lookup can be configured differently from how the same list looks when opened as a listplace. Conversely, in cases where in fact the same configuration should be used regardless of where a page is opened from, it is necessary to duplicate the configuration.
Because this duplication was a frequent need during the work to configure W1, an internal tool was developed that included the concept of a "master page". A master page for each list and card page was crafted and duplicated in the Department page (and other places), so the user gets configured pages regardless of whether they come from the navigation pane or the Department page. The "configured" page included in Department was the one from the most predominant role - e.g.: the Sales Order list optimized for the Sales Order Processor is the "default" Sales Order list for all profiles when accessing the Department page. The Purchasing Agent optimized Purchase Order should be the one included in the Department page, the Finance pages optimized for the Accounting Manager are included in the Department page, etc. The basic configuration of pages that was duplicated as described includes:
Example on Sales order card page: Release and Posting are groups placed where frequency is the design criteria. Prepare, Order, and Documents reflects a sequence of activities.
On the Actions Tab, the positioning of the Posting group follows the sequence of tasks.
As an example, see the following screenshots of the non-configured ribbon for the sales Journal List place Home and Action tabs:
The following is the configured ribbon for the same page (Sales Journal List place) without redundant Actions Tab and without the group "Show as Chart"
The integration to Office is included by default in the NAV Application menu:
Examples of integration to office - Excel for list, Email or Word for Document or Card page:
You can select the "Customize FastTab" button on the Customize page, and then select Quick Entry for fields. You do not need to select Quick Entry for fields with the Importance set to "Additional." (The "Additional" fields are fields that are included when you click "Show more fields.")
Some pages like the Job Journal with integration to several application area and a complex functionality benefit greatly from a Freeze pane when working with the lines.
All list places on the Navigation pane have received a Freeze pane, usually with No. field. The description field is usually placed just after the freeze pane. Note: a quick way to see if a page has been configured is to see if there is a freeze pane defined or a promotion of a Send To group is created. These are two examples of improvements that are not defined out-of-the-box on the page object.
Creation of new tabs: The following is the Accounting Manager Role Center. To avoid giant groups and to make the Actions group more readable, several actions have been placed under new tabs. One example is the Setup tab. An analysis of what are the frequent Setup tasks of an accounting manager suggested that some VAT setup and some other general setup could be included. Since these additions were made at Configuration time, there are no actions in the page object that can be assigned an icon. This also demonstrates the current lack of ability to add an icon at the time of promoting an action to the Role Center ribbon.
Stage 3: Finalize the Role Tailoring experience
The third and final stage of RoleTailoring relates to the configuration one carries out for individual user profiles. Needless to say, this is when your knowledge about the roles and responsibilities of the individual user profiles come into play. Overall, this is how this stage of configuration was implemented in Microsoft Dynamics NAV 2013:
The following are three examples with Item card. Purchasing agent, including journals:
Warehouse responsible, excluding journals, bringing Bin Contents to a predominant place. Depending on the company flow, it can be simplified much more, for example, by removing reports and Requisition Worksheet.
Service Technician, excluding journals, add Service group. Requisition Worksheet is kept in case the technician has his own batch, where he can add missing parts for the consideration of the Purchasing agent.
The following are two examples with the Sales Order page. Sales personnel, Purchase and Finance:
Warehouse Responsible, location with WMS: Sales Order, no posting group, only Create Whse Shipment (the posting is done at the warehouse shipment):
The following are two examples with Customer page. Warehouse Responsible, location with WMS:
Sales order line for a warehouse responsible:
Sales order Lines for a Purchasing agent:
The following example is from the Accounting Manager profile where the vendor ledger entries has been added to the navigation pane and a view is created for purchase invoices due today.
On the Sales Invoices “Pending Approval” view (built up filtering on sales, invoices pending approval), the following actions are promoted: “Release,” “Cancel Approval,” and “Approvals.” The Posting group and the Reopen, SendApproval Request etc., are not promoted because these actions are not relevant for the view.
On the subsequent “Approved” view, the "Reopen" action is promoted and the Posting group is added.
Issues to Note
Known Issues for Profiles or Limitations in the Configuration Capabilities
The following issues exist with the configured ribbons:
The configuration capabilities are evolving with the following not currently available in the product:
Deleted or Promoted Actions
The following table shows pages in the local version of Microsoft Dynamics NAV 2013, which contain actions that have been deleted or promoted to another group, with a recommendation for a possible resolution.
9020 - Small Business Owner RC
Sales Order (42)
Delete the action or delete and move the duplicate action from the "New Document" group.
Purchase Order (50)
43 - Sales Invoice
Delete the action.
44 - Sales Credit Memo
507 - Blanket Sales Order
509 - Blanket Purchase Order
51 - Purchase Invoice
52 - Purchase Credit Memo
6630 - Sales Return Order
6640 - Purchase Return Order
132 - Posted Sales Invoice
5743 - Posted Transfer Shipment
9004 - Bookkeeper Role Center
Sales Invoice (43)
Replace caption with "Sales Invoice".
Purchase Invoice (51)
Replace caption with "Purchase Invoice".
16 - Chart of Accounts
Detail Trial Balance (4)
Replace caption with "Detail Trial Balance"
21 - Customer Card
27 - Vendor List
Vendor List (27)
Payments on Hold (319)
370 - Bank Account Card
Bank Account Statement List (389)
Replace the caption with "Bank Account Statement List".
371 - Bank Account List
Replace the caption with "Bank Account Statement List"
434 - Reminder
Customer - Trial Balance (129)
Replace the icon with "Customer - Trial Balance"
Purchase Order (50
Replace the caption with "Sales Invoice".
Replace the caption with "Purchase Invoice".
Senior Program Manager
Reports join different views of data in one place. In Microsoft Dynamics NAV 2013, reports are delivered in RDLC 2008 format, supported by Visual Studio 2010. The RDLC 2008 format and Visual Studio 2010 offers Microsoft Dynamics NAV reports much more richness, so that the reports can be compelling, more readable, and more easily understood.
Since RDLC 2005, which was used by Microsoft Dynamics NAV 2009, you can get a better overview of the presented data, such as by grouping data through coloring, or by visualizing data through charting, for example. The format also makes it possible to interact dynamically with reports on screen so that you have a better experience searching for data. For example, you can link from one report to another report, and you can even link to a page. In this release, we have used these features in some of our reports.
The following sections provide a quick overview of the main changes to reports and where you can find examples of how they are used in Microsoft Dynamics NAV 2013.
Charts in Reports
Charts can be used so that customers get the most out of their data. At a minimum, charts should be readable, be understandable, and identify actionable tasks. They should help users find items of interest or outliers in business data based on objectives or measures.
RDLC 2008 supports different types of charts. In Microsoft Dynamics NAV 2013, reports use the following chart types:
Charts are used in the following reports in the W1 version of Microsoft Dynamics NAV 2013:
Grouping Data with Color
You can use shades of colors to group data visually. This improves the readability of the report by emphasizing similar kinds of data. This type of coloring can improve reports that contain lists, such as the Customer Detailed Aging report, wherewe have applied a color to group the lines for each customer. Coloring is implemented in several reports in Microsoft Dynamics NAV 2013, such as:
Drill-Through Reports and Hyperlinks
When a report gives you the ability to drill through to the underlying data, you are more likely to find the right data. You can create a report that enables a user to go from the high-level overview to a detailed view with a single click. You can also provide hyperlinks that open another report or a page. Situations where it is useful to drill down into specific information include navigation from a customer to the customer's phone number or from a total amount to the underlying transactions.
For example, in the Inventory Valuation report, you can choose the item number for an inventory item, and this opens the Inventory Valuation – Cost Specification report for that item.
Hyperlinks are implemented in the following reports:
It’s easier to get the view that you want if you can change the order of rows of data, based on the sort order of the specified column. We have enabled sorting on-the-fly in some reports, so that you can easily visualize the right priorities. In most cases, the sorting has been enabled on name, number, and amount fields. The sorting that is applied during preview of the report is what will also be used during printing.
Sorting is enabled in the following reports:
You can find technical information on the Microsoft Developer Network (MSDN): http://msdn.microsoft.com/en-us/library/dd338753(v=nav.70).aspx.
Microsoft Dynamics NAV 2013 ships with a fully integrated Timeline Visualization tool. It provides the user with a visual projection of future supply and enables the user to make modifications on the fly.
The Timeline helps you understand and optimize your inventory profile with its visual projection of future supply, demand, and planning data.
Who Will Benefit from the Timeline?
Well, the initial idea with the Timeline was to create a tool that would bring clarity to specific supply and demand situations. It was intended to help the planner analyze the planning output and quickly make adjustments. However, we quickly realized that this was a great tool for other types of users, including sales people, purchasers, and so forth.
Okay, So What Does It Do?
Basically, the Timeline Visualization displays a visual projection of the future inventory level for a specific item or SKU, based on supply from Purchase, Prod. Output, and other areas, and demand from Sale, Prod. Components, Forecast, and so forth. On top of this, you can choose to include planning suggestions – giving you a chance to see and modify the plan prior to executing on it. All of this takes place outside the Requisition Worksheet, so you can play with the quantities and dates until you are satisfied and then save the changes to the worksheet.
Timeline Usage Examples
The Microsoft Dynamics NAV 2013 release includes a set of new supply planning options, aimed at the following goals:
So, now you might start to wonder: Is this relevant to me? A fair question, which will probably also be raised in many upgrade, sales, and implementation situations.
The short answer: If you are working with either the Requisition or Planning Worksheet, then this change is relevant.
So What Changed?
On the Item card and SKU card on the Planning FastTab, the Reorder Cycle field has been removed and split into four new fields, making it possible to have different values for:
On the quantity side, you will also find a few new fields:
Note: The reorder point is now triggered when inventory level is equal to or below. In earlier versions, it used to be only below.
This was done to align with manufacturing standards and to address the situation when the safety stock quantity and reorder point had the same value.
During upgrade from earlier versions with low repoint values, you may need to update the Reorder Point to reflect this change. For example, if you have a Reorder Point of five pieces (with a rounding factor of one) in Microsoft Dynamics NAV 2009, this would trigger a supply when inventory dropped below five pieces, to four pieces. In Microsoft Dynamics NAV 2013, the Reorder Point would have to be four to get the same planning result.
With the new layout on the Planning FastTab, the planning fields are now grouped based on when they are used. So if you use the Lot-for-Lot Reordering Policy, you should focus on the Lot-for-Lot Parameters and if you use Fixed Reorder Qty. or Maximum Qty. you should focus on the Reorder-Point Parameters.
When you are done with the setup and turn to Calculate Regenerative Planning from either the Requisition or Planning Worksheet you should pay attention to a new option to respect planning parameters:
When you select this option, the calculation will respect the planning parameters even when Microsoft Dynamics NAV has to make an exception order to avoid having the inventory level dropbelow the safety stock level. If you do not select this check box, the calculation will just create a suggestion to cover the safety stock level – regardless of most planning parameters, as in Microsoft Dynamics NAV 2009.
Are you spending too much time analyzing and understanding the planning suggestions?
The new FactBoxes on the Requisition and Planning Worksheet make it easier to get a full overview, by displaying both item details for Replenishment, Planning, and Warehouse as well as details for the Untracked Planning Elements for each line in the worksheet. So make sure you display the FactBoxes relevant for you.
If you want more information on Supply Planning in Microsoft Dynamics NAV 2013, one place I suggest you turn is to the Readiness material on Microsoft Dynamics PartnerSource site. In general, you should also take a look at the product Help, in the box and on Microsoft Developer Network (MSDN), which got quite an overhaul and now includes content from relevant whitepapers.
Sometimes we need to run some specific object (page, report, codeunit or xmlport) on Microsoft Dynamics NAV 2013 Role Tailored Client. Let say we want to test report received from customer on our Cronus demo db.
The easiest way is of course to run report directly from Microsoft Dynamics NAV 2013 Development Environment Object Designer. However, if we have few client versions on our pc then this way could be impossible
Then we can add run object as action in initial role center.
Again, I need to create action for every new object I want to test – unproductive.
Faster way is to add new menu shortcut in menu suite 1010, then it populates to RTC menu.
Nevertheless, this action need to be repeated for every object I want to test...
Finally, I have chosen another way:
Now I have:
Now whatever I import to object designer I can it run directly from RTC.Moreover, I can run even objects from standard application if I do not know how to find it in menus :)
These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use.
Gedas BusniauskasMicrosoft LithuaniaMicrosoft Customer Service and Support (CSS) EMEA
Sometimes we need to have few Microsoft Dynamics NAV 2013 services connected to different SQL databases but running on the same server. Let us say few developers are working on different databases and want to see how RTC works with their customizations. Or maybe we want to compare how different RTC versions/builds work and want to compare functionality.In article http://blogs.msdn.com/b/nav/archive/2009/11/17/how-to-run-2-rtc-on-the-same-pc-and-connect-it-to-different-db-how-to-run-pages-reports-from-diff-db.aspx I described how to have few RTC on the same client computer in NAV 2009. This is also very useful now in NAV 2013, but let us look what new we have in NST site in NAV 2013
With Microsoft Dynamics NAV 2013 we have few solutions how to create new NAV service (NST). First NAV 2013 Service we already have installed by NAV DVD and now we want to have more
In both ways created services can be managed using Microsoft Dynamics NAV Administration Tools, so it is very easy modify services for any further needs. However if we try to remove service by using function “Remove”, then tools uninstall service and remove folder (including all binaries) and this can be problem if we have few services based on the same binaries folder.
Few Microsoft Dynamics NAV 2013 services can share the same TCP communication ports (Attention: do not mix it with NAV 2009). However, here are few tricks need to do before we use port sharing:
In Microsoft Dynamics NAV 2009, the RoleTailored client could only be deployed using a standard Windows Installer (.msi). While this is a common scenario, .msi-based deployment requires the partner to do customer visits, do remote logons, or educate the customer’s IT administration to install the Windows client and any additional add-ins, change any client-side settings, or upgrade the client (manually or through group policy).
This approach does not scale well in on-premise solutions that have a lot of users or in volume Azure or syndication scenarios when the Windows client is needed rather than a Web client for deeper functionality or better performance.
Thus, in Microsoft Dynamics NAV 2013 a new way of deploying the Microsoft Dynamics NAV Windows client, using ClickOnce, has been introduced, providing benefits such as:
These benefits allow for a more streamlined and centralized deployment of the Microsoft Dynamics NAV Windows client in high volume scenarios such as Azure.
In this blog post we’ll dig a bit into ClickOnce, the end-user and partner experiences, and the benefits and current limitations of deploying the Microsoft Dynamics NAV 2013 Windows client using ClickOnce. In other blog posts about implementation, we’ll dive into the technical details around how to actually create a ClickOnce application for the MIcrosoft Dynamics NAV 2013 Windows client.
ClickOnce is a standard deployment technology — starting with .NET Framework 2.0 — that allows you to create self-updating Windows-based applications that can be installed from a Web server or network file share and run with minimal user interaction. It addresses three major issues in deployment:
In use, ClickOnce is basically a configurable file copy from a repository to the client machine that, at a high level, consists of three parts:
With the above created, the application can be installed by the end user by running the deployment manifest. Typically, this is accomplished by hosting the above files and providing a link to the application and deployment manifest to the end user, for example, on a landing page or in an email message, after the user has signed up for a solution and required a client to be installed.
For more information on ClickOnce, see ClickOnce Security and Deployment in the MSDN Library.
The End-User Experience
To install Microsoft Dynamics NAV 2013 using ClickOnce deployment, the end user will choose the link to the application, the deployment manifest, that is provided in a landing page or email message. The link may point to a file share or a website. Using the .NET Framework on the client machine, the ClickOnce runtime runs the linked deployment manifest and opens with a confirmation dialog box, such as the dialog box shown in the following illustration.
If the user chooses the Install button, ClickOnce downloads all the necessary files to a local folder on his computer. This folder is a per user folder, located in the ClickOnce generic application cache for the user: <user>\AppData\Local app folder), not in the standard Program Files folder.
When the installation is complete, ClickOnce installs a program shortcut on the Start menu and starts the Microsoft Dynamics NAV 2013 Windows client, using the connection settings provided as part of the installation. No configuration is needed during or after installation as this is set up as part of the ClickOnce Windows client application.
The next time that the end user wants to run the Windows client, he can either select the link again, or he can select the shortcut on the Start menu. In either case, ClickOnce will check if there is a newer version available, which the user will have the option to install.
The Partner Experience
To create a ClickOnce deployment of a Microsoft Dynamics NAV 2013 client with settings, add-ins, and so forth, the typical process for a partner is to:
The above process will typically take 30-60 minutes to set up the first time. Repeating this process on changes in low fluctuating on-premise installations makes sense. In the case where the same vertical solution and Windows client setup is to be used by multiple different customers, the clientusersettings.config file will be different, it is better to streamline the above process by creating a script for creating the basic customer-agnostic client installation, and then inject clientusersettings and recompile and sign on the fly.
As mentioned, in other blog entries we’ll dig into the technical steps on how to set up a ClickOnce deployment. See also the Help topic Deploying Microsoft Dynamics NAV Using ClickOnce in the MSDN Library.
Benefits of a ClickOnce Deployment of the Microsoft Dynamics NAV 2013 Windows Client
ClickOnce deployment resembles traditional Windows Installer-based deployment. In addition to .msi-based deployment functionality, ClickOnce provides the following benefits:
The result is that end users can install the Windows client without relying on partners or super users to do it for them.
Using Windows Installer vs. Using ClickOnce
A ClickOnce-deployed Windows client has some limitations compared to the Windows client installed by the Windows Installer. These limitations are not a technical shortcoming of the ClickOnce framework, but a scoping of the provided support in Microsoft Dynamics NAV 2013, based on what we expect the typical usage of ClickOnce for deployment to be. The following are the limitations:
If any of these limitations is an issue in the given deployment scenario, and the benefits of the ClickOnce deployment scenario do not outweigh this, the guideline is to use the standard Windows Installer-based Microsoft Dynamics NAV Windows client deployment instead.
The following table provides a summary of the value proposition for Windows Installer and ClickOnce:
-Peter Borring Sørensen
Do you or your customers have peak hours when all the sales orders and invoices need to be posted at the same time? Or do you have large numbers of postings that need to be run without blocking other users? I bet the answer is yes. If so, then you may also have experienced your screen freezing for several seconds – minutes even – until the order is processed. “Try again later” is also a well-known option.
To provide a better user experience and to enable more users to leverage the possibilities of Microsoft Dynamics NAV, we have redesigned how the General Ledger (G/L) Entry table is locked during the posting process.
The implementation of Microsoft Dynamics NAV application was, for historic reasons, primarily designed for Microsoft Dynamics NAV Classic Database Server, but it has been adapted and deeply enhanced to also run on SQL Server. Microsoft Dynamics NAV Classic Database Server uses table locking, and the locking order and use of semaphores are designed to avoid deadlocks in a table locking scenario. With Microsoft Dynamics NAV 2013, the Classic Database Server is retired, which allows us to fully benefit from SQL Server’s row level locking. We decided to focus on a few key scenarios, as they involve most users:
These enhancements to G/L posting, combined with the job queue and background posting will open up more flexible usage of Microsoft Dynamics NAV and will lead to more efficient users and a better experience in peak hours.
Setup and Use of the Redesigned G/L Posting
The new locking schema is enabled by default. Do you want to still use the legacy one? That’s very easy:
Note: The new behavior is automatically turned off if the Automatic Cost Posting field is selected in the Inventory Setup window.
What Has Been Changed
Of course, you can make a comparison of codeunits 80 and 90 between previous versions of Microsoft Dynamics NAV and Microsoft Dynamics NAV 2013. But even better, you can see a graphical representation of the changes.
In codeunits 80 and 90, we were locking the G/L Entry table (as a semaphore) quite early during posting, thereby locking other users out from posting at the same time. This lock has been moved to a later stage in the posting process. With those changes, our estimates are that:
-Tomás Navarro Casbas
Work in Process, WIP, and the related recognition of costs and revenues has a huge impact on the bottom-line for a project-based company. Project managers, accountants, and controllers are monitoring this recognition closely and for them it is crucial to have the process be as simple yet accurate as possible. Since the process has such an impact on financial reporting, it is also under the scrutiny of auditors. International and country-specific accounting standards control the WIP and Recognition process thoroughly. For these reasons, it’s important that the process as well as its result be easy to understand.
So what benefits does Microsoft Dynamics NAV 2013 bring to accountants and controllers? Flexibility in defining WIP methods makes it easy to have Microsoft Dynamics NAV 2013 fit particular company or industry requirements and country specific accounting standards. Accountants are in complete control of which of the WIP methods is to be used in the company to avoid rework later in the process and risking incompliance. Accountants can enforce a policy of using a particular WIP method, posting detail, and posting schemas for all of a company’s projects, thus providing consistent and accurate financial data for management. Microsoft Dynamics NAV 2013 provides two additional levels of detail while posting WIP to improve an accountant’s efficiency during the reconciliation process. First, it provides a choice on level of detail during posting of WIP to the general ledger. Second, it provides the ability to allocate different categories of costs (inventory, resources) to different general ledger accounts.
All of the policies that an accounting department establishes come into effect at a point where data about actual execution of the project, collected by the project manager and project team, meets with the balance sheet. In Microsoft Dynamics NAV 2013, this place is called the WIP cockpit. The WIP cockpit provides a complete overview of costs, revenues, and profits generated by the project in particular period. In a single place, the accountant can overview the amounts that will be posted to company ledgers, and see how these amounts were calculated, with details of the underlying transactions that caused them just another click away. In addition, the WIP cockpit displays WIP warnings, which enable the accountant to see if the underlying data collected by the project team is in line with what is defined by the WIP method and if all prerequisites for recognizing costs and revenues are met before posting WIP to a company’s balance sheet. Posting WIP to the balance sheet (and reversing it in case of last minute changes to project costs) is as easy in Microsoft Dynamics 2013.
What about benefits for project managers? A project manager, who is responsible for the execution and monitoring of a project, can focus on his job and not become bogged down with the project’s accounting details. How? Well, Microsoft Dynamics NAV 2013 enforces policies set by the accounting department by taking care of all the accounting-related requirements during creation, planning, execution and monitoring for the project. The project manager makes sure that all the costs related to the project have been accounted for and that all that should be invoiced to the customer is invoiced. When this is done, the WIP cockpit will provide him with an overview of what will be handed over to the accounting department to be recognized in the company’s books. Before wrapping it up for a milestone or period end, the project manager can initiate calculation of WIP and verify that no warnings or violations of policies set by the accounting department exist, so project information can be properly reflected in the company’s books. When warnings appear, usually something is missing or is not accounted for. In Microsoft Dynamics NAV 2013, finding out what that is this just a click away and after warnings are sorted out, the project manager can use Microsoft Dynamics NAV 2013 to recalculate WIP, and take these last minute changes into account.
I think everyone agrees that keeping track of project performance is essential in all project-based delivery scenarios. It should be fairly easy to see if a project is on track and that everything that should be invoiced is invoiced.
Project managers need to answer questions such as:
Job task lines and job statistics in the Project Management area of previous versions of Microsoft Dynamics NAV gave a good overview of total amounts for planning, actuals, and invoicing, but it was cumbersome to tie usage to those.
The Apply Usage Link, a new feature in Microsoft Dynamics NAV 2013, enforces this link. The main goal in Microsoft Dynamics NAV 2013 is to strengthen the link between the project plan and the actual work done. That enables Microsoft Dynamics NAV to go further in calculating estimate at completion, better integrate to the planning engine, and enable partial invoicing.
Basically, you specify whether usage entered by, for example, a project manager or order processor, is linked to the project plan. This enables you to track the quantities and amounts of remaining work needed to complete a project, which easily brings you to estimate at completion numbers.
With the usage link, Microsoft Dynamics NAV 2013 provides you with an easy way to review and record usage on various parts of your project, which is automatically updated as you modify information about actual work done.
It’s important to note that previously, you would have used various tools and manually updated quantities to invoice on sales invoices if you wanted to invoice something different than what was planned for particular project task. Now, when you enable the usage link, you can really focus on planning and executing your project, rather than on the way your ERP system is working.
Using new configuration capabilities of the Microsoft Dynamics NAV RoleTailored client, you can easily set up different views on a project plan (tasks) that will fit each role, for example, that of project manager for a planning view, that will fit project team member.
In earlier versions, a user who entered purchases related to a project, or registered time or usage of inventory items, needed to know how the contract was constructed in order to match usage to particular planned project task. Now, there’s an algorithm that will do the matching of usage to project plan for you, or create new tasks for unplanned work if it doesn’t successfully identify project plan tasks to which to match usage. Of course, Microsoft Dynamics NAV 2013 flexibility still allows you to set this link manually.
As I mentioned before, with the link between usage and the project plan, you are always able to see an up-to-date estimate at completion and track your project budget variance. This also enables correct invoicing, since it tracks planned work versus done work.
Since Microsoft Dynamics NAV 2013 is an integrated solution, you can expect it to be able to use project plan as a demand source when you are planning your requisitions. Microsoft Dynamics NAV 2013 tracks the outstanding quantities that need to be supplied or processed based on the project plan.
This means it knows how many items you used on the project versus your requirements. Demand overview allows you to see whether an item you need to finish particular task on the project is in stock, and if not, when it will be. In addition, if an item is available to reserve, you can reserve it, to make sure it is available for your use.
The other day a partner asked me about how to start the Microsoft Dynamics NAV 2013 C/AL Debugger for another NAV Server instance than the one used by C/SIDE.
The explanation is below, but first, let’s see how C/SIDE finds the NAV Server instance used for running and debugging.
The Microsoft Dynamics NAV Server Instance used by C/SIDE for Run and Debug
When you Run an application object from the C/SIDE Object designer, C/SIDE is starting a Dynamics NAV Windows client with the application url constructed from:
Read more here: Starting the Windows Client at the Command Prompt, the URL parameter.
This could be an example:
Microsoft.Dynamics.Nav.Client.exe "DynamicsNAV://localhost:7046/dynamicsnav70/CRONUS International Ltd./RunPage?Page=42"
The rest of the client configurations are taken from the default ClientUserSettings.config, which is typically found at %APPDATA%\Microsoft\Microsoft Dynamics NAV\70.
The same principle is used when you start the debugger from within C/SIDE Tools/Debugger/Debug Session.
All this works quite well in more confined setups where you can address different databases and NAV Servers if you are using the same authentication type for them all, but if you want to address different NAV Servers having for example different authentication types, you have to find other solutions – feel free to be inspired by how to.
Define Alternative Ways of Starting the Microsoft Dynamics NAV 2013 C/AL Debugger
Now let’s say you have made a dedicated NAV Test environment with:
… and you want to debug some issue that appears in the Test environment from your development environment machine.
The trick is to create a Dynamics NAV Windows client shortcuts on your development machine that specifies:
Ending up in a combined command line description:
Microsoft.Dynamics.Nav.Client.exe -settings:file "DynamicsNAV://< Server>[:<port]>/<ServerInstance>/<Company>/debug"
Or the short-form (all defaults to the .config settings):
Microsoft.Dynamics.Nav.Client.exe -settings:file "DynamicsNAV://///debug"
Adding up to shortcut examples like this:
Microsoft.Dynamics.Nav.Client.exe -settings:"%USERPROFILE%\Desktop\TestEnv.config" "DynamicsNAV://///debug"
Microsoft.Dynamics.Nav.Client.exe -settings:"%USERPROFILE%\Desktop\ProdEnv.config" "DynamicsNAV://///debug"
Or with full paths like this:
"%ProgramFiles(x86)%\Microsoft Dynamics NAV\70\RoleTailored Client\Microsoft.Dynamics.Nav.Client.exe" -settings:"%USERPROFILE%\Desktop\TestEnv.config" "DynamicsNAV://///debug"
The Windows client specifically understands the “special” /debug url, which is currently a “shorthand” for starting the client with:
The debugger can be started this way because it is working similar to any Microsoft Dynamics NAV solution.
Deploying the Microsoft Dynamics NAV Windows client with ClickOnce makes it easy for end users to install, upgrade, and uninstall the Microsoft Dynamics NAV Windows client. They can do this with a few clicks, without the help from super users or IT administrators.
This video shows how a partner or IT administrator can host a ClickOnce deployment in Azure blob storage. This combines the simplicity of a file share deployment with the accessibility of a public web server deployment.
This is the fifth video in a series of how-to videos that show how a partner or IT administrator can deploy the Microsoft Dynamics NAV Windows client with ClickOnce. Make sure to watch the first video before you watch this video.
For a detailed step-by-step guide about how to deploy the Microsoft Dynamics NAV Windows client with ClickOnce, see http://go.microsoft.com/fwlink/?LinkId=251676.
-Christian Heide Damm
This video shows how a partner or IT administrator can host a ClickOnce deployment on a web server instead of on a file share. This is best suited for public deployments over the internet, as opposed to deployments internally in an organization.
This is the fourth video in a series of how-to videos that show how a partner or IT administrator can deploy the Microsoft Dynamics NAV Windows client with ClickOnce. Make sure to watch the first video before you watch this video.
-Christian Heide Dam