How to verify active inventory dimensions on an item

If you want to list items come along with their Actvie Dimension, you can do it easily with this simple job 1 2 3 4 5 6 7 8 9 10 cs inventTable; InventDimParm inventDimParm; inventTable = InventTable::find('110924'); inventDimParm = InventDimParm::activeDimFlag(InventDimGroupSetup::newInventTable(inventTable)); if(inventDimParm.InventSiteIdFlag) { info("Site Actived"); }

Only integrated security is supported for AX queries

I updated my dynamics Ax development Environment by restoring Database from Production Database. After the restoring the database, when I run any report form Dynamics Ax, there is an error Only integrated security is supported for AX queries. Checking the SSRS is working fine. The solution is to redeploy the reports, create a new report folder, open Microsoft Dynamics Ax 2012 Management Shell (make sure you run Powershell as Administrator). Publish-AXReport -ReportName *

SSRS Report Server Settings Validation Error- AX 2012 R3 CU9

Recently I updated my dynamics Ax development Environment by restoring Database from Production Dynamics AX DB and I got this problem Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager. The reporting Services are still working fine and I have already granted the AX Admin as System Administrator under site settings, Home folder settings and DynamicsAX folder with Browser, Content Manager, DynamicsAXBrowser, My Reports, Publisher, Report Builder roles.

Link Type and Join Types in ax 2012

Link Type Active: Parent and child data source is updated immediately when a new record in the parent data source is selected. Continuous updates consume lots of resources consuming. Delayed: Parent and child A pause is inserted before linked child data sources are updated. This enables faster navigation in the parent data source because the records from child data sources are not updated immediately. For example, you can scroll a list of orders where you do not want to review the lines associated with the order until you stop scrolling.

How to use operator "or" in QueryBuildRange

This blog post is show how to apply OR conditions in query build ranges in a simple way on same field in a table. Let’s see the simple query : 1 select * from CustTable where AccountNum == '2001' || AccountNum == '2002' We can find out solutions on MSDN by using expression in query ranges, but as it has lot of specifications which needs to be followed. However there is a simple way to do it :

How to install two instances SSRS on one server

Scenario: I have 2 AOS AX (maybe same in one server or different servers), but only one server for reporting server (I will install and configure multiple SRS instances in this server). Thing is how can we install and configure 2 SSRS instances on same server and running for 2 AOS. Two SSRS instance are running same server Problems: First you need to install 2 SSRS instance in same server, and install reporting service component for first AOS, this step is very simple.

AX 2012 R3 CU8 CU9 and TFS Online 2013 Error

When you try connecting between TFS and Dynamics AX CU8, CU9 and you got error like this: Error: Team Foundation services are not available from server **** Technical information (for administrator): TF400813: Resource not available for anonymous access. Client authentication required. Error: Could not load file or assembly 'Microsoft.TeamFoundation.Client, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. Client computers that are not running Visual Studio 2010 must have the Team Foundation Server 2010 SP1 Object Model installed to use TFS source control with Microsoft Dynamics AX.

Caching form into AOS to increase performance for Dynamics AX

Scenario: Normally when we open form for the first time in Dynamics AX, it will take sometimes to compilte and cache into AOS. That’s why at second time always faster. If we often restart AOS, how can we keep performance ? Solution: After restart AOS we can let some scripts run to open up some often used forms then cache to AOS, then close those forms. Here is the code