Quick Links
Advertise with Sarbanes Oxley Compliance Journal
News


< Back

Sarbanes Oxley : Technology : Back Office

Automating Loading of Excel Data into SAP




Vikram Chalana
President
Winshuttle

Winshuttle, Inc, a provider of data integration products for SAP solutions, has announced the newest version and general availability of TxShuttle 7, a desktop software tool that automates the transfer of data from both Excel and Access to any SAP solution. Winshuttle also announced that TxShuttle 7 has achieved ?Powered by SAP NetWeaver? integration status.

TxShuttle allows business users and functional analysts to effortlessly upload or download data between Microsoft Excel or Access and any SAP solution without any programming. It works with almost any transaction, including complex transactions with several screens, transactions with header data and multiple line items, and even with custom transactions. Data loading from TxShuttle to an SAP solution is very similar to manually inputting the data. From the SAP server perspective, the TxShuttle user is just another user who is entering data at an enormous speed. TxShuttle is easy to use and business users can learn and deploy it themselves within a matter of hours.

?Like many companies, a large percentage of our accounting and finance data lives in Excel,? said Christy Ruth, Manager, SAP Systems- FICO, Coca-Cola Bottling Company Consolidated. ?We needed to find an affordable, turnkey, desktop solution that could automatically integrate 900 General Ledger documents posted via Excel each month and 650 Accounts Payable documents posted via Excel each week into SAP R/3. TxShuttle has given us a way to accomplish these tasks and much more. By implementing TxShuttle, we have been able to better utilize our resources for tasks other than data entry. We have also realized cost savings by using TxShuttle for data loads instead of relying on IT development work. We have seen a return on our investment in a just short period of time."

TxShuttle 7 enhances support for many more SAP transactions and makes complex data upload tasks simpler. Some of the new tasks this release of TxShuttle enables are: creating new SAP Project System module projects from Excel data, creating SAP Finance module journal vouchers with profitability analysis (PA) segments from Excel data, posting incoming Excel payments into the SAP Finance module and uploading or downloading long text data between SAP and Excel. An optional server component shipped with TxShuttle 7 also allows centralized logging and additional controls on TxShuttle usage.

"TxShuttle is enabling Canada Post's business-users to upload and download a large amount of data themselves without any programming," said Chantal Gauvreau, Business Process Manager, Canada Post SAP Center of Excellence. ?Our ROI from using TxShuttle has been tremendous. In the past two years, we have potentially saved over $300,000 in avoided programming and reduced data entry workload costs."

TxShuttle uses native SAP interfaces to communicate with the server and completely preserves SAP system?s role-based security. If a user is not authorized to change data in an SAP system through manual data entry, the user will not be able to change data using TxShuttle either. In addition, TxShuttle maintains complete audit trail in the SAP system. TxShuttle resides outside the core SAP system and is very easy to install and maintain without any server side support. TxShuttle can even be scheduled to run in an unsupervised mode during off-peak hours.

TxShuttle applications include:

• SAP Finance and Controlling. Create and post fixed assets, journal vouchers, vendor invoices (Accounts Payable), customer invoices (Accounts Receivables), credit notes, and budget data with TxShuttle.

• SAP Logistics and Supply Chain Management (SCM). Create and update master data such as material master, vendor master, customer master, equipment master, functional locations with TxShuttle. Also, use TxShuttle for creating and modifying transactional data such as, sales orders, purchase orders, or customer invoices.

• SAP Human Resources. Create or update various employee infotypes, such as payroll, compensation, organizational assignments, or training records with TxShuttle.

?With this latest version of TxShuttle, Winshuttle continues to build on our momentum of providing our customers with cost effective solutions for uploading and downloading data efficiently and quickly to their SAP systems resulting in increased ROI on their SAP investments,? said Vikram Chalana, President of Winshuttle, Inc, ?We are very pleased to receive ?Powered by SAP NetWeaver?? integration status and believe this certification will lead to wider deployment of our solutions.?

Availability
TxShuttle 7 is available immediately and is available in two different versions ? the full featured version and a run-time version, TxRunner. Pricing is dependent on the number of users and the deployment strategy. Current customers under active maintenance contracts may receive this upgrade free of charge.

Winshuttle, Inc. is a privately-held software company that has been providing easy-to-use, innovative, and non-technical software solutions for SAP users worldwide since 2000. Winshuttle?s software products empower business users in finance, accounts payable, accounts receivable, purchasing, human resources and production planning to easily integrate Excel data with any SAP solution without any programming and without utilizing IT resources. More than 250 Global 2000 companies are using Winshuttle's solutions including Canada Post, Kraft Foods, Medtronic, Nissan Motors, Warner Bros, and Starbucks Coffee. Winshuttle is headquartered in Bothell, Washington.

More information about Winshuttle can be found at http://www.winshuttle.com






About Us Editorial

© 2019 Simplex Knowledge Company. All Rights Reserved.   |   TERMS OF USE  |   PRIVACY POLICY