Ali Raza Zaidi

Musing's of ERP Consultant

You are here: Home / Archives for Dynamics 365 for finance and operations / Dynamics 365 for Operations

Dynamics 365 for Operations

Unable to download report as PDF Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync Dynamics 365 for finance and operations

By

During Save as pdf custom report throw following error.

 
Unable to connect to the remote server at Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync[T](RESTCommand`1 cmd, IRetryPolicy policy, OperationContext operationContext) at Microsoft.WindowsAzure.Storage.Table.CloudTable.Exists(Boolean primaryOnly, TableRequestOptions requestOptions, OperationContext operationContext) at Microsoft.WindowsAzure.Storage.Table.CloudTable.CreateIfNotExists(TableRequestOptions requestOptions, OperationContext operationContext) at Microsoft.DynamicsOnline.Infrastructure.Components.TableAccessor.TableStorageAccessor.PerformOperation(CloudStorageAccount storageAccount, String tableName, Func`1 operation) at Microsoft.DynamicsOnline.Infrastructure.Components.TableAccessor.TableStorageAccessor.AddRecord[T](CloudStorageAccount storageAccount, String tableName, T record) at Microsoft.DynamicsOnline.Infrastructure.Components.SharedServiceUnitStorage.SharedServiceUnitStorage.UploadData(SharedServiceUnitStorageData data, Stream stream) at
 
It was problem that Azure Storage emulator was not running on my machine. 
For this I have to open window start and write there Azure Storage emulator.
After it searched, click and run the Azure storage Emulator.

 In my Case  emulator Version was out date. I have to download it from Microsoft Cloud. After running that service. Issue was resolved. Report successfully download as pdf.
Reference : https://docs.microsoft.com/en-us/azure/storage/common/storage-use-emulator

List of Vendor Invoices against Payment General Entry

By

Between posted Vendor Payment Journal and Settled Invoice only relation is Voucher number in ledger Journal Trans and VendSettlement Table.

So My friends my code snippet is here,

        VendTrans               vendTrans;

        VendSettlement          VendSettlement;

  while select * from VendSettlement

                join  * from vendTrans

                where VendTrans.DataAreaId == VendSettlement.TransCompany

                && VendTrans.RecId  == VendSettlement.TransRecId

                && VendTrans.AccountNum == VendSettlement.AccountNum

                && VendSettlement.OFFSETTRANSVOUCHER == _ledgerJournalTrans.Voucher

Haaapy Daxinggg

Serialization version mismatch detect, make sure the runtime dlls are in sync with the deployed metadata D365 For finance and operations

By

Don’t what reason, possible I manually copied the model files to my dev one box. After compiling my model and run the customization, on one control document. I faced this issue.
Serialization version mismatch detect, make sure the runtime dlls are in sync with the deployed metadata. Version of file ‘12104’. Version of dll ‘172’.
Solution for that. I build all models by checking all models.

The field with ID ‘0’ does not exist in table Dynamics 365 For finance and operations

By

Hi all, I face this error, while extended existing custom report. I added some fields in temp table, after update logic in dp class, On report data set update.

But at run time report shows this error. While debugging the code, I found the error occur on mapping the new fields in temp table.

 

Solution :

I build the whole model. After that error was removed.

 

An error occurred during report data sets execution D365 For finance and operations

By

Hi all, small tip. I faced this issue, when I extend the custom report in D365 for finance and operations. During development on onebox

 

 

Solution was simple,

  • restart IIS services
  • Restart Reporting Services.

Happy Daxing.

How to copy financial dimension form one object to other. Dynamics 365 For finance and operations

By

Hi all, In some cases we can need to copy  financial dimension from one object to  other for example Customer to Sales order or Vendor to purchase order.

In Ax 2012  it little easy. But in D365 For finance and operations, it is little bit tricky.

 

I did this with following code snippet.  With the help of out of box. LedgerDimensonDefaultFacade class i used the merge default dimension method and passed same table dimension in form and to dimension.

Result is interesting.

 

 

 salestable.DefaultDimension= LedgerDimensionDefaultFacade::serviceMergeDefaultDimensions(CustTable.DefaultDimension,CustTable.DefaultDimension);

Could not find FileLocations.xml in the package On-premises deployment failed Dynamics 365 for finance and operations

By

Today I faced this issue, While deployment of package on-premises deployment. Deployment failed, even rollback failed. log files shows following message

“Could not find FileLocations.xml in the package”

 

But event log files on orch 2 has very different story. It says

Task OrchestrationService.DeployModulesRunnerTask,OrchestrationService failed for command id 2b462374-eda7-41e5-88d5-da2fe3de9202

System.AggregateException: One or more errors occurred. —> System.TimeoutException: Operation timed out. —> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80071BFF at System.Fabric.Interop.NativeClient.IFabricApplicationManagementClient10.EndProvisionApplicationType3(IFabricAsyncOperationContext context) at

 

But both these error was misleading. Deployment successful, after stopping the antivirus.

 

 

 

Calling menu name in Extensions Dynamics 365 for finance and operations

By

In Ax 2012 we get menu name with element.Args().CallMenu name, using  taking decision on menu name.

 

But same logic we need to apply in Extension. But in D365 For finance and operations we did not overlay. Following code snippet helps me to implement similar logic in Extension.

 

 

[ExtensionOf(formStr(CustTable))]

final class IaLogisticsContactInfoGrid_Extension

