FT Dynamics AX blog

Journal total debit / credit balances not correct (AX4.0 SP2)

2010-07-27T21:43:00.001+07:00

Some users complain about in Vendor Payment Journal form sometimes the journal total debit/credit become incorrect after editing the journal.

The problem was that the journal balances are “remembered” by the journal table and by design when open the form it only retrieve the existing value. Some bugs probably make it such that certain updates are ignored and lead to incorrect journal balances. While this does not affect the final result, it’s very inconvenient for users to do spot check.
Well, since the issue does not affect actual posting, I guess fixing the debit credit display is enough. These journals uses the LedgerJournalEngine to display the balances. In the linkActive method in the form datasource, there’s a line that initiate a ledgerJournalEngine:

ledgerJournalEngine.newJournalActive(ledgerJournalTable);

simply change it to the following:

ledgerJournalEngine.newJournalActive(ledgerJournalTable,true);

The “true” parameter instructs the engine to do a recal on the journal balance every time the journal is opened.

It’s not the perfect solution. The next step might be add a button to recalculate as needed but I can live without it.

AX 2009 Workflows: A Quick overview

2008-06-19T16:47:00.001+07:00

A great article written by Arijit Basu on DAX 2009 workflow.
Check it out!

Microsoft Dynamics AX 2009 SDK

2008-06-19T16:41:00.001+07:00

Please follow this link.

What the DAX executives have to say?

2008-06-12T16:45:00.001+07:00

Check this out: Interview with Microsoft Dynamics Executives to see what they have to say in the present and future of Dynamics AX.

Dynamics AX 2009 RTM download

2008-05-23T15:49:00.001+07:00

Dynamics AX 2009 RTM has been released. Follow the link below for more information.

Download link (Partner source login required)

Dynamics AX - UTC time to local time

2008-05-13T13:52:00.001+07:00

A problem that I encountered when doing data conversion in AX is to grab a DateTime value in SQL and convert it to local time.

I've figured out the following way, although it's probably not the smartest.

1) Get the DateTime value from SQL as a string.
In the T-SQL statement write the following:

CAST(TableName.DateFieldName AS char(30))

so that the dateTime values becomes a string.

2) The result string has a fixed length for both the 'date' and the 'time' (Notice the 'time' part doesn't include seconds). By doing string manipulation we can eventually get the 'date' and 'time' seperately.

e.g.
datePart            = strLRTrim(subStr(dateStr,1,12));
datePart            = this.trimDateStr(datePart);
timePart            = strLRTrim(substr(DateStr,13,strlen(DateStr)));
timePart            = subStr(timePart,1,strlen(timePart) - 2) +
                      ":00" +
                      substr(timePart,strlen(timePart) - 1,2);
tmpDate             = str2date(datePart,213);
tmpTime             = str2time(timePart);

3) Now that you get the UTC 'date' and UTC 'time'. The way to transform it into local date time is make use of some WINAPI methods. (Only available in DAX 4.0. However, you can copy and paste these methods into DAX 3.0 and they'll work too)

e.g.
static container dateTime2LocalTZDateTime(TransDate _date, TimeHour24 _time)
{
    Binary      systemTime;
    container   c;
;
    systemTime = WinAPI::dateTime2SystemTime(_date,_time);
    systemTime = WinAPI::systemTimeToTzSpecificLocalTime(systemTime);
    c           = [WinAPI::systemTimeToDate(systemTime),
                   WinAPI::systemTimeToTimeOfDay(systemTime)];

return c;
}

I am interest to know if there's a better way for getting the Date and Time from a dateTime field, for the way I do it here isn't ideal I'd say.

OverwriteSystemFields(boolean)

2008-05-13T11:50:00.001+07:00

I need to do some sort of manual EDI and need to assign a specific value to the system CreatedDate field. I remember about this property method but always forgot the implementation. The trick is we can't do a simple system field assignment. So I'll put it here to remind myself.

CustTable custTable;

custTable.overwriteSystemFields(true);
custTable.(fieldNum(CustTable,createdDate)) = [custom date];

custTable.insert();

What's new in Dynamics AX 2009 (a.k.a. 5.0)

2008-03-06T13:35:00.001+07:00

I haven't look at the contents there yet but look interesting.

Check it out!

Partnersource login required.

Caching and Indexes

2007-08-27T10:53:00.000+07:00

Well, today I have to trouble shoot a weird problem for my customer (Ax30SP5). The problem is like this:

A LedgerTable consists of 822 records. Using the following select statements (in a job) yield different results.

a) While select ledgerTable
{
// work...
}
[This returns 822 records]

