Archive

Archive for the ‘Dynamics GP’ Category

Year end close in Dynamics GP

February 10th, 2010 Shrikant Indavar No comments

General Ledger

WHAT DOES CLOSING GENERAL LEDGER DO ?

During the year-end closing routine, all the records that will be moved are put in a temporary table before they are moved to the Account Transaction History table.

STEPS TO FOLLOW

Step 1: Complete the posting procedures and the closing procedures for other modules

Follow these steps if the General Ledger module is integrated with other modules.

  • If the General Ledger module is not integrated with other modules, skip this step.
  • Post final transactions in all the modules except the General Ledger module
  • Complete the month-end procedure and the quarter-end procedure for all the modules except the General Ledger module
  • Complete the year-end closing procedures for each module in the following order:
    • Inventory;
    • Receivables Management; and
    • Payables Management:

Step 2: Post the final adjusting entries in the General Ledger module

  • Adjusting entries include all entries that correct errors that were made when transactions were recorded.
  • Adjusting entries also include journal entries that are used to assign revenues or expenses to the period in which the revenues were earned or in which the expenses were incurred.
  • Use the Transaction Entry or Quick Journal Entry window to make adjusting entries in the General Ledger Module.
  • Make adjusting entries to allocate revenue, expenses or depreciation to the year that you are closing.

Step 3: Print an account list to verify the posting type of each account

  • The posting type determines whether an account is closed to the retained earnings account or whether an account brings a balance forward to the next fiscal year.
  • Set the posting type to Balance Sheet to bring forward the account balances.
  • Set the account balance to Profit and Loss to close to retained earnings A/c.
  • Use the Account Maintenance window to change the account posting type.
  • To Print the accounts list: Navigate To: Financial>>Reports>>Accounts>>All Accounts Report

Step 4: Close the last period of the fiscal year (Optional)

  • Use the Fiscal Periods Setup window to close any fiscal periods that are still open for the year.
  • This prevents transactions from being posted to the wrong period or year. Navigate To: Tools>>Setup>>Company>> Fiscal Periods

Step 5: Perform file maintenance on the Financial series group modules (Optional)

  • Run the check links procedure on the financial series group of modules. Navigate To: Microsoft Dynamics GP menu>>Maintenance>>Check Links

Step 6: Verify the settings in the General Ledger Setup window

  • Click on the Accounts and Transactions check box in the Maintain History area of the General Ledger Setup window to keep the historical records
    • The account history lets you print financial statements and calculated budgets from historical information.
    • The transaction history lets you print detailed historical trial balances. The transaction history also lets you view the transaction details.
  • Both the account history and the transaction history are updated during the year-end closing routine if these check boxes are selected.

Step 7: Make a backup

  • Make a backup of all company data, and then put the backup in safe permanent storage.
  • The backup gives you a permanent record of the company’s financial position at the end of the year.
  • The backup can then be restored later if it is required. Navigate To: Microsoft Dynamics GP>>Maintenance>>Backup

Step 8: Print a final Detailed Trial Balance report

  • Use the Trial Balance Report window to print a year-end Detailed Trial Balance report.
  • Navigate To: Reports>>Financial>>Trial Balance

Step 9: Print year-end financial statements

  • Print any year-end financial statements that are required. The most common financial statements include the following:
    • Balance Sheet;
    • Profit and Loss Statement;
    • Statement of Cash Flows; and
    • Statement of Retained Earnings:

Step 10: Set up a new fiscal year

  • Setup the new fiscal year by using the Fiscal Period Setup window before the year-end closing routine is performed. Navigate To: Tools>>Setup>>Company>>Fiscal Periods

Step 11: Close the fiscal year

  • To close the fiscal year, Navigate To: Financial>>Routines>>Year-End Closing
  • Specify an account in the Retained Earnings Account box

Step 12: Close all fiscal periods for all series (Note: This step is optional)

  • Use the Fiscal Periods Setup window to mark all periods for all series as closed, after the closing procedures for all modules are complete.
  • We recommend that you do this to prevent transactions from being posted from any module to any period that you closed.
  • After a period is marked as closed, transactions cannot be posted to the period unless you reopen the period. Later, if you must post a transaction to a closed period, return to the Fiscal Periods Setup window to reopen the period. Navigate To: Tools>>Setup>>Company>> Fiscal Periods

