We’ve all seen it many times in our projects.. Being under pressure to close these last P1 and P2 bugs by making some quick config changes in UAT, we forget to keep a record of what we did and to bring this into our Golden Config environment. And then, after cutover to Production, our users are confronted with the same issues as before.. How great would it be if we can prevent this with an extra ‘lock on the door’? More
Business processes and interfaces often go hand in hand: it’s often either a business event triggering an interface or a business event following up on incoming interface data. For example: automatically creating pick orders and updating the related order statuses in the E-commerce frontend. In our aim for maximum comfort for both the business user as well as the system administrator, how can we automate this type of business events and interfaces in a combined way?
In this blog post I’ll boil the necessary standard AX ingredients into a configuration which allows you to reach this goal. I’ll also show you how to leverage this configuration to completely automate the following example flows:
- Flow 1: importing transactions from a (3rd party) sales channel, converting the transactions to sales orders and sending an acknowledgement to the channel that the order import was successful or unsuccessful.
- Flow 2: updating the on hand stock for the different channels and sending the stock levels to the sales channels.
- Flow 3: creating picking lists for the incoming orders and informing the sales channel on the ‘picking’ status.
When you have this running, it’s like simulating a factory with Lego: when your order pickers come in in the morning they’ll find the picking lists on the printer; the sales channels can work with the latest stock levels and order statuses and by leveraging role center your system administrator sits in his control room waiting for any exception to occur which requires intervention – Sounds almost like a real factory… right?
Patrick Mouwen | | AX - Functional, AX - Process, AX - Technical - INT | Automate, Automation., AX, AX for Retail, Batch framework, Batch job, Batch task, CDX, Commerce Data Exchange, Dynamics AX, Integration, Interface, Microsoft, Patrick Mouwen, Point-of-sale, POS, Process, Retail, Solution architect, webshop | 0 Comments
Say we have non-Retail B2B sales and B2C weborders in 1 company. We sell the same items through these channels. We expect the financial dimension values for the same financial dimensions to appear on our order lines but… they differ between these scenarios… HUH?And at invoicing we get stuck (posting is cancelled) as in the B2C scenario we miss a mandatory financial dimension value CostCenter… ARGGGGG!
Patrick Mouwen | | AX - Functional, AX - Technical - DEV | AX, AX for Retail, Dynamics AX, E-commerce, Finance, Financial dimension, header, Inheritance, line, Microsoft, order, Patrick Mouwen, Point-of-sale, Retail, sales order, Solution architect, web order, webshop | 0 Comments
With the ongoing hunt for implementing ‘omnichannel strategies’ by Retail companies and the booming Microsoft Dynamics AX market, there must be a huge demand for integrating Microsoft Dynamics AX Retail with 3rd party POS and 3rd party E-commerce platforms. But when I google the internet for keywords like “AX 2012”, “Integration”, “3rd party”, “POS” and “E-commerce”, there are not too many hits. And if I find any hits, discussions quickly seem to head for the same solution: AIF (Application Integration Framework).
In my vision leveraging AIF in the Dynamics AX Retail area is a missed opportunity. To prove this and to provide more information regarding Dynamics AX Retail/3rd party integration in general, I’ve decided to write a series of blogs regarding this topic. In this blog post you can find the solution which I’ve recently implemented for a globally operating Retailer based on: Standard AX Retail CDX (Commerce Data Exchange). Here’s a picture of the entire architecture as described in the blog.
Patrick Mouwen | | AX - Functional, AX - Technical - INT | 3rd party, AX, AX for Retail, CDX, Commerce Data Exchange, Dynamics 365, Dynamics AX, E-commerce, Integration, Interface, Microsoft, Patrick Mouwen, Point-of-sale, POS, Retail, Solution architect, webshop | 0 Comments
So here’s the challenge… we have Retail CDX up-and-running… how do we hook up any middleware to integrate with 3rd party POS systems, E-commerce and other sales channels?
Hmmm… let me add one nuance here which we might overlook: how do we hook up middleware without touching the integrity of Retail CDX?
In order to answer this question I think it’s good to shortly refresh our minds about Retail CDX. Then we’ll take a look at my solution for both the batch processing as well as transactional types of interfacing.
Patrick Mouwen | | AX - Technical - INT | 3rd party, AX, AX for Retail, BizTalk, CDX, Commerce Data Exchange, Dynamics 365, Dynamics AX, E-commerce, Integration, Interface, Microsoft, Patrick Mouwen, Point-of-sale, POS, Retail, Solution architect, webshop | 1 Comment
In my main blog post regarding Dynamics AX Retail 3rd party sales channel integration I presented the mechanism to trigger BizTalk to take action after an AX scheduler job run. In this blog I’ll provide some more details on this particular topic. Let me first explain how the change tracking mechanism is leveraged on AX HQ side and let’s then take a closer look on how change tracking can be leveraged on the channel database and Async client database for use by middleware like Microsoft BizTalk.
Patrick Mouwen | | AX - Technical - INT | 3rd party, AX, AX for Retail, BizTalk, CDX, Commerce Data Exchange, Dynamics AX, E-commerce, Integration, Interface, Microsoft, middleware, Patrick Mouwen, Point-of-sale, POS, Retail, Solution architect, SQL, Trigger, webshop | 0 Comments
In my main blog post regarding Dynamics AX Retail/3rd party integration I mentioned leveraging Real Time Service to allow middleware (like Microsoft BizTalk) and 3rd party systems to report to AX on the results of their actions. As the meta data is written into the standard Dynamics AX Retail download sessions and upload sessions forms, these forms will now serve system administrators to have visibility and control even beyond their the Dynamics AX Retail CDX landscape (CDX -> see rectangle in the middle, beyond CDX -> bottom rectangle):
Patrick Mouwen | | AX - Technical - DEV, AX - Technical - INT | 3rd party, AX, AX for Retail, CDX, Commerce Data Exchange, control, dashboard, Dynamics AX, E-commerce, Integration, Interface, maintenance, Microsoft, monitoring, Patrick Mouwen, Point-of-sale, POS, Retail, Solution architect, webshop | 7 Comments
Some people hate it.. some people cherish it as a means to eternalize their brilliant designs… DOCUMENTING. One way or the other, in the bigger projects you can easily fill up a local library with all the paper produced. That’s why a good solution design is crucial in these projects. If such a design covers 1 system like AX, it’s easier to come to a holistic view on the desired solution. But what if your solution spans across multiple systems, all requiring some installation, configuration and customization. How do you keep the overview without getting lost in the details? For this situation your solution design needs an extra helper: the UML sequence diagram:
Patrick Mouwen | | AX - Methodology | AX, AX for Retail, documentation, Dynamics AX, E-commerce, Integration, Interface, methodology, Microsoft, Patrick Mouwen, Point-of-sale, POS, project management, Retail, template, UML, UML sequence diagram, webshop | 0 Comments