Microsoft Dynamics AX

Art Of Creation – Dynamics AX Blog » Batch multithreading

2012-02-08T22:56:00.000-08:00

Art Of Creation – Dynamics AX Blog » Batch multithreading:

'via Blog this'

How to increase scroll bar size in windows application?

2012-01-15T08:08:00.000-08:00

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

2012-01-11T16:47:00.000-08:00

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.

2012-01-09T16:08:00.000-08:00

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.

DAX Dude: AX 2009 Batch Job Stuck In Executing

2011-12-13T01:45:00.000-08:00

DAX Dude: AX 2009 Batch Job Stuck In Executing:

'via Blog this'

Wai Keat Ng's Dynamics AX Blog: Create Alert using X++ codes

2011-12-12T23:03:00.000-08:00

Wai Keat Ng's Dynamics AX Blog: Create Alert using X++ codes: "EventInbox inbox;
;

inbox.initValue();
inbox.ShowPopup = NoYes::Yes;
inbox.Subject = "This is the Alert subject";
inbox.Message = "This is the Alert message";
inbox.AlertedFor = "This alert is just information no links are available";
inbox.SendEmail = false;
inbox.UserId = curuserid();
inbox.TypeId = classnum(EventType);

inbox.AlertTableId = tablenum(Address);
inbox.AlertFieldId = fieldnum(Address, Name);
inbox.TypeTrigger = EventTypeTrigger::FieldChanged;
inbox.CompanyId = curext();
inbox.InboxId = EventInbox::nextEventId();;
inbox.AlertCreatedDateTime = DateTimeUtil::getSystemDateTime();
inbox.insert();"

'via Blog this'

Dynamics AX Custom ALerts

2011-12-12T22:23:00.000-08:00

Query :

How can i add custom alerts in dynamics ax?

Answer :

void createAction()
{

EventNotificationSource _source;
EventNotificationBatch event = EventNotification::construct(EventNotificationSource::Batch);
;

event.parmUserId(curuserid());
event.parmSubject(subject);
event.parmMessage(message);
event.parmNotificationType(EventNotificationType::Action);
event.parmShowPopup(NoYes::Yes);
event.parmSendEmail(sendemail);
event.create();
}

Dynamics NAVAX: How to run AX2012 HyperV on Virtualbox (Step by step guide)

2011-12-05T16:51:00.000-08:00

Dynamics NAVAX: How to run AX2012 HyperV on Virtualbox (Step by step guide):

'via Blog this'

The thing about the .NET Business Connector and the number of online users - Microsoft Dynamics AX Technical Support Blog - Site Home - MSDN Blogs

2011-11-28T01:03:00.000-08:00

The thing about the .NET Business Connector and the number of online users - Microsoft Dynamics AX Technical Support Blog - Site Home - MSDN Blogs:

'via Blog this'

Dynamics AX 2009 + SSRS Lessons Learned

2011-11-20T16:24:00.001-08:00

Following are the lessons i have learned when configuring SSRS for AX 2009,

1- Always use IP address for connecting to SSRS
2- Add both the business connector user and the client connecting user as AX users, for instance if your bc user is proxy and the client connecting is newclient both the ID's should be in AX.
3- Make sure the business connector is configured properly.
4 -Make sure that SSRS URL is under trusted sites.

app.config editor

2011-11-15T19:33:00.001-08:00

Question:

Is there any application around which I can use to update app.config files associated with .Net applications.

Answer:

The best application I have found is hosted on code project, http://www.codeproject.com/KB/files/AppConigEditor.aspx

Dynamics AX 2009 Known Issues

2011-11-09T04:50:00.001-08:00

Question :

Is there a place to review all the knows Dynamics AX 2009 Issues ?

Answer:

Yes, kindly review the following link.
http://dynamicspost.blogspot.com/2011/04/ax-2009-known-issues-solutions.html

RPC 5 Exception

2011-11-08T23:55:00.000-08:00

Question :
I am running SSRS 2008 R2 with Dynamics ax under network services user. Issue is sometimes the reports show up and sometimes they do not. I notice that i have few error with RPC 5 exception in my event log.

Answer :
This is a know issue. To fix this for SSRS 2008 remove the execution account from SSRS configuration manager and run the SSRS service under BC Proxy account.

Dynamics AX SSRS The request failed with HTTP status 401

2011-11-08T23:52:00.000-08:00

Question :
I am receiving a 401 error when connecting to AX Reports hosted on SSRS 2008 R2.

Answer :

The solution that worked for me was to open rsreportserver.config file placed in the reporting services instalaltion directory, finding authentication group and commenting WindowsNegotiate tag as shown below.

true

Dynamics AX Log On Failed on Reporting Services

2011-10-24T16:22:00.000-07:00

Query:

I am getting a logon failure when running reporting services for dynamics.

Answer:

Make sure the business connector credentials are correct.

Seconds to actual time in C#

2011-10-23T20:55:00.000-07:00

I always used to have issues when debugging time related issues in AX. Time is saved in seconds so many time when you want to know the actual time associated with it in hh : mm : ss, you will either have to do it in mind or use a calculator. In order to simplify debugging I have created a small C# based console application that takes seconds as input and returns the time in actual format.

