P.O. Wizard
P.O. Wizard is an Excel based tool that provides an alternative to the Oracle Purchase Order data entry form. It speeds up the process of entering data into Oracle Purchasing, while providing in-built validation to ensure accuracy.
The program contains all the validation and defaulting rules of the Oracle forms plus the Template and bulk-loader capabilities made possible by our popular spreadsheet model. You can download existing data from Oracle as the basis for your new Purchase Order, and employ all the usual features of Excel to help prepare your data.
Benefits
- Increases productivity and accuracy
- Fast, easy to use and flexible
- Harness the full power of MS Excel to make purchase order data entry tasks a breeze
- Configures itself to your system set up
- Cuts down data-entry time
- Eliminates re-keying errors
- Lets you automate purchase order preparation
- Robust integration between Excel and Oracle
- Close to zero implementation effort
Features
- Optional Data Entry forms, which include data validation and full List of Values capability
- Load Standard Purchase Orders and Blanket Purchase Agreements
- Load an individual Purchase Order Line, a selected range, or all lines on the worksheet
- Load One Purchase Order per sheet or multiple Purchase Orders within a sheet
- Add lines to existing Standard Purchase Orders and Blanket Purchase Agreements
- Modify existing lines in Blanket Purchase Agreements
- Submit Purchase Order Import from the toolbar and refresh the spreadsheet to view the result
- Use multiple sheets and even operate on sheets in other workbooks
- Optionally, customize your Lists of Values to restrict usage
This program uses the standard Oracle Purchase Order Interface tables. Installation can be performed in minutes by your DBA.
Compatible with Microsoft Excel 2000 and later versions, on any operating system.
Connects to Oracle E-Business Suite Release 11i onwards, on any platform.