Run Ax as another user

Create a shortcut to RunAs.exe and then enter the following in Target:

C:\Windows\System32\runas.exe /user:DOMAIN\USER “C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin\ax32.exe \\NETWORK FOLDER TO CLIENT CONFIGURATION\CONFIG.axc”

When executing you will need to type in the users password.

Incorrect filter for enum fields

If you have a listpage, at least in AX2012 RTM, where a field is an enum you can try out this odd behaviour.

Say that you have the enum MonthOfYearId as a field in the listpage. Now if you press ctrl+g to get the filter row and type in Dec* to get all lines with December you will get all lines. The filter for the field will do nothing. But if you type Dec  you will get all lines with December.

So when filtering you must know if the field uses an enum or is just a string to be able to use the filter. This is really bad.

Make EDT create relation when used in table

You might have noticed when you drag for example the EDT CustAccount to a table it asks you if you wish to create a relation. If you answer yes a relation to CustTable and an index for the CustAccount field is created. What is required for an EDT to make that happen?

1. You need to have a base table in which all valid values are stored.
2. On that table you must have an index with the properties
   • Allow duplicates: No
   • AlternateKey: Yes
3. The index must be set as Primary Index for the table.
4. The EDT must have the table as Reference Table and have the field set up under Table References.

If all those requirements are met then when dragging that EDT to a table AX can create a relation and index for you.

Using OCR as PaymId

Original post http://www.agermark.com/2013_02_01_archive.html

PaymentId is set from code in:
\Classes\CustPostInvoice\run (\Classes\CustPostInvoice\runInternal in R3)
\Classes\SalesInvoiceJournalCreateBase\createJournalHeader

You need to choose the the correct payment type for the invoice when doing the invoice update, to get the right payment id calculation.

With the correct payment type you only need to add #isoCountryCode to the container here:

if (SysCountryRegionCode::isLegalEntityInCountryRegion([#isoNO]), numberSeq)
{
    moneyTransferSlip = PaymMoneyTransferSlip::construct(custInvoiceJour.GiroType)
    moneyTransferSlip.init(custInvoiceJour.GiroType);
    moneyTransferSlip.parmNumSeqCode(numberSeq.parmNumberSequenceCode());

    paymId = moneyTransferSlip.ocrField(custInvoiceJour.InvoiceAccount,
                                         custInvoiceJour.InvoiceId,
                                         strLen(int2str(NumberSeq::highest(numberSeq.parmNumberSequenceId()))));

    custInvoiceJour.PaymId = strLRTrim(paymId);
}