Spreadsheet Writeback for JDE
Data Entry and Uploading to JD Edwards within Excel
Using the power of JD Edwards and the simplicity of Excel, Spreadsheet Writeback for JDE provides you with the interface and tools to quickly and easily write data from Microsoft Excel workbooks. Create, delete or modify one or more setups on each worksheet, then load secure data straight into JDE without having to leave Excel.
Save Time and Resources with Spreadsheet Writeback for JDE
- Intuitive Uploading – Data entry, data updating and reporting utilizing Microsoft Automation
- Empower Users – Leverage JD Edwards EnterpriseOne Orchestrations with no additional programming necessary
- Safe and secure – Inherits all existing JDE security, and includes data validation using standard JDE warnings and error messages
- Reduce manual intervention – Reduce IT development time while providing centralized controls
Load data back into JD Edwards
Spreadsheet Writeback uploads data into JD Edwards through EnterpriseOne Orchestrations. Easily create templates for specific uses throughout the JD Edwards modules in order to securely upload and update data, including but not limited to Accounts Payable invoice uploads and supplier maintenance, Accounts Receivables transactions and customer maintenance, General Ledger journals and budgets, Inventory transactions and maintenance, Human Capital Management, Project and Task uploads and much more.
Leverage JD Edwards EnterpriseOne Orchestration functionality
Any data can be uploaded back to JD Edwards. EnterpriseOne Orchestration interfaces easily with any standard or custom JDE application, securely processing data and allowing users to auto-populate fields based on their Orchestrator entries. All without ever leaving Excel.
|Minimum Software Requirements|
|Windows XP Professional Service Pack 1|
|SQL Server 7.0 Service Pack 4|
|SQL Server 2000 Service Pack 4|
|SQL Server 2005|
|MS Data Transformation Services (DTS) on client machines for any user processing data to SQL Server Data Marts. This includes Database Manager, Budget Writeback and all filter products. Version and service pack level must be the same as the server. Install DTS by installing Client Connectivity from SQL Server Client tools|
|Oracle 10g for Windows: Oracle Client 9.2 or higher installed on all clients</li><li>For Oracle sites, SQL Plus must be installed on any machine where a database will be generated with new or updated account parts. Typically install on machines that will have Database Manager and Profile Management installed. The version of SQL Plus must be the same as the server|
|For Oracle sites, SQL Plus must be installed on any machine where a database will be generated with new or updated account parts. Typically install on machines that will have Database Manager and Profile Management installed. The version of SQL Plus must be the same as the server|
|For Oracle sites where source and target data is not contained in the same database, it is highly recommended that SQL Loader be installed on any machine running filter processes. This allows for best performance of filter processing. If SQL Loader does not exist the application will still run using slower data transfer methods. (See 'Guidelines for Permissions and Database Configuration' in the 'Analyst Suite Readme.chm'' file for more information.)|
|IBM DB2 UDB for Windows Version 8: DB2 Run-Time Clients 8.1 with fixpack 4 installed on all clients|
|IBM DB2 UDB for Windows Version 8.2: DB2 Run-Time Clients 8.2|
|MDAC 2.6 Service Pack 1 or later required on client and server machines. MDAC version is controlled by the operating system in later versions of Windows|
|Excel 9 from Office 2000 (Service Pack 1)|
|Excel 10 from Office XP|
|Excel 11 from Office 2003|
|Excel 12 from Office 2007|
Client Hardware Requirements
Hardware requirements follow the recommendations for the Operation system, Microsoft® Office version and database platform
Frequently Asked Questions
View a listing of Technical Requirements for Spreadsheet Writeback for JDE.