X++ code to find the available printers to print from AX (Print Sales picking list report at designated printer)

printJobSettings  printJobSettings;

sysPrintOptions  sysPrintOptions;

map                     printerMap;

mapIterator         mapIterator;

    ;

printJobSettings = SysPrintOptions::newPrintJobSettingsOnServer();

sysPrintOptions = new sysPrintOptions();

sysPrintOptions.setPrintJobSettings(printJobSettings);

sysPrintOptions.buildPrinterMap();

printerMap        = sysPrintOptions.getPrinterMap();

mapIterator       = new mapIterator(printerMap);

mapIterator.begin();

while (mapIterator.more())

{

      info(mapIterator.value());

      mapIterator.next();

 }

Scenario:

In order to print a sales picking list to the desired destination(printer):

1. Class responsible to print picking list is "SalesPickingListJournalPrint".

2. You need to override the printSettings and pass it to FormLetter. Write the below code before call the doPrint method (SalesPickingListJournalPrint.doPrint())

private void ChangePrintSettings(Name_printerName)

{

    SRSPrintDestinationSettings printSettings = new SRSPrintDestinationSettings();

    printSettings.printMediumType(SRSPrintMediumType::Printer);

    printSettings.printerName(_printerName);

    //this.parmUsePrintManagement(false);

    this.parmPrinterSettingsFormLetter(printSettings.pack());

}

Tip:
https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/configure-an-aos-instance-to-print

ODBC connection in AX 2012

ODBC is to access data of any database mentioned. We use X++ code to access.
1. Start -> admministrative tools ->Datasources(ODBC) -> Add ->Sql Server->Finish.

Next, Next,Finish.

2.Write following job to set ODBC connection.
static void Job19(Args _args)
{
    OdbcConnection oDBC;
    LoginProperty  login;
    Statement      stmt;
    ResultSet      rs;
    ResultSetMetaData rsmd;
    FCCAirports    fCCAirports;
    CustTable      CustTable;
   
    login = new LoginProperty();
    login.setDSN("AVinashDSN");  
    login.setDatabase("DynamicsAXDemo");
   
    oDBC = new OdbcConnection(login);
   
    try
    {
        stmt = oDBC.createStatement();
        rs   = stmt.executeQuery("select AccountNum,currency from custtable");
   
        while(rs.next())
        {
            info(rs.getString(1));
            info(rs.getString(2));
        }
    }
    catch
    {
        error('Unexpected error');
    }
}

Adding filter on form with one and multiple range values

1.Created two tables and on e form

2. Take an EDT and give relation to PCustomerTable.CustomerId and extends to outbound control on form(openmode:edit)

3.

In clicked method
PCustomerTable_ds.filter(fieldNum(PCustomerTable,CustomerId),FilterButton.valueStr());

4.

For multiple selection:

In form methods:

public void multiLookup()

{

    Query query = new Query();

    QueryBuildDataSource qbds;

    qbds = query.addDataSource(tableNum(PCustomerTable));

    msCtrlCust = SysLookupMultiSelectCtrl::constructWithQuery(element, CustomerIDFilter, query);

}

public void init()

{

    super();

    element.multiLookup();

}

public class FormRun extends ObjectRun

{

    SysLookupMultiSelectCtrl msCtrlCust;

    container                values;

}

5. In PCustomerTable -->executequery()

public void executeQuery()

{

    PCustomerTable       ptc;

    PItemTransactions    pit;

    query                query;

    QueryBuildDataSource qbds,qbds1;

    QueryBuildRange      qbr;

    QueryRun             qr;

    int                  i;

    int64                r;

    container            c;

    ;

    query = new query();

    qbds  = query.addDataSource(tableNum(PCustomerTable));

    qbds1 = qbds.addDataSource(tableNum(PItemTransactions));

    qbds1.relations(true);

    values = msCtrlCust.get();

    for (i = 1; i <= conLen(values);i++)

    {

        r = conPeek(values,i);

        Ptc = PCustomerTable::find(r);

        c = conIns(c,i,Ptc.CustomerId);

    }

    qbds.addRange(fieldNum(PCustomerTable,CustomerId)).value(con2Str(c));

    qr = new QueryRun(query);

    while (qr.next())

    {

        ptc = qr.get(tableNum(PCustomerTable));

        PCustomerTable_ds.query(qr.query());

    }

    super();

}