Step 13: Adjust budget figures for the New Year and print financial statements

  • Adjust budget figures by using one of the following windows:
    • Excel-Based Budgeting
    • Budget Maintenance
    • Single-Account Budget Maintenance

Step 14: Adjust budget figures for the New Year, and print financial statements

Step 15: Make a backup

  • Make a backup of all company data, and then put the backup in safe permanent storage.
  • The backup gives you a permanent record of the company’s financial position at the start of the New Year.
  • This backup can be restored later if it is required.

Payables Management

WHAT DOES CLOSING PAYABLES MANAGEMENT DO ?

  • The Payables Management procedures transfer current-year balances to last year’s balance and clear out the current-year balances.
  • There are two closing procedures for Payables Management—fiscal year and calendar year. Both the calendar and fiscal year must be closed even if only fiscal periods is being used

STEPS TO FOLLOW

Step 1: Post all transactions for the year

  • Post all transactions for the year before the year is closed.
  • If you want to enter future period transactions before you close the year, create a new batch for the future period transactions.
  • Save the future period transactions in the new batch, but do not post the new batch until after the year has been closed.

Step 2: Print the Aged Trial Balance with Options report

  • Print a paper copy of the Aged Trial Balance with Options report to keep with year-end permanent financial records.
  • Navigate To: Dynamics GP>>Purchasing>Reports>Trial Balance. In the Reports list, click Aged Trial Balance with Options

Step 3: Print the Vendor Period Analysis report

  • Print a paper copy of the Vendor Period Analysis report to keep with year-end permanent financial records. To do this, follow these steps:
  • Navigate To: Dynamics GP>Purchasing>Reports>Analysis. In the Reports list, click Period

Step 4: Make a backup that is named Pre-1099 Edits

  • Create a backup and then put the backup permanent storage.
    • The backup lets you recover data quickly if a power fluctuation or other problem occurs during the year-end closing procedure.
  • Follow the below steps to create a back up in Microsoft Dynamics GP:
  • Microsoft Dynamics GP>>Maintenance>>Backup
  • Change the path of the backup file if it is required
  • Click OK.

Note: It is recommended that you name this backup “Pre-1099 Edits” to differentiate it from other backups

Step 5: Verify the 1099 information and edit it if it is required

  • Print the 1099 Edit List. On the File menu, click Print.

Step 6: Print the 1099 statements

  • Print the 1099 Statements. Navigate To: Purchasing>>Routines>>Print 1099

Step 7: Make a backup that is named “Pre Year-End”

  • Create a backup, and then put the backup in safe, permanent storage.
  • Follow the below steps to create a back up in Microsoft Dynamics GP:
    • Microsoft Dynamics GP>>Maintenance>>Backup (Select Company name in the Company Name list)
    • Change the path of the backup file if it is required
    • Click OK.

Note: It is recommended that you name this backup “Pre-Year End” to differentiate it from other backups

Step 8: Close the year

  • Navigate To: Purchasing>>Routines>>Year-End Close
    • If you are closing both your fiscal and calendar year at the same time, click All.
    • If you are just closing your calendar year, click Calendar.
    • If you are just closing your fiscal year, click Fiscal.
  • Click to select the Print Report check box, and then click Close Year.

Step 9: Close the fiscal periods

  • Navigate To: Microsoft Dynamics GP menu>>Tools>>Setup>> Company>>Fiscal Periods
  • Click to select the Purchasing check box for the Period that you must close.

Step 10: Close the tax year

Note: This procedure should only be completed after you have completed the year-end closing procedures for all sales and purchasing modules.

  • To close the tax year, follow these steps:
    • Navigate To: Microsoft Dynamics GP menu>>Tools>>Routines>> Company>>Tax Year-End Close
    • Click to select the Close Year check box and the Print Report check box.
    • Click Process. Click ‘YES’ when you are prompted to continue with the year-end close.

