We developed this tool to meet the demand from Oracle Receivables users seeking a user-friendly and robust Excel-based solution for loading transactions into the Oracle Receivables module using the public APIs.
It's important to note that the Oracle Public APIs only support the creation of transactions in the Transaction Workbench. To date there hasn't been any release of an Oracle Public API that supports updates.
The AR Invoice Wizard is a VBA program integrated into a Microsoft Excel workbook. It shares the same user interface as our other 'Wizard' products for familiarity and ease of use.
Features
All options are conveniently accessible via ribbons. Double-clicking in the sheet opens the appropriate data entry form, although these forms are optional as data can also be typed, imported, downloaded or pasted directly into the sheet.
Transactions can be uploaded individually, selected individually, or in bulk with the entire contents of your worksheet as each mode allows.
The Wizard layout is flexible, allowing you to move, delete, or hide unwanted columns. It supports multiple sheets within the Wizard and referencing data in other workbooks using formulas.
