Two departments that are most important in a business is finance and operations. Unless they are efficient and perform well, you as a company are going to struggle a lot. Hence, you need to plan on using Dynamics 365 for Finance and Operations to streamline your business. It is yet another product from Microsoft that will allow your business to tackle difficult issues with ease.  If your staff spends a few hours learning how to use the product they will become quite efficient. They will become super efficient in tackling any hurdles that might come on the way. For example, deleting model/package might not be an easy task. Here are details of how you can do it with ease Many of the time when You don’t want Existing Data Types(Base Enums, EDTs) or Data Models(Table, Views etc)  and many more elements which can ultimately cause naming conflict while development. So Option is either you want to delete those data type or Model consisting those Data Model/Data Types. Following methods are needed to be performed while Deleting model: 1.First Open Services and Select  Microsoft Dynamics 365 Unified Operations: Batch Management Service and Stop that services 2.Navigate To following path K:\AosService\PackagesLocalDirectory And Select Your Respective package/Model and delete that Note:- Here I’m using One box machine so my “AosService” is located at K drive. For other machine users “AosService” can be located at other location so you will look for it and Follow steps same as above. 3. Don’t forget To start Microsoft Dynamics 365 Unified Operations: Batch Management Service again. 4. Now refresh models from Visual Studio as follows You have successfully Deleted the Respective model/Package. Hope this helps!

Dynamics 365 for finance and operations is one of the best ERP solutions in the world. Clients can do a lot of complex jobs with ease when they choose to go for ERP solutions. It not only helps in improving the efficiency of the staff but will also help in improving the productivity of the company and will also help in managing the relationship with the clients. An enterprise is going to have total control of their business when they pick an ERP solution such as Microsoft Dynamics.  The best part is that Microsoft Dynamics has some of the most unique features that you will not find in any other ERP solution or software that you find in the world. Many of the time while development we have problems due to IIS services which are necessary while debugging in D365 Finance and Operations, many of the time problems can be just resolved by restarting IIS services on one box machine. IIS services can be restarted using two methods one is from Visual studio itself and the other is from Command prompt. Let’s see both the methods one by one: 1.Restart IIS services by Visual Studio:- this is a quite easy method only needs that your visual studio should be opened with administrator permissions. Now in Visual Studio Navigate to Dynamics 365 option and click on it Now select Option Restart IIS Express thats it Now your IIS Express service will restart 2.Restart IIS services by Command Prompt:- Other than Visual Studio IIS Express can be restarted using Command Prompt as follows Open Command Prompt as an Administrator Now enter the command as “iisreset” and Hit enter After completion, you will see the following screen That’s it, your IIS Service will get restarted using Visual Studio and Command Prompt.

“Run Jobs” – as the name suggests is a process between Retail Channels and Retail essentials through which we transfer data between channels and database. Please Note: Jobs Run at a specified time which may be different for every Retail Scheduler. Be aware of what the time is set for jobs to run automatically.  Running jobs at a specific time requires setting to be done so that we can schedule a specific job to run at specific time. It can be easily done manually. You’ll have to follow the below steps: Step 1: Go to distribution schedule or Channel database in Retail Dynamics 365. If the job doesn’t run from distribution schedule run it through channel database. Step 2: Go to download sessions and make sure your Job is available or in applied state. If it is in available state, go to “Batch Jobs“. Step 3: Now you will have to find the same batch job that you were searching and need to run it at a specified time. Step 4: Here, since the Job is in waiting state, you need to change it’s scheduled date and time to current time. This change must be according to the time at which you want your job needs to be run. The specified time will make your job run immediately.   Step 5: You can check if Job is being applied in “Download sessions” whenever required. Step 6: You can also change how often the job should run from going to Recurrence. Step 7: Only things highlighted in Red boxes should be checked. Hope this helps!!! Thank you! Please feel free to post any doubts you have.

Error handling is very important part of any integration project, it is also very important to fix the issue when it is recognized, so it is very important to take action to resolve it earliest. In the Integration project of CDS we can setup email alert option in following way. First go to Admin Center Go to Data Integration -> Select the project -> Go to Scheduling Following window will appear Tick the checkbox and specify the email address on which we wanted to receive the alerts and click on save. In this way we can set up the email alert notification for Integration progress in CDS.

