Symmetry error in Ax 2012 R3 CU8

Hello Guys...!

Issue: Symmetry  error in PayrollCalculatePayStatementBenefits class in Ax 2012 R3 CU8

Solution :

Go to AOT-> References-> Add Reference

Browse ste-net.dll file from  C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin

 

Press Ok.

 

 

 

Again do full compilation

That's it....

 

@Rahul Talasila

How to See Log Files Paths In AX 2012

Hello Guys..

Here i'm sharing information about how to see log file paths in ax 2012

Full Compilation Log :

This is when you compile the entire application and it is located in
%USERPROFILE%\Microsoft\Dynamics Ax\Log\ by default - this is the path found in the configuration of the client. The log name is AxCompileAll.html

CIL Compilation Log :

 This is when you do Generate Full CIL and this can be found in the Server folder of you AX installation similar to this
 C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL and it is called Dynamics.Ax.Application.dll.log



@Rahul Talasila

How To Export Data Into Excel - Ax 2012

Hello Guys,

In this post i'm showing how to export data into excel.

In this example i'm exporting all number sequence list  in current legal entity .

Example : vend id,custid,paymentjournalnum

Step1 :Copy and Paste the below code in AOT-> Job
Step2: Run the Job
step3: Go to "C" drive and then find the excel sheet Named as "Numseqlist"

static void Numberseq_List(Args _args)
{
   SysExcelApplication  xlsApplication;
   SysExcelWorkBooks    xlsWorkBookCollection;
   SysExcelWorkBook     xlsWorkBook;
   SysExcelWorkSheets   xlsWorkSheetCollection;
   SysExcelWorkSheet    xlsWorkSheet;
   SysExcelRange        xlsRange;
    NumberSequenceReference NumberSequenceReference;
    NumberSequenceTable NumberSequenceTable;
    NumberSequenceDatatype NumberSequenceDatatype;
   int                  row = 1;
   str                  fileName;
    CompanyInfo companyInfo;
   ;
   //Filename
   fileName = "C:\\Numseqlist.xlsx";
   //Initialize Excel instance
   xlsApplication           = SysExcelApplication::construct();
   //Open Excel document
   //xlsApplication.visible(true);
   //Create Excel WorkBook and WorkSheet
   xlsWorkBookCollection    = xlsApplication.workbooks();
   xlsWorkBook              = xlsWorkBookCollection.add();
   xlsWorkSheetCollection   = xlsWorkBook.worksheets();
   xlsWorkSheet             = xlsWorkSheetCollection.itemFromNum(1);
   //Excel columns captions
   xlsWorkSheet.cells().item(row,1).value("NumberSeqId");
   xlsWorkSheet.cells().item(row,2).value("Format");
   xlsWorkSheet.cells().item(row,3).value("Name");
   row++;
   //Fill Excel with NumberseqId,Format,Name fields (only 10000 records)
    companyInfo.RecId = CompanyInfo::findDataArea(curext(),false).RecId;
   while select NumberSequenceReference where NumberSequenceReference.numbersequencescope == companyInfo.RecId
    {
        select numbersequence from NumberSequenceTable where NumberSequenceTable.recid == NumberSequenceReference .numbersequenceId;
        select firstonly1  NumberSequenceDatatype where NumberSequenceDatatype.RecId == NumberSequenceReference.NumberSequenceDatatype;
       if(row == 10000)
        break;
       xlsWorkSheet.cells().item(row,1).value(NumberSequenceTable.NumberSequence);
        xlsWorkSheet.cells().item(row,2).value(NumberSequenceTable.Format);
       xlsWorkSheet.cells().item(row,3).value(NumberSequenceDatatype.referenceLabelForDisplay());
       row++;
   }
   //Check whether the document already exists
   if(WinApi::fileExists(fileName))
      WinApi::deleteFile(fileName);
   //Save Excel document
   xlsWorkbook.saveAs(fileName);
   //Open Excel document
   xlsApplication.visible(true);
   //Close Excel
   //xlsApplication.quit();
   //xlsApplication.finalize();
}


@Rahul Talasila

Missing Label File Problems - AX 2012

Hello Guys,

Problem : 

