Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Saturday, October 11, 2014

Convert UTCDateTime to date & date to UTCDateTime in AX

Hi,

    print DateTimeUtil::newDateTime(today(), 0, DateTimeUtil::getCompanyTimeZone());
    // Here today() is the date format not utcdatetime format...


    print DateTimeUtil::date(UTCFieldValue);
    // Here UTCFieldValue is theUTC date time field...


    //Get date diff from 1 UTC date time and another date type in AX
    return DateTimeutil::getDifference(
                        DateTimeUtil::newDateTime(resRentAgreement.StartDate, 0,       DateTimeUtil::getCompanyTimeZone()),
                        resGracePeriodHistory.createdDateTime))
// here resRentAgreement is the date field and resGracePeriodHistory is UTCDateTime field.

Regards,

Saturday, October 4, 2014

Microsoft ebooks free download

Hi,

Microsoft free e-books are available at.

http://blogs.msdn.com/b/microsoft_press/archive/2011/03/03/ebooks-list-of-our-free-books.aspx

Regards,

Free dot net (*.net) frame work download

Dear,

.net frame works *.exe files from MS office official page download center.

.NET Framework 4.5 Setup
.NET Framework 4.0 Setup
.NET Framework 3.5 Setup
.NET Framework 3.5 Setup Service Pack 1
.NET Framework 3.0 Setup
.NET Framework 2.0 Setup
.NET Framework Client Profile Offline Installer

Regards,


Code to check document is attached in AX

Hi,

static void AlfasithCheckAttacheddocu(Args _args)
{
    PurchTable             PurchTable; //Table your concern
    DocuRef                 DocuRef;
    ;
    select purchTable where purchTable.PurchId == "112255"; // Table your concern
    select DocuRef where DocuRef.RefTableId == PurchTable.TableId
                    &&  DocuRef.RefRecId == PurchTable.RecId;
   
    info(DocuRef.Name);
    pause;
}

Regards,

Difference between Microsoft dynamic AX 2012 with Dynamic AX 2009. Microsoft white paper

Hi,

Difference between Microsoft dynamic AX 2012 with Dynamic AX 2009.

http://www.microsoft.com/en-us/download/details.aspx?id=7225

This document provides a summary of new and changed features that have been implemented in Microsoft Dynamics AX 2012, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012 R2, and Microsoft Dynamics AX 2012 R3. It also describes companion apps and tools and services that support AX 2012. It also includes deprecated feature notices that describe features that have been removed in an

Regards,

Get a table ID in SQL / table browser - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' <URL>/?cmp=<CompanyID>&mi=sysTableBrowser...