Sunday, June 13, 2010

Workflow, BPM, ERP and ERP Workflow Integration

The aim of an ERP system is to provide an integrated solution to all business areas of a particular enterprise. Ideally, you have one software system that the entire company can access and work with. So, for example, all the data for finance, sales, accounting, human resources and inventory is managed in one central repository and each business group within the organization accesses only the subset of data that they need.

Workflow as a concept is nothing new. Even before the era of computers, there have always been established procedures for handling operations within a corporate structure. Take a purchase order, for example: an employee notifies their manager that they require a particular item; the manager then puts in a requisition, which, depending on his level of authority, may need to be bumped further up the management chain until it is authorized; it is then handed over to the purchasing coordinator and finally purchased. The workflow can be relatively straightforward or very complex, but it is basically a business process that consists of a number of sequential tasks performed in a particular order or following a set of rules that is designed to facilitate a particular objective. Examples of processes for which workflows are commonly in place include order processing and fulfillment, sales cycle and campaign management, performance reviews, medical/insurance claims processing, expense reporting, warranty management, invoice processing and more.

The ERP workflow can be part of the larger concept of Business Process Management (BPM), which is a more holistic approach to business processes. Companies that employ BPM aim to optimize their business processes while striving to be more efficient, more effective, and improve the level of tracking and control built into their processes as a whole.

BPM and workflow implementation force companies to sit down and evaluate their processes and the rationale behind them: what is the flow of a particular task (e.g. draft -> ready -> financial approval -> final authorization -> sent to vendor), what possible scenarios exist, what rules need to be applied at each stage of the process (e.g., a purchase order cannot be moved from a status of "cancelled" to "sent to vendor" or any order over $10,000 needs another level of authorization), who is involved at each stage and what level of authority should they be granted. Creating a detailed blueprint of business processes, streamlining and regulating the workflow facilitates a greater degree of control; enhanced ability to respond to any potential issues; and increased efficiency, accountability and transparency for continued auditing and analysis of the process.

In many of the available solutions, in addition to automating the routing of documents and tasks from one person to another, email or SMS notification is employed to inform the next person in the chain of events that a document or process requires their attention. Rules can often be set so that another person in the chain is notified if a document remains at a particular status for too long (e.g. if the tracking document for an item in a repair shop remains by a certain technician at the status "in process" for more than two days, both the technician and his or her supervisor will receive automatic notification so that they can investigate the delay).

BPM and workflow functionality are increasingly a part of many ERP solutions, and it makes sense to implement such process maps and controls early in the game in order to maximize the benefits of the ERP system. Some ERP vendors offer built-in workflow functionalities, while others offer possibilities for third-party integration. If third-party solutions are employed, it's very important that the ERP and BPM/Workflow groups understand and communicate about the technology and processes that are being implemented.

Remember: workflows involve humans, and the people involved at all levels of the process should also be involved in the initial mapping out of the processes before they are implemented. While mapping out the process, you may discover new and better ways to perform tasks or provide better oversight. The defining and modeling phase is often a learning process for both employees and managers. Collaboration during the definition process can produce enhanced processes, improve performance of both the system as a whole and of individual employees, and ultimately foster a sense of "ownership" in each individual regarding his or her part in the process itself.

In conclusion and to recap, workflow and BPM systems control the flow of information between individuals or departments, and direct it to the next appropriate processing stage according to an established workflow map. A good system should enable managers to monitor the progress of a particular process within the workflow, handle exceptions, escalate individual exceptions and generate reports that can be used to improve performance. It is therefore advisable that you make BPM and workflow one of your priorities when selecting or implementing an ERP software solution.

Workflow Management Software: Businesses are Getting into the Flow

Overall, most of the daily business activities include collaboration with committees, departments, that board, or this client, in order to bring everyone onto the same page. Though collaboration is the most effective way to enable workflow, the challenge is finding workflow management software that enables effective workflow.

Drafts of budgets, sales reports, market presentations, and more, flow back and forth as fast as a mouse can click "send." The back and forth, or ebb and flow of these documents is often a challenge to manage. About two-thirds of businesses do collaborative work as a normal part of the business day, and I am sure that most of them know what I am talking about. Workflow management software is now available in a variety of workflow management software packages. In fact, if you type "workflow management software" in Google, the search yields about 8 million 120 thousand indexed pages regarding the subject. This is a reflection of the growing need for workflow management software which helps businesses track documents that are incoming and outgoing.

True, the right workflow management software will help you feel that you are standing on solid ground again, but searching through the over 8 million options available may make you feel that you are drifting out on the water again.

There are two major challenges to adopting workflow management software. First, it is often intimidating to adopt new technology. Second, it is a challenge to find workflow management software that meets your businesses needs.

These do not have to be challenges. There is a way to whittle down the 8 million options available to find one that is easy to use and meets all of your business's needs. In searching for workflow management software, most businesses are not interested in adding new IT to their technology. They simply want software that will work for them the minute it is downloaded. Search for workflow management software that does not require IT. It is easy to use and it is not at all intimidating. It is helpful to use the free demo to see exactly how the workflow management software helps you to track document workflow and to see if it is what your business is looking for.

