Number Sequence Formatting

When using a format such as PO#####_XXX, I am told by MicroSoft that AX v.3 will accept this with no issues. However, MS says that v.4 has a technical change in the database and such a format will slow down performance. MS now recommends that the number sequence not use a prefix such as PO##### ... although the delivered product still has some number sequences with such prefixes. MS recommends that if a more easily identifiable number sequence is used then a suffix be used ... such as #####_PO2007, etc.

Lean Manufacturing In AX

I always wondered that will Microsoft incorporate Lean Manufacturing in Dynamics AX. After some look around i found the answer. A company named eBECS, a Microsoft Gold Partner developed the Lean Manufacturing module and Microsoft has acquired this module as announced by eBECS on March 13th, 2007.

http://www.ebecs.com/LeanAcquired.aspx

Lean Software Development

I am a big fan of Lean philosophy and happy to know that this particular strategy is strengthening its roots in software development as well. Below are some links from where you can get a good understanding of what Lean philosophy is and how it can improve the software development process.

http://xpday3.xpday.org/slides/LeanTutorial.pdf
http://codebetter.com/blogs/darrell.norton/pages/50341.aspx

And there is a very great work done by Mary Poppendieck on Lean Software Development in her book 'Lean Software Development : An Agile Toolkit' available on Amazon.

AX and RSS

Dear Readers,

Availability of business data is crucial along with data itself. Axapta currently lacks with the facility to use RSS to present data on demand on the web. These days i am trying to work on this integration and i hope that probably i will get some success once i complete this research. Idea is Microsoft AX provides a secure, central data collection, storage, and modification tool for business data while RSS provides the transport mechanism to use this data on internet.

Useful Reports in AP and AR

Someone from another blog asked me where to get the following reports in AX:

• AP>Reports>Status>Accrued Purchases
• AR>Reports>Status>Shipped not Invoiced

I looked for the solution and came across the fact that these two and some other reports are linked with a configuration key named 'Multiple countries/regions' under Administration>System>Configuration>Country/region-specific features.

So if you select this configuration key, you would be able to view these reports. I am not sure why MS linked these reports with this particular configuration key but atleast we know where to get these reports from.

Company Exchange Rates

As we know that in Axapta we can modify exchange rates for a company's default currency by navigating through General Ledger>Setup>Exchange rates. An important point which i think as a limitation of this process is one has to do it manually everytime he has to change the exchange rates and there is no way to get the latest exchange rates from an online resource for this purpose. It means that one has to keep track of the exhange market whenever a change is required in the exchange rates.

First is it a good idea to use an online resource (using web services) for this purpose and if yes then is MS going to tackle this issue in later version of AX? Let's wait for the next version!!!!

Sample project in AX

Dear All,

While trying to evaluate the Dynamics AX for the first time, i developed a small project called 'Automotive Research System'. In this project i particularly explored the ways to integrate Dynamics AX with MS Excel. Now i am willing to take this project to web by integrating it with MOSS and web services.

An .xpo of this project can be found on:

http://www.savefile.com/files/1043971

Regards

Microsoft Axapta Localisation Issues

Hi Guys,

I just come across with a problem while i was looking at the date data SQL Server stores in the database. The SQL Server puts a time component (default value = 00:00:000) alongwith date data. This time component is not GMT and so i am not able to synchronize time between two different regions in Axapta. Idea is that MS should either modify the existing Date data type or add a new data type to make it GMT effective.

Hope that i makes sense!

Regards

Welcome

Dear All,

I welcome you all to visit my Blog which i have created particularly for MS Dynamics AX.


Enjoy!