Microsoft Dynamics AX

Over delivery of line is 100 percent, but the allowed over delivery is only 0 percent.

2015-05-26T18:42:00.000-07:00

Q: I am getting the following error in AX 2009, how can I fix it?

"Over delivery of line is 100 percent, but the allowed over delivery is only 0 percent."

A:

Use the following script

static void
fixPurchaseOrders(Args _args)

{

   PurchParmTable purchParmTable;

   PurchParmLine purchParmLine;

;

   ttsbegin;

   while select forupdate
purchParmTable

       join
forupdate purchParmLine

       where
purchParmLine.ParmId == purchParmTable.ParmId

     
 && purchParmLine.TableRefId ==
purchParmTable.TableRefId

     
 && purchParmTable.PurchId == ""

     
 && purchParmTable.ParmJobStatus == ParmJobStatus::Waiting

     
 && purchParmTable.Ordering == DocumentStatus::Invoice

   if(purchParmTable.RecId
|| purchParmLine.RecId)

{

     
 purchParmTable.delete();

     
 purchParmLine.delete();

}

   ttscommit;

}

How to build a User List Lookup / Drop Down in AX 2009

2014-11-27T16:08:00.004-08:00

User
List Lookup / Drop Down 

Step 1:Create a method in the form to get the user
list lookup

void userListLookup(FormStringControl control)

{

    Args                args;

   
MenuFunction        menuFunction;

    Object              formRun;

;

    args = new
Args();

   
menuFunction = new
MenuFunction(menuitemdisplaystr(WorkflowUserListLookup),
MenuItemType::Display);

    args = new
Args(menuFunction.object());

   
args.caller(element);

   
args.parm(control.text());

    formRun =
ClassFactory::formRunClassOnClient(args);

   
formRun.init();

   
formRun.run();

   
formRun.wait();

    if
(formRun.closedOk())

{

       
control.text(formRun.parmTo());

       
element.redraw();

}

}

Step 2: Call the method in the lookup event of the
EDT

public void lookup()

{

   
element.userListLookup(this);

}

Alternative Method: Just select
WorkflowUserListLookup as formhelp on your EDT

How to import and compile an xpo from Start Up

2014-11-18T20:04:00.002-08:00

How to import and
compile an xpo from Start Up

In
order to import an XPO from command line in AX
2009 we can use AX32.exe StartUp command; 

ax32.exe -StartupCmd=AutoRun_c:\Configuration.XML

The
configuration XML would contain path to the AOT object to compile after import
the XPO.

exitWhenDone="true" 

version="4.0" 

logFile="C:\Temp\AxaptaAutorun.log">

file="C:\Temp\CodeFile.xpo" />

References: http://msdn.microsoft.com/en-us/library/aa870082(v=ax.50).aspx

AX 2012 Development Cheat Sheet

2014-10-20T23:21:00.001-07:00

AX 2012 Development Cheat Sheet / X++ Cheat Sheet

Wednesday, 21 May 2014

3:02 PM

How to access individual field on the form using form data source?

myTable_ds.object( fieldNum( myTable, myField ) ).visible( false );

How to create an auto lookup without writing code where Field 2 lookup is based on Field 1 Value?

In order to achieve this create a relationship in the related table but make sure Field 1 is the first relation in the relationship and Field 2 is the second relation. This can be done by actually creating Field 2 relation before Field 1.

How to create a simple dialog box?

Dialog      dialog;

DialogField
field;

dialog = new
Dialog("My Dialog");

