We developed this tool in response to demand from Oracle Receivables users for a user-friendly and robust Excel based tool to load Invoices into the Oracle Receivables module using the public APIs.
Please note that that Oracle Public APIs only support creating invoices in the Transaction Workbench. No Oracle Public API has been released that supports updates.
AR Invoice API 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.
Features
All options are available on a ribbon. Double clicking in the sheet opens the appropriate data entry form. These forms are optional as you can simply type, import, or paste the values directly into the sheet.
You can upload invoices one at a time, individually selected invoices, or the entire contents of your worksheet.
The Wizard layout is flexible. You can move, delete, or hide unwanted columns. You can also have multiple sheets within the Wizard and even reference data in other workbooks using formulas.
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
The required data and layout is the same for Invoices and On Account Credit Memos. Applied Credit memos require different parameters. This will be detailed further in this document in the respective sections.
