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

By Wally Carr | July 30, 2015

Going from as/400 to dynamics ax 2012: taking the good stuff with you

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

Recommended Reading:

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!