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

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

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

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

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

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

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

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)

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

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.

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

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

BgInfo: "BgInfo v4.16"

'via Blog this'

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

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

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)

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

'via Blog this'

Dynamics AX: Free ebook: Introducing Windows Server 2012

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

'via Blog this'

Dynamics Ax « Casperkamal's Dynamics Ax blog

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.

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

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

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

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.

Get MS Dynamics Ax Call Stack in X++ Code - Microsoft Dynamics AX FOR TECHIES - AX Technical Blogs - Microsoft Dynamics Community

Get MS Dynamics Ax Call Stack in X++ Code - Microsoft Dynamics AX FOR TECHIES - AX Technical Blogs - Microsoft Dynamics Community:

'via Blog this'

How to check filter is enabled on a form

Query:

How can i check if the filter is enabled on an AX Form.

Answer:

The actions user perform an an ax form are processed in a method called task. You can override that method to see task id 2855. If it is the value then filter is enabled.

Enable remote errors on SSRS

Query:


I am getting some errors when viewing SSRS reports on client machines but i can not see the full error because it is asking me to enable remote errors on ssrs. How can i do that on ssrs 2005.

Answer:
The setting is stored in the table named 'ConfigurationInfo ' on the report server. Just open the table and set Enable Remote Errors to true.

Art Of Creation – Dynamics AX Blog » Batch multithreading

Art Of Creation – Dynamics AX Blog » Batch multithreading:

'via Blog this'

How to increase scroll bar size in windows application?

Question:


How can i increase scroll bar size in a windows application based on .Net Business Connector ?


Answer:


You can use windows display properties under personalization for it.
Further reading

How TO Write an Edit Method

Question:
How to write an edit method?


Answer:
Suppose you have an integer field with allowed values of 0 and 1. We can use an edit method to show a check box instead. We just have to use this edit method as a display method on the form control.


public edit NoYesId IsAllowed(boolean _set, NoYesId _value)
{
    NoYesId ret;
    int actualValue;
    if (_set)
    {
        if(_value == NoYes::Yes)
        {
            actualValue = 1;
        }
        ttsbegin;
        this.IsAllowedInt = actualValue;
        this.update();
        ttscommit;
    }
    else
    {
        if(this.IsAllowedInt)
        {
            ret = NoYes::Yes;
        }
    }
    return ret;
}

Dynamics AX Business Connector : Client made two requests at the same time.

Question :

I received a following error in my application built on the middle ware of business connector, "Client made two requests at the same time.".

Answer:


This is happening because you might have a multi-threaded application using same AX session in two requests. What you can do to fix it is to use different session objects for different parallel threads.