• Skip to main content
  • Skip to primary sidebar
  • Home
  • About
  • Recommended Readings
    • 2022 Book Reading
    • 2023 Recommended Readings
    • Book Reading 2024
    • Book Reading 2025
  • Supply Chain Management Guide
  • PKM
  • Microsoft Excel

Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

Dynamics Ax 7

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

April 11, 2019 by alirazazaidi

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.

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

February 23, 2019 by alirazazaidi

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

February 4, 2019 by alirazazaidi

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.

February 3, 2019 by alirazazaidi

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();

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

January 21, 2019 by alirazazaidi

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.

January 18, 2019 by alirazazaidi

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.

 

How to get table id in Dynamics 365 for finance and operations.

January 15, 2019 by alirazazaidi

Table Id can be found SysTableIdView.  in Dev environments, you can do direct query on sql server.

select * from SysTableIdView

 

If you did not access sql server then you can open it on table browser.

 

http://usnconeboxax1aos.cloud.onebox.dynamics.com/?cmp=usmf&mi=SysTableBrowser&TableName=SysTableIdView

 

List of best blog post and article for Customization with extensions. Dynamics 365 for finance and operations

January 5, 2019 by alirazazaidi

Here collection of good articles / blog posts for Extension framework.

I just completed the customization using extension. Initially, it’s really tough for me. But with passage of time and my library of code snippet increased, I  felt the power of extensions over old classic overlay concept. Even I used extension in custom forms instead write old age methods in controls and data sources.

Here are some  links which are very helpful for me and worth to share.

 

Event handling:

 

https://us.hitachi-solutions.com/knowledge-center/customize-dynamics-365-user-interface-extension-event-handler/

https://community.dynamics.com/365/financeandoperations/b/newdynamicsax/archive/2016/10/11/code-behind-extension-forms-how-to-add-state-variable-and-override-methods-without-overlayering

 

https://community.dynamics.com/ax/b/dynamicsaxconcoction/archive/2017/05/17/d3fo-customizing-interaction-classes-using-extensions

 

https://devserra.wordpress.com/2016/04/19/ax7-using-table-event-handler/

https://community.dynamics.com/365/financeandoperations/b/howtodynamics365/archive/2018/04/24/how-to-create-display-method-for-table-extension-in-dynamics-365

https://axility.net/en/access-stuff-in-the-new-event-subscriptions/

 

 

 

 

 

 

 

Workflow:

http://d365technext.blogspot.com/2018/07/avoid-over-layering-in-development-of.html

 

https://community.dynamics.com/365/financeandoperations/b/nareshsdynamicsaxblog/archive/2017/03/15/create-custom-workflow-in-d365-dynamics-365

 

https://devmusings.blog/2018/03/18/custom-workflows-in-microsoft-dynamics-365-for-operations/

 

https://community.dynamics.com/365/financeandoperations/b/dynamics365foaxhub/archive/2018/10/06/create-custom-workflow-participant-assignment-provider-type-in-ax-2012

https://workflowax.wordpress.com/2009/10/30/participant-provider-example/

https://www.lexisnexis-es.co.uk/blog/2018/10/22/workflows-in-microsoft-dynamics-365-for-finance-and-operations/

 

 

 

 

 

 

 

 

Model:

 

 

https://stoneridgesoftware.com/what-is-the-modelutil-exe-good-for/

 

https://community.dynamics.com/365/financeandoperations/f/765/t/223547

https://www.cloudfronts.com/model-importexport-in-dynamics-365-operations/

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/dev-tools/models-export-import

 

 

Email templates

 

https://www.sikich.com/insight/how-to-email-purchase-orders-in-dynamics-365-for-operations/

 

 

 

Vendor Collaboration:

 

https://gfeaxblog.wordpress.com/2018/05/16/vendor-collaboration-in-microsoft-dynamics-365-for-finance-and-operations/

 

 

 

Reports through extension:

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

https://blogs.msdn.microsoft.com/dynamicsaxbi/2017/01/02/customizing-app-suite-reports-using-extensions/

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/customize-app-suite-reports-with-extensions

 

 

Custom form:

https://dynamicsaxinsight.wordpress.com/2017/06/23/ax7-d365-operations-create-details-master-pattern-form/

 

 

Avoid Over layering in Development of Workflows on Existing Form Extension version – Dynamics 365 for finance and operations

November 23, 2018 by alirazazaidi

Hi all,  My fellow Sohail Shaikh wrote an excellent blog Post, I used it in my customization to avoid overlay methods in some of out of the box table.

http://d365technext.blogspot.com/2018/07/avoid-over-layering-in-development-of.html

 

 