The code is below and you can compile it in visual studio to make it work.

Enjoy!

Download the application from here.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Decimal2Hours
{
class Program
{
static void Main(string[] args)
{
while (true)
{
Console.WriteLine(Program.ConvertSecondsToHoursMinutes(Console.ReadLine()));
}
}

public static string ConvertDecimalToHours(string paramHours)
{
int realPart;
int decimalPart;
decimal hours;
string hoursStr;
string minStr;
int decimalLocation;
string finalMinutes;
decimal _hours = decimal.Parse(paramHours);
;
try
{
hours = _hours;
hoursStr = hours.ToString();
decimalLocation = hoursStr.IndexOf(".");
hoursStr = hoursStr.Substring(0, decimalLocation);
hoursStr = hoursStr.Trim(new char[] { '.' });
minStr = hours.ToString();
minStr = minStr.Substring(decimalLocation);
minStr = minStr.Trim(new char[] { '.' });
realPart = Convert.ToInt32(hoursStr);
decimalPart = Convert.ToInt32(Math.Floor((decimal)Convert.ToDecimal("0." + minStr) * 60));
finalMinutes = (realPart.ToString().Length == 1 ? "0" + realPart.ToString() : realPart.ToString())
+ ":" +
(decimalPart.ToString().Length == 1 ? "0" + decimalPart.ToString() : decimalPart.ToString());
return finalMinutes;
}
catch
{
return paramHours;
}
}

public static string ConvertSecondsToHoursMinutes(string paramSeconds)
{
string finalTime;
int seconds = Convert.ToInt32(paramSeconds);
int result;
int hours = Math.DivRem(seconds, 60 * 60, out result);
seconds = result;
int minutes = Math.DivRem(seconds, 60, out result);
seconds = result;

finalTime = hours.ToString() + " : " + minutes.ToString() + " : " + seconds.ToString();

return finalTime;
}
}
}

How can I add sql server account from command prompt?

2011-10-20T05:01:00.001-07:00

Query :
How can I add sql server account from command prompt?

Answer :

http://blogs.ameriteach.com/chris-randall/2009/12/11/sql-server-2008-forgot-to-add-an-administrator-account.html

Dynamics AX Excel Sheet Import, In Correct Time Values

2011-10-17T17:51:00.000-07:00

Query
Whenever I import an excel sheet containing a timing point, it is converted to 1 second less than the actual value.

Answer
This is a known issue and you can look at http://support.microsoft.com/kb/969186 for the resolution and workaround.

SharePoint Database Configuration Failed

2011-10-12T09:02:00.000-07:00

Query :

I changed the DNS IP today and was unable to connect to SharePoint database. The error that i am getting is "Failed to connect to the configuration database"

Answer :
There can be many factors to cause this issue. You can read about this issue at "http://support.microsoft.com/kb/823287/en-us".

One more issue can be the change of the IP of your DNS Server. In order to resolve most of the issues you can create a new database using the following command,

"C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\PSCONFIG.EXE" -cmd configdb -create -database

Excel Value to String

2011-08-23T22:55:00.000-07:00

Query: How can i create a generic method for returning string values from excel.

Answer:

// convert into str from excel cell value
str COMVariant2Str(COMVariant _cv,
                    int _decimals = 0,
                        int _characters = 0,
                        int _separator1 = 0,
                        int _separator2 = 0)
{
    switch (_cv.variantType())
    {
        case (COMVariantType::VT_BSTR):
            return _cv.bStr();

        case (COMVariantType::VT_R4):
            return num2str(_cv.float(),_characters,_decimals,_separator1,_separator2);

        case (COMVariantType::VT_R8):
            return num2str(_cv.double(),_characters,_decimals,_separator1,_separator2);

        case (COMVariantType::VT_DECIMAL):
            return num2str(_cv.decimal(),_characters,_decimals,_separator1,_separator2);

        case (COMVariantType::VT_DATE):
            return date2str(_cv.date(),123,2,1,2,1,4);

        case (COMVariantType::VT_EMPTY):
            return "";

        default:
            throw error(strfmt("@SYS26908", _cv.variantType()));
    }
    return "";
}

Corrupted applicationHost.config

2011-08-17T19:12:00.000-07:00

Query:
The IIS file applicationHost.config got corrupted today, is there any way i can regenerate?

Answer:
You can restore from the backup placed at C:\inetpub\history

No .NET Business Connector session could be found

2011-08-16T22:09:00.001-07:00

ssrs unable to load client print control on windows 2003

2011-08-15T17:49:00.000-07:00

Query:
I am getting an issue when trying to print the SSRS reports. It keeps saying "unable to load client print control".

Answer:

Uninstall KB KB956390

Dynamics AX Workflow Purchase Requistion

2011-07-24T19:08:00.000-07:00

Queries:
I can not create purchase requisition on behalf of other users?

Answer:
Go to HR->Employee Details->Setup->on behalf of to setup employees on behalf of whom you want to create PR's.

How to check configuration key in X++

2011-07-21T20:30:00.001-07:00

Query:
How can i check if the configuration key is enabled through x++?

Answer:

if (isConfigurationKeyEnabled(configurationkeynum(keyname)))
{
//insert code here
}