Step 11: Make a backup that is named “Post Year-End”

  • Create a backup and then put the backup in safe, permanent storage.
  • Follow the below steps to create a back up in Microsoft Dynamics GP:
    • Microsoft Dynamics GP>>Maintenance>>Backup. (Select Company name in the Company Name list)
    • Change the path of the backup file if it is required
    • Click OK.

Receivables Management

WHAT DOES CLOSING RECEIVABLES MANAGEMENT DO ?

  • The Receivables Management procedures transfer current-year balances to last year’s balance and clear out the current-year balances.
  • There are two closing procedures for Receivables Management—fiscal year and calendar year. Both the calendar and fiscal year must be closed even if only fiscal periods are being used.

STEPS TO FOLLOW FOR CLOSING THE CALENDAR YEAR<

  • Use the Receivables Year-End Closing window to close the calendar year to update information that is displayed in the Customer Finance Charge Summary window. Make a backup of all company data. Navigate to: Dynamics GP>>Tools>>Routines>>Sales>>Year-End Close
  • Mark All, if the calendar year coincides with your fiscal year.
  • If the periods do not coincide, close the fiscal year separately
  • Mark Print Report to print the Year-End Closing Report when the closing process is complete.
  • Save this report to be part of the audit trail.
  • Choose Process to begin the closing process.
  • Close the fiscal periods for the Sales series using the Fiscal Periods Setup window. Navigate To: Dynamics GP>Tools>Setup>Company>Fiscal Periods Setup

STEPS FOR CLOSING THE FISCAL YEAR

  • Use the Receivables Year-End Closing window to close the fiscal year to update information that is displayed in the Customer Finance Charge Summary window. Make a backup of all company data. Navigate to: Dynamics GP>>Tools>>Routines>>Sales>>Year-End Close
  • Mark Fiscal to close the fiscal year.
  • If your calendar and fiscal years coincide, you can close them at the same time by marking All
  • Mark Print Report to print the Year-End Closing Report when the closing process is complete.
  • Save this report as this report is part of audit trail.
  • Choose Process to begin the closing process.
  • Close the fiscal periods for the Sales series using the Fiscal Periods Setup window. Navigate To: Dynamics GP>Tools>Setup>Company>Fiscal Periods Setup

STEPS FOR CLOSING THE TAX YEAR

  • Use the Tax Year-End Closing window to prepare your tax records for a new year.
  • When you close the tax year, the accumulated year-to-date tax totals in the Tax Detail Maintenance window are cleared and transferred to last year’s tax totals.
  • Separate year-to-date tax totals can then be recorded for the New Year.
  • Any tax amounts entered after closing the tax year are added to the new year-to-date total.
  • Closing a tax year affects all the tax details entered for the year. Navigate To: Dynamics GP>>Tools>>Routines>>Company>>Tax Year- End Close to open the Tax Year-End Closing window.
  • Mark Close Year as tax year cannot be closed unless the ‘close year’ option is marked.
  • Mark Print Report to print the Tax Year-End Closing Report when the closing process is complete.
  • This report shows year-to-date and last year’s tax amounts as they appeared in the Tax Detail Maintenance window before the tax year was closed.
  • Save this report as part of audit trail.
  • Choose process to begin the closing process

Inventory Series

WHAT DOES CLOSING INVENTORY SERIES DO ?

  • Closing a year transfers all summarized current-year quantity, cost and sales amounts to transaction history for the items for which you have been keeping summarized Sales History.
  • This procedure also updates the amount in each item’s Beginning Quantity field to the Quantity on Hand field at each site.

STEPS TO FOLLOW

Step 1: Post all transactions for the year

Be sure that all Invoicing, Sales Order Processing and Inventory transactions for the current year have been entered and posted before year is closed. This is important to ensure that historical information is accurate for the year being closed and year-to-date amounts are accurately stated for the New Year.

If you want to enter future-period transactions before closing the year, create a new batch with new transactions, but do not post it until after the year has been closed.

Step 2: Reconcile Inventory Quantities

Use the Reconcile Inventory Quantities window to ensure that Inventory Control data has not become damaged over the course of the year.

Navigate to: Inventory>Utilities>Reconcile

