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"); }
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 *
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 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.
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 :
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.
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 ****.visualstudio.com/defaultcollection.
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=10.0.0.0, 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.
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
