Integrating Manufacturing Execution Systems to Microsoft Dynamics 365

Manufacturing execution systems (MES) are software programs that are used to control and track production processes in manufacturing environments. The MES software sits above the SCADA (supervisory control and data acquisition), PLCs (programmable logic controller) and sensors on the production equipment, and is thus specifically designed to receive information from these machines. These systems often house data that is very valuable to pass on to an ERP system.

At Tridea, we have encountered numerous MES systems, including Inductive Automation’s Ignition, Wonderware, and Rockwell Automation. Our clients  frequently capture in their MES systems such things as quality data related to production batches, quantities of raw materials issued to production orders, and quantities of finished product reported as finished on production orders. In many cases, this data flows electronically from the production equipment to the MES system, with no human intervention. An obvious next step is to pass that information on to Microsoft Dynamics 365.

Whereas with Microsoft Dynamics AX 2012 we typically used middleware such as SQL programs and tables to pass this information between the MES system and Dynamics AX, we are now using web services for the communication with D365. Some examples of integrations that we have built to MES systems include updates to production order statuses, recording consumption of raw materials (picklist journals) on production orders, recording report as finished journals on production orders, and updating of batch attributes. In addition to saving the time of having to manually record this data, there is a significant improvement in the accuracy of the data when it flows directly from the machinery that is performing the work or from sensors that read the data pertaining to quantity updates and / or batch attributes. One of the nice aspects of these types of integrations is that they are very repeatable, and thus become a very cost-effective solution for clients.

To learn more about how Tridea Partners can integrate MES systems to your Microsoft Dynamics 365 solution, visit or contact us at

Microsoft GP 2018 — Comprehensive Document Attachment | Tridea Partners

Welcome to the Microsoft Dynamics GP 2018 Feature of the Day Blog Series!

Learn more about the newest updates in GP 2018, beginning with the Comprehensive Document Attachment feature.

With Microsoft’s release of Dynamics GP 2018 this past December, there have been numerous new features added that improve user experience. Throughout the next several months, we will be posting a blog series in conjunction with our sister company, InterDyn BMI, highlighting the newest features that GP 2018 has to offer. Each post will contain a detailed briefing on what these enhancements are and how it can affect your business operations.

To start this series, we are looking at the Comprehensive Document Attachment feature in GP 2018. Head on over to InterDyn BMI’s post to learn more about the newest updates to this feature: Click Here

Dynamics AX – Accessing Data for Multiple Companies

Have you ever had to compare data for several companies in Microsoft Dynamics AX?

That is usually not a problem to change the company you are currently attached to. You just double-click the company on the bottom of your current work space, and change it.




This becomes more of a challenge when dealing with more than a handful of companies.

That is where the crossCompany and changeCompany keywords can be helpful.

The table DataArea stores the company Id for all companies configured in your environment. Using the crossCompany keyword, you can construct a query to retrieve all records, regardless of the company you are currently logged into. This example loops through all of the companies in the table DataArea, then calls a routine to do some work in that company.

while select crossCompany * from dataArea


