Home

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 InventTable inventTable; InventDimParm inventDimParm; ; inventTable = InventTable::find('110924'); inventDimParm = InventDimParm::activeDimFlag(InventDimGroupSetup::newInventTable(inventTable)); if(inventDimParm.InventSiteIdFlag)...

Read more

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, all gave error “Only integrated security is supported for AX queries.” The reporting Services are still working fine. For this, best way to redeploy them, create a new repo...

Read more

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. Anyway, The reporting Se...

Read more

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...

Read more

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 : 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 ...

Read more

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. easierly, please take a look the picture below Figure 1: Two...

Read more

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 1 Team Foundation services are not available from server ****.visualstudio.com/defaultcollection. Technical information (for administrator): TF400813: Resource not available for anonymous access. Client authentication required. Error 2 Could not...

Read more

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 th...

Read more