{

 

 

/// <summary>

///

/// </summary>

/// <param name=”sender”></param>

/// <param name=”e”></param>

[FormEventHandler(formStr(LogisticsContactInfoGrid), FormEventType::Initialized)]

public static void LogisticsContactInfoGrid_OnInitialized(xFormRun sender, FormEventArgs e)

{

 

FormRun formRun = sender;

 

;

 

info(formRun.args().menuItemName());

}

 

}

Journal name . does not support journal type Daily X++ Dynamics 2012 r3

By

Hi did one customization, where I create Ledger Journal using X++ code. It was working perfectly fine with Ledger General Ledger entries. But threw error  on creating Ledger for AR,PR Payment.

 

I created ledger with following code snippet.  But it works only for Ledger for of Type Daily

 

AxLedgerJournalTable    header  = new AxLedgerJournalTable();
AxLedgerJournalTrans    trans   = new AxLedgerJournalTrans();

container               offsetDim;
LedgerJournalNameId     ledgerJournalNameId = “payment”;

header.parmJournalName(ledgerJournalNameId);
header.parmJournalType(LedgerJournalType::CustPayment);
header.save();

I replaced the above code with following snippet it works perfectly fine, rest of the code is works fine

LedgerJournalName ledgerJournalName;
LedgerJournalTable ledgerJournalTable;
LedgerJournalTrans ledgerJournalTrans;

select firstonly ledgerJournalName
where ledgerJournalName.JournalName == parameters.LedgerJournalNameId &&
ledgerJournalName.JournalType == LedgerJournalType::CustPayment;
if(!ledgerJournalName.RecId)
throw error(“@CAM184”);
if(ledgerJournalName)
{
ledgerJournalTable.JournalName = ledgerJournalName.JournalName;
ledgerJournalTable.Name = ledgerJournalName.Name;
ledgerJournalTable.insert();
}

In keyword While select statement X++ Dynamics 365 for finance and operations

By

Hi  Today I found very interesting post here , where we can use “In” keyword for While select or Select statement.

in will be enum based.

SalesTable  salesTable;
container   con = [SalesType::Sales, SalesType::ReturnItem, SalesType::Subscription];
while select * from salesTable
where salesTable.SalesType in con
{
Info(salesTable.SalesId);
}
reference :

D365/AX7:SQL IN Operator In X++ Where Clause (Enum Fields Only)

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.

 

Data source filter using extension Dynamics 365 for finance and operations

By

Hi every one, Today I have very small tip. During customization we need to add filters at run time. Specially in the case of inquiry forms. But Now we have to work with extension. Extensions are much more powerful then over layering.

 

So first one thing to copy Datasource  OnQueryEXecuting event. And paste in Extension class.

The sample code snippet is here.

 

 

 

 [FormDataSourceEventHandler(formDataSourceStr(HcmDiscussion, HcmTopicRef), FormDataSourceEventType::QueryExecuting)]

public static void HcmTopicRef_OnQueryExecuting(FormDataSource sender, FormDataSourceEventArgs e)

{

FormRun          HcmDiscussionForm = sender.formRun();

sender.query().dataSourceName(sender.name()).addRange(fieldnum(HcmTopicRef,     HeadingRefRecId)).value(queryValue(_heading.RecId));

}

Report menu item is not found when constructing the query string” Dynamics 365 for finance and operations.

By

I found following error, while running custom report.

 

 

 

Following message shown message.

 

 

 

Report run from controller class.  I found “controller.parmArgs(_args);” was missing. That reason report threw this error.

 

Complete code will be similar.

 

 

 

 

        contract.parmRecordId(invoiceJour.RecId);

controller.parmArgs(_args);

 

controller.parmReportName(ssrsReportStr(DSSCompletionCertificate, Design));

controller.parmShowDialog(false);

controller.parmReportContract().parmRdpContract(contract);

controller.startOperation();

error : Can’t start service W3SVC on computer ‘.’. Dynamics 365 for finance and operations.

By

I got error on My Dev box virtual machine. When I tried to restart AOS or IIS service.

 

 

I found that World wide web service is in stopping mode. Some reason it stuck. So I restart my machine.

AOS/ IIS works perfectly fine after restart. Basically two services need to run if you found this error

 

  • IIS admin service.
  •  World wide web service

 

Custom designs for business documents- Issue Original report was running instead customized, Dynamics 365 for finance and operations

By

I did some customization in Business Document or some places these reports are called control document. In classic Ax 2012 we overlay and a lot of efforts saves. But In D365 use extension, which is more powerful feature.

 

With help of a following article I did customization at least 3 to 4 reports and these reports works fine.

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/custom-designs-business-docs

 

But In one case. It did not work, the required report designer did not show in

Setup > Forms > Form setup. Click Print Management . And original report with design run instead of custom design.

I tried on multiple environment, but issue sustain.

 

 

By adding following code snippet in my Extended Controller class will resolve the issue. It works for me.

 

 

protected void outputReport()

{

SRSCatalogItemName  reportDesign;

reportDesign = ssrsReportStr(MyPurchPurchaseOrder,Report);

this.parmReportName(reportDesign);

this.parmReportContract().parmReportName(reportDesign);

formletterReport.parmReportRun().settingDetail().parmReportFormatName(reportDesign);

super();

}

How to disabled workflow approval options in Dynamics 365 for finance and operations.

By

Amazing, I got requirement that Change request option need not in workflow. I opened the workflow approval in AOT. Approval all options were there. As compare to other AOT objects where we enable disabled two properties without creating extension are “Label” and visible. But here nothing found. There is no option to modify anything “out of the box” workflow.

 

While exploring workflow designer configuring Workflow. I found that some properties when we drag approval  object on workflow designer. Not step object inside approval.

In properties, I found some options. That works for me.

 

On workflow dialog change request options is gone.