b) While select ledgerTable
where ledgerTable.accountNum >= [something] &&
ledgerTable.accountNum <= [something]
{
// work...
}
[This would only returns 278 records]

The interesting aspect of this problem is it only fails in a certain company. Yet the data in ledgerTable is the same as in other companies. Also, there's no problem if I use other fields in the where clause.

After playing around with parameters and settings I've figured:
i) If I change the caching from Entire Table cache to another type of cache, the problem's gone but this impact the performance of the system. [The problem comes back if I change it back to Entire Table cache]
ii) I can change the "Primary index" to another index to solve the problem. [The problem actually disappear even after I change the primary index back to its original one]

During the debug process I read through some articles and other resources. While I have no logical explanation on this, it seems that there's a slight chance the client side record caching would fail. Which in turn leads to problem in record selection related to primary key. [For record cache populates itself with primary key]

P.S. Anyone who has a better idea of what's happening please kindly share it with me. Thanks in advance.

Known issues when upgrading to Dynamics AX 4.0

2007-06-22T10:11:00.000+07:00

Last updated 6/6:
Link (Require partner source access)

Tabax v0.3 is out

2007-05-23T11:02:00.000+07:00

Finally, Tabax v0.3 is out. Thanks to Max Belugin and other contributors, now we can use this awesome tools in DAX 4.0!!

Check it out.

Hot Fixes released in March 2007 for Microsoft Dynamics AX

2007-04-13T10:35:00.000+07:00

Check out the latest Hot fixes released by Dynamics AX team.

Link

You will need partner source log in to access the page.

Exporting a table (or temp table buffer) to an excel file.

2007-04-12T15:12:00.000+07:00

I've recently created a class to help export a temp table buffer to an excel file. I'd share it here for whoever interested. Cheers~

Download

Note: The code comes with no warrenty, use it at your own risk.

Dynamics AX 4.0 Trace Parser (beta) tool

2007-03-21T10:42:00.000+07:00

Just saw a post regarding a beta tracing tools for Dynamics AX 4.0 Here.

Instead of writing similar introduction, please follow the above link to find the description and links for download. [Partner source log in required to download the tool]

Customizing Infolog through SysInfoAction (by Kamal)

2007-02-01T17:14:00.000+07:00

Today I saw this very interesting article by Kamal on "Customizing Infolog through SysInfoAction":
http://casperkamal.spaces.live.com/Blog/cns!9138ED475277CD63!207.entry

Wooo....Enlightenment!!

Tabax for 4.0 follow up

2007-01-04T15:58:00.000+07:00

After taking some time looking into it, I found those missing functions were due to tabax not able to find the correct image to load. The problem is the line of code that returns the path to the [DAX path]\application\share\include now returns [DAX path]\client\share\include instead. Fair enough, I just put the images into client folder instead and the functions are back.

However, the other problem regarding tabpages switching not working properly is outta my league. Hope someone can figure it out.

Tabax for DAX 4.0

2007-01-03T16:15:00.000+07:00

Yurii has post an article on getting tabax to work on DAX 4.0. I tried it on SP1 and I had to change the security reference within assertDevelopment method also.

At this point some functions seems to be missing and the tab isn't 100% working (but close enough). It is functional but I missed many of the stuff I can do on 3.0.

It'd be nice if it's fully compatible with 4.0 in the future.

AxCreateNewProject

2006-12-07T16:45:00.000+07:00

There's this nifty little tool that "creates a Shared/Private project with selected project nodes and opens it in a new window." I downloaded it and it runs well on DAX 3.0. However, it needed slight modification to run on 4.0.

Now you can find the original and the modified version for 4.0 on: http://www.axaptapedia.com/AxCreateNewProject#AxCreateNewProject

My new blog

2006-12-06T23:31:00.000+07:00

Greetings~ This would be the place for me to place my 2cents. Mainly on Dynamics AX (for as long as I am associating with it)