Alfasith AX

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

Tuesday, April 28, 2015

Management Reporter versions and hotfix values with link to download

Hi,

Management Reporter 2.0

SP 1FP 1SP 2SP 2 Update
2.0.1663.32.0.1664.192.0.1700.312.0.1700.66

Management Reporter 2012

RTM
RU1
RU2
RU3
RU4
RU5*
2.1.1026.37
2.1.1028.0

CU7CU8CU9CU10CU11                       CU12
2.1.7044.432.1.8001.02.1.9001.112.1.10001.112 2.1.11001.1        2.1.12000.26
 
* This build number for RU 5 includes a hot fix. From what I have found, the original RU 5 was build number was 2.1.1037.12
Downloads for Management Reporter 2012 can be found here on CustomerSource (for partner).

Ref : http://victoriayudin.com/2011/07/04/management-reporter-versions/

Regards,

Thursday, April 9, 2015

User 'Domain\UserId' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Hi

Error:

User 'Domain\UserId' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

or

unable to validate / create folder for report server.

or

rsAccessedDenied - Reporting Services Error

Solution

1. Internet Explorer using "Run as Administrator"
2. Enter URL http://localhost/reports
3. Go to properties tab
4. Security->New Role Assignment
5. Enter Domain\UserId

Regards,

Wednesday, February 25, 2015

System date is different current zone date in AX

Hi,

static void AlfasithDateCompOfTodayWithServerTime(Args _args)
{
    utcDateTime startdate = DateTimeUtil::getSystemDateTime();
    print startdate;
    print DateTimeUtil::applyTimeZoneOffset(StartDate, DateTimeUtil::getUserPreferredTimeZone());
    pause;
}


Note: Same print statement whereas different value has been printed.

Regards,


QueryDataSourceLink in AX

Hi,

static void AlfasithQueryDataLink(Args _args)
{
    Query                   query;
    QueryBuildDatasource    datasource;
    ;

    query = new Query();

    datasource = query.addDataSource(tableNum(CustInvoiceJour));// Add Parent table

    datasource = datasource.addDataSource(tableNum(CustInvoiceSalesLink)); // Add child table

    datasource.joinMode(JoinMode::InnerJoin);       // Mode of join

    datasource.relations(false);        // Indicate you don't want to use relations DynamicLink

 
    datasource.addLink(fieldNum(CustInvoiceJour, SalesId),
        fieldNum(CustInvoiceSalesLink, SalesId));     // Add link between parent field and child field

    info(query.xml());
}

Regards,

Monday, February 23, 2015

Code to print only particular language label for any language environment in AX

Hi,

Code to print only particular language label for any language environment

info(SysLabel::labelId2String2(literalstr("@SYS87980"),"ar"));

Regards,

Thursday, February 19, 2015

Get a table ID in SQL / table browser - D365

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