The Beginner’s Guide to ERP Testing (SAP Testing) – Part 1

Let us explore an interesting and challenging topic “How to Test ERP Software”. We’ll learn the challenges involved in ERP testing (e.g SAP Testing) , guidelines and road-map for a successful ERP testing.

Before going into more details about ERP testing, first we need to understand some key information about ERP. For testing purpose, understanding the features, functionalities and workflow of ERP software is most important. Without proper knowledge, testing ERP modules is very critical and cumbersome.

ERP SAP Testing

What you will learn?

What is ERP and why companies need ERP software?

ERP means Enterprise Resource Planning. In a more practical thought, if an “Enterprise” (an organization or a company) is “Planning” to increase the productivity and efficiency by integrating the “Resource”, then it is ERP.

What are the resources? It is called as 4M’s in any type of organization like: Man, Machine, Method and Materials.

Every ERP Software in the globe is built based on this concept in mind. Every company needs an Accounting or ERP solution which is a fact of any business.

An organization may use one or many software as per the requirements of the individual departments. For example, the Accounts department may use accounting software developed in Oracle technologies, finance department may use budgeting software developed in Microsoft technologies, personnel department may use payroll software developed in Java and inventory department may use warehousing software developed by IBM and so on.

Apart from the technologies, each software is different. The database used for storing the data is also different like Oracle, SQL Server, DB/2 etc.

Most importantly, the data available in one department is not available for the other department, as the data is not stored in a centralized location. This situation arises many complexities in a business scenario of an enterprise organization and reduces the productivity of the company as well as impact the efficiency of the employees.

For instance, the sales manager doesn’t know the inventory stock in the warehouse for committing the sales order with a customer and the Vice President of the company doesn’t know the financial status of the company until unless visit the department or have a phone call with them.

ERP Software consider all these various business situations and functional flow scenarios and giving the solution to the enterprise customers by integrating the multiple department’s workflow inside the organization and centralizing the database through a server infrastructure.

So, every department’s data will be stored in a centralized server on a daily basis. And, any authorized employee can be able to see the live data online without the need to interact with anyone to proceed with their daily operations. Finally, the VP of the company can review the complete organization data with a single mouse click. Great work, right?

The worldwide ERP software market per year is more than $25Billion which grows 10-20% every year and the demand will be increased in small and medium enterprise business segments through SaaS (Software-as-a-Service) and Cloud (Off-Premises Infrastructure) platforms.

Subsequently, the demand for ERP testing professionals is also increasing in the IT industry. Many ERP implementation projects spent more than 50% of their budget in testing and related activities.

Even though, we call it as ERP Software, it is not “just software” and the ERP vendor’s job is not completed by selling ERP software to the customer. ERP is actually a “business solution” to an organization by automating the business process and workflow inside the company. This will not be achieved by just installing the software and setup the infrastructure, rather the success of ERP implementation requires lot of dedicated workaround and people involvement.

In this ERP world, how to select and evaluate the best ERP software, which is having the quality and performance as expected is a big question and dilemma amongst the enterprise customers.

A snapshot of the ERP enabled business organization will be captured as below.

(Click on image for enlarged view)

ERP tutorial 1

ERP Vendors

There are many ERP vendors in International market.

