Archive

Archive for April, 2012

Improve Controls with Purchase Order Approvals in Microsoft Dynamics AX 2012

April 23rd, 2012 Sandeep Walia No comments

As a matter of financial compliance, organizations should use Purchase Orders for all of their purchasing over a certain minimal limit. This builds a level of financial control in the organization as Purchase Orders do two things

  1. Ensure there is approval of a purchase before it is triggered.
  2. Ensure that the vendor does not invoice more than the limit that Purchase Order sets plus any tolerance limit

Organizations that don’t use Purchase Orders run the risk of fraud as well as risk runaway spending that may never be caught or caught after it is too late. Dynamics AX 2012 is built so that organizations can use the purchase order functionality as a tool of financial control as well as vendor compliance. In this article we will focus on the financial control element on it and in a subsequent blog article, I will focus on the vendor compliance aspect of purchasing.

The control is ensured by the powerful purchase order (PO) approval process built into Microsoft Dynamics AX 2012. For example, an organization may put the following rules in place for financial controls

  • PO below $100 don’t require any approval
  • PO above $100 and less than $1,000 require approval from a Sr. Manager
  • PO above $1,000 and less than $10,000 require approval from Sr. Manager AND a Vice President.
  • PO above $10,000 and less than $100,000 require 3 approvers including one Sr. Manager and two Vice Presidents
  • PO above $100,000 requires 3 approvers including one Sr. Manager, one Vice President and the CEO.

While this would be a fairly logical scenario, most ERP systems in the market can’t support this scenario because of product limitations or outdated technology. Many ERP systems don’t support Purchase Order approval at all or require significant customization and corresponding cost to implement this. In those scenarios approvals are often done outside of the system via email or some offline mechanism which don’t have an approval audit trail. Microsoft Dynamics AX 2012 is able to support this scenario natively with just configuration of the system. The building blocks to this functionality are two elements

  • Purchase Order entity in Dynamics AX
  • Powerful workflow toolset

The Purchase Order has multiple approval status fields to allow for financial controls.

Draft – The initial state for purchase orders and change requests – the PO has not been submitted for approval

In review – The purchase request has been submitted for approval and is processed within an approval workflow. There may be multiple approvers required. Till all of them approve it, the Purchase Order approval status will remain In Review. However, the workflow history on a PO can show who has approved it so far

Approved – The purchase order has passed the approval process and can now be issued to the vendor.

Rejected – The purchase request has been rejected by an approver.

Confirmed –The Purchase Order is sent to the vendor. In Dynamics AX you can specific the preferred format that a vendor prefers to receive a PO. Some vendors may like it emailed, while others may want it faxed and another may want it emailed and paper mailed. Dynamics AX allows for unique settings at a vendor level and also allows for duplicate copies e.g. one copy via paper and one via email.

Finalized – All lines on the PO have been received and invoice or are either canceled to reach this state. No changes can be applied after this point.

Purchase Order Approval Stages in Dynamics AX

Purchase Order Approval Stages in Dynamics AX

The screen shot below shows different Purchase Orders in different Approval Status. The first one PO# 406 is Finalized and Invoiced – which means no changes can be made to this. The next four (407 to 410) are Approved Open Purchase Orders. That means they have been submitted and approved but not yet been sent to the Vendor. The next three (411 to 414) on the list have gone to the next stage where they have been confirmed i.e. transmitted to the vendor and have also been invoiced by the vendor.

Purchase Orders with different approval status in Dynamics AX

Purchase Orders with different approval status in Dynamics AX

So how does one actually make these complex approval rules a simple configuration in Dynamics AX. The backbone of that is the powerful workflow functionality in Microsoft Dynamics AX. The workflow editor in Dynamics AX is built on modern architecture and offers drag and drop capability with the ability to build If/then conditions, checks, actions and delegation very easily without any programming effort. The Dynamics AX workflow engine offers rich functionality including the ability to have multiple rules through line items, Actions or Tasks that someone needs to do e.g. an approval with supporting notifications, escalation in case a person does not respond in a certain time frame for a task e.g. if a person does not approve a PO in 48 hours it can automatically be escalated to his manager; delegation where someone who is going to be out of the office can delegate tasks and approvals assigned to him/her to someone else. The workflow engine also allows for multiple workflows to be tied together by the use of sub-workflows.