Be sure that all Invoicing, Sales Order Processing and Inventory transactions for the current year have been entered and posted before year is closed. This is important to ensure that historical information is accurate for the year being closed and year-to-date amounts are accurately stated for the New Year.

If any differences are found during the reconcile process, the quantities will be adjusted. If adjustments are made, they will be reflected on the Reconcile Report, together with any serial numbers and lot numbers that were added for the adjusted items. If you want to edit these serial numbers and lot numbers, you can use the Item Transaction Entry window to make adjustment transactions.

Navigate to: Inventory>>Transactions>> Transaction Entry

Step 3: Complete a Physical Inventory count and post any adjustments

  • Stock Calendar: Use this to set up and maintain information about when stock counts can be performed, and which days will be recounted when the system calculates suggested dates for the next stock count for a specific item-site combination.Navigate to: Tools>>Setup>>Inventory>>Stock Calendar
  • Stock Count Cycle Assignment: Use this to assign one stock count frequency to many items.Navigate to: Cards>>Inventory>>Count Cycle Assignment.
  • Stock Count Schedule: Creates a list of the specific items at a specific site that will be counted during a specific count. When you start a stock count schedule, the quantity on hand for each line in the stock count schedule is captured. Later, the actual count number quantities will be compared to the captured values to create default variance transactions. Stock Count Forms can be printed during this process. Navigate to: Transactions>>Inventory>>Stock Count Schedule
  • Stock Count Entry: Use this to enter information about the results of your stock counts. When you process a stock count, variance transactions are created. If the Auto-post Stock Count Variances check box is marked, the transactions will also be posted.Navigate to: Transactions>> Inventory>>Stock Count Entry
  • Physical Inventory Checklist: Print a Physical Inventory Checklist using the Inventory Activity Reports window and perform a physical count of your Inventory Items to verify that quantity on hand amounts are accurate for all Items.Navigate to: Inventory>>Reports>>Activity>>Inventory Activity Reports
  • Ensure no difference exists. If difference still exists, enter the necessary adjustments in the Item Transaction Entry window, and then post the transactions.

Step 4: Print additional reports:

  • Print any additional reports you will need for planning or your permanent records.
  • Generally the below reports will be good to be printed via Inventory>>Reports:
    • Stock Status Report;
    • Purchase Receipts Report;
    • Turnover Report;
    • Transaction History Report;
    • Serial Number List; and
    • Lot Number List:

Step 5 – Backup

  • Make a backup of all company data.

Step 6: Close the year:

  • Use the Fiscal Periods Setup window to close any fiscal periods that are still open for the year.Navigate to: Microsoft Dynamics GP>>Tools>>Setup>>Company>>Fiscal Periods Setup
  • Stops the user from posting to wrong period or year.
  • Ensure all transactions for the period and year for all modules before closing fiscal periods have been posted.
  • Re-open the Fiscal Periods Setup window, in case you later need to post transactions to a fiscal period you have already closed.

This post is written by Shrikant Indavar. Shrikant is a Senior Business Analyst in the Microsoft Dynamics GP Practice at Ignify. Ignify is a Global Microsoft Dynamics Inner Circle Partner specializing in Microsoft Dynamics ERP for RetailDistribution, Manufacturing and Chemicals verticals. For help on Microsoft Dynamics ERP email us at dynamics@ignify.com

Dynamics GP MACROS: LITTLE HELPER BIG ON RESULTS

February 6th, 2010 Tod Heath 1 comment

Written by Tod Heath, Senior Dynamics GP Business Analyst for Ignify

If you’re like me, there are times when you have more work than you can handle.  This is based on the fact that we are limited in what we can accomplish by our two hands and some of our tasks can be quite repetitive.  Well, what if you had the ability to recruit a ‘Little Helper’ to assist you with some of your chores and tasks?

Dynamics GP has a Little Helper ready to assist you.  All you need to do is recognize that’s he’s waiting around, hoping that you call upon him so he can feel productive.  Providing him with some simple instructions can make him happy and you more productive.  By the way, he is known as the GP Macro. 

