Much of the data being uploaded into SAP already exists in a digital format such as Microsoft Excel spreadsheets or Microsoft Access databases. Moving data out of these spreadsheets and databases requires either manual data entry or ABAP development resources.

Quadrate has an easier solution. For a fraction of the cost of a regular inflexible custom-built ABAP upload program, ERP² can be used to upload Excel files and Access files directly into SAP without any ABAP programming or technical expertise. Utilizing the Microsoft Office suite as the data management platform, users can manipulate and prepare data for upload without any additional training or software.

ERP², pronounced ERP Squared, is a desktop application that is installed directly onto the users’ workstation without any need for changes/installations to the SAP systems. The installation process is quick and simple, and the user-friendly interface can be mastered in a couple of hours. Most customers are creating their own templates and uploading data the very same day that ERP² is installed.

ERP² can be used for a variety of applications within the different SAP modules. Common uses are Mass Uploads of SAP data, Mass Maintenance of SAP data, SAP data migration and the automation of SAP data entry.

Why ERP2

Seasonal burst demand for mass data modification to SAP
Over the lifecycle of the ERP system, there are seasonal demand to revamp the business data at mass basis. Examples are Material Price Changes, Post journal voucher documents into the GL with many line items, Automate Daily Cash Reconciliation and Monthly Investment Activity entries, and Payroll/Human Resources, Timesheets, expense claims update.
Cost for SAP client license to satisfy seasional demand is high
ERP2’s flexible licensing module help
Time & Cost to develop custom Program is too high
The time required to create a custom ABAP program that uploads data into SAP can be quite substantial. It begins with the business user writing up the requirements, then passing them onto the developer who will create and test the program. The business user then tests the program in the development environment, relaying any changes back to the developer. This back and forth continues until both are satisfied. Once this is complete, the code is migrated to the QA environment and the testing process begins again. Changes will result in testing again in the development environment and re-migrating to QA. Once the testing is complete in both environments, the program can be moved to production. Depending on how often production migrations are done, this can take several days to occur.
Mass data update through SAP user interface demands for excessive screens navigation
It is common to navigate through multiple SAP screens to complete a single transaction. The time taken will become significant when there are large volume of data update involve. With ERP2, there is the advantageous of using simple copy-and-paste to reproduce business transactions with similar paramters that makes data entry much faster

Key Features

Simple 3 Steps Process

The procedure to upload Excel or Access files into SAP is a simple three step process designed for even the most inexperienced of end-users. The user records the transaction by executing it from within ERP^(2). Once the recording is complete an Excel or Access file is automatically created for the user to add the data to upload. The final and simplest step in the process is to return to ERP^(2) and select the file to upload the data.

Automatic Load File Generation

While navigating between SAP’s transaction screens, ERP^(2) does automatic mapping between spreadsheets/databases to fields automatically and a load file will be generated for mass data upload.

Error Handling

Simple to understand error handling separates the records that failed, facilitating quick corrections and upload procedures. User can take advantage of the step-through function where graphical view of every screens that Quadrate goes through to upload data will be displayed for diagnosis purpose.


Report Generation

Report can be generated as printer output or HTML file for audit purpose. Summary r

eport displayed an overall success and error rate for each transaction and ROI summary in form of time saved by Quadrate’s ERP2.

Respects SAP Security
No need to setup additional security and ensures users can only upload data that they could have done manually.

Data Validation
Ensures that data being uploaded into SAP is in the correct format so as to prevent errors even before uploading into SAP.

Additional Application Security
Allows the restriction of certain tasks in the application even if the user has sufficient SAP authorizations.

Broad Transaction Support
Allows uploads of data into SAP in all SAP functional areas as well as custom transactions.  

Flexible Licensing & Pricing
Lets you choose from a licensing model that suits your individual requirements.  

Transaction Stringing
Strings multiple transactions together that can be executed in one step rather than many.

Translate »
Web Design MymensinghPremium WordPress ThemesWeb Development

New White Paper – Two Factor Authentication on the IBM i by Townsend Security

April 22, 2016April 22, 2016

Security Beyond Usernames and Passwords

Today's organizations must take a defensive strategy against the constant threat of network data breaches. Recent password leaks from high-profile sites (Anthem, Target, etc.) suggest that their sensitive data may not be as secure as once thought. Companies and web properties have to do a better job protecting security credentials.

Download this white paper to learn:

  • Why the IBM i may not be as secure as you think
  • The need for verification on the IBM i
  • How to meet compliance requirements (PCI DSS, FFIEC, etc.)

[Download Now]

For More Information:
Contact: Mr. Savio Sin (
         Sales Manager - Wiseco Consultants Ltd. 

White paper – Simplifying Security for IBM i by Townsend Security

February 27, 2016February 27, 2016

Collecting real-time security events and actively monitoring system logs is one of the most effective security tools any organization can deploy. 

Request the Simplifying Security for IBM i and IBM Security QRadar white paper to find out more about: 

  • How IBM i customers can make integration with QRadar simple, fast, and inexpensive
  • How IBM Security QRadar users can rapidly experience success and better security
  • How continuous, active monitoring is a key security control
  • The security benefits of the combining IBM Security QRadar and Townsend Security's Alliance LogAgent for IBM QRadar

Now, the integration between Alliance LogAgent for IBM QRadar and IBM Security QRadar has dramatically reduced the effort and expense required to deploy an effective SIEM solution for the IBM i (AS/400, iSeries).

White paper – Top 10 Reasons to Choose PHP for IBM i Web Application Development by Townsend Security

February 13, 2016February 13, 2016

Learn why PHP is a great choice for IBM i web development and application modernization.

PHP ebook

When deciding on an IBM i web development strategy, it's important to choose technologies that are easy for RPG programmers to learn, attract new programmers and grow with technologies like mobile. PHP gives you all of this and more.

Download this free eBook to get a detailed look at the top 10 reasons why PHP is a great web development choice for IBM i shops, including:

  • Why PHP is easy for RPGers to learn
  • How you can leverage DB2 and RPG with PHP
  • The benefits of choosing an open-source language
  • Why PHP makes mobile applications easy to deploy

This eBook, which was co-sponsored by BCD and Zend, also features a foreword written by Alan Seiden.

Complete the form to the right to download it now!