AX7 Table Browser and Class Runner

Challenge 1: delete a worker in Dynamics AX “7” aka “Dynamics 365 for Operations” in the table browser Create a worker under Human resources > Workers > Employees. Now try to delete it. If you ever touched the Project setup settings etc of the employee, a message appears announcing that a “Worker cannot be deleted while dependant Resources…


Migrate document attachments to AX7

The Archive directory, Database and the Original location options for storing file attachments in the “New Dynamics AX” aka “Dynamics AX Online” aka AX7 are depreciated in favor of the Azure Storage or SharePoint. The option Archive directory (see Organization administration > Document management > Document types) now designates the Azure Blob Storage, the Database…


Mass create Worker-User relations in AX 2012

A relation between the worker and the system user records (System administration > Common > Users > User relations) is necessary to approve BOMs, enter timesheets or expense reports in Dynamics AX. The user records can be easily imported from the Active Directory, the Employee records can be migrated from a legacy ERP or a…


“Cost accounting” for multi-level process manufacturing

In the series “Dynamics AX modules we rarely implement”, imagine a dialogue between a financial controller (C) and a Dynamics pre-sales consultant (S):– C: I would like to see the contribution of raw materials (direct costs) separately from the energy, machine depreciation and wages (indirect costs) in the cost price of my finished goods.– S: Nothing is…


VISA VCF plain text credit card statement into Dynamics AX with XSLT

Introduction A good level of travel expense automation in Microsoft Dynamics AX 2012 R3 requires daily import of credit card files. The credit card number must be specified for the employee in the Human Resources module. The daily credit card statements with unbilled credit card transactions are picked up by the Travel and expense /…


One warehouse, 2 cost models

Around 14 years ago I designed a feature called the “Dual warehouse”. The feature is scarcely documented (https://technet.microsoft.com/en-us/library/jj733298.aspx) and barely understood. It was intended to maintain 2 warehouse cost prices in parallel in countries suffering from hyperinflation. In 2002 I was even given a chance to present this feature to Erik Damgaard, at that time known…


Work item could not be created. Insufficient rights for user %1

Have you ever encountered the issue that a workflow in Microsoft Dynamics AX stops with the following error message? Stopped (error): X++ Exception: Work item couldnot be created. Insufficient rights for user %1. at SysWorkflowWorkItem-create SysWorkflowWorkItem-createWorkItems SysWorkflow-save SysWorkflowQueue-resume   Moreover, the issue still occurs even after assigning the user to the System Administrator role? The…


German travel expenses in AX 2012 / Deutsche Reisekostenabrechnung 2015

Introduction  You want to implement travel expense reporting for Germany in Dynamics AX out-of-the-box? Congratulations! You are about to deploy an exotic module (“Travel and expense”) on an undoubtedly exotic AX implementation project in an exotic country. Luckily enough, the requirements of the federal income law with its painstaking per diem regulations may be implemented…


Override configuration ID in the constraint-based product configurator in AX2012

The new constraint-based product configurator was a huge leap forward compared to the old product builder. In version AX2012 R3 we additionally got “Calculations” and a slight possibility to work with real numerical values A feature to automatically re-use configurations instead of generating a new one every time Yet with regards to the integration with…


What we talk about when we talk about KITS in Dynamics AX

We often encounter the requirement for handling kits or product combinations, sets, bundles or packs in the sales module in Dynamics AX. They all have in common a fixed (or partially variable) set of components (‘A’, ‘B’, ‘C’…) offered to the client as a single package ‘K’. Here the common part ends. The users may…