Dynamics AX workflow engine provides functionality for approvals, task assignments, delegations, escalations and the ability to have multiple sub-workflows

Dynamics AX workflow engine provides functionality for approvals, task assignments, delegations, escalations and the ability to have multiple sub-workflows

A screen shot of the workflow editor in Dynamics AX is shown below reference. In this example, a condition is added to be checked for every PO as to whether it is more than $500. If it is more than $500 then an approval request is sent out.

Conditional workflow example in Dynamics AX 2012 for Purchase Order approvals

Conditional workflow example in Dynamics AX 2012 for Purchase Order approvals

If you are looking to improve financial controls or streamline your business processes with an ERP implementation or upgrade, please email us at dynamics@ignify.com.

Sandeep Walia is CEO of Ignify. Ignify is a leading provider of Microsoft Dynamics ERP solutions to mid-market and Enterprise businesses. Ignify has been ranked as Microsoft Partner of the Year Winner in 2011 and 2010 and in the Microsoft Dynamics Inner Circle, Microsoft Dynamics Presidents Club in 2009. Ignify has offices and team members in Southern California, Northern California, Arizona, Tennessee, Illinois, Washington, Canada, Singapore, Malaysia, India, Philippines.

Supply Chain Management Buyer’s Guide by Technology Evaluation Centers features Microsoft Dynamics AX

April 5th, 2012 Ashley Harbaugh No comments

The Technology Evaluation Center (TEC) released its annual Supply Chain Management Buyer’s Guide, and Microsoft Dynamics AX is one of the solutions cited as a crucial supply chain management tool.  One of the case studies showing the benefits of Microsoft Dynamics AX is an Ignify customer – BIDZ.com.

BIDZ.com is a publicly listed retailer that specializes in jewelry, fine art, collectibles, and accessories sold through on online auction format, offering products from leading brands such as Gucci, Chanel, Disney, Rolex. Providing its customers quality products as well as complete control over the purchasing process are hallmarks of the company and its two divisions, BUYZ.com and Modnique.com. BUYZ.com is an online jewelry store, and Modnique.com is a store that offers special discounts and sales on designer clothing and accessories.

With its previous ERP software limiting the company’s business directions, BIDZ wanted a solution that offered complete management over all the company’s data and processes—from accounting, to inventory data, to warehouse data, and so on. BIDZ needed an enterprise software solution that offered flexibility to launch new lines of business as well as provide integrated functionality for sales, purchasing, inventory, warehouse, and financial management. 

The enterprise software also needed to be flexible to work with its unconventional business model, with very different selling formats across three unique divisions—BIDZ.com, BUYZ.com, and Modnique.com. In addition, BIDZ needed a system that could integrate with its online sites and handle a high volume of orders from inventory that changed very frequently.

With three different online stores operating on different models, the rich functionality of Microsoft Dynamics AX offers complete organization and in-depth reporting of each BIDZ entity’s business processes. BIDZ selected Microsoft Dynamics AX due its flexibility, superior technical architecture, deep integrated functionality, ability to easily integrate with its online sites, and ability to scale to handle its large volume of transactions. Microsoft Dynamics AX provided BIDZ with a complete solution that streamlined sales and purchasing processes, as well as a single consolidated database that containing all information in one place. The flexible platform of Microsoft Dynamics AX also strengthens the company’s business growth and development by supporting many unique customizations and adaptations.

The case study delves into the specifics of how BIDZ operates with Microsoft Dynamics AX, the tangible benefits the company receives from using the system, and the ways in which Microsoft Dynamics AX gives customers a superior shopping experience across all of the BIDZ entities. With this solution streamlining the sales and purchasing process across its unique business models, BIDZ has the solid foundation for future business expansion and is able to optimize valuable resources and time.  

Feel free to download the Buyer’s Guide here. And if you have any questions, please don’t hesitate to contact dynamics@ignify.com

Ashley Harbaugh is a Product Marketing Specialist at Ignify. Ignify is a technology provider of CRM, eCommerce and ERP, software solutions to businesses and public sector organizations. Ignify has been included as the fastest growing business in North America for 5 years in a row by Deloitte, Inc Magazine and Entrepreneur Magazine and ranked as one of 100 most innovative companies in the world in the Red Herring Global 100 in 2011.