Introduction This blog explains how to use “startswith” filter query in MS Flow. Use Case Using MS Flows to retrieve the bunch of students who’s mobile numbers begin with +91 and send them a text (using Twilio connector) regarding the Top Indian Universities. The “starts with” filter query in MS Flows allows to easily achieve this functionality. Steps to be Followed: We will use “Dynamics 365 – List records” Actions. Enter the Organization Name and select the entity. Filter Query: startswith(new_phonenumber,’+91′) “new_phonenumber” is the logical name of the field which stores the phone number of students. ‘+91’ is the value of phone number by which we want to filter the retrieved student list. Enter the above query in Filter Query: Run the flow to test.It will return all the students whose phone number starts with “+91”

Today, I will show you the Environment Setup for PSA to F&O integration with CDS. Step 1: Create the environment Open the link https://admin.powerapps.com and click to create new environment Following pop-up window will appear and enter the details and click on Create Environment, so new environment will gets created   The environment will get created   Step 2: Create the connections To create the connection, open the link https://web.powerapps.com and go to the connection in newly created environment (In this case: DemoEnvironment) In the data section click on connections section and click on the “Create a connection” to create new connection Following screen will be visible, select the “Dynamics 365” connection. When clicked on the Dynamics 365 popup window will appear asking whether to create connection or not. Click on create and enter the credentials     And finally source connection gets created Now create the Destination connection In the connections search for “Dynamics 365 for Fin & Ops”, when clicked it will ask whether to create connection or not click on create and then enter the credentials and finally connection will be created     Once we created the Environment and connections now create Connection sets and create project   Go to https://admin.powerapps.com and open the Data Integration tab.   2. Click on the connection set section and click on the “New Connection Set” following popup window will appear and click on Create   Step3: Once Connection set gets created now let’s create the Project   Go to project section and click new project and following form will be visible and enter the Integration project name and select the ready made template available or create custom integration project. In this case we are selecting ready made template for account and click on next.   Select the connection set from the drop down select the connection set which we have created earlier: DemoConnectionSet and click on next Select organization and click next and finally click on create   So now we have created accounts integration project Hope the above helps!

Inventory dimension are used to determine physical characteristics of product, storage of products well as track inventory transactions for product. There are three type of inventory dimension group 1. Product Dimensions: Product dimensions are characteristics that serve to identify a product variant. The following table shows the storage dimensions that are available. > Size > Color > Configuration > Style For open Product dimension group form navigate to Product information management > Setup > Dimension groups > Product Dimension Group 2. Storage Dimensions: A Storage Dimensions determine where and how a product is stored. > Site > Warehouse > Location > Pallet ID > Inventory status ( New dimension in AX 2012 R3) > License Plate ( New dimension in AX 2012 R3) To open Storage Dimension Group form navigate to Product information management > Setup >Dimension groups > Product Dimension Group 3. Tracking Dimensions: Tracking Dimensions provide companies with the ability to trace their products. > Batch > Serial Number To open Tracking Dimension Group navigate to Product information management > Setup > Dimension groups > Tracking Dimension Group The following information provides descriptions for the controls Storage Dimension Group and for Tracking Dimension Group.  Mandatory: If the Mandatory check box is selected, you want to have dimension as a mandatory dimension for products that are associated with the dimension group. The Site dimension is always mandatory. However, the Location and the Pallet ID dimensions cannot be set to mandatory. (Note: This option is only available for Storage Dimension Group) Primary Stocking: If the Primary stocking check box is selected, it is mandatory that the dimension be entered before any physical updates. (Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group) Active: If the Active checkbox is selected, the dimension is enabled for any products that are associated with the dimension group. Blank Receipt Allowed: If the Blank receipt allowed check box is selected, Microsoft Dynamics AX 2012 accepts a blank value for the dimension at the physical update of a receipt. This option only applies if the Primary stocking check box is cleared. (Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group) Blank Issue Allowed: If the Blank issue allowed check box is selected, Microsoft Dynamics AX 2012 accepts a blank value for the dimension at the physical update of an issue. This option only applies if the Primary stocking check box is cleared. (Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group) Physical Inventory: If the Physical inventory checkbox is selected the dimension must be included in physical inventory. (Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group) Financial Inventory: Select the Financial inventory check box if the dimension is to be included in calculating the financial cost of a product sold. (Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group) (Example of Physical and Financial Inventory: If you booked an item into Warehouse 1 and Site 1 at $600 and the same item into Warehouse 2 site 1 at $400. (Cost FIFO) If you unticked physical inventory from warehouse you could pick 2 from warehouse 1 because the check is at site where you have 2. At the same time if you looked at the cost and unticked financial inventory from warehouse the cost of each would be $500.) Coverage plan by dimension: Select the Coverage plan by dimension check box if this dimension is to be included in coverage plans that are created through master planning. (Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group) For Purchase Price: Select the for purchase price check box if you want to include the dimension as a criterion to determine a product’s purchase price. In the Journal lines, price/discount agreement form, you can create a trade agreement where you associate a purchase price with a specific dimension that is set up for a product. For Sales Price: Select the for sales price check box if you want to include the dimension as a criterion to determine a product’s sales price. In the Journal lines, price/discount agreement form, you can create a trade agreement where you can associate a sales price with a dimension that is set up for a product. Now you can use Inventory Dimension for Purchase Order for Sales order and also for Inventory Journals like Movement, Adjustment, Transfer, Counting, Item arrival, Counting etc. After Inventory transaction you can track the inventory by Inventory dimensions in On hand inventory form.

