Dynamics 365 FinOps Data Integration using Microsoft Forms (Part 1)

With any D365FO users, Data Management workspace and Data Entities should have become one of the most used and well-known tools in the system. We all agree how powerful such integration framework is, especially when it comes to a large number of records that we would need to import into different tables. The classic method that we have been utilizing is to include all source data in a single (or multiple, much depending on the purpose and order of data integration) Excel sheet, trigger an import execution, pass any validation layers that present and ultimately have the data available on D365FO.

Database Sync after data type on field has been changed

You will got an error like this when doing Database Synchronization after changing the data type of the field on the table: Failure InvalidOperationException: Table … : Converting Field ‘..’ of Type ‘..’ to ‘..’ is not support. Please drop the original field, sync the table and add new field with same name if needed. Solution: Drop the table and delete references from SQLDictionary 1 2 3 4 5 6 7 8 9 10 DROP TABLE AXDB.

Getting onebox VHD Dynamics 365 finance and operations virtual machine

1. Download Dynamics 365 finance and operations VHD files 2. Extend the Evaluattion license 3. Rename VM Update financial reporting Update the Azure Storage Emulator 4. Location of packages, source code, and other AOS configurations 5. Redeploying or restarting the runtime on the VM 6. Update to the latest version 7. For (VHD) that was released for versions 10.0.24 and later 7.1 Register a new application in Azure Active Directory 7.

Azure Storage Emulator 'Port conflict with existing application', Dynamics 365 finance and operations

1. Reason 2. Resolution 2.1. To determine the conflict program we can use this command in CMD 2.2. To change the default port for Azure storage Emulator The Microsoft Azure storage emulator is a tool that emulates the Azure Blob, Queue, and Table services for local development purposes. You can test your application against the storage services locally without creating an Azure subscription or incurring any costs. When you’re satisfied with how your application is working in the emulator, switch to using an Azure storage account in the cloud.

Create Purchase Orders - Confirm - Product receipt - Post using X++ in Dynamics 365 Finance & Operations

The script will work for Dynamics 365 Finance & Operations version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 class MaxGeneratePO { public static void main(Args _args) { int i = 0; // number of purchase orders NumberSeq numberSeq; PurchTable purchTable; PurchLine purchLine; InventDim inventDim; while (i <= 3) { ttsBegin; MaxGeneratePO createPO = new MaxGeneratePO(); numberSeq = NumberSeq::newGetNum(PurchParameters::numRefPurchId()); numberSeq.

Microsoft Dynamics AX 2012 Update Process

What is an Update? Updates include hotfixes, cumulative updates, and feature packs. Hotfix: A fix or set of fixes that address a specific issue, problem, or customer scenario. Cumulative update: An update that contains all previous hotfixes to date. Feature pack: A group of updates that relate to a feature area or group of functionality. Contains design changes. 1. Types of Hotfixes To determine which type of update is in a package, download the package, and then extract contents and review them to determine which type of update it is.

Dynamics 365 finance and operations ODATA consuming - Length cannot be less than zero

When you consume a custom data entity, you get an error Failure errorSystem.ArgumentOutOfRangeException : Length cannot be less than zero” and it works fine for standard data entities. The reason is the temporary XML file where the metadata stored which mismatches with the metadata from https://<yourenvironment>.cloudax.dynamics.com/data/$metadata You can follow this post to understand how to create the XML file. If you try to regenerate the metadata by saving the ODataClient.tt file, the XML will be accumulated, and the error keeps happening.

Enable Power BI Embedded in cloud hosted Dynamics 365 finance and operations 8.0 +

In this article, we will go through how to enable Power BI embedded in Dynamics 365 finance and operations version 10 in a cloud-hosted environment (customer managed). From the previous version of FinOps, Power BI embedded uses workspace collections at Azure to display the report, since the workspace collections have been deprecated, Microsoft also disables power BI embedded in cloud-hosted environments. You can only enable Power BI embedded in multiple boxes environments like UAT and production.