NAV RDLC Reports: Using Dataset for Totaling Value Fields

Seeing the Dataset of a report can be very helpful, because it shows all values for every Data Item‘s column in one table. It‘s useful to export this table to Excel and, with the help of filters, see how particular values are calculated. 1ClickFactory developers found this less time-consuming than adding test messages to the code of test controls in Layout.

Top 5 Microsoft Dynamics AX Upgrade/Re-implementation Myths

1. “Dynamics Partners Live to Upgrade & Re-implement”

Are you dreading the inevitable upgrade versus re-implementation discussion with your AX customers? You are not alone.  It is a common misnomer that all Microsoft Dynamics Partners love to resell services – such as through software upgrades and re-implementations.

The truth is, without dedicated upgrade or re-implementation resources, these projects can be a drain on your capacity and productivity.  Trying to execute these upgrade and re-implementation projects without upgrade tools, methodologies and experienced practitioners, these projects can end up being more costly than profitable.

Stop Wasting Time & Resources Upgrading Classic Reports

Upgrading NAV Classic Reports to RDLC is tedious, requiring you to sacrifice valuable development resources to a low margin project.  These upgrade projects typically take the most development time but make the least return on development resources.  It is no wonder many Dynamics Partners try to avoid upgrade services all together. 

Minimize the time invested by your development resources and maximize the upgrade benefit to your customers with 1ClickFactory’s Transformation Services for NAV Classic Report upgrades. 1ClickFactory took on the challenge of simplifying NAV Classic Report upgrades for partners through Transformation Services enabling you to transform an object in “just a few clicks”.

Introducing Self-Provisioning for Microsoft Dynamics NAV® on Windows Azure™ and in Office 365™

We are pleased to announce the release of our latest service to the Microsoft Dynamics Partner Community, Self-Provisioning for Microsoft Dynamics NAV on Windows Azure and in Office 365.

We saw a unique opportunity with Microsoft Dynamics NAV to ‘change the game’ for Microsoft Dynamics partners by providing them a service that would deliver the high performance and reliability of an on-premise solution, with Windows Azure at the foundation, but translate the simplicity and ease-of-use to the end user in the Cloud.

How to set up AX 2012 R2 Order of Dimensions on Forms

With the release of Microsoft Dynamics AX 2012, many features and functions have changed. One item that may cause a slight inconvenience for partners and customers is the change to the R2 order of dimensions. If you have worked with Microsoft Dynamics AX 2009 or earlier versions, you are used to a fixed order of dimensions, as shown in this blog post. 

Dynamics NAV development tips: "FILTERGROUP" changes starting from Microsoft Dynamics NAV 5.0 SP1

To create a complex filter, a developer usually uses command "FILTERGROUP" to place different filters for the same field. In the first Microsoft Dynamics NAV Windows-based versions, developers were able to use filtergroups starting from 0 to 255. Some of them were reserved and used within the application like filtergroup 2 used by properties SubFormView, DataItemTableView or when you use command SETTABLEVIEW. There was also a reserved filtergroup 1, which was supposed to be a "Global filter" as it was in the DOS version.

Beginning with version Microsoft Dynamics NAV 5.0 SP1 build 28913, Microsoft introduced filtergroup 1 functionality.

How to run Subpage Functions in a Form when using RTC?

In this article, we are going to talk about the "Promoted" actions feature. It allows users to easily access the main functions related to the active page. When we use pages without subpages, we can promote any function we want. The challenge arises when using subpage functions - where from the main page you can't get to the active subpage record.  (When you call the subform function in the Classic client, the Microsoft Dynamics NAV knows on which record the user stays, but in the RTC it doesn't work this way).

At 1ClickFactory we found a way to solve this issue - to promote actions that need subpage functions -- by using Parts (fact boxes). When you use parts, you can link them with lines subpages. The example we are going to present in this article is based on the standard Microsoft Dynamics NAV 2009 SP1 W1 version.

Designing Account structures for Customer (Vendor) balance accounts and Exchange rate revaluation accounts

One of the setup issues is performing correct dimensions values setup for the automatic transactions accounts. For example: Accounts structure for the Currency exchange unrealized profit and Loss accounts that are used for currency revaluation differences in Accounts payable and Accounts receivable.

The problem appears when the requirements for dimensions on Customer or Vendor balance accounts differs from the dimensions requirements on Currency exchange rate Profit and Loss accounts in the Accounts structure.