In some situation could happen that after installing cumulative updates there are missing some SYP labels.

Solution : 

1. Stop AOS
2. Delete ALD and AUC files from Microsoft Dynamics AX\60\Server\<instance>\bin\Application\Appl\Standard
// Note : In search type.ald, .alc and delete files

3. Start AOS again.

That's It..

Issue : 
Some times we face the same labels issue after upgrading sql server
Example: upgrading from Sql 2012 to Sql 2014

Solution : 
http://technet.microsoft.com/EN-US/library/hh389762.aspx


@Rahul Talasila

How To Add Company Logo To SSRS Report

Hello Guys..

Here i'm sharing steps how to add company logo to a ssrs report.

Step1 :

-> Add Extended Data Type "BitMap" to your table and name it as "CompanyLogo".
-> Add Extended Data Type "NoYesId" to your table and name it as "PrintLogo".

Step 2 :

-> Go to insert method of your ssrs report DP class and paste the below code before yourtable.insert();

if (conLen(FormLetter::companyLogo()) == 0)
    {
        yourtable.PrintLogo = NoYes::No;
    }
    else
    {
        yourtable.PrintLogo = NoYes::Yes;
        yourtable.CompanyLogo = FormLetter::companyLogo();
    }

//Note : Change table name

Step 3:
-> Edit your ssrs report design in visual studio.
-> Insert Image as shown in the below screen shot

-> Then go to image properties

-> In the properties go to "Use this field" and paste the below code and change the data set name

=IIF(First(Fields!PrintLogo.Value, "datasetname") = "Yes", First(Fields!CompanyLogo.Value, "datasetname"), "")

-> Select company logo type in the "Use this MIME type"
-> Save and then deploy the report ..

That's It ... :)




@ Rahul Talasila

How To Show Limited Records In a Form Info Part

Hello...!

In this post i'm going to show how to show Limited Records In a Form Info Part.

Example : Top 10 Vendors (AP-> Vendors)

In this example i'm going to show only top 5 vendors

Steps :
-> Open related info part(VendTop10VendorsByPurchase)
-> Go to infopart(VendTop10VendorsByPurchase) Properties and change Caption to Top 5 Vendors
-> Expand infopart(VendTop10VendorsByPurchase) ->Layout-> Main properties and change Rowcountwhensmall 10 to 5
->save and close .

Now we can see only 5 records... :)

@ Rahul Talasila

There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. The InnerException message was 'Element 'http://tempuri.org/:queryBuilderArgs' contains data from a type that maps to the name 'http://schemas.datacontract.org/2004/07/XppClasses:SRSQueryBuilderArgs'

There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. The InnerException message was 'Element 'http://tempuri.org/:queryBuilderArgs' contains data from a type that maps to the name 'http://schemas.datacontract.org/2004/07/XppClasses:SRSQueryBuilderArgs'........................................

Some times we get the above error while running reports in Axapta 2012. To resolve this issue we need to delete usage data in the AOSserver.


Solution : 

Step 1 -> Connect to sql server and go to axapta database(MicrosoftDynamicsAx) and delete all records in dbo.SYSCLIENTSESSIONS table.

Step 2-> Close the AX 2012 client to clear any in-memory elements.

Step 3-> Stop the Microsoft Dynamics Server service on the Application Object Server (AOS) to clear any in-memory elements.

Step 4-> Delete the application element cache files (*.auc),(*.KTI) from the Local Application Data folder.

C:\Users\AOSAccount\AppData\Local  (Delete the all the AUC and KTI files)

Step 5-> Delete VSAssemblies from the Local Application Data folder.

C:\Users\youruserid\AppData\Local\Microsoft\Dynamics AX\VSAssemblies

Step 6-> Start the service

Note : Make sure show hidden files,folders,and drivers option enabled

@Rahul Talasila

Display customized Text In Status Bar- Axapta 2012

Here i'm sharing the code to Display customized Text In Status Bar

//Copy and paste the below code in a Job

static void statusbar(Args _args)
{
    str customtext;
    ;

    customtext = "Test";

    // Force the text to be shown
    xUserInfo::statusLine_CustomText(true);
    infolog.writeCustomStatlineItem(customtext);

}

