How to get D365 environment URL from LCS

This post shows how to get D365 for Finance and Operations environment URL from LCS.

As shown in the picture below, logon to environment, click Login and select Log on to environment.

How to connect UAT database using SQL Server Management Studio

In this post I am will demonstrate how to connect to UAT database (Azure) in SQL server management studio unlike DEV environment where database sits on same box.

Following are the steps involved in connecting SQL server management studio to UAT database:

Step 1:

Go to your environment page in LCS and scroll down to database accounts sections under Manage Environment tab.

Step 2:

Open SQL Server Management Studio in UAT environment and put the highlighted SQLServer\Databasename in Server name box with addition to ".database.windows.net" as shown below

Step 3:

Set the Authentication mode to SQL Server Authentication, get the password from environment page under database accounts section and hit Connect.

You are now connected to UAT database.

Inventory transaction statuses

The statuses of inventory transactions represent different process steps in a normal demand and supply flow. The status impacts the different on-hand balances that are kept in the inventSum table.

• StatusIssue statuses represent demand and can be thought of as subtractions from the inventory.
• StatusReceipt statuses represent supply and can be thought of as additions to the inventory.

List below describes the StatusIssue and StatusReceipt statuses are used in Microsoft Dynamics 365 for Finance and Operations and AX 2012. 

Status Issue

• None
• Sold
• Deducted
• Picked
• ReservPhysical
• ReservOrdered
• OnOrder
• QuotationIssue

Status Receipt

• None
• Purchased
• Received
• Regestired
• Arrived
• Ordered
• QuotationReceipt

Let's review all of them in details.

Changing Splash Screen in D365 Finance and Operations

In this post I am going to show changing splash screen in Dynamics 365 Finance and Operations. In order to change that you need to go under webroot folder found in AOSService folder, in this folder you will find html file with name "App".

In App.html file you will find the following code:

Stylesheet of Splash Screen

Html code of Splash Screen

D365 Finance and Operation URL parameters

In this post I will discuss different query strings parameters which can be passed in D365 Finance and Operations.

Following are the list of Query strings parameters which works with D365 Finance and Operations:

• f
• mi
• cmp
• prt
• debug
• cls
• activityId
• limitednav
• TableName
• q
• Mode
• hidesplash
• lng
• theme

Unable to connect to Azure storage D365 VM

While working with file downloads on D365 VM I encountered following error and was not able to download file.

Unable to connect to the remote server at Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync[T](RESTCommand`1 cmd, IRetryPolicy policy, OperationContext operationContext) at Microsoft.WindowsAzure.Storage.Table.CloudTable.Exists(Boolean primaryOnly, TableRequestOptions requestOptions, OperationContext operationContext) at Microsoft.WindowsAzure.Storage.Table.CloudTable.CreateIfNotExists(TableRequestOptions requestOptions, OperationContext operationContext) at Microsoft.DynamicsOnline.Infrastructure.Components.TableAccessor.TableStorageAccessor.PerformOperation(CloudStorageAccount storageAccount, String tableName, Func`1 operation) at Microsoft.DynamicsOnline.Infrastructure.Components.TableAccessor.TableStorageAccessor.AddRecord[T](CloudStorageAccount storageAccount, String tableName, T record) at Microsoft.DynamicsOnline.Infrastructure.Components.SharedServiceUnitStorage.SharedServiceUnitStorage.UploadData(SharedServiceUnitStorageData data, Stream stream) at Dynamics.AX.Application.FileUploadTemporaryStorageStrategy.completeUpload(Boolean _blobAlreadyExists, String _uniqueFileName, String _originalFilename, String _fileId, Stream _stream, String _contentType, Boolean @_contentType_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_FileUploadTemporaryStorageStrategy.xpp:line 140

This issue arises because of AzureStorageEmulator was not running, which can be identified using following CMD.

Solution

Issue was resolved after starting AzureStorageEmulator using command as shown below

Synchronization error on LedgerPeriodModuleAccessControl after upgrading to CU12

I just upgraded our AX 2012 R3 development environment with cumulative update 12 (CU12)  and after compiling, synchronization fails on one table with this error :

Description de l'erreur SQL: [Microsoft][SQL Server Native Client 11.0][SQL Server]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.LEDGERPERIODMODULEACCESSCONTROL' and the index name 'I_7375LEDGERFISCALCALENDARPERIODIDX'. The duplicate key value is (5637144576, 5637144576).

Instruction SQL: CREATE UNIQUE  INDEX I_7375LEDGERFISCALCALENDARPERIODIDX ON "DBO".LEDGERPERIODMODULEACCESSCONTROL (PARTITION,LEDGERFISCALCALENDARPERIOD)