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…

0 Comments

Submit a Comment

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

Upcoming Events

august

12aug10:00 am10:30 amWhy Levridge Grain? How to Achieve Efficient and Accurate Scale Tickets

12aug12:00 pm1:00 pmThe Three Paths to Dynamics 365 Finance and Supply Chain from Dynamics AX

13aug11:00 am12:00 pmConfab with Stoneridge - Livestream - Inspire Keynote Breakdown

19aug10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

19aug12:00 pm12:30 pmThe Modern Manufacturer - Death by Safety Stock

27aug11:00 am12:00 pmConfab with Stoneridge - Livestream - Dynamics 365 2020 Wave 2 Preview

september

02sep10:00 am10:30 amThe Modern Manufacturer - Cycle Count Management

09sep10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

16sep10:00 am10:30 amThe Modern Manufacturer - Product Lifecycle Management

30sep10:00 am10:30 amThe Modern Manufacturer - Return Management

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!

X