Posts

DIXF - Copy data between Ax systems

Image
At various points in time during an Ax implementation and following go live, it is necessary to move data between systems. Sometimes restoring the entire database is both unnecessary and inconvenient. Depending on who the tasks falls to (or who has time to complete it) there are a few different ways this can be achieved. A more technically inclined resource might look to the Test Data Transfer Tool. A more functionally minded resource might use the old definition groups, or the new (to Ax 2012 R2 CU7) Data Import Export Frameworks ability to export an entity. The DIXF currently supports 150 entities out of the box , and also provides the ability to create custom entities. To begin with, create a new processing group in the source system. Add the entity (or entities) to be exported to the processing group. Select Export to Ax Select an export location, file name and file format. This step will resemble the definition group export functionality. ...

Enable DB Compression in Ax 2012 with SQL 2012

Image
Database compression can be beneficial under certain circumstances. Ax 2012 supports enabling database  compression from within the application. See this blog post  for more details.This is quite handy. Unfortunately it only works with SQL 2008, not SQL 2012. The class SysSQLSetupHelper checks the SQL version and the controls on the form SysSQLSetup are enabled or disabled based on that. Luckily the fix for this is very easy - check whether the SQL version is 10 OR 11 (2008 OR 2012).

Windows Server 2012 Desktop Experience

If using the new Task Recorder with Ax 2012 R2, you'll need to have Windows Media Player installed also. Took a while to find where it was hidden in Server 2012, but it's there, under User Interface and Infrastructure...see this blog post for details. http://blogs.technet.com/b/meamcs/archive/2012/05/01/how-to-add-desktop-experience-feature-on-windows-server-8-beta.aspx

DIXF - Copy data between companies

Image
Of the many new features introduced in Ax 2012 R2 CU7 , one is the ability to use the Data Import Export Framework (DIXF) to copy data between companies. From the DIXF menu, select Copy entity data between companies. Enter a name & description for the processing group. Select the entities to include in the processing group. Select the source company, and destination companies. The process can run interactively, or for larger data sets, in batch. More detail on the new DIXF features here . The DIXF can also be used to export and import data between Ax systems, as can the Test Data Transfer Tool.

Setup Canadian Demo Company

Image
In Ax 2012, country based functionality is tied to an entities primary address. Recently when setting up a demo Canadian company, we needed to enter a registration number and a software identification code. The software identification code was easy, as explained by the help - two letters followed by 6 numbers. The registration number took a little more though - Ax validates this number. After quickly drilling through to the validation code, we found in a lovely piece of commenting the developers had left a sample number as part of a worked example - 100000041

Number sequence 0 does not exist

Image
If you receive the error 'Number sequence 0 does not exist', check the voucher number sequence associated with the journal type you are trying to post.

Life Cycle Services

Image
Microsoft recently released Life Cycle Services . LCS is built around a collaborative work space that customers and partners can both access to use online tools that can assist in managing a Dynamics Ax 2012 project from license estimation to system diagnostics. Microsoft have published a series of videos giving an overview and detailed look at the LCS features. License estimator -  License sizing estimator helps you estimate the number of licenses required for Microsoft Dynamics AX 2012. It provides a shared workspace that enables you to model default and customized roles, and then automatically calculate required client access licenses (CALs). Usage Profiler -  In Microsoft Dynamics Lifecycle Services, Usage profiler (beta) is a data-gathering tool that can help you describe your projected or current usage of a Microsoft Dynamics AX 2012 implementation. You can use the data from the Usage profiler (beta) for a variety of purposes, such...