Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

Customization Tips for D365 for Finance and Operations

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

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.

How to copy financial dimension form one object to other. Dynamics 365 For finance and operations

by

Hi all, In some cases we can need to copy  financial dimension from one object to  other for example Customer to Sales order or Vendor to purchase order.

In Ax 2012  it little easy. But in D365 For finance and operations, it is little bit tricky.

 

I did this with following code snippet.  With the help of out of box. LedgerDimensonDefaultFacade class i used the merge default dimension method and passed same table dimension in form and to dimension.

Result is interesting.

 

 

 salestable.DefaultDimension= LedgerDimensionDefaultFacade::serviceMergeDefaultDimensions(CustTable.DefaultDimension,CustTable.DefaultDimension);

Calling menu name in Extensions Dynamics 365 for finance and operations

by

In Ax 2012 we get menu name with element.Args().CallMenu name, using  taking decision on menu name.

 

But same logic we need to apply in Extension. But in D365 For finance and operations we did not overlay. Following code snippet helps me to implement similar logic in Extension.

 

 

[ExtensionOf(formStr(CustTable))]

final class IaLogisticsContactInfoGrid_Extension

{

 

 

/// <summary>

///

/// </summary>

/// <param name=”sender”></param>

/// <param name=”e”></param>

[FormEventHandler(formStr(LogisticsContactInfoGrid), FormEventType::Initialized)]

public static void LogisticsContactInfoGrid_OnInitialized(xFormRun sender, FormEventArgs e)

{

 

FormRun formRun = sender;

 

;

 

info(formRun.args().menuItemName());

}

 

}

Journal name . does not support journal type Daily X++ Dynamics 2012 r3

by

Hi did one customization, where I create Ledger Journal using X++ code. It was working perfectly fine with Ledger General Ledger entries. But threw error  on creating Ledger for AR,PR Payment.

 

I created ledger with following code snippet.  But it works only for Ledger for of Type Daily

 

AxLedgerJournalTable    header  = new AxLedgerJournalTable();
AxLedgerJournalTrans    trans   = new AxLedgerJournalTrans();

container               offsetDim;
LedgerJournalNameId     ledgerJournalNameId = “payment”;

header.parmJournalName(ledgerJournalNameId);
header.parmJournalType(LedgerJournalType::CustPayment);
header.save();

I replaced the above code with following snippet it works perfectly fine, rest of the code is works fine

LedgerJournalName ledgerJournalName;
LedgerJournalTable ledgerJournalTable;
LedgerJournalTrans ledgerJournalTrans;

select firstonly ledgerJournalName
where ledgerJournalName.JournalName == parameters.LedgerJournalNameId &&
ledgerJournalName.JournalType == LedgerJournalType::CustPayment;
if(!ledgerJournalName.RecId)
throw error(“@CAM184”);
if(ledgerJournalName)
{
ledgerJournalTable.JournalName = ledgerJournalName.JournalName;
ledgerJournalTable.Name = ledgerJournalName.Name;
ledgerJournalTable.insert();
}

Data source filter using extension Dynamics 365 for finance and operations

by

Hi every one, Today I have very small tip. During customization we need to add filters at run time. Specially in the case of inquiry forms. But Now we have to work with extension. Extensions are much more powerful then over layering.

 

So first one thing to copy Datasource  OnQueryEXecuting event. And paste in Extension class.

The sample code snippet is here.

 

 

 

 [FormDataSourceEventHandler(formDataSourceStr(HcmDiscussion, HcmTopicRef), FormDataSourceEventType::QueryExecuting)]

public static void HcmTopicRef_OnQueryExecuting(FormDataSource sender, FormDataSourceEventArgs e)

{

FormRun          HcmDiscussionForm = sender.formRun();

sender.query().dataSourceName(sender.name()).addRange(fieldnum(HcmTopicRef,     HeadingRefRecId)).value(queryValue(_heading.RecId));

}

Report menu item is not found when constructing the query string” Dynamics 365 for finance and operations.

by

I found following error, while running custom report.

 

 

 

Following message shown message.

 

 

 

Report run from controller class.  I found “controller.parmArgs(_args);” was missing. That reason report threw this error.

 

Complete code will be similar.

 

 

 

 

        contract.parmRecordId(invoiceJour.RecId);

controller.parmArgs(_args);

 

controller.parmReportName(ssrsReportStr(DSSCompletionCertificate, Design));

controller.parmShowDialog(false);

controller.parmReportContract().parmRdpContract(contract);

controller.startOperation();