Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

alirazazaidi

The internal time zone version number stored in the database Dynamics 365 for finance and operations

by

I  faced database Synch Error after deploying latest code to my Onebox VM.

 

The internal time zone version number stored in the database is higher than the version supported by the kernel (15/13). Use a newer Microsoft Dynamics 365 for Finance and Operations kernel

 

 

Solution is

Open local Database in SQL server management Studio

And run following Query on AXDB.

 

update SQLSystemVariables set VALUE = 7 where parm =’SYSTIMEZONESVERSION’

 

 

Reference:  http://dilliraj.blogspot.com/2016/07/the-internal-time-zone-version-number.html

 

Unable to download report as PDF Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync Dynamics 365 for finance and operations

by

During Save as pdf custom report throw following error.

 
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
 
It was problem that Azure Storage emulator was not running on my machine. 
For this I have to open window start and write there Azure Storage emulator.
After it searched, click and run the Azure storage Emulator.

 In my Case  emulator Version was out date. I have to download it from Microsoft Cloud. After running that service. Issue was resolved. Report successfully download as pdf.
Reference : https://docs.microsoft.com/en-us/azure/storage/common/storage-use-emulator

List of Vendor Invoices against Payment General Entry

by

Between posted Vendor Payment Journal and Settled Invoice only relation is Voucher number in ledger Journal Trans and VendSettlement Table.

So My friends my code snippet is here,

        VendTrans               vendTrans;

        VendSettlement          VendSettlement;

  while select * from VendSettlement

                join  * from vendTrans

                where VendTrans.DataAreaId == VendSettlement.TransCompany

                && VendTrans.RecId  == VendSettlement.TransRecId

                && VendTrans.AccountNum == VendSettlement.AccountNum

                && VendSettlement.OFFSETTRANSVOUCHER == _ledgerJournalTrans.Voucher

Haaapy Daxinggg

Serialization version mismatch detect, make sure the runtime dlls are in sync with the deployed metadata D365 For finance and operations

by

Don’t what reason, possible I manually copied the model files to my dev one box. After compiling my model and run the customization, on one control document. I faced this issue.
Serialization version mismatch detect, make sure the runtime dlls are in sync with the deployed metadata. Version of file ‘12104’. Version of dll ‘172’.
Solution for that. I build all models by checking all models.

Add Financial dimension to Customer/Vender with X++ Dynamics 365 for finance and operations

by

Small tip, I used following code snippet to add financial dimension in Customer / Vendor, You can extend this code by adding more dimension and values on Containers in following code snippet.
public class  iaxFinancialDimensionHelper
{
    Public static DimensionDefault ProjectDimension(ProjId _ProjId)
    {
        DimensionAttributeValueSetStorage valueSetStorage = new DimensionAttributeValueSetStorage();
        DimensionDefault result;
        int i;
        DimensionAttribute dimensionAttribute;
        DimensionAttributeValue dimensionAttributeValue;
        container conAttr = [“Projects”];
        container conValue = [_ProjId];
        str dimValue;
        for (i = 1; i <= conLen(conAttr); i++)
        {
            dimensionAttribute = dimensionAttribute::findByName(conPeek(conAttr,i));
            if (dimensionAttribute.RecId == 0)
            {
                continue;
            }
            dimValue = conPeek(conValue,i);
            if (dimValue != “”)
            {
                // The last parameter is “true”. A dimensionAttributeValue record will be created if not //found.
                dimensionAttributeValue =
dimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute,dimValue,false,true);
                // Add the dimensionAttibuteValue to the default dimension
                valueSetStorage.addItem(dimensionAttributeValue);
            }
        }
        result = valueSetStorage.save();
        return result;
    }
}
Reference : Internet. possible Dynamics forum. it works for me.