Microsoft Dynamics AX

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'

Dynamics AX: Free ebook: Introducing Windows Server 2012

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

Dynamics AX: Free ebook: Introducing Windows Server 2012: "Free ebook: Introducing Windows Server 2012"

'via Blog this'

Dynamics Ax « Casperkamal's Dynamics Ax blog

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

Dynamics Ax « Casperkamal's Dynamics Ax blog: "Tools4Dax – Development tools for Dynamics Ax"

'via Blog this'

David Sandor | Dynamics Ax 2009 Logon/Logoff overhead, Business Connector, AIF.

2012-06-27T00:25:00.001-07:00

David Sandor | Dynamics Ax 2009 Logon/Logoff overhead, Business Connector, AIF.: "Dynamics Ax 2009 Logon/Logoff overhead, Business Connector, AIF."

'via Blog this'

Dilip's blog on DYNAMICS AX: Inside Microsoft Dynamics AX 2012

2012-06-13T21:59:00.001-07:00

Dilip's blog on DYNAMICS AX: Inside Microsoft Dynamics AX 2012: "Inside Microsoft Dynamics AX 2012"

'via Blog this'

Microsoft Dynamics AX 2012: Install multiple instances of Reporting Services extensions on the same machine - Microsoft Dynamics AX Technical Support Blog - Site Home - MSDN Blogs

2012-06-07T18:53:00.001-07:00

Microsoft Dynamics AX 2012: Install multiple instances of Reporting Services extensions on the same machine - Microsoft Dynamics AX Technical Support Blog - Site Home - MSDN Blogs: "Microsoft Dynamics AX 2012: Install multiple instances of Reporting Services extensions on the same machine"

'via Blog this'

Dynamics AX License Tables

2012-05-24T16:54:00.000-07:00

Question
I copied my clients database today to do some testing on live data. How can I make sure that the local licenses are intact.

Answer
Dynamics AX stores licenses data in two tables,

1.SysLicenseCodeSort
2.SysConfig

If you copy the data from your local AX instances to client AX instance the layers code will be intact.