Ali Raza Zaidi

Dynamics 365 development notes

You are here: Home / Archives for Tips and tricks

Tips and tricks

Trying:exec BudgetControlCheckBudgetProc :BudgetControlCheckBudgetProc: Dynamics Ax 2012 R3

By

Hi all I faced this error on Production server.  Error occur when User Post Purchase Invoice. [Microsoft][SQL Server Native Client 11.0][SQL Server]BudgetControlProcessProc ( in SysRaiseErrorProc): Trying:exec BudgetControlCheckBudgetProc :BudgetControlCheckBudgetProc: Trying:Initial insert #BSTDStage - BudgetSourceTrackingDetail:String or binary data would … [Read more...] about Trying:exec BudgetControlCheckBudgetProc :BudgetControlCheckBudgetProc: Dynamics Ax 2012 R3

Required table did not appear in relation drop-down D365 for Finance and Operations.

By

Hi All, I was doing my Pilot project in D365 for Finance and operations. I want to add HCMWorker relation to my custom table. But did not found in drop down.         It means model reference(Package) was not included in Current Model. For this   For this first check Required model on table and add its reference On … [Read more...] about Required table did not appear in relation drop-down D365 for Finance and Operations.

Data Manipulation in Dynamics Ax 2012- Array as Extended Data Type

By

I found a array based field in TSTimesheetLineWeek table, Field TSWeeklyHours Now challenge is to enabled field based on Array. For example need to disabled on day 6. Following code snippet help me to enabled disabled fields generated on the base of array extended Type TSTimesheetLineWeek_ds.object(fieldId2Ext(fieldNum(TSTimesheetLineWeek, Hours), … [Read more...] about Data Manipulation in Dynamics Ax 2012- Array as Extended Data Type

How to get Worker’s Dependent Dynamics Ax 2012 R3

By

Here is small and quick tip. Couple of Days ago I helped a developer to get Dependent out of worker. Microsoft provide a View DirPartyRelationshipsUnionView. Here Worker Party Id is saved as "otherParty" and dependent Party id can be found as " SELFPARTY". Quick SQL query is below, select name from DIRPARTYTABLE where recid in ( select SELFPARTY from … [Read more...] about How to get Worker’s Dependent Dynamics Ax 2012 R3

Updating Date Effective Tables in AX 2012, Dynamics 365 for finance and operations

By

I was struggling to update Date Effective Table in Dynamics Ax 2012 R3. At least one hour of struggle, finally I update the required record.   Only good post which helps is by Agnela GoldBrg.   http://ibisinc.com/blog/updating-date-effective-tables-in-ax-2012/   One line tip from this post is on Date Effective table, The active record reference … [Read more...] about Updating Date Effective Tables in AX 2012, Dynamics 365 for finance and operations

System.Net.ProtocolViolationException: Cannot send a content-body with this verb-type. Dynamics Ax 2012 Json Service

By

The piece of code you wrote, take long way to reach production server. And usually different errors occurs when we take code one server to other.  I test restful service code C# class and call it form X++  code multiple times and it works perfectly fine on QA. But when I took same code to Uat server it started throw following error System.Net.ProtocolViolationException: … [Read more...] about System.Net.ProtocolViolationException: Cannot send a content-body with this verb-type. Dynamics Ax 2012 Json Service

Drill through SSRS – Dynamics 365 for Finance and Operations

By

Helped a junior, build a small SSRS expression, who build hyperlink to Course page on SSRS. You can modify it with respect your need.   =Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink( Parameters!AX_ReportContext.Value, Parameters!AX_UserContext.Value, "HRMCourseTable", "Display", "HRMCourseTable", "hrmCourseId", … [Read more...] about Drill through SSRS – Dynamics 365 for Finance and Operations

Where to download D365 for finance and Operations VM

By

Hi all, connect link is now part of past. VHD link on  collaboration  site did not work.  You can down it from lcs. For this you have subscription on LCS.Dynamics.com for D365 for Finance and operations.   After successful, login you will find Shared Asset in boxes section.     At the time of writing this small tip, Dynamics 365 for Finance … [Read more...] about Where to download D365 for finance and Operations VM

Parameter _reportName cannot be null or empty. Dynamics Ax 2012 R3

By

Hi, All, After Incremental CIL,  errors started to appear on controller classes. These are all those classes where report Name is mentioned in code. Error message in compilation as below. Parameter _reportName cannot be null or empty. When we compiled respected class, This error move to next controller class. After compiling number of classes. Finally We decided to compile … [Read more...] about Parameter _reportName cannot be null or empty. Dynamics Ax 2012 R3

Operation could not completed parameter is incorrect D365 for finance and operations.

By

Aahaaaa, just started development, one table, some edts and a form, as I tried to compile , I found the Error " Operation could not completed parameter is incorrect". Interestingly, the old trick, run visual studio as administrator still works here. So I saved the project and run the Visual studio by right click on visual studio Icon and select the run at … [Read more...] about Operation could not completed parameter is incorrect D365 for finance and operations.

Customer / Vendor ledger Dimension D365 for finance and operations X++

By

  In D365 for finance things are little bit change and much more organized. In Dynamics Ax 2012, which consider as classic AX. We get ledger dimension  with DimensionStorage class   ledgerDim = DimensionStorage::getDynamicAccount( 'US-001', LedgerJournalACType::Cust);//Account offsetLedgerDim = DimensionStorage::getDynamicAccount( 'USMF … [Read more...] about Customer / Vendor ledger Dimension D365 for finance and operations X++