WS OFFICE
Move Data From Excel to SAP. Extract Data From SAP to Excel.
Built on Synactive's WS Platform, GuiXT WS Office is fully integrated with Adobe Acrobat, as well as Microsoft's core office applications. GuiXT WS Office enables mass entry of data via Excel spreadsheets, uploading data from PDF forms, and spell check via MS Word. WS Office also includes error handling that will identify and flag any mistakes made by a user during the data entry process.
WS Office in Action
Sales & Distribution Module
WS Office allows customers to record data in Excel and then do a mass upload to a given SAP transaction. WS Office also enables customers to extract data from a given record or transaction and modify it in the familiar interface of Excel, while providing error handling for the subsequent upload back to SAP.
Example: A user might want to create a promotion where the top one hundred customers will receive a promotion containing the same materials, the same pricing and the same shipping information. The customer could use Excel to enter the data for each customer, and then click a single button in SAP as shown below to perform a mass upload of the data to SAP.
Benefits: A SAP user is enabled to create the same kind of data for all customers in SAP. For example, in the scenario described above, the SAP user can use Excel to quickly and easily copy in the data for the customers' materials, quantities, shipping information and sales organizations using Excel's copy functionality since this data will be the same for all customers. Then once all the data is input into Excel, the single click of a button in SAP initiates the mass upload of data to SAP. Any errors will be caught by WS Office's built-in error handling mechanisms, prompting the user to correct the data before errors are introduced in the data stored in SAP.
Finance Module
WS Office enables customers to input multiple financial transactions into SAP, or who wish to extract data and modify it outside of SAP in the familiar environment of an Excel spreadsheet. Like the previous example utilizing the SD module, this is also convenient for finance users to input or extract data to and from SAP.
Example: A user might have a spreadsheet that contains data related to a financial transaction which needs to be reconciled to the data contained in SAP. In the spreadsheet, the user can modify any values necessary, using Excel's macro capabilities. Then the user would need to simply navigate to the correct screen in SAP and once again, a single button click would upload the data from Excel to SAP. As in the SD example, any errors would be caught by WS Office's error-handling mechanisms.
Benefits: The user is able to perform all data manipulation in Excel, and utilize Excel's formulas and macros to perform the basic computations needed. Then a single button-click would upload the data to SAP. Conversely, any data from a given transaction could be extracted to a specific spreadsheet using the same process. WS Office will then proceed to reconcile the spreadsheet with the SAP transaction. Any errors introduced in either the data or in the column names will be caught by WS Office's built-in error handling, enabling users to avoid inputting erroneous transactions.
PDF Module
WS Office enables customers to input multiple financial transactions into SAP, or who wish to input data using a PDF form. Like the previous example utilizing the SD module, this is also convenient for finance users to input data to SAP without actually needing to manipulate SAP itself.
Example: A user might have a form that is repeatedly input containing different datum. Using a PDF form, the user can input any values necessary. Then the user would need to simply navigate to the correct screen in SAP and once again, a single button click would upload the data from Excel to SAP.
Benefits: The user is able to quickly input data into the PDF form's pre-set fields, eliminating any need to perform data manipulation in SAP. Then a single button-click would upload the data to SAP. In this manner a great deal of similar types of data can be quickly and easily uploaded to SAP by a single user in a short amount of time.
Current Features
WS Office enables SAP users to utilize Microsoft Excel and other Office applications for automating data entry and editing in SAP. The following functions are currently enabled with WS Office:
- Mass entry of data via Excel spreadsheets.
- Creating Excel, Word, Access and PDF files.
- Spell-checking via the Microsoft Word spell-checker.
- Accept POSTed forms from PDF files.
- Validation or error handling that will identify and flag any mistakes by a user during the data entry process.
- A limited interface offers less confusion and restricts the possible user actions to entering and submitting information.
Future extensions are planned, including a screen recorder for recording transactions and mapping the fields recorded to Excel columns. Future releases will also include F4 search help for Excel fields, PDF form creation and the creation of web scripts from a recorded transaction.
Technology
WS Office is built on the WS Platform and utilizes the same industry-standard web scripting as do all other elements of the platform. Fully integrated with Adobe's Acrobat application as well as Microsoft Office (particularly Excel), WS Office utilizes Active X technology to automate these applications.
Solution
GuiXT WS Office enables users to use the power and familiar interface of Microsoft Office for SAP input and extraction. These transactions can be deployed along with all current GuiXT WS scripts to a variety of platforms. The beauty of WS is that a single development can be deployed to multiple platforms - Desktop, Mobile, Web or Offline.