Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

Dynamics Ax 2012 Technical Side

How to convert utcdate time to ISO 8601 Formats D365 Finance and Operations

by

Hi friends, recently I got chance to write a code to convert Utc date time to iso 8601. I wrote following code snippet you can modify as per your need

public static str GetEPochTime(utcdatetime _DateTimeValue)
{
    utcDateTime utcDateTimeValue;
    str formattedDateTime;
  
    date datepart;
    int milliseconds;
    TimeOfDay _time;
    // _DateTimeValue = DateTimeUtil::applyTimeZoneOffset(_DateTimeValue, Timezone::GMTPLUS0300KUWAIT_RIYADH); // Adjust for specific timezone if needed
    int _year= DateTimeUtil::year(_DateTimeValue);
    int _day = DateTimeUtil::day(_DateTimeValue);
    int _Month = DateTimeUtil::month(_DateTimeValue);
    int _Hour = DateTimeUtil::hour(_DateTimeValue);
    int _second = DateTimeUtil::second(_DateTimeValue);
    int _minute = DateTimeUtil::minute(_DateTimeValue);
    int _timetomilliSecond = 0;
    var localTime =  new System.DateTime(_year, _Month, _day, _Hour, _minute, _second,_timetomilliSecond, System.DateTimeKind::Utc);
    localTime =System.TimeZoneInfo::ConvertTime(localTime,System.TimeZoneInfo::FindSystemTimeZoneById("Arabic Standard Time"));
    // Example UTC DateTime
    // utcDateTimeValue = _DateTimeValue;
    formattedDateTime = localTime.ToString("o");
    // formattedDateTime =DateTimeUtil::toStr(_DateTimeValue);
    formattedDateTime =strReplace(formattedDateTime,".0000000",".00+03:00");
    return formattedDateTime;

TempDB, SrsReportDataProviderPreProcessTempDB And long Running Report Dynamics 365 Finance and operations

by

Recently I got interesting issue. I developed the report based on RDP Class. I have to populate temp table. And based on this temp table I have to aggregate some calculation like sum, Average on Group by.

But when I populate another table based on this aggregation. Report starts to go long awaiting state. I dont know the reason. Later I found that I did not give active connection to temp table variables.

I added following line of code in reports and report processing reduce to less then 2 minutes

this.takeOwnershipOfTempTable(_BEGroupWiseSalarySheetTmp);
this.takeOwnershipOfTempTable(_BEBranchWiseSalarySheetTmp);

List of technical learning Paths on Microsoft Learn – Dynamics 365 for Finance and Operations

by

Hi all, I just created a list of technical learning paths on Microsoft learn.
Amazingly simple, good and easy to learn.
Hope you all enjoy, learn and take benefit from these links

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.

How to get table id in Dynamics 365 for finance and operations.

by

Table Id can be found SysTableIdView.  in Dev environments, you can do direct query on sql server.

select * from SysTableIdView

 

If you did not access sql server then you can open it on table browser.

 

http://usnconeboxax1aos.cloud.onebox.dynamics.com/?cmp=usmf&mi=SysTableBrowser&TableName=SysTableIdView