Going from AS/400 to Dynamics AX 2012: Taking the Good Stuff With You

by | Updated August 15, 2016 | Dynamics AX, General Technology, Manufacturing

This is the story of how a custom application made the transition from an AS/400 to Dynamics AX 2012. I had the honor of working for 12 years at a place I will call the Happy Spaniel Company. (The owner’s dogs liked me…) The company was running Infor/BPCS 8.2 on the IBM AS/400. I was on an IT team with some really sharp developers, former employees of the (now defunct) company that wrote the package. As time went on, we developed some very effective custom applications, both native green-screen and interactive .net code. All the applications in question used the DB2 database. Here’s the story on how you can take the good stuff with you.

Happy Spaniel is basically in the “goop” business. Filled materials, or dielectric insulators, if you want to be picky. When cured and applied, these materials keep electricity in place while moving heat. It’s great for making integrated circuits. The goop is web-coated onto a flexible substrate, and sold by rolls, sheets, and custom-stamped parts to cool components on circuit boards. Oh, and sometimes the goop (dispersion) is just squirted onto the board during assembly. The dispersion itself is mixed in discrete batches, each with its own identifier. Each batch is tested, with different tests based upon the formulation. While the web-coating is going on, the operators take samples at prescribed footages and or time intervals to make sure the coating run is going well. Each batch of dispersion, substrate, and liner that is fed into the run is tracked by when it is started and finished.

The application that takes the interval measurements and records new barrels of goop started life as a MS-Access database written by an engineer. The database had a fixed vocabulary of tests that could be recorded for each unique coating machine. When new tests were needed, the results were simply added to the comments. Company legend cited an engineering tech who could actually get meaningful reports from the database. They say he took the job seeking a challenge – finding Jimmy Hoffa was too easy. At last report his doctor is very optimistic of a full recovery in time.

Metamorphosis provided by the Visual Studio and .Net saw the database become a C# butterfly with a SQL-based interface to DB2. We added tables to BPCS to join a measurement to an operation on a router.  As Production orders were created, the type and frequencies of samples were called out by the tests attached to the router step. This created the test plan for each order.  Results were captured in another set of relational tables while issues to the order and receipts from the order were automatically entered into BPCS from the application, known as IP (In Process) Capture. Sample data was then available for customer reporting.

Going from AS/400 to Dynamics AX 2012
When Happy Spaniel began to implement Dynamics AX 2012 R2, we decided to bring the Coater IP along.  There were a number of changes to make:

  • Communication to and from the ERP system changed from RPG with embedded SQL to Query Services using the AIF:
    • Logic to detect Batch orders that had a coating operation and create/maintain the test plan for that order.
    • Logic to update journal entries for inventory transactions.
  • The IP Capture database was moved from DB2 to SQL server. This contains the test plans per coating operation per product, as well as historical results.
  • Changes to the IP Capture interface to accommodate the differences between BPCS and Dynamics AX.

Going from AS/400 to Dynamcis AX 2012
The process was a good deal more detailed, of course, and messier than the nice neat diagrams above. The most interesting point to me was the way a well-designed C# application could be reused between ERP systems, even ones as different as Dynamics AX and BPCS. The first enabling factor was a good object-oriented design in the original IP Capture. The second was the power and flexibility built into the AIF.

Credits and kudos: Thanks for the memories and discoveries to the “Happy Spaniel” folks, especially to John M. and Chad A., who built the code, and to Adam S., the long suffering SME from Engineering.


Related Posts

  • Support for manufacturing in Dynamics AX 2012 rests upon several key concepts: Bill of Materials (BOM): The BOM for an item contains every item and service which is valuable enough…

  • The Safari browser is now supported natively on Dynamics AX 2012 R2 as well as being supported on Dynamics AX RTM with a hotfix.  Taken from the updated System Requirements…

  • I put together some certification information on the requirements for Microsoft Dynamics AX 2012 and a proposed training roadmap to get to each of the core certifications.  Rather than have this…


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Managing Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Management: Introduction of NEW Functionality for Manufacturers Using Dynamics 365


11nov10:00 am10:30 amThe Modern Manufacturer - Tears and Trauma of MRP

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!