1. To create an AIF service using Wizard, we are supposed to prepare an AOT query containing the tables with proper relations. 2. Once we generate the AIF Service using Wizard, the AxBC classes gets generated for each table present in the AOT Query. 3. AxBC classes contains the parm methods for each field as per table. 4. Now if we want to have a filed in the XSD/XML from a table that is not the part of the Query, we will need to do the below changes: a: In the AxBC class i.e. Ax[TableName] class, create a parm method for the field you want to include in the XSD/XML for the corresponding AIF Service. b: Perform Incremental CIL c: Refresh AIF Services d: Re-Activate the Inbound port. 5. By doing the above steps, the required field will be the part of the XSD/XML for the corresponding AIF Service.

1. Go to AOT. 2. There is a Form called “AifGlobalSettings”. 3. Right Click & Open the form [Refer to the below snapshot of the form] 4. There is a check box called “Enable Runtime Caching”. 5. Make sure the check box is checked else the AIF services will NOT be accessible from outside.

1. The maximum size of the XML message that AX can receive is 64kb. In order to accept the XML of bigger size, we have to configure the Inbound port.   2. The web.config is created from the configuration of the inbound port. So, in order to preserve the changes even if the Inbound port gets reactivated, please make the changes as detailed below [Please refer to the below snapshots for your information] a. Go to the Inbound port. b. De-Activate the inbound port. c. Click on “Configure” button as shown below [A pop up window will come] d. Click “Yes” on the window popped up[Find below the snapshot of the popped up window] e. Now go to Bindings basicHttpBindingWithWindowsAuth as highlighted in the below snapshot. f. Now set the size of the property “MaxReceivedMessageSize” to a bigger value(like: 10485760). g. Save the changes and close the form. h. Click on Activate button to activate the Inbound port. i. Check the Web Config file from the above file location and verify the value that was set in the previous “step-f”. X++ code to fetch the data from Excel in AX 2012R2 I have come across the requirement to fetch the data from Excel in AX. Below is the X++ code to do the same: static void ImportDataFromExcel(Args _args) {     SysExcelApplication application;     SysExcelWorkbooks workbooks;     SysExcelWorkbook workbook;     SysExcelWorksheets worksheets;     SysExcelWorksheet worksheet;     SysExcelCells cells;     COMVariantType type;     int row;     ItemId itemid;     Name name;     FilenameOpen                    filename;     dialogField                     dialogFilename;     Dialog                          dialog;     ;     #AviFiles     #Excel     application = SysExcelApplication::construct();     workbooks = application.workbooks();       dialog = new Dialog(“ExcelUpload”);     dialogFilename      =   dialog.addField(extendedTypeStr(FilenameOpen));     dialog.filenameLookupFilter([“@SYS28576”,#XLS, “@SYS28576”,#XLSX]);     dialog.filenameLookupTitle(“Upload from Excel”);     dialog.caption(“Excel Upload”);     dialogFilename.value(filename);     if(!dialog.run())         return;     filename            =   dialogFilename.value();     application         =   SysExcelApplication::construct();     workbooks           =   application.workbooks();     try     {     workbooks.open(filename);     }     catch (Exception::Error)     {     throw error(“File cannot be opened.”);     }     workbook = workbooks.item(1);     worksheets = workbook.worksheets();     worksheet = worksheets.itemFromNum(1);     cells = worksheet.cells();    do { row++; itemId = cells.item(row, 1).value().bStr(); type = cells.item(row, 1).value().variantType(); info(strfmt(‘%1’, itemId)); } while (type != COMVariantType::VT_EMPTY); }