Macros in GP are simply recordings of a series of keystrokes, mouse-clicks and mouse-movements made while performing a procedure. It’s like taking a video of a series of tasks that you want to accomplish and then being able to replay it at any time to accomplish various tasks.  Your Little Helper can be a big time saver while performing certain tasks such as Bank Transfer entries or other repetitive tasks.  Simply record the series of events up until the time you need to key in any data.  When ready, just replay the macro and you’ve saved yourself a series of keystrokes.

However, your Little Helper can really be productive by helping you import data.  Running Macros can be effective when working with these situations:

1)      Integration Manager does not support what you’re trying to import.

2)      You are using a customized or third party version of a window that might interfere with Integration Manager.

3)      You don’t want to use eConnect, Table Import, SQL or some other technical method.

4)      GP Master Records.

5)      Transactional data that would access only a single form (window).

6)      Any process where identical repetitive steps are required. As an example, members of my team have deleted selective inventory Items in GP using macros as it was not possible to be done via SQL as there were multiple related tables.

7)      Some developers even use them for testing purposes.

 

Summary Steps to create a Macro to import data are as follows:

1)      Record a dummy macro in Dynamics GP to be the template macro.

2)      Open the macro template in an MS Word document.

3)      Use the Mail Merge feature using the Step By Step Mail Merge Wizard to locate your data set and create your letter to define the records in the template.

4)      Run the macro in Dynamics GP to import the data.

 

Dynamics GP Macros really can aid you in many different ways.  It’s just up to you to give your Little Helper some instructions. 

 

This post is written by Tod Heath. Tod is a Dynamics GP Senior Analyst in the Microsoft Dynamics GP Practice at Ignify. Ignify is a Global Microsoft Dynamics Inner Circle Partner specializing in Microsoft Dynamics ERP for RetailDistribution, Manufacturing and Chemicals verticals. For help on Microsoft Dynamics ERP email us at dynamics@ignify.com

Evaluating your ERP system

January 20th, 2010 Carla Whitcomb No comments

At the beginning of a new year resolutions are the hot topic. However, most of these are of a personal nature, but how about some resolutions for your business – starting with your current ERP system. Even if it seems that every person in the company, from management to the end user, is thrilled with the business system(s) being used there is always room for improvement.

With that in mind – here are 5 ERP New Year’s Resolutions to begin working on now:

1. Evaluate the fit of your current system to the business. Business operations change, management changes, processes change, etc. The ERP system implemented years ago may not be meeting the business requirements anymore. Create an RFP and apply it to your current system just as you would if you were evaluating a whole new system. If you don’t have in-house expertise to put together a proper RFP, which fully addresses the business requirements, there are software programs and consultants that can assist in this exercise for a reasonable cost.

2. Conduct a full audit of business processes and system application. Apply your RFP to the ERP system and truthfully evaluate the capabilities of your system against the business requirements. Does it have what it takes to address those requirements and is it scalable enough to fulfill the projected requirements in the coming years.

3. Conduct user training. This is an often overlooked factor in successful implementation/use of any computer software. And even if training was fully addressed in the initial implementation, again, business processes change, new employees are hired or users move to new positions, upgrades to the software offer new features, etc. User training should be an ongoing never ending practice in order to maintain optimum system application, and reduce help desk inquiries.

4. Upgrade to the newest version. If your RFP and full system evaluation reveal that the current system is still the right one for your business then the focus should be on making sure you are using the most recent version available from the software provider.   In some cases this can be painful (customizations must be ported, testing must be done, etc.) but the payoff is worth it. Upgrades typically include new/improved features that will benefit the business, not to mention the increased support that is available from your software vendor.

5. Implement a new system. Sometimes your evaluation will indicate that your current system is no longer meeting the needs of the business and then it is time to move on, the RFP created in step 1 will simplify the search for a new system. Be sure that you include in this search evaluation/selection of a full service consulting organization to manage your implementation project and provide expert resources that will assist in the installation, training, and customizations.

Taking a long hard look at the ERP system being used in your organization is worth the effort and should be done regularly.Once the facts of need and fit have been gathered generating an ROI for approval of training, and/or upgrades, and/or a new system will be easy and management approval a sure thing. Happy New Year.

