Ali Raza Zaidi

Dynamics 365 development notes

You are here: Home / Archives for Dynamics 365 for finance and operations

Dynamics 365 for finance and operations

How to load number sequence class on UAT or Production server Dynamics 365 for finance and operations.

By Leave a Comment

In Dev machine, we can call runnable class to load number sequence, but UAT or production server Visual Studio is not in our access.

In UAT or production server we can run number sequence load class in browser.  with following command.

usnconeboxax1aos.cloud.onebox.dynamics.com[company]&mi=SysClassRunner&cls=[job/runnable class name]

For current example, if my class name is xyzNumberSeqLoadModule

you can add class name after basic url as

SysClassRunner&cls=xyzNumberSeqLoadModule

usnconeboxax1aos.cloud.onebox.dynamics.com&mi=SysClassRunner&cls=xyzNumberSeqLoadModule

 

 

 

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.

unable to read beyond the end of stream Dynamics 365 for finance and operations

By

After deployment of custom report on my  Dev one box. I faced this error when I run the report for testing. IIS restart, Project compilation and Service restart did not solve the problem.
“

unable to read beyond the end of stream

“
Solution was simple, Build the full model.

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.