We developed this tool in response to demand from Oracle Payables users for a user friendly and robust spreadsheet tool to load AP Invoices into the Oracle Payables module.
AP Invoice 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 Open Interface table for AP invoices. It does NOT modify any other Oracle objects except during the installation, where it adds the More4apps Batch Source.
Features
All options are available on a ribbon. Double-clicking in the spreadsheet also loads the forms. The forms are optional and you can simply type, import, or paste the values into the spreadsheet.
You can upload Invoices one at a time, or your entire worksheet.
The program is flexible about the spreadsheet layout. You can move, delete, or hide unwanted columns. You can also have multiple sheets or even sheets in other workbooks.