Skip to main content

Adding users in Management Reporter from AX2012 R2

thank you TOMMY SKAUE

I have been getting some requests from blog readers on how users are added in Management Reporter. If you are on AX2012 R2 with CU7 and onwards the users are collected directly from AX by the service itself. This means that if you attempt to create the users from Management Reporter, the MR client (Report Designer) will stop you.

Management Reporter comes with 2 users and a limited license. So the very first thing you need to do is load the license. You will find the license on VOICE where you find the license for Dynamics AX. Load the license and observe the number of users granted. Management Reporter has four types of users: Viewer, Designer, Generator and Administrator. The account installing will become administrator immidately, and as soon as the service starts it will start collecting users from AX.

What typically happens is that you'll get your own user in right away, and then the two users given by the demo license. You then load the license and then the service adds the remaining users.

If you still don't see any users, it is most likely due to one of these two:

  1. No users have the correct roles in AX
  2. An error
The overview of roles is in the Whitepaper "Management Reporter Integration Guide for Microsoft Dynamics AX (DynAXDataProvInstGuide_ENUS)". But since you're reading here, I'll list the current ones:

Designer: Accounting manager, Accounting Supervisor.
Generator: Accountant, Accounting manager, Accounting supervisor, Chief executive officer, Chief financial officer, Compliance manager, Financial controller
Administrator: Security Administrator
Viewer: No roles but there is a privilege. Create your own role or edit one of the existing ones if you need this MR role.

As for error, the only problem I've experienced so far is having AX users who were removed from Active Directory. The service will simply stop collecting users as soon as it hits a user in AD which it cannot find in Active Directory. Personally, I would prefer if the service skipped inactive users. In one of my environment I had a handful of users who were deleted from AD, and these users prevented the service from collecting all the users.

Popular posts from this blog

What does this mean: "The form datasource query object does not support changing its AllowCrossCompany property after the form has executed the query."?

I have made a form with datasources vendtable and vendtrans. Inside vendtable_ds.executequery() looks like this: QueryBuildDataSource queryBuildDatasource ,queryBDS_VendTrans_Invoice; ; queryBuildDatasource = this.query().dataSourceTable(tablenum(vendtable)); queryBDS_VendTrans_Invoice = this.query().dataSourceTable(tablenum(vendtrans)); if (curext() == "MASTERCOMP") { this.query().allowCrossCompany(true); } else { this.query().allowCrossCompany(false); } //FilterVendorName = stringedit control on form if (FilterVendorName.text()) { queryBuildDatasource.addRange(fieldNum(VendTable,Name)).value(strfmt("*%1*", FilterVendorName.text())); } else { queryBuildDatasource.clearRange(fieldNum(VendTable,Name)); } //FilterInvoiceNumber = stringedit control on form if (FilterInvoiceNumber.valueStr() == "") { queryBDS_VendTrans_Invoice.enabled(false); } else { queryBDS_VendTrans_Invoice.enabled(true); queryBDS_VendTrans_In...

Credit Note [Dynamics AX] using X++

This post will help to create credit note for a sales order based on the invent lot id. All the invoices raised for a particular sales line – Lot Id will be raised back as a credit note. Information on Credit Note: A credit note or credit memorandum (memo) is a commercial document issued by a seller to a buyer. The seller usually issues a Credit Memo for the same or lower amount than the invoice, and then repays the money to the buyer or sets it off against a balance due from other transactions Below Code will help to create credit note for all the invoices raised against the sales line -lot id. Please note: This code can be customized as per your requirements. This is just a template to help creating credit note using X++ code. Please test the code before use. static void SR_CreateCreditNote_Sales(Args _args) { // Coded by Sreenath Reddy CustInvoiceTrans custInvoiceTrans; Dialog dialog = new Dialog(“Create credit note – for sales.”); DialogField dfInv...