Material Transaction Wizard
Material Transaction Wizard is an Excel based front-end for the Oracle Miscellanous Transaction Form. This program contains the validation and defaulting rules of the Oracle forms plus the capabilities made possible by our popular spreadsheet model. You can download transactions from within Oracle as the basis for your new Material Transactions and employ the features of Excel to help prepare your data. Material Transaction Wizard is an ideal tool for quantity on hand data conversion and data migration.
Features
- Optional Data Entry forms, which include data validation and full List of Values capability
- Load one, a selected range or all Material Transactions from the worksheet
- Add a custom Account Generator to each of your transactions
- Supports Lot and Serial Transactions, including all WMS descriptive flexfield columns
- Supports Wip Job Component Issues and Receipts
- Supports Average Cost Updates
- Upload Material Transactions from the toolbar either online or as a background process, transacting via the material transaction processor
- Error messages are returned to the worksheet so there is no need to go into Oracle Applications to check the transaction status.
- Can use formulas in place of values
- Use multiple sheets and even operate on sheets in other workbooks
This program uses the standard Oracle Material Transaction Interface Table. Installation can be performed in minutes by your DBA.
Compatible with Excel 2000 and later versions, on any operating system.
Connects to Oracle E-Business Suite from Release 11i onwards, on any platform (contact us if you require a version for 11.5.9).