Purchase Order Wizard

×
Menu
  • About PO Wizard

About PO Wizard

 
 
 
 
Welcome to PO Wizard.
 
We have developed this tool to help with the data conversion process of purchase orders and to provide an alternative to the Oracle Applications Purchase Order data entry form.
 
PO Wizard is a VBA program embedded in a Microsoft Excel workbook.  It is a close cousin to our other ‘Wizard’ products and shares the same look and feel.
 
The software interfaces with the standard Oracle Purchasing Documents Interface. It does NOT modify any Oracle objects.
 
Features
 
Optional Data Entry forms, which include data validation and full list of values capability.
 
Load Standard Purchase Orders, Complex Purchase Orders, Blanket Purchase Agreements and Contract Purchase Agreements.
 
Load 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.
 
Load additional Lines/Shipments and Distributions to existing Standard Purchase Orders and Blanket Purchase Agreements.
 
Load additional Lines and Price Breaks to existing Quotations.
 
Modify existing data for Standard Purchase Orders and Blanket Purchase Agreements.
 
‘Close’, ‘Finally Close’ or ‘Cancel’ Purchase Orders, Lines and/or Shipments.
 
Submit Purchase Order Import from the ribbon and refresh the upload status with any Oracle rejection errors.  Error messages are returned to the worksheet so there is no need to go into the applications to check the import status.
 
Delete individual Purchase Order Lines or Distributions from the interface tables based on the Interface ID and Dist ID column values.
Update Lines, Shipments and Distributions in the interface tables prior to submitting Purchase Order Import Program.
Use multiple sheets and even operate on sheets in other workbooks.
Download requisitions from Oracle to be approved/altered and uploaded back to Oracle as Purchase Orders.
 
This documentation is written with the assumption the user knows how to create a Purchase Order manually and understands from a functional point of view how the purchasing documents open interface works. 
 
We highly recommend you read this document in conjunction with the following:
 
     Oracle Purchasing Users Guide, Section 4 and Section 9
     APIs and Open Interfaces Manual, Section 10, Purchasing Documents Open Interface
 
This product is supported on most versions of E-Business suite from 11.5.10.2 onwards.  Please reference our compatibility section for further details:  https://more4apps.com/support/what-we-support
 
If you encounter any problems or have any suggestions, please do not hesitate to contact us at https://more4apps.com/support/new-support-request