Restrict mutiple logins of same user in ax 2012

Note:Compied from external source

Copy Paste the Following Code in startupPost method of info class in AOT

void startupPost()
{
// To restrict user login form second login
xSession session;
SysClientSessions SysClientSessions;
UserId currentUserId;
int counter;
;
currentUserId = curUserId();
if(currentUserId!="Admin")// Allow Admin User to login multiple time
{
while select SysClientSessions
where SysClientSessions.userId == currentUserId &&
SysClientSessions.Status == 1 // 1 : Login 0 : Logout
{
session = new xSession(SysClientSessions.SessionId, true);
if (session && session.userId())
{
counter++;
}
}
if(counter>=2)
{
Box::stop("Already Logged-in : The same user id can't log in twice.");
infolog.shutDown(true);
}
}
}

Creation of simple workflow in AX 2012

Creating Workflow for courses in HumanResource Module.

• Create WFstatus enum

• Create query for that table

• Add workflowstate enum as a field in HRMCourseTable

• Override CanSubmittoworkflow() of table with following code

        public boolean canSubmitToWorkflow(str _workflowType = '')

{
  boolean ret;
     ret = super(_workflowType);
     ret = this.RecId != 0 && this.WorkflowState == WorkflowState::NotSubmitted;
     return ret;
}

• Also write Updateworkflowstate method(Not override)

public static void UpdateWorkflowState(RefRecId _recId, WorkflowState _state)

{

    HRMCourseTable hRMCourseTable = hRMCourseTable::findByRecId(_recId, true);

    ttsBegin;

    hRMCourseTable.WorkflowState = _state;

    if(hRMCourseTable.RecId)

        hRMCourseTable.update();

    ttsCommit;

}

• Create/Identify WF category(module)
• Create WF type from wizard

• Create WF approval from wizard and give appropriate label names to all created MIs

• Private projects will be created.
• In WF Type main() of submitMngr class write as below and make necesary changes 

public static void main(Args args)

{

    HRMCourseTable                          hRMCourseTable;

    FormRun                                 formRun = args.caller();

    recId                                   recId = args.record().RecId;

    WorkflowCorrelationId                   workflowCorrelationId;

    WorkflowTypeName                        workflowTypeName =workflowtypestr(CoursesWFType);

    WorkflowComment                         note ="";

    WorkflowSubmitDialog                    workflowSubmitDialog;

    workflowSubmitDialog = WorkflowSubmitDialog::construct(args.caller().getActiveWorkflowConfiguration());

    workflowSubmitDialog.run();

    if (workflowSubmitDialog.parmIsClosedOK())

    {

        recId = args.record().RecId;

        hRMCourseTable = HRMCourseTable::findByRecId(recId);

       //We can validate record before submite and will through error

        note = workflowSubmitDialog.parmWorkflowComment();

        try

        {

            ttsbegin;

            workflowCorrelationId = Workflow::activateFromWorkflowType(workflowTypeName,recId,note,NoYes::No);

            hRMCourseTable::UpdateWorkflowState(recId,WorkflowState::PendingApproval);

            info("Submitted to workflow.");

            ttscommit;

        }

        catch(exception::Error)

        {

            info("Error on workflow activation.");

        }

    }

    formRun.dataSource().research(1);

    formRun.reload();

}

• In the WFType Eventhandler write appropriate code in existed methods

public void completed(WorkflowEventArgs _workflowEventArgs)