This post is written by Carla Whitcomb. Carla is a Dynamics AX Team Lead in the Microsoft Dynamics AX Practice at Ignify . Ignify is a Global Microsoft Dynamics Inner Circle Partner specializing in Dynamics AX for Retail, Distribution, Manufacturing and Chemicals verticals. For help on Microsoft Dynamics ERP email us at dynamics@ignify.com

Centralized/Shared GP Reports and Dictionaries

December 31st, 2009 Devesh Kasat 1 comment

Dynamics GP installations usually have many different client installs of GP all accessing data on a centralized server.  GP allows customizations to reports and forms (windows) and it’s very beneficial if everyone that logs into GP accesses the same version of these customizations.  Following are some steps that can be taken to centralize these customizations.

Pre-Requisites

  1. GP installations should exist with a client server relation and all client systems accessing the same set of databases.

  2. Shared folder should be available either on server/network with read/write access to all users.

  3. Depending on 3rd party modifications VBA and Visual Studio Add-ins may still need to be updated manually as they must reside with the runtime components.

Steps to follow in order listed below:

  1. Identify the list of products which have Forms/Report customizations.

    1. To identify these, navigate to the Customization Maintenance window in GP (Microsoft Dynamics GP >> Tools >> Customize >> Customization Maintenance).
  2. Note: The list of customizations may also vary per user. Ensure to verify and check each client machine to ensure all customizations are placed in the shared location.

  3. In Customization Maintenance window verify ‘Product’ column to get name of products (EX: In Picture 1  below you would notice that there are two products with customizations i.e. ‘Microsoft Dynamics GP ’ and ‘Ignify’)

  4. PIC1-2

  5. Next obtain the Forms and Report dictionaries for the products as in step 2.

    1. To get Forms and Report dictionary name & location navigate to Edit Launch File window
      (Microsoft Dynamics GP >> Tools  >> Setup >> System >> Edit Launch file)

    2. Select Product from Edit Launch file window and obtain the path of Forms and Report DIC name from the location provided
      (EX: In Picture 2 below Product is ‘Microsoft Dynamics GP’ and Forms dictionary name is ‘FORMS.DIC’)

    3. pic2

    4. Create a shared folder on the server and copy the dictionaries and reports.

    5. Ensure shared folder has access to all users as mentioned in prerequisites.

    6. pic3

    7. Ensure to copy all products that have customizations.

  6. Launch GP on client’s system and go to Edit Launch file window (Microsoft Dynamics GP >> Tools  >> Setup >> System >> Edit Launch file)

  7. Select the products which have Customizations  and change Forms and Dictionary path to map to shared folder path on server (Note : Use UNC path)

  8. Pic4

  9. Repeat this on all clients and you would be ready with Centralized sharing of reports and dictionaries.

This post is written by Devesh Kasat. Devesh is a Technical Analyst in the Microsoft Dynamics GP Practice at Ignify. Ignify is a Global Microsoft Dynamics Inner Circle Partner specializing in Microsoft Dynamics ERP for RetailDistribution, Manufacturing and Chemicals verticals. For help on Microsoft Dynamics ERP email us at dynamics@ignify.com

Make your ERP project more than just a new system that works like the old one did

December 18th, 2009 Sandeep Walia 1 comment

I'm still surprised at how many customers still insist that the new system work exactly the last one does or supports their business process like they had it before the project. A fundamental question then is - why are you doing this project? If you are just looking for a nicer looking interface with no meaningful results then don't even waste time on an ERP project. Modern ERP systems bring with them bundled best practices. And an ERP project is the perfect time to re-evaluate your business processes and bake those processes into your new implementation.

