SQL Quick tip - OpenQuery

Alright, it's been a while since I had to do this, but just in case. If you are in an implementation and you happen to be moving data from Oracle or and AS/400 and want to query the tables and views, first:

• Take and create a linked Server, with the correct provider to the database.


• Make sure to make use of the openquery syntax

The syntax for openquery goes: select * from openquery(Linked_Server,'Select Statement')

This will save a lot of pain, and allow the other server to handle servering up table attributes, data types and the likes that will cause issues if you try a standard linked server, FQN statement. :-)

Check back soon!

Find a job at: www.DynamicsAXJobs.com

DAXguy - DAX and the .Net CLR

DAXGuy over at Link did a great write up on Dynamics AX and the .Net CLR interoperation and concept. You can check out the article here: Dynamics AX - CLR interop

What I want to point out is that this is an integration / interoperation between Dynamics AX and .Net. Right now in the current version Dynamics AX is .Net 'aware' but is not a native .net application or framework. In the future, and this is the important part, this will not be the case. In future releases, Dynamics AX will be more and more wrote in .Net and those that develop in X++ will do so from Visual Studio.

I think this is a great move, and support this. There are some questions in my mind for how the data model will be handeled, but I don't think the simplistic way that X++ allows data manipulation of it's managed tables will go away. So thanks DAXGuy for the great post!

Check back soon!

Find a job at: www.DynamicsAXJobs.com

ERPSolutions.biz - Total Quality Control Management

Well I wanted to take the time and talk a bit about the Dynamics AX 4.0 Total Quality Control Management add-on from ERPSolutions.biz.. We have actually had the chance to implement this a few times now and it really brings Quality Control into Dynamics AX. There are other packages that can possible get some of what is offered from this add-on, but now as much and the user friendly detail that ERPSolutions.biz delivers.

Check out the site here: ERPSolutions.biz TQCM Add-on

From the site:
"Total Quality Control Management is a flexible solution that establishes quality control standards for your products and processes. Control and manage corrective actions and non-conforming materials, select items or operations for incoming inspections, react to customer complaints and implement preventative measures. With Total Quality Control Management you have a complete tool set to improve the quality of your products and to serve your customers better."

And the Key features info [Link]:

• Sample lot Testing with Acceptable Quality Levels (AQL)


• Set inventory specific items to mandatory inspection


• Set inspections for internally manufactured and/or purchased items


• Create corrective actions for vendor items, customer items, and internal production items


• 8D Corrective Actions


• Create and manage non-conforming materials and items


• Create and maintain non-conformance reports


• Create quality verifications for in process manufacturing


• Association between corrective actions and non-conformance


• Complete equipment calibration and certified reporting processing


• Create and maintain quality and ISO Standard Order Procedures (SOP)


• Email notifications


• Standard reports included


• Ad-hoc reporting capabilities


• Fully integrated and built for Microsoft Business Solution Axapta


• Integration to other Axapta Series

Make sure to take the time and check this out, and if the need arises Sunrise Technologies, Inc. is an authorized solution provider for Dynamics AX and offers now ERPSolutions.biz TQCM Add-on!

Check back soon!

Find a job at: www.DynamicsAXJobs.com

Office SharePoint Designer - Information Worker bliss!

When you think SharePoint, and sites today, you think of a possible long setup process, customizing pages, and fitting things together. The future though is not the most technical aspects, or should I say the code, but the designer of SharePoint itself.

What I mean by this is the new offering of SharePoint Designer with Office 2007 system. Bye-bye we say to FrontPage, and hello SharePoint Designer to take it's place. The goal with this is going to allow Information Workers, or super users to easily create the flows, and collabration sites needed by them, and managed by their IT dept. The future I see here, is the front UI for most information worker processes inside Dynamics AX today!