dialog.addText("Select
your favorite customer:");

field =
dialog.addField(ExtendedTypeStr(CustAccount));

dialog.run();

if
(dialog.closedOk())

{

info(field.value());

}

How to convert string to enum?

SMATransactionType  transactionType;

transactionType
= str2enum(transactionType, "Hour"); 

info(enum2str(transactionType));

Date Time Affectivity

http://dynamics-ax-chronicles.blogspot.com.au/2011/09/date-effective-tables-with.html

utcDateTime
fromDateTime, toDateTime;

fromDateTime = DateTimeUtil::newDateTime(3\3\2012, 0);

toDateTime   = DateTimeUtil::maxValue();

#Selecting a time effective record based on from date

select
validTimeState(fromDateTime) table;

#Selecting a time effective record based on from date
and to date

select
validTimeState(fromDateTime, toDateTime) table;

Import Text File

static void
RB_ReadTextFile(Args _args)

{

   
Filename                                             
filename = @'C:\Desktop\AX2012.txt';

   
System.IO.StreamReader         
reader;

   
System.String                                   line;

   
InteropPermission                      
interopPermission;

   
Str                                                        
text;

   
interopPermission = new InteropPermission(InteropKind::ClrInterop);

   
interopPermission.assert();

   
reader = new System.IO.StreamReade(filename,System.Text.Encoding::get_UTF8());

   
line = reader.ReadLine();

   
while (!System.String::IsNullOrEmpty(line))

{

       
line = reader.ReadLine();

       
text = line;

       
info(strfmt("%1", text));

}

   
reader.Close();

   
reader.Dispose();

}

Import CSV File

static void
RB_ReadCsvFile(Args _args)

{

   
#File

   
IO  iO;

   
CustAccount custAccount;

   
CustName custname;

   
FilenameOpen        filename =
"C:\\Desktop\\RB.csv";

   
Container           record;

   
boolean first = true;

;

   
iO = new CommaTextIo(filename,#IO_Read);

   
if (! iO || iO.status() != IO_Status::Ok)

{

       
throw error("@SYS19358");

}

   
while (iO.status() == IO_Status::Ok)

{

       
record = iO.read();

       
if (record)

{

           
if (first)  // to exclude the header

{

               
first = false;

}

           
else

{

               
custAccount = conpeek(record, 1);

               
custname = conpeek(record, 2);

               
info(strfmt('%1--%2',custAccount,custname));

}

}

}

}

Import Excel File

// >>>
abdul @ 4th June 2014 / This job is used to update the parking locations for
all shifts

//>>>
Excel Format / Shift ID, Block ID, Parking Location

static void MSTA_DM_Roster_UpdateParkingLocations(Args
_args)

{

    //Dialog Field

    Dialog fileDialog;

    DialogField sharedPath;

    // Excel Setup

    SysExcelApplication application;

    SysExcelWorkbooks workbooks;

    SysExcelWorkbook workbook;

    SysExcelWorksheets worksheets;

    SysExcelWorksheet worksheet;

    SysExcelCells cells;

    COMVariantType type;

    int row = 1;

    //Data Setup

    MSTARosterGroupLine rosterGroupLine;

    MSTARosterLine rosterLine;

    str 20 shiftFilter;

    fileDialog = new Dialog("Select
parking locations improt files for company " + curext());

    fileDialog.addText("Select parking
locations improt files for company " + curext());

    sharedPath =
fileDialog.addField(extendedTypeStr(FilenameOpen), "File Path");

    fileDialog.run();

    if (fileDialog.closedOk())

{

try

{

            application =
SysExcelApplication::construct();

            workbooks   =
application.workbooks();

            //TODO: Enter the excel file path

            workbooks.open(sharedPath.value());

            workbook = workbooks.item(1);

            worksheets = workbook.worksheets();

            worksheet =
worksheets.itemFromNum(1);

            cells = worksheet.cells();

            ttsBegin;

do

{

                //First row should be column
names

                row = row + 1;

                while select forupdate
rosterGroupLine                

                    where
rosterGroupLine.ShiftId == Global::COMVariant2Str(cells.item(row,
1).value())                       

{

                   
rosterGroupLine.ParkingLocationUniqueId =
Global::COMVariant2Str(cells.item(row, 3).value());

                    rosterGroupLine.update();

                    while select forUpdate
rosterLine

                        where
rosterLine.GroupRefId == rosterGroupLine.RecId

{

                       
if(rosterLine.VehicleBlockId == Global::COMVariant2Str(cells.item(row,
2).value()))

{

                           
rosterLine.ParkingLocationUniqueId =
Global::COMVariant2Str(cells.item(row, 3).value());

                           
rosterLine.update();

}

}

}

                type = cells.item(row,
1).value().variantType();

            }while (type !=
COMVariantType::VT_EMPTY);

            application.quit();

            info("Records Import " +
int2str(row));

            ttsCommit;

}

        catch

{

            ttsAbort;

            application.quit();

            error("@SYS80663");

}

}

}

Importing Data from Database

Which EDT is associated with File Selection and Folder Selection

For folder use FilePath EDT

For File Name use FileNameOpen EDT

How to make any alphabet as capital letter?

Use strUp method

How to create manual auto numbering system?

A technique I used in HR was as below,

// >>>
abdul @ 3rd June 2014 / Get New Auto Number Based On Company

public static
str getNewPersonnelNumber()

{

    int maxLenght = 4;

    str tempEmployeeID;

    str newNumber;

    int newIndex;

    str companyIdx;

    HCMWorker localWorker;

    str ret;

    str 2 companyIdFilter;

    //Pickup the first digit as company name

    companyIdx = String::trimToLength(curext(),
1);

    companyIdx = strUpr(companyIdx);

    companyIdFilter = companyIdx + '*';

    select firstOnly localWorker

        order by localWorker.PersonnelNumber
desc

        where localWorker.PersonnelNumber like
companyIdFilter;

    tempEmployeeID =
localWorker.PersonnelNumber;

    newNumber =
String::replaceAll(tempEmployeeID, companyIdx, "");

    newIndex = str2int(newNumber);

    newIndex = newIndex + 1;

    newNumber = String::fillString(maxLenght -
strLen(int2str(newIndex)), '0') + int2str(newIndex);

    newNumber = companyIdx + newNumber;

    ret 
= newNumber;

    return ret;

}

// >>>
abdul @ 3rd June 2014 / Get New Auto Number Based On Company

Creating a form at run time / dynamic form

http://dynamicsax-dev.blogspot.com.au/2008/07/creating-form-at-run-time.html

Creating and saving AX object on runtime (Saving in AOT Tree)

http://axblog4u.wordpress.com/2010/12/04/treenode-aot-save-%E2%80%93-did-you-know/

Creating a sys progress bar

#AviFiles

SysOperationProgress    progressBar = new SysOperationProgress();

;

// Initialising
progress bar

progressBar.setCaption("Export
To Excel in progress...");

progressBar.setAnimation(#AviTransfer);

progressBar.setText(strfmt("Employee
%1", emplTable.name()));

Traversing a data source on a form

PRMJournalTransHeader
journalTransHeaderLocal;

    if(Box::yesNo("@BCS10177",
DialogButton::No) == DialogButton::Yes)

{

        ttsbegin;

        for (journalTransHeaderLocal =
PRMJournalTransHeader_DS.getFirst();

            journalTransHeaderLocal;
journalTransHeaderLocal = PRMJournalTransHeader_DS.getNext() )

{

           
PRMGenerateEarningAndDeductions::generateAllDedAndEarns(journalTransHeaderLocal);

}

        ttscommit;

       
PRMJournalTransHeader_ds.executeQuery();

}

}

Ledger Dimensions Functionality

Print the financial dimensions for all employments

static void
MSTA_HR_140610_EmplDim(Args _args)

{

    HcmWorker worker;

    HcmEmployment employment;

    #AviFiles

    SysOperationProgress    progressBar = new SysOperationProgress();

    // Initialising progress bar

    progressBar.setCaption("Printing in
progress...");

    progressBar.setAnimation(#AviTransfer);

    while select worker

{

       
progressBar.setText(strfmt("Employee %1", worker.name()));

        employment =
HcmEmployment::getActiveEmploymentsByWorker(worker.RecId);

        if(employment.DefaultDimension)

{

            info(strFmt("%1, %2,
Department Value: %3", worker.PersonnelNumber, worker.name(),
getDefaultDimensionValue(employment.DefaultDimension,
"Department")));

}

}

}

How to get the dimension value from a ledger dimension

static str 255
getDefaultDimensionValue(RecId defaultDimension, Name dimName)

{

    str 255 ret;

    DimensionAttributeValueSetStorage
dimStorage;

    dimStorage =
DimensionAttributeValueSetStorage::find(defaultDimension);

    ret =
dimStorage.getDisplayValueByDimensionAttribute(DimensionAttribute::findByName(dimName).RecId);

    return ret;

}

How to get the dimension value from a ledger dimension

static RecId
setDefaultDimensionValue(RecId defaultDimension, Name dimName, str 255
dimValue)

{

    DimensionAttributeValueSetStorage
dimStorage;

    Counter i;

    DimensionAttribute dimAttributeCostCenter;

    DimensionAttributeValue dimAttributeValue;

    dimStorage =
DimensionAttributeValueSetStorage::find(defaultDimension);

    dimAttributeCostCenter =
DimensionAttribute::findByName(dimName);

    if(dimValue)

{

        dimAttributeValue =
DimensionAttributeValue::findByDimensionAttributeAndValue(dimAttributeCostCenter,
dimValue, true, true);

        dimStorage.addItem(dimAttributeValue);

}

    else

{

       
dimStorage.removeDimensionAttribute(DimensionAttribute::findByName(dimName).RecId);

}

    return dimStorage.save();

}

How to update worker dimension values

static void
MSTA_HR_140610_UpdateEmplDim(Args _args)

{

    HcmWorker worker;

    HcmEmployment employment;

    #AviFiles

    SysOperationProgress    progressBar = new SysOperationProgress();

    // Initialising progress bar

    progressBar.setCaption("Printing in
progress...");

    progressBar.setAnimation(#AviTransfer);

    ttsBegin;

    while select worker

{

       
progressBar.setText(strfmt("Employee %1", worker.name()));

        employment =
HcmEmployment::getActiveEmploymentsByWorker(worker.RecId);

        employment.selectForUpdate(true);

       
employment.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);

        if(employment.DefaultDimension)

{

            employment.DefaultDimension =
Global::setDefaultDimensionValue( employment.DefaultDimension,
"Contract", "None");

            employment.DefaultDimension =
Global::setDefaultDimensionValue( employment.DefaultDimension,
"ContractType", "None");

            employment.update();

            info(strFmt("%1, %2,
Department Value: %3", worker.PersonnelNumber, worker.name(),

               
getDefaultDimensionValue(employment.DefaultDimension,
"Department")));

}

}

    ttsCommit;

}

How Can I use distinct / unique is X++ statements?

Use 'GroupBy' in the select statement which field you want the distinct records.

A4 portrait and landscape paper size?

The paper size for A4 portrait is 8.27 * 11.69 inches and for Landscape is 11.69 * 8.27. Make sure that the page size is inclusive of the margins.

The paper size for A4 portrait is 210 * 297 mm and for Landscape is 297 * 210. Make sure that the page size is inclusive of the margins.

How to convert EDT to str to be used in dialog fields?

Use extendedTypeStr

How to shrink the database log files?

See names of the log file in DB

SELECT name, physical_name AS current_file_location

FROM sys.master_files

USE AdventureWorks2012;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE AdventureWorks2012
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (AdventureWorks2012_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE AdventureWorks2012
SET RECOVERY FULL;
GO

How to export to Excel?

static void SR_SysExcelWorksheetHelper(Args _args)

{

    CustTable               custTable;

    SysExcelWorksheetHelper
worksheetHelper;

    SysExcelHelper          sysExcelHelper;

    SysExcelWorksheet       worksheet;

    int                     currentRow
= 1;

    int                     sumRow;

    str                     worksheetName;

    int                     redColor
= WinAPI::RGB2int(255, 0, 0);

    SysExcelRange           range;

    COMVariant              cellValue
= new COMVariant(COMVariantInOut::Out);

    str                     fileName;

    str attachmentPath      = "C:\\";

    // Sets the font color
for a range of cells

    void setRangeFont(int _fromColumn, int _fromRow, int _toColumn, int _toRow, int _rgbIntColor)

{

        range
= worksheetHelper.getWorksheetRange(_fromColumn, _fromRow, _toColumn, _toRow);

        worksheetHelper.setFontColor(range,
_rgbIntColor);

}

    // Defines the columns
of the spreadsheet

    #define.AccountNum(1)

    #define.Currency(2)

    #define.CustGroup(3)

    #define.BalanceMST(4)

    worksheetName
= "@SYS135880";

    sysExcelHelper =
SysExcelHelper::construct();

    sysExcelHelper.initialize();

    worksheet =
sysExcelHelper.addWorksheet(worksheetName);

    worksheetHelper =
SysExcelWorksheetHelper::construct(worksheet);

    // Populate the header
row with the appropriate field labels and format the columns

    worksheetHelper.addColumnFromTableField(#AccountNum, tablenum(CustTable), fieldnum(CustTable, AccountNum));

    worksheetHelper.addColumnFromTableField(#Currency, tablenum(CustTable), fieldnum(CustTable, Currency));

    worksheetHelper.addColumnFromTableField(#CustGroup, tablenum(CustTable), fieldnum(CustTable, CustGroup));

    worksheetHelper.addColumn(#BalanceMST, "Balance MST", Types::Real);

    while select custTable

{

        currentRow
++;

        worksheetHelper.setCellValue(#AccountNum,
currentRow, custTable.AccountNum);

        worksheetHelper.setCellValue(#Currency,
currentRow, custTable.Currency);

        worksheetHelper.setCellValue(#CustGroup,
currentRow, custTable.CustGroup);

        worksheetHelper.setCellValue(#BalanceMST,
currentRow, custTable.balanceMST());

}

    if (currentRow > 1)

{

        sumRow
= currentRow + 2;

        worksheetHelper.setCellValue(#BalanceMST,
sumRow, "@SYS58659");

        worksheetHelper.sumRange(worksheetHelper.getWorksheetRange(#BalanceMST, 2, #BalanceMST, currentRow), #BalanceMST,
sumRow);

        setRangeFont(#BalanceMST, 2, #BalanceMST, currentRow, redColor);

        cellValue
= worksheet.cells().item(sumRow, #BalanceMST).value();

        if (cellValue.currency() > 0)

{

        setRangeFont(#BalanceMST,
sumRow, #BalanceMST, sumRow, redColor);

}

}

    worksheetHelper.autoFitColumns();

    worksheetHelper.formatWorksheetTableStyle(sysExcelHelper.getOfficeVersion());

    // Generate the file
using the current UTC date time (without the ‘:’ character)

    // since it is not
allowed for file names.

fileName = strfmt("%1%2%3", WinApi::getTempPath(), strReplace(DateTimeUtil::toStr(DateTimeUtil::utcNow()), ":",""), sysExcelHelper.getFileExtension());

    sysExcelHelper.save(filename);

    sysExcelHelper.launchExcel();

}

How to get temporary Path in AX?

WinApi::getTempPath()

How to add a new Field in Managerial Hierarchy (Workflow Approval Limits)?

In order to add a new field in the managerial hierarchy either create a new HierarchyProvider or use WorkflowLimitHierarchyProvider class and add new fields in it. Check the new method of WorkflowLimitHierarchyProvider to get an overview.

Infolog system in Dynamics AX, how does it work?

setPrefix("Level 1");

Info("A");

Unbalanced TTS Begin

static void resetTTS(Args _args)
{
while (appl.ttsLevel() > 0)
ttsAbort;
}

How to check if Code is running in CIL?

Use if(xSession::isCLRSession()) {…}

Reflection: Traverse Projects AOT

static void
MSTA_Utility_ExportAllProjects(Args _args)

{

    #aot

    #properties

    #AviFiles

    SysOperationProgress    progressBar = new SysOperationProgress();

    TreeNode _treeNode;

    TreeNode projectNode;

    TreeNodeIterator iterator;

    int i, a;

    // Initialising progress bar

    progressBar.setCaption("Export To
Excel in progress...");

    progressBar.setAnimation(#AviTransfer);

    _treeNode = infolog.projectRootNode();

    _treeNode = _treeNode.AOTfirstChild();

    for(i = 0; i < 2; i++)

{

        iterator = _treeNode.AOTiterator();

        projectNode = iterator.next();

        while (projectNode)

{

           
progressBar.setText(strfmt("Project %1",
projectNode.treeNodeName()));

           
if(String::beginsWith(projectNode.treeNodeName(), "MSTA"))

{

               
info(projectNode.treeNodeName());

}

            projectNode = iterator.next();

            a++;

}

        _treeNode = _treeNode.AOTnextSibling();

}

}

Reflection: Traverse Classes AOT

//Traverse
Class

static void
FindClassStartsWithXXX(Args _args)

 {

   UtilIdElements utilId;

 ;

   while select utilId where
utilid.recordType == UtilElementType::Class

   && utilId.name like
'XXX*'

   {

     print utilId.name;

   }

   pause;

 }

//Traverse
Class

static void FindTablesStartsWithXXX(Args _args)

{

UtilIdElements utilId;

;

while select utilId where utilid.recordType == UtilElementType::Table

&& utilId.name like 'MSTA*'

{

info(utilId.name);

}

pause;

}

//Update Class
Properties

static void
RenameXXXObjectsToYYY(Args _args)

 {

   TreeNode  node =
TreeNode::findNode(@'\Classes\XXXClass');

   str oldName;

   str newName;

   #Properties

   ;

   oldName =
node.AOTgetProperty(#PropertyName);

   newName =
strdel(oldName,1,3);

   node.AOTsetProperty(#PropertyName,
"YYY"+newName);

   node.AOTsave();

   node.treeNodeRelease();

   node = null;

 }

How to add database log manually?

    DatabaseLog dblog;

    ttsBegin;

    dblog.logTable = tableNum(HcmWorker);

    dblog.LogType = DatabaseLogType::Delete;

    dblog.insert();

    ttsCommit;

Dynamics AX Collections

How to create a list of records and iterate them?

 AifAction aifAction;

    List actionsList = new
List(Types::Record);

    ListEnumerator listEnum;

    ;

    if(_actionsList)

    {

        listEnum =
_actionsList.getEnumerator();

while(listEnum.moveNext())

        {

            aifAction = listEnum.current();

            if(
aifAction.WebMethodEnabled == NoYes::No &&

                aifAction.WebSvcOutOfSync
== NoYes::Yes &&

                aifAction.ErrorState ==
AifServiceGenerationErrorState::WebServiceOutOfSyncError &&

                aifAction.Intercompany ==
NoYes::No)

            {

actionsList.addEnd(aifAction);

            }

        }

    }

How to convert real numbers to time format

public static str 5 num2Time(real _hours)

{

    int realPart;

    int decimalPart;

    real hours;

    str hoursStr;

    str minStr;

    int decimalLocation;

    str finalMinutes;

;

try

{

        hours =
_hours;

        hoursStr =
num2str(hours, 0, 2, 1, 0);

       
decimalLocation = strfind(hoursStr, ".", 0, strlen(hoursStr));

        hoursStr =
substr(hoursStr, 0, decimalLocation);

        hoursStr =
trimString(hoursStr, ["."]);

        minStr =
num2str(hours, 0, 2, 1, 0);

        minStr =
substr(minStr, decimalLocation, strlen(minStr) - strlen(hoursStr));

        minStr =
trimString(minStr, ["."]);

        realPart =
str2int(hoursStr);

        decimalPart
= str2int(minStr);

       
finalMinutes = hoursStr + ":" + (int2str(60 * decimalPart / 100) ==
"0" ? "00" : int2str(60 * decimalPart / 100));

        return
finalMinutes;

}

    catch

{

        return
num2str(_hours, 0, 2, 1, 0);

}

}

strFmt("%1:%2", hours div 1, strRfix(int2str(round(abs(hours)*60,1) mod 60),2,"0"))

From <http://msdax.blogspot.com.au/2011/06/converting-real-number-to-time.html>

SQL Server: Identifying and Killing Blocking Transactions

SELECT

db.name DBName,

tl.request_session_id,

wt.blocking_session_id,

OBJECT_NAME(p.OBJECT_ID) BlockedObjectName,

tl.resource_type,

h1.TEXT AS RequestingText,

h2.TEXT AS BlockingTest,

tl.request_mode

FROM sys.dm_tran_locks AS tl

INNER JOIN sys.databases db ON db.database_id =tl.resource_database_id

INNER JOIN sys.dm_os_waiting_tasks AS wt ON tl.lock_owner_address =wt.resource_address

INNER JOIN sys.partitions AS p ON p.hobt_id =tl.resource_associated_entity_id

INNER JOIN sys.dm_exec_connections ec1 ON ec1.session_id =tl.request_session_id

INNER JOIN sys.dm_exec_connections ec2 ON ec2.session_id =wt.blocking_session_id

CROSS APPLY sys.dm_exec_sql_text(ec1.most_recent_sql_handle) AS h1

CROSS APPLY sys.dm_exec_sql_text(ec2.most_recent_sql_handle) AS h2

KILL

From <http://blog.sqlauthority.com/2010/10/06/sql-server-quickest-way-to-identify-blocking-query-and-resolution-dirty-solution/>

How to Assign temporary table to Grid?

Grid.setTmpData(temporaryTabeReference);

Lookups

How to create simple lookup?

Simple lookups can easily be created by adding a relation between the tables.

How to create a dynamic lookup?

In order to create a dynamic lookup there are two steps,

Step1: Create a lookup method in table or class

public static
void lookupVendorByCurrency(

    FormControl _callingControl,

    CurrencyCode _currency)

{

    Query query;

    QueryBuildDataSource qbds;

    QueryBuildRange qbr;

    SysTableLookup lookup;

    query = new Query();

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

    qbr = qbds.addRange(fieldNum(VendTable,
Currency));

    qbr.value(queryvalue(_currency));

    lookup =
SysTableLookup::newParameters(tableNum(VendTable), _callingControl, true);

    lookup.parmQuery(query);

    lookup.addLookupField(fieldNum(VendTable,
AccountNum), true);

   
lookup.addLookupField(fieldNum(VendTable,Party));

   
lookup.addLookupField(fieldNum(VendTable,Currency));

    lookup.performFormLookup();

}

Step2: Call the lookup method from the overridden lookup method on the data source field

public void
lookup(FormControl _formControl, str _filterStr)

{

   
VendTable::lookupVendorByCurrency(_formControl, CustTable.Currency);

}

Display Method Caching

Display methods
must be written at table levels, in AX 2012 you can also use cache display
method property of form controls.

CustTable_ds.cacheAddMethod(tableMethodStr(CustTable,
name), false);

How to implement multi-threading in AX ?

How to Place a new line character in a Label?

Use  info(strFmtLB("@Label"));

How to change the splash screen for AX?

http://www.axaptapedia.com/Changing_Splashscreen

How to check configuration key?

if
(isConfigurationkeyEnabled(configurationKeyNum('MSTARails')))

{

}

How to create a new number sequence in AX 2012?

1.  Create an edt : CarId .

AOT >>
Extended Datatype

2. Write a code
on lode module() on NumberSeqModuleProject

{

    
datatype.parmDatatypeId(extendedTypeNum(Car Id));

    
datatype.parmReferenceHelp(literalStr("@SYS334483"));

     datatype.parmWizardIsManual(NoYes::No);

    
datatype.parmWizardIsChangeDownAllowed(NoYes::No);

    
datatype.parmWizardIsChangeUpAllowed(NoYes::No);

     datatype.parmWizardHighest(999999);

     datatype.parmSortField(20);

    
datatype.addParameterType(NumberSeqParameterType::DataArea, true,
false);

     this.create(datatype);

}

3.Write a
method on Projparameters Table

client server
static NumberSequenceReference numRefcarId()

{

     return
NumberSeqReference::findReference(extendedTypeNum(car Id));

}

4.Write a job
and run that

static void
Carid(Args _args)

{

    NumberSeqModuleProject  NumberSeqModuleProject = new
NumberSeqModuleProject();

;

    NumberSeqModuleProject.load();

}

5. Then run the
wizard

Organization
Administration >> CommonForms >>
Numbersequences>>Numbersequences>> Generate >> run the
wizard.

6.Now we have
to check the number sequence  is
correctly working  for that write a job:

static void
number(Args _args)

{

    NumberSeq 
numberSeq;

    CarId num;

;

    numberSeq =
NumberSeq::newGetNum(ProjParameters::numRefcarId());

    num = numberSeq.num();

    info(num);

}

Run the above
job.We will find the generated Number    
sequence.                                                   
.

7. Now we want
that Number Sequence in form level(Car Table):

Declare the
number sequence On Form Declaration:

public class
FormRun extends ObjectRun

{

    NumberSeqFormHandler numberSeqFormHandler;

}

8. Write the
NumberSeqFormHandler() in form methods node.

NumberSeqFormHandler
numberSeqFormHandler()

{

    if (!numberSeqFormHandler)

{

        numberSeqFormHandler =
NumberSeqFormHandler::newForm(ProjParameters::numRefcarId       ().NumberSequenceId,

                                                            
element,

                                                            
CarTable_DS,

                                                            
fieldNum(CarTable, Car Id)

);

}

    return numberSeqFormHandler;

}

9.Write the
close() on the form methods node.

void close()

{

    if (numberSeqFormHandler)

{

        numberSeqFormHandler.formMethodClose();

}

    super();

}

10. Then final
add the below methods on data source methods node

Create()

void
create(boolean append = false,

            boolean extern = false)  // If created externally

{

   
element.numberSeqFormHandler().formMethodDataSourceCreatePre();

    super(append);

    if (!extern)

{

       
element.numberSeqFormHandler().formMethodDataSourceCreate(true);

}

}

Delete()

public void
delete()

{

   
element.numberSeqFormHandler().formMethodDataSourceDelete();

    super();

}

Write()

public void
write()

{

    super();

   
element.numberSeqFormHandler().formMethodDataSourceWrite();

}

Validate
Write()

public boolean
validateWrite()

{

    boolean         ret;

    ret = super();

    ret =
element.numberSeqFormHandler().formMethodDataSourceValidateWrite(ret)
&& ret;

    if (ret)

{

        CarTable.validateWrite();

}

    return ret;

}

Link Active()

public void
linkActive()

{

;

   
element.numberSeqFormHandler().formMethodDataSourceLinkActive();

    super();

}

Now our
numberseqence is generated .

*** Set the
field or Tabpage Allowedit property to No.

***Check the
continues on wizard.

Getting a list of all projects

2014-07-14T22:34:00.002-07:00

Question: How can i get a list of all projects in a system?

Answer: Use the code snippet below,

static void MSTA_Utility_ExportAllProjects(Args _args)
{
#aot
#properties
#AviFiles
SysOperationProgress progressBar = new SysOperationProgress();

TreeNode _treeNode;
TreeNode projectNode;
TreeNodeIterator iterator;
int i, a;
// Initialising progress bar
progressBar.setCaption("Export To Excel in progress...");
progressBar.setAnimation(#AviTransfer);

_treeNode = infolog.projectRootNode();
_treeNode = _treeNode.AOTfirstChild();

for(i = 0; i < 2; i++)
{
iterator = _treeNode.AOTiterator();
projectNode = iterator.next();
while (projectNode)
{
progressBar.setText(strfmt("Project %1", projectNode.treeNodeName()));
if(String::beginsWith(projectNode.treeNodeName(), "MSTA"))
{
info(projectNode.treeNodeName()) ;
}
projectNode = iterator.next();
a++;
}
_treeNode = _treeNode.AOTnextSibling();
}

}

Database Diagrams for AX 2012 R2! - Microsoft Dynamics AX Support - Site Home - MSDN Blogs

2013-06-17T18:59:00.001-07:00

Database Diagrams for AX 2012 R2! - Microsoft Dynamics AX Support - Site Home - MSDN Blogs: "Database Diagrams for AX 2012 R2!"

'via Blog this'

Object Server 01: The license information can not be decoded.

2013-05-16T16:36:00.003-07:00

Question:

AX 2012 AOS Service is not starting and I am getting the following error

"Object Server 01: The license information can not be decoded. "

Answer:
This is mainly because of permissions, I gave admin rights to AOS service account and it worked.

data or calculated fields with type 'Record' are not supported

2013-05-05T21:42:00.000-07:00

Question:
I am getting an error "data or calculated fields with type 'Record' are not supported".

Answer:
Make sure the table and all related tables does not have any display method returning a record.

Keyboad Mapper

2013-05-05T16:50:00.001-07:00

http://sharpkeys.codeplex.com/

Dynamics AX 2009 Report libraries to Dynamics AX 2012 SSRS Reports

2013-04-02T21:41:00.001-07:00

Question:How can i convert my Dynamics AX 2009 reporting libraries to be usable in Dynamics AX 2012?Answer:In order to use the Reporting Libraries from 2009 in 2012 use the following steps,1- Use the upgrade reports command line that comes with AX 2012 , normally located at C:\Program Files\Microsoft Dynamics AX\60\tools, to upgrade the reporting libraries to current format.

2- Open the business logic project created after the step above , compile and add the business logic to AOT.

3- Open the reporting project and change the business logic to be using the new business logic.

4- Compile the project, add to AOT and deploy to SSRS.

Other Links
1-http://technet.microsoft.com/EN-US/library/hh292607.aspx
2- http://technet.microsoft.com/en-us/library/hh292607.aspx

Mindbrations: AX2012 - How to control the visibility of FactBox on form thru X++

2012-11-06T21:29:00.001-08:00

Mindbrations: AX2012 - How to control the visibility of FactBox on form thru X++: "AX2012 - How to control the visibility of FactBox on form thru X++"

'via Blog this'

Print Main Menu

2012-10-24T21:54:00.003-07:00

Question: How can i print all elements of a main menu.

Answer: Use the following job,

static void menuPrint(Args _args)
{

SysDictMenu menu;
SysExcelWorksheetHelper worksheetHelper;
SysExcelHelper sysExcelHelper;
SysExcelWorksheet worksheet;
str menuToPrint;
str worksheetName;
int currentRow = 1;
str fileName;
str path;

void reportLevel(SysDictMenu _sysDictMenu)
{

SysMenuEnumerator enumerator;

if(_sysDictMenu.isMenuReference() || _sysDictMenu.isMenu())
{
path += _sysDictMenu.label() + "//";
enumerator = _sysDictMenu.getEnumerator();
while (enumerator.moveNext())
{
reportLevel(enumerator.current());
}
}
else
{ currentRow ++;
worksheetHelper.setCellValue(2, currentRow, _sysDictMenu.label());
path = "";
}
}

;

sysExcelHelper = SysExcelHelper::construct();
sysExcelHelper.initialize();

menuToPrint = 'Roster';
worksheetName = menuToPrint;
worksheet = sysExcelHelper.addWorksheet(worksheetName);
worksheetHelper = SysExcelWorksheetHelper::construct(worksheet);
// Populate the header row with the appropriate field labels and format the columns
worksheetHelper.addColumn(1, "Path", Types::String);
worksheetHelper.addColumn(2, "Item", Types::String);
worksheetHelper.addColumn(3, "Status", Types::String);
worksheetHelper.addColumn(4, "Assigned To", Types::String);
worksheetHelper.addColumn(5, "Notes", Types::String);
reportLevel(SysDictMenu::newMenuName(MenuStr(Roster)));
worksheetHelper.autoFitColumns();
worksheetHelper.formatWorksheetTableStyle(sysExcelHelper.getOfficeVersion());

// Generate the file using the current UTC date time (without the ‘:’ character)
// since it is not allowed for file names.
fileName = "C:\\Windows\\Temp\\ExportToExcel.xlsx";

sysExcelHelper.save(filename);
sysExcelHelper.launchExcel();

}

Read / Write Files from document handling

2012-08-28T21:32:00.001-07:00

Question:
How can you read / writes files from document handling?

Answer:

void fromFolderToDB(FilePath _path)
{
System.IO.DirectoryInfo         dir = new
System.IO.DirectoryInfo(_path);
System.IO.FileInfo[]            files;
System.IO.FileInfo              curFile;
System.Collections.IEnumerator enumerator;

BinData binData;

DocuValue docuValue;

;
files = dir.GetFiles(_path);
enumerator = files.GetEnumerator();
while (enumerator.MoveNext())
{
curFile = enumerator.get_Current();

docuValue.clear();

binData.loadFile(curFile.get_FullName()); // get file content

docuValue.File = binData.getData();
docuValue.FileName = curFile.get_Name();
docuValue.insert(); // insert into DB
}
}

void fromDBToFolder(FilePath _path)
{
BinData binData;
DocuValue docuValue;

;
while select docuValue // load From DB
{
binData.setData(docuValue.File);
binData.saveFile(docuValue.FileName); // insert into file system
}
}

Make attention to CodeAccessPermission when reading/writing to file system
and when using CLR inside X++

Error "Cannot access a disposed object" when deploying AX 2009 Enterprise Portal on a SharePoint 2010 server - Microsoft Dynamics AX Technical Support Blog - Site Home - MSDN Blogs

2012-08-27T18:51:00.001-07:00

Error "Cannot access a disposed object" when deploying AX 2009 Enterprise Portal on a SharePoint 2010 server - Microsoft Dynamics AX Technical Support Blog - Site Home - MSDN Blogs:

'via Blog this'

CAL License or Server License for SQL Server in AX Environment

2012-08-13T21:02:00.003-07:00

Question
Should we use CAL based licensing or server based licensing for SQL Server in AX Environment?

Answer
Please read the link from here.

Matching Invoices to Portions of a Packing Slip

2012-08-01T19:34:00.000-07:00

Question
Is there any way to find out invoices corresponding to individual packing slips

Answer
There is a link between InventTrans, CustInvoiceJourn and CustPackingSlipJour. This can be used to get the desired result. Also read this document.

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

Sending email through outlook in Dynamics AX

2012-07-26T23:34:00.000-07:00

Question:
How can i send an email in AX through outlook?

Answer:

static void OutlookEmail(Args _args)
{
SmmOutlookEmail smmOutlookEmail = new SmmOutlookEmail();

;
if (smmOutlookEmail.createMailItem())
{
smmOutlookEmail.addEMailRecipient('asamad@moorestephens.com.au');
smmOutlookEmail.addSubject("Test");
smmOutlookEmail.isHTML(true);
smmOutlookEmail.addBodyText('Test');
smmOutlookEmail.sendEMail(smmSaveCopyofEmail::No);
}
}

Dynamics AX (2009 & 2012): How to get On-Hand inventory of past years (by date)

2012-07-24T02:10:00.001-07:00

Dynamics AX (2009 & 2012): How to get On-Hand inventory of past years (by date): "How to get On-Hand inventory of past years (by date)"

'via Blog this'

Re: AXADOMD is not installed error. - Microsoft Dynamics AX Forum - Microsoft Dynamics AX - Microsoft Dynamics Community

2012-07-23T21:59:00.001-07:00

Re: AXADOMD is not installed error. - Microsoft Dynamics AX Forum - Microsoft Dynamics AX - Microsoft Dynamics Community: "AXADOMD is not installed error"

'via Blog this'

David Sandor | SOLVED: You must install SQL Server 2005 Analysis Services with Service Pack 2 or higher before installing the Analysis extensions.

2012-07-22T16:55:00.001-07:00

David Sandor | SOLVED: You must install SQL Server 2005 Analysis Services with Service Pack 2 or higher before installing the Analysis extensions.: "You must install SQL Server 2005 Analysis Services with Service Pack 2 or higher before installing the Analysis extensions."

'via Blog this'

AxUpdatePortal not working with SharePoint 2010

2012-07-19T19:56:00.001-07:00

Question:

When trying to deploy files using AxUpdatePortal utility in a SharePoint 2010 environment, the utility is not working at all.

Answer:

Make sure you have completed all the steps mentioned in the KB 2278963.

Server wallpaper with configuration info

2012-07-18T22:36:00.001-07:00

BgInfo: "BgInfo v4.16"

'via Blog this'

Microsoft Dynamics AX: Dynamics AX 2009 Bulk Data insert using SSIS - Arijit Basu | Dynamics AX MVP

2012-07-06T01:31:00.001-07:00

Microsoft Dynamics AX: Dynamics AX 2009 Bulk Data insert using SSIS - Arijit Basu | Dynamics AX MVP:

'via Blog this'

Dynamics AX 2009 - X++ Thread Development - Brandon George's Microsoft Dynamics AX Blog - AX Technical Blogs - Microsoft Dynamics Community

2012-07-06T01:27:00.001-07:00

Dynamics AX 2009 - X++ Thread Development - Brandon George's Microsoft Dynamics AX Blog - AX Technical Blogs - Microsoft Dynamics Community: "Dynamics AX 2009 - X++ Thread Development"

'via Blog this'

AX WONDERS: Intelligent Data Management Framework (IDMF)

2012-07-01T18:48:00.001-07:00

AX WONDERS: Intelligent Data Management Framework (IDMF): "Intelligent Data Management Framework (IDMF)"

'via Blog this'