Below is a quick list of ERP software and its vendors based on the market shares, cost, implementation model, average time for deployment, platform and delivery, technology, features and functionalities. Each vendor offers different flavors of the product depends on the customer’s domain and industry verticals.

  • SAP (#1) – From SAP since 1972, major market share holders, millions of users worldwide.
  • Microsoft Dynamics (#2) – From Microsoft Corporation, millions of users worldwide.
  • Oracle E-Business Suite (#3) – From Oracle Corporation, millions of users worldwide.
  • Epicor ERP
  • Sage ERP
  • NetSuite
  • Infor ERP
  • Ramco ERP
  • Focus ERP
  • Tally ERP

ERP Modules

What are ERP Modules? Module in ERP is a group of features and functionalities for a specific group of process or departmental workflow.

For example, sales order process, payment process and customer management can be grouped as a unique functional workflow in a company and can be formed under “Sales & Distribution” module and similarly employee attendance, payroll process, personnel management can be grouped as a unique functional workflow in a company and can be formed under “HR & Payroll” module.

For testing purpose, understanding the features, functionalities and workflow is most important. Without proper knowledge, testing ERP modules is very critical and cumbersome.

ERP vendors may have different module name for grouping the functionalities, but the concept will be the same. For example, let us have a quick look on few SAP modules to have an idea if we are performing SAP Testing.

  • SAP FICO (for Financial and Cost Accounting)
  • SAP HR (for Human Resources)
  • SAP MM (for Materials Management)
  • SAP PP (for Production Planning)
  • SAP SD (for Sales & Distribution)
  • SAP CRM (for Customer Relationship Management)
  • SAP SCM (for Supply Chain Management)

Similarly, every ERP software is having such modules as per their functionality grouping and naming conventions.

Importance of ERP Testing

Majority of the ERP Implementation projects fails because of the improper test planning and testing. To understand the importance of ERP testing, testing professionals needs to understand the variations of the ERP systems.

ERP systems may be available in multiple versions for multiple domains targeting multiple customers. For example, major ERP vendors are having different versions and flavors of their ERP software as below.

  • Microsoft Dynamics NAV: Designed for small and medium enterprise customers
  • Microsoft Dynamics AX: Designed for large enterprise customers
    • System testing, performance testing and load testing is important, apart from the functional testing.
  • SAP Insurance: Designed for Insurance companies
  • SAP Banking: Designed for Banking sectors
  • SAP Chemical: Designed for Chemical companies
    • Domain knowledge and industry experience is importance, apart from the functional testing.

Similarly, the products from Oracle viz., E-Business Suite, PeopleSoft, Siebel and JD Edwards etc, each have different features, target customers and industries, where the testing team needs to understand the purpose and functionalities of the complete systems.

There are two types of testing teams available in ERP companies:

------------

  • “Core testing team” to test the ‘base ERP software’ with the static functionalities.
  • “Implementation testing team” to test the ‘implementation project’ with dynamic and customized functionalities.

When a feature and functionality is customized as per the customer requirements, the modified impact will be on multiple modules and systems. The testing team should capture each and every changes and the related impact for the complete traceability.

ERP companies are having dedicated testing force for testing their ERP systems. Testing such a large system requires the test execution to be “automated”. Depends upon the requirements, the ERP companies design their automated testing framework and setup their testing infrastructure.

Automated testing is suggested for ERP testing as manual testing requires lot of time to complete one round of testing. It is evidence, that without testing each and every component of a system and ensuring 100% quality, ERP implementation fails.

The below is the list of different type of ERP testing as most of the ERP systems are being built in an SOA (Service Oriented Architecture).

Why ERP Testing is Critical?

ERP Testing is really critical, if the testing plans not cover the complete road-map of the implementation phase. All the modules within the system are completely integrated and inter-related, means all the functionalities are dependent on the functionalities of other modules or other systems.

For example, to create a sales order in “Sales” module, the system has to check the available stock in the “Inventory” module and check the credit limit of the customer in “Customer” module.

The functionality is not only dependent on other modules, but also dependent on external systems like a multi currency enabled system retrieves the current exchange rate from an external live system, the shipping rate for the sales order may be required from an external live system, the sales tax of the inventory items may be required from a government agency etc.,

When a test case is written based on the above business use case, a tester needs to understand the complete workflow of the functionality and the dependency of the workflow, otherwise the test case will fail or remain incomplete.

Below diagram gives an overview of a sales order process and the dependency of internal and external systems.

ERP tutorial 2

Apart from the functional testing like in the above business use case, the other phase of testing is on the “ERP Implementation” which is more critical. The implementation phase of ERP involves lot of modifications and customization as per the customer requirements and infrastructure.

This kind of testing not only involves the normal functional testing but also the performance and user acceptance testing. There are multiple components interacted with the live system from internal and external sources.

Understanding all the components and their functionalities is more important for testing professionals to prepare the test plans and the test suite with all the feasible use cases to be covered for the application under testing.

The successful ERP testing professionals are trained and worked on lot of different ERP implementations for many years and gather experience to become a capable ERP tester with an additional credential as a “subject matter expert” or a “domain expert”.

The heart of many ERP system is in Accounting or Finance module, where most of the testers are lacking accounting knowledge and hard to understand the financial concepts and the general ledger system. The complexity in the inter-related and the outer-related workflow of the ERP systems demotivates the testing professionals in writing a proper ERP test suite.

Particularly, the implementation of ERP systems requires various forms of system testing, multiple user acceptance testing, multiple level of performance and load testing with millions of “live test data” from the existing systems which needs to be imported to the new ERP system.

The main challenge is in collecting input data for testing the feature and analyzing the correctness of the output data, which requires domain knowledge.

For example, it is not that much easy to collect data to test the general ledger transactions or a sales order transactions in ERP systems. Even though, the data is collected for input, it is highly critical to understand and analyze the correctness of output data as per the financial standards like IFRS.

For example, a “balance sheet” generated from the general ledger transactions cannot be understandable by normal testers without the knowledge of a balance sheet or trial balance. The reason being the “balance sheet” is generated from the general ledger based on multiple transactions from all the modules.

(Click on image for enlarged view)

Erp testing 3

Can I Test ERP Software?

The important question for testing professionals is “Can I test ERP system with my available knowledge and experience?”. The answer to this question is not simple “Yes or No”, but requires self-assessment.

ERP systems are available in multiple languages, supporting multiple currencies, adaptable for multiple platforms, targeting multiple domains and designed for multiple users. And, the testers are not going to test the complete ERP system individually or alone.

No one is expected to have the complete and full knowledge and experience of all the modules in ERP or multiple languages expertise or multiple industrial exposures. But, testing professionals needs to ask themselves few questions as below, which will help them to prepare for ERP road-map.

  • Do I know ERP and ERP Modules?
  • Did I write test cases for ERP before?
  • Did I execute test cases for ERP before?
  • Do I have any technical knowledge like Scripting, HTML, XML and SQL?
  • Do I have any industrial exposure like Pharmaceutical, Chemical and Banking etc?
  • How many ERP modules I am going to Test?
  • Do I need training for ERP testing?
  • ERP testing is manual or automated?
  • I am part of Core testing team or Implementation testing team?

ERP Testing Road-map

So, let’s prepare ourselves with a road-map with a checklist for ERP testing. Point to note is that the “testing effort” might be almost equal to “development effort” for ERP testing and the ERP companies are trying to setup a platform and infrastructure to reduce the effort, but increasing the efficiency and productivity.

This is a quick checklist and may vary on a case-to-case basis.

ERP Testing Checklist:

Sl.No.Action ItemStatus
1.Identify the scope of testing and check the ERP testing is for the base product or for the implementation project.
2.Identify the total modules available / released in the product for the application under testing.
3.Identify the target customers, system users, and industry verticals of the product to be implemented.
4.Estimate the testing effort for writing testing plan, test suite, test cases, test execution and test reports.
5.Check the status of previous testing strategy, test execution plans for the application under testing.
6.Identify the business process to be tested and identify the business process to be automated.
7.Identify the test scenarios to be tested and identify the test scenarios to be automated.
8.Analyze the existing testing framework for manual and automated testing for the ERP application under testing.
9.Check the existing / proposed automated testing tool is configured and the framework is well tested for execution.
10.Setup the Quality Assurance strategy with the quality metrics identified for the ERP testing for both manual and automation.
11.Analyse the automation test scripts for all the business use case scenarios are well reviewed and approved.
12.Identify the best practices for improving the efficiency and productivity of testing efforts for both manual and automation.
13.Form a testing team with the group of experienced professionals with the right skill set for both manual and automated ERP testing.
14.Setup the testing framework for maintaining the test scripts which can be reusable in automation process.
15.Escalate the test scenario / business use cases which are not feasible to test or not feasible for automation framework.
16.Identify the process of collecting test data for both input and output and check the availability of domain expert to analyze the output data.

Conclusion

Before getting into ERP testing, the testing professionals needs to understand the concepts, process and strategies and the criticalities of ERP testing. Yes, now we are ready to start the testing process with a quick road-map in hand.

Next ERP testing tutorial: So, our next step is to initiate the ERP testing process by preparing the QA & Test Plan, preparing the Test Suite with module wise Test Cases, identify the best practices for manual and automated Test Execution and preparing the template format for Test Reports.

We will cover all these topics in our next tutorial. So don’t miss it.

About the author: Balu A. is an experienced techno-functional IT professional with over two decades of IT software experience and a decade of project and test management experience delivering enterprise applications and mobility solutions across domains using Microsoft, Oracle, Java and Mobile technologies.

Let us know if you have any questions on ERP or SAP Testing.

Recommended reading

41 comments ↓

#1 Gaurav Khurana

Very nice article. I was not aware of the ERP application before reading this article.

It would be great if some example would have been shared along with some snapshots to explain better.

#2 Aniket Shrivastava

nice introduction.
sap testing is tough to do. please share test cases.

#3 Shobha Pandey

Very nice overview and introduction to SAP testing. This is very helpful article not only for beginners but for experienced tester as well.

#4 Balu A

@Gaurav, @Aniket: You can find your requirements with classic examples of ERP test cases with snapshots in the next article. @Shobha: Thanks for reading the article and your comments.

#5 Pradeep

Hai
Currently I am working as tester in a ERP based company(chennai).I want to know what know wether i need to continue in thew same company or i need to switch over to any web oriented company. is ERP is good for me.if its then what are all new technology that i need to learn to update myself.

#6 Pooja Desai

Great article!! You have explained it very well. Thank you.

#7 Shahabuddin Mohammad

Indeed a very good article on ERP testing explained in layman’s language !!This article is not only useful for the beginners but also helps experienced people as a ready refresher.
Author touched upon different aspects of ERP in detailed & organized way. Appreciate the efforts done.it’s worth read and share to the people in ERP domain.

#8 Balu A

@Pradeep: Feel proud to be part of ERP domain as it’s not only challenging for your career but have great future if you groom yourself as a subject matter expert in ERP domain. Learn how to test Finance related modules rather than Inventory, Sales, Payroll etc., which will give you value add on your testing profession. On the technology side, concentrate on automation framework using any open source tool like Selenium. Also, learn to test the process on Mobile ERP and Cloud based ERP which are having excellent future in the ERP market.

#9 Balu A

@Shahabuddin Mohammad: Thanks for reading the Article and your valuable comments.

#10 S Balu

Really great article for testing professionals

#11 Venkat

Great article for testing professionals on ERP domain.

#12 priya

Useful article, Waiting to read the next articles
cheers!!!!

#13 Parag

Really a great learning experience sir Thanks a lot all for guiding us for ERP Testing. Waiting for the next one…

#14 Vinoth Kumar

Hi What skills are needed for this ERP testing. Is it manual/domain knowledge enough for this? Please let me know how can we switch into this ERP testing from Manual.

#15 Balu A

@Vinoth Kumar: For ERP Testing, the test scenarios, business use cases and test boundaries are wider, so you should be strong in manual testing and must have the domain knowledge (at least 3-4 modules), without which the test coverage cannot meet the requirements. You may need some training and time effort to be spent in ERP domain to start with. All the modules in ERP are somewhat inter related and dependent on one another. So, for a test case you may need to travel 2 or 3 modules.

#16 Suma

Very good article and good explanation. Thanks for posting.

#17 Nada

very good article, very simple in explanation and giving examples

#18 s

nice

#19 ganesh999

Great, very use-full article.

#20 Rakesh

can we do globalization and localization testing on ERP

#21 Balu A

@Rakesh: Yes. All the ERP products are targeting the global market in terms of functionality and culture, which supports multiple currencies and multiple languages. So, for sure, globalization and localization is part of ERP testing. For example, the product should support GAAP accounting standards for US and Canada, IAS for Middle East, IFRS for India and OHADA for African countries with English, Arabic, Hindi and French language support, to be tested as part of test plan.

#22 shyam iyer

Dear Sir, I am working in DRCongo as IT Manager in a Mining/copper metal producing company. Recently DRC has also accepted OHADA system. I am trying to introduce SAP ECC ERP system here. Whether SAP can be customized to work with OHADA accounting system. I am from Mumbai,India and new to OHADA. Also the SAP partner is from India and has heard OHADA for first time. Please help in this regard. Are there any third party modules that can imported into SAP or any possible workaround ? my mobile no. is +243995000497

#23 shyam iyer

My email id is shyamiyer2005@gmail.com

#24 Balu A

@shyam iyer: Thanks for your query. I don’t think any ERP products in the global market is OHADA enabled for the french accounting system. But many african countries still demand OHADA and not ready to adheres to US GAAP or IFRS. The only best option available is to customize the SAP accounting system as per OHADA which is not easy and also time consuming and your budget even doubles/triples the budget of your SAP purchasing cost, as your SAP Partner’s ABAP billing might be very costly. I’m sharing this information as per my analysis few years back after going through the OHADA accounting principles.

#25 Ankita

Hello Sir, I am new in testing field but the way you described ERP is brilliant and very helpful. Thanks for sharing it. Could you please explain some test cases related to manufacturing domain?

#26 Balu A

@Ankita: Please read Part 2 of this article at http://www.softwaretestinghelp.com/erp-testing-sap-testing-test-plan-part-2/ for a sample test case of a manufacturing domain.

#27 Bhasker

@Balu A: I am working as a German Language Localization Test Engineer and I do have working experience on SAP SD. I am looking out for a Job on SAP Testing, could you please let me know the companies in which I can apply/approach.

Thank you in advance for your advice.

Regards,
Bhasker

#28 TARAKESH

Hi Guys,

This is the one of the best article which is written on SAP Testing, which is covered from the basic to real time scenario. Really appreciate you guys for making available for the public.
Thanks
TARAKESH

#29 Sandhya

Hi ,

I have experience in SAP testing for 4 year.
Can anybody suggest , Selenium / QTP or any automation tool will be helpful in growth of my career ??

your suggestions are welcome !!!

#30 Sudheer

very nice and detailed explanation of ERP testing and nice presentation of workflow chart for easy understanding.Thanks.

#31 TARAKESH

Hi Sandhya,

Learn QTP first, Because for SAP Automation Testing we use QTP. It will give you a better career.

Regards
TARAKESH
SAP TESTING GURU

#32 PLACIDE LUDIWA

I would like to have more details on testing on SAP HR

#33 Atye E.

Thank you for this information , it’s very useful
Can you explain to us how we write a business scenarios ?? can you give us a example

#34 Satish

Hi ,

I have experience in Manual Testing for 5 year (Healthcare Domain).
Can anybody suggest me , Selenium / SAP/ ERP or any automation tool will be helpful in growth of my career ??

#35 Satish

any update on my blog

#36 siddharth Mori

Very nice article. good detailed explanation of ERP testing and nice presentation of workflow chart for easy understanding.Thanks.

#37 Raju Ranjan Kumar

hi i am doing testing on ERP Application, and your valuable article help me a lot.

#38 Tamilarasan

ERP based on tests at client site or administration control database?

#39 ERP_BASIC

Which book or study guide can guide me about the basics or latest trends in sap testing any reference guide will be beneficial

#40 Sandhya

Hi TARAKESH,

can you please suggest me what would be the best option to gear up my career is to go with SAP FICO / SD / MM etc module specialization or learn QTP ?

Cause in my past experience i was part of only manual functional testing.

Thanks a lot for you suggestions !!

#41 Rattan Singh Rawat

Hi Team,

I have an 5 Years of experience in ERP Oracle in Support side. Now, i am getting a chance in ERP Testing side.

So, could you please suggest whether getting into testing side will boost my career or destroy it.

Regards
Rattan.

Leave a Comment