{

    if (_workflowEventArgs.parmWorkflowContext().parmTableId() == tableNum(HRMCourseTable))

        HRMCourseTable::UpdateWorkflowState(_workflowEventArgs.parmWorkflowContext().parmRecId(),WorkflowState::Approved);

}

• In WFApproval ResubmitActionManager class, write following

public class CoursesWFApprovalResubmitActionMgr

{

    RecId           recId;

    Args            args;

}

protected boolean actionDialog(WorkflowWorkItemActionDialog _workflowWorkItemActionDialog)

{

    _workflowWorkItemActionDialog.run();

    return _workflowWorkItemActionDialog.parmIsClosedOK();

}

protected WebActionItemName getEPReSubmitAction()

{

    WebActionItemName WebActionItemName;

    return WebActionItemName;

}

public Args parmArgs(Args _args = args)

{

    args = _args;

    return args;

}

public boolean reSubmit()

{

    WorkflowWorkItemActionDialog    workflowWorkItemActionDialog;

    WorkflowWorkItemTable           workItem = args.caller().getActiveWorkflowWorkItem();

    boolean                         ret;

    boolean                         dispatchWorkItem = false;

    WorkflowComment                 comment;

    UserId                          targetUser;

    if (workItem.RecId)

    {

        workflowWorkItemActionDialog = WorkflowWorkItemActionDialog::construct( workItem,

                                                                                    WorkflowWorkItemActionType::Resubmit,

                                                                                    

new MenuFunction(args.menuItemName(), args.menuItemType()));

            if (this.actionDialog(workflowWorkItemActionDialog))

            {

                comment = workflowWorkItemActionDialog.parmWorkflowComment();

                targetUser = workflowWorkItemActionDialog.parmTargetUser();

                dispatchWorkItem = true;

            }

    }

    if (dispatchWorkItem)

    {

        WorkflowWorkItemActionManager::dispatchWorkItemAction(workItem,

                                                                comment,

                                                                targetUser,

                                                                WorkflowWorkItemActionType::Resubmit,

                                                                args.menuItemName(),

                                                                args.menuItemName() == this.getEPReSubmitAction());

        ret = true;

    }

    return ret;

}

public static void main(Args args)

{

    CoursesWFApprovalResubmitActionMgr submitManager = new CoursesWFApprovalResubmitActionMgr();

    submitManager.parmArgs(args);

    submitManager.reSubmit();

}

• Drag WFapproval into WFtype-->supported elements
• Give Form design properties(WorkflowEnabledyes,WorkflowDataSource,WorkflowType)
• Generate Incremental CIL.
• Configure WF

• Double click on approval element

Find some important links for WF approvals
Signing limits in AX 2012
Managerial hierarchy in AX 2012
Approval limits in AX 2012

Role based Security in AX

·         To setup security roles to a user need to follow following hierarchy

·         Create Security role

Go to System administration > setup > security > security roles

Give security role name by clicking new button

·         Create Duties, privileges and permission

Go to System administration > setup > security > security privileges

Click new to create a new process cycle, again click new to create duty, again click new to create new privilege

By keeping the cursor on newly created privilege, add permission and give access level

·         Assign duties to the role

Go to System administration > setup > security > security roles

Select your security role and click on Add in role content then select the duty and privilege from your process cycle

·         

      Assigning user to roles

Go to System administration > setup > security > Assign users to roles

Select your role and click on manually assign/exclude user from users assigned to role and select the users

Now Logon to Microsoft dynamics AX with the assigned user login credentials and check the permission level you applied is working or not

Note: 1. for system administrator role no privilege takes effect as he has full control

X++ Program to print 143 as 100+40+3

static void Job10(Args _args)
{
    int r,n,i,j;
    real mul=0.1,q;
    str k;
    ;
    n = 143;
    q = n;
    for(i=1;q>=1;i++)
    {
        mul = mul * 10;
        r = (q mod 10)*mul;
        q=q/10;
       if(k)
        k = int2str(r)+"+"+k;
        else
            k=int2str(r);
    }

    info(k);