With this I see custom web parts for achieveing business goals, and out of the box ones as well, that then allow an information worker to talior their SharePoint site experince, targeted for their usage of the business logic, in a mashup of Dynamics AX web parts, Office System documents, and Software + Services offerings. The goal would be to allow the information worker, if they so choose, the abilities to better manage their flows. It makes sense, seeing they own and work the flows everyday right? This would then free up with IT dept. to focus on the next thing, and development of core business logic, vs. UI flows, and interactions. I really see a great deal of things that can be accomplished in the future with SharePoint, SharePoint Designer and the future releases of Dynamics AX.

For now, though, I would recommend looking more and more into the use of SharePoint 2007 and the entire Office 2007 system all together interacting with Dynamics AX as is. It's a bright future, and all kinds of possibilities!

Check back soon!

Link to Office SharePoint Designer Product page

Find a job at: www.DynamicsAXJobs.com

First day of AXUG 2007!

Today is the first day of AXUG 2007 in Orlando, FL! Sunrise Technologies, Inc. [Sunrise Website] is a Platinum level Sponsor. Check out who is sponsoring and at what level here: AXUG Sponsors Link

Sunrise will be presenting the different aspects of Dynamics AX, along with showcasing or industry experts, as well as our new Dynamics AX Add-on offerings. This years summit is set to be the biggest in AXUG history, and I hate I will be missing. I am there in spirit though for all those who are attending! Make sure to go by and talk with Heather Essic and Mike Pereria from Sunrise to ask all your questions too.

Well check back soon as I pick up more technically related post, DAX 5.0, and some in depth X++!


Find a job at: www.DynamicsAXJobs.com

Sunrise Dynamics AX Add-ons

Well I wanted to take and post the week some more exciting news from Sunrise Technologies, Inc. [Sunrise Website]. Offically we are now offering Dynamics AX value adding software, that is geared towards the following topics:

- Textile-Apparel-Footwear Solution
- Advanced Warehouse Management
- StarShip Integration
- Bartender Integration
- Vertex O Series Integration

This really respresents a new ERA for integration, warehouse management, and solutions that target the TAF vertical. The integrations and warehouse management can be used and applied to any type of vertical, and the TAF template, or Solution is targeted towards helping Textile, Apparel & Footwear companies get the most out of thier Dynamics AX install base.

For me I am very excited to see this, and see that we are now offically offering this to the public and other partners. Sunrise will be showcasing these Add-ons at the AXUG meeting this month. You can use the links above to find out more about each, and download the brochure for each. Also feel free to use the contact form located here: [Contact Us!] To get in touch with a Sunrise Rep. for further information.

Way to go Sunrise! Check back soon!
Find a job at: www.DynamicsAXJobs.com

Sunrise Technologies, Inc. Reconized... Again!

Well Sunrise Technologies, Inc., [www.sunriseconsult.com] the wonderful VAR that I am a part of has been reconized again, and this time as one of the Top 50 Fastest growing companies in the Triad Area of Winston-Salem, NC.

You can see the full press release here: Sunrise Top 50 Press Release

Congrats to all my fellow Sunrisers!

Check back soon!

Find a job at: www.DynamicsAXJobs.com

Working on Third year of posting!

Well I am entering my third year of posting on this blog about Dynamics AX. When I started it was called Axapta. Man a lot as happened with the landscape of Dynamics AX so far, and I am very excited to continue to learn, work, and share about the Dynamics platform.

I want to thank everyone who reads this blog. I hope that I have been able to post about get topics, that are interesting and share in the growth of the Dynamics AX community. I love to write, and this has been a nice outlet for me that mixes both my technical and writing desires. I am really looking forward to this up coming year, with 5.0 coming out, SQL Server 2008, and Visual Studio 2008. Also the Office 2007 system, that includes PerformancePoint Server for BI. Truly an exciting year!

Well like I said above, I hope that the content found here helps build up the wonderful commuity we all live in on the web!

Check back soon!

P.S. Just for connecting the circle, I have links below to the following years post around this time. Interesting to see what was being posted about back then, and compare to now:

2005:
Ax 3.0 COM Connector Post

2006:
DAX 4.0 Test Projects Post


Find a job at: www.DynamicsAXJobs.com