@ Rahul Talasila

Filtering Records in a Form - Microsoft Dynamics Axapta

Hello Guys...


In this post i'm sharing steps how to do the Filtration of records in a Form

Here  i'm filtering records based on the selected gender(m/f)

Step 1 :

Go to Form-> Methods->class declaration and declare QueryBuildRange.

public class FormRun extends ObjectRun
{
    QueryBuildRange range;
}

Step 2:
Go to Data sources->your datasource->Add a Range in init() method of the DataSource.

public void init()
{
    super();
    range = this.query().dataSourceName("Test_Filteration").addRange(fieldNum(Test_Filteration,Gender));
}
//Note : You can use dataSourceNo also

Step 3 :

Go to Data sources->your datasource->Override the executeQuery() method


public void executeQuery()
{
    range.value(Gender.valueStr());
    super();
}

//Note : Enable "Gender"Auto-declaration to "Yes" in design

Step 4 :

Finally  Call the executeQuery() method in the Selection Changed method of the ComboBox(Gender).


public int selectionChange()
{
    int ret;

    ret = super();
    Test_Filteration_ds.executeQuery();
    return ret;
}




@ Rahul Talasila

Import Vendor Balances In Microsoft Dynamics Axapta 2012

Here I'm sharing code to import Vendor Opening Balances Lines.

Note : The below code import only Lines.


-> Copy and paste below code in AOT->Jobs(Compile Job before using)
->open excel and fill the data according to the below format and save in CSV format
->Run job and browse file and press ok

Csv Format :

column1 - Journal Number
column2 - MainAccountNum
column3 - Dimension1
column4 - Dimension2
column5 - Dimension3
column6 - Debit Amount
column7 - Credit Amount
column8 - Transaction Date
Column9 - Description

Column10 - InvoiceId
Column11 - PostingProfile

//Code Starts From Here- @ Rahul Talasila