info (strFmt(“%1 %2”

, dataArea.Id





In this example, I just want to know how many customer records exist in each company. This routine will use the changeCompany keyword to define the scope of work. Using this, I can run one job to interrogate all companies that are set up, or you can manually change companies and run the query in each company. You decide which is more efficient.

void showCompany(DataAreaId _dataAreaId)


CustTable   custTable;




custTable = null;

select count(RecId) from custTable;

info (strFmt(”  Company: %1, # of Customers: %2″

, _dataAreaId

, custTable.RecId





To learn more about how Tridea Partners can help you get the most out of your Microsoft Dynamics AX solution, visit or contact us at

What Life Sciences can Accomplish in the Cloud

How does moving to the cloud help achieve your goals for growth, innovation, and competitiveness, and what are some of the main outcomes of transitioning to the cloud that you might want to anticipate and plan for?

Predictive maintenance ensures the uptime, productivity, and performance of your infrastructure

For many life sciences companies, evolving legacy systems from condition based to predictive, enabled with data insights from IoT, is an important use case for cloud technologies.  Your analysis of data coming from connected devices, and the IoT, allows for improved communications with your contract manufacturers, 3rd Party Logistics providers or in-house manufacturing team.  This connectivity allows for you to anticipate and avoid poor decisions on R&D and product movements throughout the enterprise.   That intelligence enables you to keep product innovation to occur quickly and/or fulfilment of orders to be as efficient as possible.

People, trading partners and market visibility enables complete, contextual intelligence to help you meet company objectives

In life sciences, the ability to compete as a viable, relevant business depends largely on your ability to understand and control product research and supply chain. This learning offers an avenue to intelligence that overcomes the practical and conceptual boundaries of individuals, who are easily misled by their selective awareness of events and trends. Instead of acquiring the tools and building your own intelligence systems, you can take advantage of the resources available in the cloud today. When you connect your industrial assets or the complex products to the IoT, storing and processing the data in the cloud, they become available to cloud intelligence that can combine with data from your entire operation.

At that point, your insight is not limited to your individual employees. You can surround it with contextual information about R&D, material planning, training and the supply chain. If you want to cast an even wider net, you can also assess customer behaviors, market trends, and competitive threats, and correlate those findings with your R&D and product management.

Collaborative innovation opens additional revenue streams and increases team efficiency

Predictive maintenance is a great achievement that your internal and external customers will appreciate. No need to stop there. Cloud-enabled, intelligence-driven collaboration with your customers can help you understand them much better, strengthen the relationships with them, and maintain your share of their attention and spending. It can also result in product enhancements that you might eventually launch to your entire market.

Within your organization, you can rely on the performance and scalability of cloud resources to enable scientists, partners and rest of the workforce collaborate from anywhere. They can use cloud-based virtual reality modeling to work together on new formulas and products. You save the expense and disruption of business travel by your skilled innovators, and you enable them to collaborate always, not just on special occasions.

Service provider expertise lets you make more strategic use of your own IT department

If your IT department is fully occupied with the day-to-day activities of keeping applications, networks, and infrastructures running and secure, you can move most of these routines to the cloud and let your service provider handle them. Instead, you can use your in-house IT resources to perform custom development and other high-value tasks that help you move forward. Working with a strong cloud service provider, your IT team can efficiently learn the skills of development, provisioning, resource management, and security in the cloud, especially if you maintain a hybrid environment that requires integrations between on-premise and cloud computing. You can draw on your service provider’s specializations, for instance, to enable advanced intelligence, collect and process large volumes of data, or take the complexity out of working in the IoT.

Worldwide resources and networks let you grow at your own pace while being compliant

Leading cloud providers maintain advanced cloud infrastructures in global networks of data centers. They will have a data center close to your headquarters, and, when your company reaches across the globe, they can support you wherever you go. That means you can grow in the cloud at your preferred pace. If you want to take a measured, low-risk approach, you could move just one workload into the cloud – product engineering, for example – to start with, and test the new infrastructure’s performance, reliability, and analytical capabilities. You continue your cloud migration at the right time.

When you’re ready to increase the momentum, you can take advantage of cloud-based ERP and CRM resources with multi-language and multicurrency features to reach customers and markets anywhere. If you’re operating production and distribution facilities in several countries and regions, the cloud offers an efficient way to make corporate systems and information available to them and connect their processes to the entire organization.

Transform your life sciences business in the cloud

Starting now, you can act on the cloud opportunities that offer the highest benefits. Together, Tridea Partners technology and expertise, Microsoft Dynamics 365, and the analytics resources available on the Microsoft Azure cloud can make life sciences business growth in the cloud practical, fast, and affordable. Before, during, and following your move to the cloud, we help you optimize processes, increase efficiencies, and reduce costs. We offer proven, practical solutions and approaches within an affordable subscription model that eliminates distractions and lets you focus on results.

At Tridea, we help our life science customers digitally transform their businesses and improve the value realization of their business application investments. We mitigate the inherent risks associated with implementing, upgrading and replacing legacy ERP systems. We lead our life science customers with best-practice consulting services we have refined over thousands of engagements. We take care of our customers and aspire to keep them for life.

To learn more about how Tridea can help you get the most out of your Microsoft solutions, visit  or contact us at

CFO’s often ask “Why should I renew my Microsoft ERP’s Maintenance Plan”?

The answer is twofold – 1) There’s tremendous value associated with being on a current Maintenance plan and 2) there’s a significant downside to not renewing in a timely manner.

  • You maximize the solution value with ongoing Microsoft Dynamics product improvements.If your Maintenance Plan is current, you are entitled to new software upgrades, updates, product fixes, and service packs.  Microsoft often improves or adds functionality with new releases of the software.  These all enable your business to be up-to-date with Microsoft’s innovations.  If your plan is not current, you will miss out on these innovations.
  • You protect your Investment. Stay current on maintenance and your maintenance costs will be based upon the protected system list price (the initial cost of your system).  It’s useful to have a predictable cost to plan for…
  • You retain access to CustomerSource.CustomerSource is a large knowledge database supplied and maintained by Microsoft, and can be used to get essential information such as technical support, product updates and downloads, training, events, and provide access to community forums. It available 24/7. Many of our clients use CustomerSource to aid them as they configure or troubleshot issues that arise occasionally. This saves the client time and cost when they can perform the work themselves. 


Important NoteIf your organization decides to let the Maintenance Plan lapse, you will be no longer entitled to any of the services listed above. In addition you will not being able to purchase new modules or user licenses. It’s possible to re-institute a Maintenance Plan, but please be advised that Microsoft does charge a penalty.  We highly recommend that you stay current on your Maintenance Plan.