In addition to simple workflow management software, compatible software is what studies show businesses are looking for. By compatible, I mean that businesses use email to collaborate. That means that attachments are often included. Is there workflow management software able to track documents through email and computer drives? Is there workflow management software able to work with the most common office applications? The answer to both questions is yes.

New technologies are now available in workflow management software that enables you to track documents and its changes through email, desktops, and hard drives. This technology is called Digital Thread, and it threads document versions together, tracking the who's, what's, when's, where's, and how's of documents.

Saturday, May 1, 2010

Extensible Business Reporting Language

The Christopher Cox modernization commission proposes that companies provide their financial statements to the Commission and on their corporate Web sites in interactive data format using the eXtensible Business Reporting Language (XBRL). A statement on Page 29 of the PDF states that the decision about this request becoming compulsory was to have been decided on December 15th, 2008.

XBRL was derived from the XML standard. It was developed and continues to be supported by XBRL International, a collaborative consortium of approximately 550 organizations representing many elements of the financial reporting community worldwide in more than 20 jurisdictions, national and regional.

The proposal is a significant one for Mr. Cox as he is a proponent of modernization and the use of current technology to reduce business and government expenses. His legacy will be the promotion of “interactive data” and modernization of SEC filings through the use of XBRL.

Mr Cox has decided to retire at the end of President Bush’s term. During Mr. Cox’s tenure, the regulator has convinced over 8,000 companies to use XBRL in various types of filings. Large international organizations such as Proctor and Gamble and Pepsi file with GAAP and IFRS, are using XBRL, and are on the very pro XBRL bandwagon.

About the only criticism I have about Mr. Cox’s plan is the timeline. CFOs balked at the aggressiveness of the schedule that SEC proposed. SEC wants them to aim for concrete results for 2010.

Sharing SharePoint and Unified Communications

Microsoft SharePoint is the platform for portal-based collaboration and document management/enterprise content management (ECM). The product also works tightly with Windows Workflow Foundation (WF) and Unified Communications (UC), both Microsoft technologies that will be described in detail later on. This integration provides great visibility for workflows related to documents and document libraries, and improving collaboration through the “presence” and “click to communicate” features.

Today, SharePoint is the universal portal technology for the Dynamics portfolio; for example, in Dynamics AX 2009, the AX Enterprise Portal (formerly Axapta Enterprise Portal) is now based on SharePoint. The portal was devised from the standard SharePoint design experience, whereby a gallery of Dynamics AX Web parts is now available, making it very simple to bring to the surface Dynamics AX data (with the inherent AX security model enforced) on SharePoint portal pages.

In addition to Web parts, other strategies for SharePoint integration are its Business Data Catalog (BDC) Web Services feature (currently used within Microsoft Dynamics GP [evaluate this product] and Dynamics CRM [evaluate this product]), and data binding (within Dynamics AX). It is likely that BDC services will grow further in importance, and we should expect a broad Microsoft Dynamics consistency around this feature.

The abovementioned UC technology provides the ability for applications to identify users’ “presence” and enable “click to communicate” capabilities. Via Microsoft Office Communications Server 2007, Dynamics AX 2009 and Dynamics CRM 4.0 currently work with UC (which is envisioned for the upcoming Dynamics ERP releases too). For example, whenever a user sees a person in the application screen, he/she can also see a presence indicator showing if they are “out of the office”, “in a meeting”, “on a call”, or “available”. By clicking on the indicator, a user gets to pick the preferred method to communicate with them with a single click, whether it might be via email, instant messenger (IM), or phone, if the company has the computer telephony integration (CTI) capabilities.

The Microsoft Dynamics team is working together with the UC team to develop even more advanced scenarios that bring people closer to the processes represented in their applications. One such possible scenario, “Call Center of the Future”, was showed at Convergence 2008 during Steve Ballmer’s keynote speech. Expected scenarios for the next version of UC platform will revolve around how to factor in application embedding, advanced in-context collaboration scenarios, and blending UC and business process management

Microsoft’s Underlying Platform Parts for Enterprise Applications

Innovation is now surfacing as a result of integration between the Microsoft Visual Studio.NET (VS.NET) development platform and SQL Server. Namely, there is now the ability to launch Precision Report Designer and maintain the Dynamics AX semantic models in VS.NET and to pass the data in a closed-loop manner to and from Dynamic AX logic models. These models can in turn look into the Dynamics AX database (SQL Server) via database secure views. The future development will make these currently static models dynamic for report-customization purposes.

Along similar lines will be the use of Microsoft SQL Server Analysis Services (SSAS), whereby all Dynamics role centers within the user experience (UX) project (mentioned in Part 1) will feature embedded contextual business intelligence (BI). Currently, Dynamics AX 2009 has the cube generation capability, whereby analytics perspectives have been added to the business logic model, and which can generate Data Source Views (DSV’s) and Online Analytic Processing (OLAP) cubes. The future research and development (R&D) forays will likely enable the round-trip (between VS.NET and SQL Server) advanced features that will require similar features to the abovementioned reporting tools.