I lead the implementation for an global Activity Based costing (ABC) effort for a 1 billion dollar division of a Fortune 10 customer. Of the many things I was analyzing, one key element was how people spent their time.One report in particular took about 5 person days of time to get ready every month. An annual cost of over 15,000 ($40/hour X 12 month x 5 days x 8 hours a day).This particular unit had a net profit margin of just $1 million on revenues of $1 billion and such reports were a gold mine to bring that net margin up. However, the cost to auotomate this report was estimated to be in the $45,000 range as it was a fairly complex report. The management balked at this cost. So we started digging into ways of simplifying the report. The report was initiated by a person in San Jose, California. Other data was filled by a finance person in Singapore and then by a team members in UK, Phoenix, Malaysia, UK and Germany. Certainly a lot of coordination and time. When finalized, the report was distributed to about 50 executive team members. I took the approach of reaching out to each recipient to ask them what was truly critical in the report so we could eliminate some of the complexity of the report. The results were staggering – none of the recipients ever readthe report and felt it was something that others probably found useful. Instead a simpler report was designed that cost only $2,000 to write and built in a day and was actually useful to all the divisional heads in improving their bottom-line. The report was completely automated and required no manual intervention.However, the fact that we developed a report that saved $15,000 is not so significant as the fact that had we not dug deep enough to find out the true pain we would have spent $45,000 ensuring the system worked like the client worked prior to the implementation and achieved nothing in the process. Are you sure you are not doing this to some degree?

I even found traces of this at Ignify. When we cut over to Dynamics AX – we got the ability to attach each receipt or expense with an AP invoice. We no longer had to sort and catalog these on a portal as Dynamics AX automatically catalogued our attachments with the invoice that was posted. However, our booking team members for a full 6 months after going live on Dynamics AX kept uploading the booking receipts to the portal while our payables team kept cataloging this in Dynamics AX. Of course we stopped the earlier process of uploading to the portal as soon as we found out. We had found a better way to do this, adopted it but forgot to tell someone to stop doing what they were doing :-) . How much work goes on that is useless and redundant. In my ABC analysis project that I had done – I found it was very significant. Employees were spending approximately 40% of their time doing non value-adding activities. When you cut over to a new system – leverage its intrinsic benefits of best practices. There is no better time to re-engineer your business process and ask 'How can I make this better simpler and more cost-effective' for every process. Weigh the cost with the benefit. The highest benefit with the lowest cost is when you can leverage what is out of the box and use that.

When Ignify adopted Dynamics AX globally, we cut out several redundant and manual processes – the workflow and ability to review postings, role-based security allowed us to cut out all the manual approvals that we had.We are still learning to improve but we implemented Dynamics AX globally for 300 employees across seven offices in 6 weeks by staying vanilla. We made zero customizations and drove our business to the best practices Dynamics AX provided to us. We spent a lot of time on business process design and how each process can be improved over what we had today. We spent time writing up process training documents for pretty much every finance, accounting, collections, and AP job – how to post a credit card transaction, how to post vendor invoices, how to post wire transactions, how to apply a customer payment. It was great- suddenly we moved from an undocumented, disorganized set of processes to a methodical way of doing business that supported our core consulting and software implementations.And these processes were written 100% by the Dynamics AX task recorder tool and have Microsoft Dynamics AX screen shots in them. At the heart of it we asked ourselves if we were a complex business and the answer was a resounding no. We are a simple business model and we wanted everything to be simple and easy to understand. Our goal was to make our processes even simpler and yet have the desired level of controls which Microsoft Dynamics AX did a great job of bringing to the table.

Microsoft Dynamics AX was great for us and has been great for our customers but I'm not proposing that as your ERP. I'm proposing that whatever system you choose to work with, that you leverage its native strengths and use the ERP implementation as a way of strengthening and simplifying your business processes and getting more for less. I've also run into situations where customers want to wait for writing up the perfect business process before starting an ERP project.That can take a really long-time and you may never start. The ERP application you choose will give you business processes out of the box as a starting point – use that as a spring board to move to the next level.

Sandeep Walia is the President & CEO of Ignify. Ignify is a technology provider of ERP, CRM, and eCommerce software solutions to businesses and public sector organizations. Ignify is a Microsoft Dynamics Inner Circle Partner and ranked in the top 18 Microsoft Dynamics partners. Ignify has been included as the fastest growing business in North America for 3 years in a row by Deloitte, Inc Magazine and Entrepreneur Magazine.

Get Adobe Flash playerPlugin by wpburn.com wordpress themes