Tuesday, December 17, 2013

Create Var layer Visual studio

right click edit Visual studio short cut
paste the following link, edit correct path link.

"E:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" /AxConfig C:\VAR_INCEIF_STG_FINAL.axc
pause

Open Client auto clash

go to C:\Users\sj.lee(UserName)\AppData\Local

delete all file name start with ax_...

Deploy all report

Open Windows PowerShell as an administrator by following these steps:

1. Click Start > Administrative Tools.

2. Right-click the Microsoft Dynamics AX 2012 Management Shell option.

3. Click Run as administrator.

4. To deploy a specific report, enter the name of the report. For example, to deploy the CustTransList report, enter the following command:

Publish-AXReport -ReportName CustTransList

5. To deploy two or more specific reports, enter the names of the reports. For example, to deploy the CustTransList and CustTransOpenPerDate reports,
   enter the following command:

Publish-AXReport -ReportName CustTransList, CustTransOpenPerDate


6. To deploy all reports, enter the following command:

Publish-AXReport ReportName *

Duplicate Object

Duplicate type with name 'Dynamics.Ax.application.<My Object Name>' in assembly
'Dynamics.Ax.application, version=6.0.947.280, culture...

You can try the solution:
1. import twice the object, second time system will prompt you object exist, overwrite it? click Yes to all.
2. Full CIL

Untick consolidate Legal Entities

Stack trace: Field 'IsConsolidationCompany' in table 'CompanyInfo' has not been explicitly selected.

go to db edit dbo.dirpartytable.isConsolidateCompany from null to 0

Request password for every report

More appropriate solution would be to delete all the reports and redeploy all the reports. Steps are as follows:

First step is to delete all the existing SSRS Reports. For doing this you can navigate to DynamicsAx folder and delete the entire folder.

Then go to Report servers form in Dynamics Ax 2012 Tools > BI > Report server and click on "create report folder" button to create the Folder DynamicsAx again.

Now you can open Powershell (Administrative Tools > Microsoft Dynamics Ax 2012 Management Shell). Make sure you run Powershell as Administrator.

Deploy all the reports with the help of command:

Publish-AXReport -ReportName *

And once, all the reports are deployed you should be good to go.

SysXppAssembly

'Cannot create a record in SysXppAssembly (SysXppAssembly). The record already exists.'


Full gen CIL issue solve

SRSFrameworkService Prolem

Error message: A call to the Microsoft Dynamics AX SRSFrameworkService service failed. No connection could be made because the target machine actively refused it

Steps to resolve the issue

1. Generate full CIL

open AOT and register the following services:

SRSFrameworkService

SSASFrameworkService

go to Services Group node and auto deploy the following service groups:

BIServices

UserSessionService

Thursday, March 7, 2013

use code to control Table field: allowEdit = Yes / No

when Person name order = manual, can edit the name,

when Person Name order = (other), can't edit.



1. copy the field name from design.
        example Design-> Tab -> Tab page-> Grid ->field  AvPatient_TestSJ_Name

2. set the field auto decraration = yes from design properties

3. use it to code:


if(AvPatient_TestSJ.PersonNameOrder == AvDirPersonNameOrder_TestSJ::Manual)
        AvPatient_TestSJ_Name.allowEdit(true);

    else

        AvPatient_TestSJ_Name.allowEdit(false);


Extral knowledge* if write in method modified, have to write again in method active.