As a little caveat, these native reporting and analytics features will not be automatically available to the users of the proprietary Microsoft Dynamics NAV C/Side database (about half of the install base) and Dynamics AX Oracle instances. For Dynamics NAV customers using the older C/Side database, most of them upgrade to SQL Server when they move to a new NAV version anyway, while Dynamics AX users on Oracle can access the new reporting and analytics features by adding SSRS and SSAS to their deployment. Still, Microsoft will, for the foreseeable future, honor the ongoing support for these databases alongside its SQL Server.

Wednesday, January 27, 2010

What About the Microsoft .NET Framework Parts

The situation is much less “crystal clear” when it comes to leveraging components of the Microsoft .NET Framework. Namely, on the programming and development platform side, only Microsoft Dynamics SL [evaluate this product] is leveraging Visual Basic.NET (VB.NET), one of the languages embraced by .NET. Having already abandoned the gut-wrenching route of a single code base, as noted in Part 1, Microsoft now has to live with the proprietary platforms within Dynamics GP (i.e., Dexterity) , Dynamics NAV (i.e., C/Side AL), and Dynamics AX (i.e., X++/MorphX).

But, on the upside, the abovementioned Windows WF technology, which is an application-hosted workflow orchestration engine, and with a VS.NET design experience, is much more pervasively used throughout Dynamics. WF tools are VS.NET-based tools for developers that add simplified analyst (information worker) experiences.

The technology originated in the Microsoft BizTalk Server team (to be described later on), and in a future major release of BizTalk, WF will become the orchestration engine for BizTalk. WF is used in SharePoint and within Dynamics applications (i.e., Dynamics GP 10, Dynamics AX 2009, and Dynamics CRM 4.0) as the workflow engine. A distinct feature is its Tracking Provider architectural design (Dynamics AX 2009 implements this) that allows users to capture process execution information in the same database as the transaction data.

There is the ability here to track and record data about WF instances as they execute, such as the current status of long running processes, time spent across parts of/the whole process, exception paths taken, etc. This enables an analysis like, for example, how much time or how many escalations is it taking the user to approve Purchase Orders (PO) for his/her preferred suppliers with PO’s value under US$25,000.

Furthermore, Windows Communication Foundation (WCF), formerly called Indigo and WinFX, is an application web services inter-communication framework, and can be used to access Dynamics AX 4 and 2009 business logic through web service interfaces. This provides a higher level document interface to the application for integration, complementing the .NET Business Connector which offers more granular, lower level component interfaces to the Dynamics AX business logic. Microsoft’s .NET Business Connector replaces the older Microsoft Component Object Model (COM)-based COM Business Connector.

Sharing SharePoint and Unified Communications

Microsoft SharePoint is the platform for portal-based collaboration and document management/enterprise content management (ECM). The product also works tightly with Windows Workflow Foundation (WF) and Unified Communications (UC), both Microsoft technologies that will be described in detail later on. This integration provides great visibility for workflows related to documents and document libraries, and improving collaboration through the “presence” and “click to communicate” features.

Today, SharePoint is the universal portal technology for the Dynamics portfolio; for example, in Dynamics AX 2009, the AX Enterprise Portal (formerly Axapta Enterprise Portal) is now based on SharePoint. The portal was devised from the standard SharePoint design experience, whereby a gallery of Dynamics AX Web parts is now available, making it very simple to bring to the surface Dynamics AX data (with the inherent AX security model enforced) on SharePoint portal pages.

In addition to Web parts, other strategies for SharePoint integration are its Business Data Catalog (BDC) Web Services feature (currently used within Microsoft Dynamics GP [evaluate this product] and Dynamics CRM [evaluate this product]), and data binding (within Dynamics AX). It is likely that BDC services will grow further in importance, and we should expect a broad Microsoft Dynamics consistency around this feature.

The abovementioned UC technology provides the ability for applications to identify users’ “presence” and enable “click to communicate” capabilities. Via Microsoft Office Communications Server 2007, Dynamics AX 2009 and Dynamics CRM 4.0 currently work with UC (which is envisioned for the upcoming Dynamics ERP releases too). For example, whenever a user sees a person in the application screen, he/she can also see a presence indicator showing if they are “out of the office”, “in a meeting”, “on a call”, or “available”. By clicking on the indicator, a user gets to pick the preferred method to communicate with them with a single click, whether it might be via email, instant messenger (IM), or phone, if the company has the computer telephony integration (CTI) capabilities.

The Microsoft Dynamics team is working together with the UC team to develop even more advanced scenarios that bring people closer to the processes represented in their applications. One such possible scenario, “Call Center of the Future”, was showed at Convergence 2008 during Steve Ballmer’s keynote speech. Expected scenarios for the next version of UC platform will revolve around how to factor in application embedding, advanced in-context collaboration scenarios, and blending UC and business process management (BPM).