Maximise ROI by integrating SAP R/3 and Excel / Access
Maximise ROI by integrating SAP R/3 and Excel / Access
 

EzySolutions Product Explorer

 
 
       
Information

User Interface

Activity Automation

Data Management

EzyPlan
EzyPlan
Ezyactuals
EzyWorkflow
EzyConversions
   
   
 
 
Click on EzyPlan to find out how to rapidly and simply integrate SAP plan, budgeting and financial data.
Click on EzyActuals to learn about improving your retrieval and upload of journal and transactional SAP data.
 
EzyActuals for SAP

EzySolutions - SAP and Excel data integration software

EzyActuals for SAP
Functionality
Features
Benefits


EzyActuals for SAP

EzyActuals is a role-based improvement tool that integrates specific transactional and master data maintenance transactions with SAP R/3 – seamlessly, that is, EzyActuals is fully integrated with SAP. EzyActuals improves a users role by providing a single user interface, Microsoft Excel. Users make changes exclusively in Excel; no additional transactions are required in SAP.

This approach is closely aligned with the way people work.

For further information on EzyActuals, please contact us. We can provide a whitepaper or a guided virtual demonstration of EzyActuals for SAP R/3. You can also get a 2 weeks trial version for evaluation on your own data.


Functionality

As of December 2002 PCS Consult has released Version 1.4 of EzyActuals for SAP. EzyActuals consists of a number of modules. These are:

Transactional Data Processing:

  • General Ledger Journals
  • Recurring Journals
  • Accounts Payable Invoices
  • Accounts Receivable Invoices
  • Statistical Key Figure (SKF) Postings
  • Goods Movements
  • Asset Acq & Retirement

Master Data Maintenance (including creating and changing):

  • Bill's of Materials
  • BOMS's & Routings
  • Projects/WBS's
  • Customers
  • Vendors
  • Chart of Accounts
  • Cost Centres
  • Cost Centre Groups
  • Profit Centres
  • Assets
  • Purchase Info Records

Features

  • Post and/or save data to SAP R/3 – whether it be through journals, recurring journals, master data maintenance or SKF postings
  • Advanced error checking – The advanced error checking is one of the key differentiators from a simple load program. Standard SAP R/3 error messages are passed back to Excel, therefore the user sees exactly as if they had input directly into SAP
  • Master data validation – As standard SAP R/3 methods are used to update SAP the same master data validation and authorisation checking as the manual transaction is used.
  • Posting locks – As standard SAP R/3 methods are used to update SAP, EzyActuals receives postings locks if someone is processing a transaction against the records we are attempting to update through EzyActuals.
  • Supports manual entry or formulas – with EzyActuals it is possible to enter data either as a manual number, a formula or a reference to another sheet. In this way EzyActuals integrates directly with a user spreadsheet without extra steps as is the case with a normal upload program.

Benefits

The main business benefits of EzyActuals are completly aligned with that of our EzyPlan product. Such benefits are achieved through:

  • Simplification
  • Efficiency
  • Increased Functionality
  • Improved User Satisfaction
  • Lower Cost of Processing

It therefore saves you time and money.The main benefit areas include:

  • The current process of manually rekeying data from a spreadsheet to SAP R/3 will be eliminated. This will save on the cost of temps, the training effort required, the cost of data entry mistakes, rework and rechecking.
  • Multiple transactions (journals, recurring journals, SKF postings, etc) can be processed from one virtual worksheet in Excel. This effectively replaces several transactions with one;
  • Existing Excel models and formats can be enabled rather than recreated from scratch
  • It is easier to use than standard SAP R/3 screens
  • It minimises (re)training requirements as users can use Excel rather than SAP R/3 – something they often prefer and a more intuitive product
  • The full functionality of Excel can be used

 
Search       
Newsletter
Subscribe
Unsubscribe
 
 

Copyright © 2004 PCS Consult
All rights reserved
Maximise ROI by integrating SAP R/3 and Excel / Access