That article made my day and worked perfectly fine. But here one thing that article missed.  How we have to set form designer the custom workflow in list page . Something like If I copied from Sheiks sabs article.

 

 

There is error when I created on initialized of custom table in a extension class for list page . I got following error.

 

 

So it is not possible, I still not figure out. Later possible I will got they way to do so. Any how I achieved this in extension for interaction class.  I copied the  post event of initializeQuery method and copied in my class and following code will work for me. To enable or disabled workflow in list page

 

[PostHandlerFor(classStr(TableListPageInteraction), methodStr(ListPageInteraction, initializeQuery))]

public static void TableListPageInteraction_Post_initializeQuery(XppPrePostArgs args)

{

TableListPageInteraction TableListPageInteraction = args.getThis();

StatusTable RFQStatusTable = purchRFQCaseTableListPageInteraction.listPage().activeRecord(queryDataSourceStr(TableListPage, DDSRFQStatus)) as DDSRFQStatus;

FormRun formRun = TableListPageInteraction.listPage().formRun();

 

FormRun.design().workflowDatasource(formDataSourceStr(PurchRFQReplyTable, DDSRFQStatus));

FormRun.design().workflowEnabled(true);

FormRun.design().workflowType(workflowtypeStr(DSSRFQCaseWFType));

 

}

 

It works for me

Out of the box workflow labels Dynamics 365 for finance and operations

November 23, 2018 by alirazazaidi

Hi all, this is post is for me. I used to make workflow in Customization, Instead created new labels, I used out the box label for workflow menus

 

menu items labels

@SPS1299 Submit to workflow
@SPS1329 Cancel
@SPS1303 Delegate
@SPS1306 Resubmit
@SPS1301 Reject
@SYS38598 Approve
@SYS109045 RequestChange

@SYS109048 Resubmit

Status enum labels

@SPS1268 not submitted

@SPS1283 Submitted
@SPS1285 Approved

@SYS75939 Draft
@SYS784 Rejected

                    @SYS319813 Cancelled

@SYS319123 InReview

                        @SYS109045                  ChangeRequest

 

« Previous Page
Next Page »

Primary Sidebar

About

I am Dynamics AX/365 Finance and Operations consultant with years of implementation experience. I has helped several businesses implement and succeed with Dynamics AX/365 Finance and Operations. The goal of this website is to share insights, tips, and tricks to help end users and IT professionals.

Legal

Content published on this website are opinions, insights, tips, and tricks we have gained from years of Dynamics consulting and may not represent the opinions or views of any current or past employer. Any changes to an ERP system should be thoroughly tested before implementation.

Categories

  • Accounts Payable (2)
  • Advance Warehouse (2)
  • Asset Management (3)
  • Azure Functions (1)
  • Books (6)
  • Certification Guide (3)
  • Customization Tips for D365 for Finance and Operations (62)
  • D365OF (59)
  • Data Management (1)
  • database restore (1)
  • Dynamics 365 (58)
  • Dynamics 365 for finance and operations (135)
  • Dynamics 365 for Operations (165)
  • Dynamics AX (AX 7) (134)
  • Dynamics AX 2012 (274)
  • Dynamics Ax 2012 Forms (13)
  • Dynamics Ax 2012 functional side (16)
  • Dynamics Ax 2012 Reporting SSRS Reports. (31)
  • Dynamics Ax 2012 Technical Side (52)
  • Dynamics Ax 7 (65)
  • Exam MB-330: Microsoft Dynamics 365 Supply Chain Management (7)
  • Excel Addin (1)
  • Favorites (12)
  • Financial Modules (6)
  • Functional (8)
  • Implementations (1)
  • Lifecycle Services (1)
  • Logseq (4)
  • Management Reporter (1)
  • Microsoft Excel (4)
  • MS Dynamics Ax 7 (64)
  • MVP summit (1)
  • MVP summit 2016 (1)
  • New Dynamics Ax (19)
  • Non Defined (9)
  • Note taking Apps (2)
  • Obsidian (3)
  • Personal Knowledge Management (2)
  • PKM (13)
  • Power Platform (6)
  • Procurement (5)
  • procurement and sourcing (5)
  • Product Information Management (4)
  • Product Management (6)
  • Production Control D365 for Finance and Operations (10)
  • Sale Order Process (10)
  • Sale Order Processing (9)
  • Sales and Distribution (5)
  • Soft Skill (1)
  • Supply Chain Management D365 F&O (3)
  • Tips and tricks (278)
  • Uncategorized (165)
  • Upgrade (1)
  • Web Cast (7)
  • White papers (4)
  • X++ (7)

Copyright © 2025 · Magazine Pro On Genesis Framework · WordPress · Log in