static void VendorOpeningBalances(Args _args)
{
    CommaIO                   csvFile;
    container                 readCon;
    counter                   icount,inserted;
    Dialog                    dialog;
    DialogField               dfFileName;
    FileName                  fileName;
    LedgerJournalACType       ledgerJournalACType;
    AxLedgerJournalTable      axLedgerJournalTable ;
    AxLedgerJournalTrans      axLedgerJournalTrans;
    container                 accPatternvend,accPatternledger;
    container                 offSetPattern;
     DimensionDynamicAccount   ledgerdimension;
   str transdate;
    ;
     inserted =0;
    #File
    dialog     = new Dialog("Pick the file");
   // dialog
    dfFileName = dialog.addField(extendedTypeStr(FileNameOpen));
    dialog.filenameLookupFilter(["All files", #AllFiles]);
    if(dialog.run())
    {
       filename =  dfFileName.value();
    }
       csvFile  =  new CommaIO(filename,'r');

    if(csvFile)
    {
        ttsBegin;
        while (csvFile.status() == IO_Status::OK)
        {
          readCon  = csvFile.read();
          if(readCon)
            {
                transdate = conPeek(readCon, 8);
                axLedgerJournalTable = new AxLedgerJournalTable();
                axLedgerJournalTrans = new AxLedgerJournalTrans();
                axLedgerJournalTrans.parmJournalNum(conPeek(readCon, 1));
                axLedgerJournalTrans.parmTransDate(str2Date(transdate,123));
                axLedgerJournalTrans.parmAccountType(LedgerJournalACType::Vend);
                ledgerdimension = DimensionStorage::getDynamicAccount(conPeek(readCon, 2), LedgerJournalACType::Vend);
                axLedgerJournalTrans.parmLedgerDimension(ledgerdimension);
                axLedgerJournalTrans.parmDefaultDimension(LedgerJournalTable::find(conPeek(readCon, 1)).DefaultDimension);
                axLedgerJournalTrans.parmAmountCurDebit(conPeek(readCon, 6));
                accPatternledger = [conPeek(readCon,2) + conPeek(readCon,3) + conPeek(readCon,4) + conPeek(readCon,5), conPeek(readCon,2),conPeek(readCon,3),conPeek(readCon,4),conPeek(readCon,5)];
                axLedgerJournalTrans.parmOffsetAccountType(LedgerJournalACType::Ledger);
                axLedgerJournalTrans.parmOffsetLedgerDimension(AxdDimensionUtil::getLedgerAccountId(accPatternledger));
                axLedgerJournalTrans.parmAmountCurCredit(conPeek(readCon, 7));
                axLedgerJournalTrans.parmTxt(conPeek(readCon,9));
                axLedgerJournalTrans.parmInvoice(conPeek(readCon,10));
                axLedgerJournalTrans.parmPostingProfile(conPeek(readCon,11));
                axLedgerJournalTrans.save();
                icount++;
                inserted++;
            }
        }
      ttsCommit;
    }
   info(strfmt("%1 records Inserted out of %2",inserted,icount));

}

Note : Based on ledger account dimension structure your account pattern will change

@ Rahul Talasila

"Unable to preview the report, install the Business Intelligence Development Studio feature of Microsoft SQL Server. For more information, see http://go.microsoft.com/fwlink/?LinkId=212331”

"Unable to preview the report, install the Business Intelligence Development Studio feature of Microsoft SQL Server. For more information, see http://go.microsoft.com/fwlink/?LinkId=212331”

Solution:

-> Axapta 2012 needs to integrate with Visual Studio 2010.

-> Therefore you have to install BIDS (Business Intelligence Development Studio). 

->You can use a SQL Server 2008 R2 installation image to install it (it’s one of the components you can select during installation of “A new standalone server or additional components” on the client machine.

After the installation open report in visual studio - 2010. 

 Rahul Talasila

Ternary Operator (?) In Axapta 2012

Ternary Operator (?)  is one of code optimization technique in axapta .It acts as a IF condition in axapta


Syntax : 

expression1 ? expression2 : expression3

expression1 must be a Boolean expression. If expression1 is true, the whole ternary statement resolves to expression2; otherwise it resolves to expression3.

expression2 and expression3 must be of the same type as each other.

Example :

By using Ternary operator(?):

int nVar = 2;

;

print nVar < 3 ? nVar + 1 : nVar - 1; // print output 3.

pause;

Same Code By using If() Condition:

int nVar = 2;

;

if(nVar < 3)

{

  nVar = nVar +1;

}

else

{

nvar = nvar-1;

}

// print output 3.

How To Delete Usage Data in Microsoft Dynamics Axapta 2012

Here i'm sharing steps to reset usage data in axapta 2012


-> Open the Microsoft Dynamics AX client.
-> Click File > Tools > Options.
-> Click Usage data.
-> On the General tab, click Reset.


@Rahul Talasila

How To Refresh The Application Object Directory (AOD) Cache

Here I'm sharing steps to refresh the Application Object Directory (AOD) cache.


This will clear cached application object information for all items in the application object tree (AOT) of Microsoft Dynamics AX.


-> Open the Microsoft Dynamics AX client.
-> Open the development workspace.
-> Click Tools > Caches > Refresh elements.

After the cache has been cleared, the Infolog displays a message indicating that AOD elements have been refreshed.

@ Rahul Talasila

Error while setting server report parameters. Error message: The item '/DynamicsAX/*********************' cannot be found. (rsItemNotFound)

Some time we get the below error while opening reports in axapta.

Reason : Reports are not deployed

Solution : To deploy reports.

Here i'm sharing steps how to deploy reports in axapta 2012

 Open Windows PowerShell as an administrator by following these steps:

-> Click Start > Administrative Tools.

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

-> Click Run as administrator.

-> paste below command and press enter .Takes 10-25 minutes to deploy reports.

Deploy All Reports :

Publish-AXReport –ReportName *

Deploy a Specific Report :

Publish-AXReport -ReportName Vend

@ Rahul Talasila

Import General Ledger Opening Balances In Axapta 2012

Here I'm sharing code to import GL Opening Balances Lines.

Note : The below code import only Lines.


-> Copy and paste below code in AOT->Jobs(Compile Job before using)
->open excel and fill the data according to the below format and save in CSV format
->Run job and browse file and press ok

Csv Format :

column1 - GL Journal Number
column2 - MainAccountNum
column3 - Dimension1
column4 - Dimension2
column5 - Dimension3
column6 - Debit Amount
column7 - Credit Amount
column8 - Transaction Date
Column9 - Description

//Code Starts From Here- @ Rahul Talasila

static void GL_OpeningBalances(Args _args)
{
    CommaIO                   csvFile;
    container                 readCon, accPattern,offSetPattern, dimPattern1;
    counter                   icount,inserted;
    Dialog                    dialog;
    DialogField               dfFileName;
    FileName                  fileName;
    AxLedgerJournalTable      axLedgerJournalTable ;
    AxLedgerJournalTrans      axLedgerJournalTrans;
    MainAccount               mainAccount;
    MainAccountNum            mainAccountNum;
    DimensionDynamicAccount   ledgerdimension;
    str transdate;
    ;
     inserted =0;
    #File
    dialog     = new Dialog("Pick the file");
   // dialog
    dfFileName = dialog.addField(extendedTypeStr(FileNameOpen));
    dialog.filenameLookupFilter(["All files", #AllFiles]);
    if(dialog.run())
    {
       filename =  dfFileName.value();
    }
       csvFile  =  new CommaIO(filename,'r');

    if(csvFile)
    {
        ttsBegin;
        while (csvFile.status() == IO_Status::OK)
        {
          readCon  = csvFile.read();
          if(readCon)
            {
                MainAccountNum = conPeek(readCon,2);
                mainAccount = mainAccount::findByMainAccountId(MainAccountNum);

                if(!mainAccount)
                {
                    info(strFmt("%1",MainAccountNum));
                }
                transdate = conPeek(readCon, 8);
                axLedgerJournalTable = new AxLedgerJournalTable();
                axLedgerJournalTrans = new AxLedgerJournalTrans();
                axLedgerJournalTrans.parmJournalNum(conPeek(readCon, 1));
                axLedgerJournalTrans.parmTransDate(str2Date(transdate,123));
                axLedgerJournalTrans.parmAccountType(LedgerJournalACType::Ledger);
                accPattern = [conPeek(readCon,2) + conPeek(readCon,3) + conPeek(readCon,4) + conPeek(readCon,5), conPeek(readCon,2),conPeek(readCon,3),conPeek(readCon,4),conPeek(readCon,5)];
                axLedgerJournalTrans.parmLedgerDimension(AxdDimensionUtil::getLedgerAccountId(accPattern));
                axLedgerJournalTrans.parmDefaultDimension(LedgerJournalTable::find(conPeek(readCon, 1)).DefaultDimension);
                axLedgerJournalTrans.parmOffsetAccountType(LedgerJournalACType::Ledger);
                axLedgerJournalTrans.parmAmountCurDebit(conPeek(readCon, 6));
                axLedgerJournalTrans.parmAmountCurCredit(conPeek(readCon, 7));
                axLedgerJournalTrans.parmTxt(conPeek(readCon,9));
                axLedgerJournalTrans.save();
                icount++;
                inserted++;
            }
        }
         ttsCommit;
    }
  info(strfmt("%1 records Inserted out of %2",inserted,icount));
}

Note : Based on ledger account dimension structure your account pattern will change

@ Rahul Talasila

Axapta Application Compilation In CU7

In cu7 we can compile the application by using the below comamnd

-> Go AOS installed server 
-> Open command prompt(cmd) as a administrator

->paste the below code(Before pasting change aos name ,aos number, workers)

->Press Enter .

cd \Program Files\Microsoft Dynamics AX\60\Server\<YOUR AOS NAME>\bin
axbuild.exe xppcompileall /aos=01 /altbin="C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin" /workers=4

NOTE : <your AOS NAME> -    C:\Program Files\Microsoft Dynamics AX\60\Server (Here you can see you AOS name)

(aos = 01) - check your Axapta Server configuration and give the aos number

You should stop the AOS service before you start

@ Rahul Talasila

Fatal SQL condition during login. Error message: "The internal time zone version number stored in the database is higher than the version supported by the kernel (5/2). Use a newer Microsoft Dynamics AX kernel."

Some times AOS  will not start and shows the below error in the Event Viewer.

Fatal SQL condition during login. Error message: "The internal time zone version number stored in the database is higher than the version supported by the kernel (5/2). Use a newer Microsoft Dynamics AX kernel."


Reasons :
->  when you restore axapta database.
-> when you install more than one AOS in the same server
-> when running more than two axapta environments in the same server

Solution :

->Open  Sql Management Studio

->Go to MicrosoftDynamicsAx(Axapta Database) database and dbo.SQLSystemVariables table and edit records. In that go to SYSTIMEZONESVERSION  record and update value (5/2) in the place of 5 to 2.

@Rahul Talasila

How to Install Management Reporter in Ax 2012 R3 - Step by step

Here I'm sharing steps how to install Management Reporter in Ax 2012 R3

Sql Server Version : 2014

Windows server : 2012 R2

Axapta : Ax 2012 R3

 Management Reporter 2012 CU10 (version 2.1.10001.112)

Download Link : https://mbs.microsoft.com/customersource/northamerica/MR/downloads/service-packs/MROverview

customer/partner id and password is required 

Note : If you are using sql 2012 then install MR from Ax 2012 R3 set up.

Steps 

Run MR Setup

Insall->Management Reporter Server

Give service account user id and password 

Database Server : DB server name

Select windows authentication(If want to use"sa" then uncheck it and give "sa" and password)

Give password and confirm password

Port Num : 4712(By default this the port number . If you want you can change but remember the port number because while installing MR client we use the same port number)

Services Endpoint Port: 8201 (Generally people confuse here 8101 or 8201.  8101 is WSDL port number not service endpoint port)

AOS Server: AOS Installed Machine Name

User Name : AOS execution user name and password

DataBase Server : DB server Name

DataBase Name : MicrosoftDynamicsAX(Axapta DB Name)

Click Next

After few minutes Management Reporter will be installed.

Then open configuration console and you will have a new node under ERP Integration. Select the node and ENABLE INTEGRATION and click on refresh.

Again go back to the setup and click on

Install->Management Reporter Client->Next->Next

Server : http://servername:4712

(serverName : MR installed server Name)

click next and finish the installation.

@Rahul Talasila

Integrate Google Maps In Axapta 2012 R2 & Axapta 2012 R3

In Axapta system we can see customer / vendor address in bing.com maps.

In this customization I will show the same in google maps.

Before:

Accounts receivable/Common/Customers/All customers

Select any customer and edit

In Address tab we can see “Map”. When we click on that we can see customer address in bing maps.

After

Go to AOT-> Classes -> smmutility ->mapit (Method)

Copy and replace the below code in mapit method

/// <summary>

/// Opens Bing maps with the address.

/// </summary>

/// <param name="_address">

/// The address to map.

/// </param>

public static void mapIt(LogisticsPostalAddress _address)

{

   // #DEFINE.MapURL('http://maps.bing.com/default.aspx?where1=\%1')//Commented By Rahul

    #DEFINE.MapURL('https://www.google.com/maps/place/')//N-Code Added By Rahul Talasila

    #DEFINE.comma(',')

    #DEFINE.newLine('\n')

    str     address;

    ;

    if (_address)

    {

        address = _address.Street + #comma +

                  _address.City + #comma +

                  _address.State + #comma +

                  _address.ZipCode + #comma +

                  _address.CountryRegionId;

        // Replace the newline with comma

        address = strReplace(address, #newline, #comma);

        // URL encode

        address = System.Web.HttpUtility::UrlEncode(address);

        // Add the address to the URL

        infolog.urlLookup(strFmt(#MapURL+ address));//N-Code Changed By Rahul Talasila

    }

}

Go back to the customer->address and click on map.

 Below link helped me ..

http://querystring.org/google-maps-query-string-parameters/

@Rahul Talasila

Example : DialogButton with box YesNo

Dialogbutton db;
;
db = box::yesNo("Choose Yes or No", dialogButton::Yes, "YesNo Box Example");
if (db == dialogButton::Yes)
  {
      info( "We chose Yes");
  }
else if (db == dialogButton::No)
{
     info( "We chose No");
}

@RahulTalasila

How to resolve unbalanced TTSBegin/TTSCommit Error in Axapta

static void resetTTS(Args _args)
{
   while (appl.ttsLevel() > 0)
   ttsAbort;
}

using cacheAddMethod in display and edit methods

Display and edit methods are used on forms to display data that must be derived or calculated based
on other information in the underlying table. These methods can be written on either the table or the
form. By default, these methods are calculated one by one, and if there is a need to go to the server
when one of these methods runs, as there usually is, each function goes to the server individually. The fields associated with these methods are recalculated every time a refresh is triggered on the form, which can occur when a user edits fields, clicks menu items, or presses F5. Such a technique is expensive in both round trips and the number of calls placed to the database from the Application ObjectServer (AOS).

Caching cannot be performed for display and edit methods that are declared on the data source
for a form because the methods require access to the form metadata. If possible, you should move
these methods to the table. For display and edit methods that are declared on a table, use the
FormDataSource.cacheAddMethod method to enable caching.Caching cannot be performed for display and edit methods that are declared on the data source for a form because the methods require access to the form metadata. If possible, you should move these methods to the table. For display and edit methods that are declared on a table, use the FormDataSource.cacheAddMethod method to enable caching. This method allows the form’s engine to calculate all the necessary fields in one round trip to the server and then cache the results. To use cacheAddMethod, in the init method of a data source that uses display or edit methods, call cacheAddMethod on that data source and pass in the method string for the display or edit method.For example, look at the SalesLine data source of the SalesTable form. In the init method, you will

Example

public void init()
{
super();
salesLine_ds.cacheAddMethod(tableMethodStr(SalesLine, invoicedInTotal), false);
salesLine_ds.cacheAddMethod(tableMethodStr(SalesLine, deliveredInTotal), false);
salesLine_ds.cacheAddMethod(tableMethodStr(SalesLine, itemName), false);
salesLine_ds.cacheAddMethod(tableMethodStr(SalesLine, timeZoneSite), true);
}

How To Refresh elements in the AOT

If several developers modify elements simultaneously in the same installation of AX 2012, each
developer’s local elements might not be synchronized with the latest version. To ensure that the local
versions of remotely changed elements are updated, an auto refresh thread runs in the background.
This auto refresh functionality eventually updates all changes, but you might want to force the refresh
of an element explicitly. You do this by right-clicking the element, and then clicking Restore. This
action refreshes both the on-disk and the in-memory versions of the element.


Typically, the general integrity of what’s shown in the AOT is managed automatically, but some
operations, such as restoring the application database or re installing the application, can lead to
inconsistencies that require manual resolution to ensure that the latest elements are used. To perform
manual resolution, follow these steps:


1. Close the AX 2012 client to clear any in-memory elements.
2. Stop the Microsoft Dynamics Server service on the Application Object Server (AOS) to clear
any in-memory elements.
3. Delete the application element cache files (*.auc) from the Local Application Data folder
(located in %LocalAppData%) to remove the on-disk elements.

         C:\Users\youruserid\AppData\Local

Note : Make sure show hidden files,folders,and drivers option enabled

@Rahul Talasila

All Element Names In The AOT use The Following Structure

 <Business area name> + <Functional area> + <Functionality, action performed, or type of content>


Prefixes are commonly used to indicate the team responsible for an element.
For example, in the name BankLCImport the prefix Bank is an abbreviation
of the business area name (Bank), LC describes the functional area (Letter Of Credit),
and Import lists the action performed (import).

@Rahul Talasila

New Element Naming Conventions In Ax 2012

When creating new elements in the AOT, ensure that you follow the recommended naming conventions.

Prefix Description Ax Microsoft Dynamics AX typed data source Axd Microsoft Dynamics AX business document Asset Asset management BOM Bill of material COS Cost accounting Cust Customer Dir Directory, global address book EcoRes Economic resources HRM/HCM Human resources Invent Inventory management JMG Shop floor control KM Knowledge management Ledger General ledger PBA Product builder Prod Production Proj Project Purch Purchase Req Requirements Sales Sales SMA Service management SMM Sales and marketing management, also called customer relationship management (CRM) Sys Application frameworks and development tools Tax Tax engine Vend Vendor Web Web framework WMS Warehouse management

@Rahul Talasila