Alfasith AX

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

Wednesday, February 14, 2018

Disable/hide report parameter on form AX 2012

Hi,

There is an attribute makes this visibility control in Contrac class level.

This can be also achieve through visual studio parameters property of visibility.

[
DataMemberAttribute,
SysOperationControlVisibilityAttribute(false)
]
public AccountNum parmCustomerAccount(AccountNum  _accountNum = accountNum )
{
    accountNum = _accountNum;
    return accountNum;
}

Thanks,
Alfasith

Tuesday, February 13, 2018

Arabic letters in the report needs to be right alignment particulary in Cheque in SSRS

Hi,

Pass another filed in insert method along with your context as language by getting a values in LedgerJournalTrans values like 'en-us', 'en-ar'..

In the Alighment property of the textbox select the Horizontal  fx   with below commands.

iif(Fields!Languague.Value="en-ar","right","Left")


Query not value enum in AX 2012

Hi,

    qbrLogStatus    = qbdsDASProjLogLines.addRange(fieldnum(DASProjLogLines,ProjLogStatus));
    qbrLogStatus.value(SysQuery::valueNot(enum2str(DASProjLogStatus::Superseded)));

Thanks,

Saturday, January 13, 2018

Dialog date field and OK CANCEL in job AX 2012

public static void dialogDate()
{
    Dialog      dialog;
    DialogField field;
    ;
    dialog = new Dialog("Submitted Date");
    dialog.addText("Select submitted date:");
    field = dialog.addField(identifierStr(TransDate));

    dialog.run();
    if (dialog.closedOk())
    {
        info(field.value());
    }
}

Thursday, January 11, 2018

Management Reporter has not yet been configured on the server. Contact your server administrator to publish the connection from within the Management Reporter Configuration Console.

Hi,

Whenever you get the error
'Management Reporter has not yet been configured on the server. Contact your server administrator to publish the connection from within the Management Reporter Configuration Console.'
 you please republish the console or can be easily solved by.
1. make the LedgerParameters table filed MangementReporterURL file visible :Yes.
2. Just place your MR URL to make it success.
mrd://?ServerConnection=http://<ServerName>:4712/&Company=<DefaultCompanyName>
mrd://?ServerConnection=http://MicrosoftIndDEV:4712/&Company=IMSD.

Regards,

Monday, December 25, 2017

Get a table ID in SQL / table browser - D365

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