Ali Raza Zaidi

Dynamics 365 development notes

You are here: Home / Blog

Blog

Customer Financial Dimensions copy to Ledger Trans Financial dimension. Dynamics ax 2012 R3

By

Does experience count, As ERP consultant, There are always new challenge. With 7 years core Dynamics Customization Experience, Still found new things to learn. Experience told you how to hide your fear of unknown and possibility.

Today very small tip. Which i resolve with experience. We usually create Ledger General With X++ code. The code is available in many webs sites. But today I need to copy financial dimension of Customer/ Vendor/Bank/ Assets to Ledger Journal trans. I found  function in AxdDimensionUtil Class provide the functionality.

The code snippet is as follow. The ledger Journal trans have to two default dimension, one for account and second for offset account.

Suppose we are copy financial dimension form customer account to customer.

trans.parmAccountType(LedgerJournalACType::Cust);
custTable =CustTable::find(_account);
conDim= AxdDimensionUtil::getDimensionAttributeValueSetValue(custTable.DefaultDimension);
trans.parmDefaultDimension(AxdDimensionUtil::getDimensionAttributeValueSetId(conDim));

 

Paging in Query X++ Dynamics 365 for finance and operations

By

For paging in X++ Query. There are three steps required. Rest of Query Code is same.

We have to set following things in Query data source

  • Set Sort field in Query data Source.
  • Paging position property of QueryRun is set to true.
  • Add page range with starting position and number of records in QueryRun

Here is code snippet

 

  QueryBuildRange qbr,qbrStartDate,qbrEndDate;
QueryBuildDataSource qbd;
IAPageSize EnumPageSize;

QueryRun        qr;

Query           query = new Query();

Int pageSize = 2;

 

qbd = query.addDataSource(TableNum(ProjPlanVersion));
qbd.addOrderByField(fieldNum(ProjPlanVersion,HierarchyId));

qr = new QueryRun(query);

qr.enablePositionPaging(true);
            CurrentPageNumber =1;
            startingposition = CurrentPageNumber * pagesize;
            qr.addPageRange(startingposition, totalRows);
while(qr.next())

 

{

 

Info (“”);

}

Cannot stop DynamicsAxBatch service on computer Dynamics 365 for finance and operations

By

I still like the Idea shared by “Gary Vaynerchuk ” Post ” Document dont create” So I document what I face today and resolved.

 

Today I am facing Project compilation Error in Visual studio output pane, I am struggling to understand Table control, so I can meet the development of my next assignment.  Error was

 

 

 

Severity        Code        Description        Project        File        Line        Suppression State

Error                One or more errors occurred. —> System.InvalidOperationException: Cannot stop DynamicsAxBatch service on computer ‘.’. —> System.ComponentModel.Win32Exception: The service cannot accept control messages at this time

— End of inner exception stack trace —

at System.ServiceProcess.ServiceController.Stop()

 

When I open Services, I found that DynamicsAXBatch services is in stopping mode and stuck.

 

So I killed the service process with CMD command. “taskkill /f /pid [pid number]”

 

The message already shows the service name. ” DynamicsAXBatch” You can copy it from Service detail dialog.

 

So Open CMD with run as administrator and run the following command and get  pid

 

sc queryex DynamicsAxBatch

 

Now I have IP.

 

And kill the Process Id

 

taskkill /f /pid 5352

 

Now I start the service again.

Project is successfully complied.