Ali Raza Zaidi

Dynamics 365 development notes

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

By Leave a Comment

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)

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 … [Continue reading] about Customer Financial Dimensions copy to Ledger Trans Financial dimension. Dynamics ax 2012 R3

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 … [Continue reading] about Paging in Query X++ Dynamics 365 for finance and operations

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 … [Continue reading] about Cannot stop DynamicsAxBatch service on computer Dynamics 365 for finance and operations

How to capture Fiddler logs for Dynamics 365 for finance and operations

By

Here is another tip, how to capture for Finance and operations. You can download fiddlerCap from below link   http://www.telerik.com/fiddler/fiddlercap   https://www.youtube.com/watch?v=DvFki__HzPM   … [Continue reading] about How to capture Fiddler logs for Dynamics 365 for finance and operations

Very simple Canvas Power app for beginners – Microsoft Power Apps

By

Hi all, here is my another musing for beginners. I created a very simple power apps with excel. Two videos, In first video, I just create very simple excel file and then upload it to on drive. In second video I created power app form excel file and … [Continue reading] about Very simple Canvas Power app for beginners – Microsoft Power Apps

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 … [Continue reading] about Data source filter using extension Dynamics 365 for finance and operations

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 … [Continue reading] about Report menu item is not found when constructing the query string” Dynamics 365 for finance and operations.