Wednesday, July 7, 2021

Fetch Data from direct SQL Queries in ax 2012 d365fo

›
 Fetch Data from direct SQL Queries         Connection  connection;         Statement   statement;         str         sql;         ResultSe...

Record Insert List in D365 FO in AX 2012

›
Record Insert List to insert data in one SQL Call. Helps in improve performance RecordInsertList tmpValueReporting = new RecordInsertList(ta...
Wednesday, June 23, 2021

SSRS Report Deployment failed - The number of defined parameter is not equal to the number of cell definitions in the parameter panel. in d365fo

›
  Report deployment parameter Error Error: - The number of defined parameter is not equal to the number of cell definitions in the parameter...
3 comments:
Monday, June 21, 2021

AX2012 - How to fix ID Conflict issue

›
 We can Get ID Conflict issue while importing Model Store or XPO etc. I was able to fix somehow by using below link: - https://github.com/DA...
Wednesday, June 16, 2021

Workflow approver with submitted date and approved date in d365fo

›
  public void init() { AFZ_PurchaseRequisitionSummaryReportTableTmp prTmp; PurchReqTable purchReqTable; PurchReqLine purchReqLine; Wor...
Monday, May 24, 2021

To find out which table access is missing - event create rule permission in d365fo

›
  class EventSecurity, method isFilterAccessible. To find out which table access is missing you can change this method in a TEST environment...

get last workflow approver in d365fo

›
  while select workflowTrackingTable  order by CreatedDateTime asc                                              where workflowTrackingTable....