Ali Raza Zaidi

Musing's of ERP Consultant

You are here: Home / 2019 / Archives for May 2019

Archives for May 2019

Allow duplicate check Global Address Book Dynamics 365 for finance and operations.

By

Dynamics 365 for finance and operations provide functionality of check Party Name already exists in Global Address book, So End user can select instead create a new one if required.

Here is video I shared this functionality in small less then 5 minutes series.

 

 

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.