To enter Material Transactions, click on the ‘New Sheet’ button from the ‘Material Transaction Wizard’ ribbon.
You are now ready to create Material Transactions.
Methods of Entering Data into the Worksheet
There are three ways to populate information in the worksheet:
a)Import a file, type or paste data directly into the cells provided. No validation is performed until you run the upload or open the data-entry forms.
b)Use the data-entry forms (Material Transaction Header, Material Transaction Line, Material Transaction Item Lot, Material Transaction Item Serial, Material Transaction Item Serial Lot and/or Material Transaction Average Cost Elements forms), to enter the data into the worksheet. Information is validated and lists of values are available.
c)Use the ‘Download Material Transaction History’ form or ‘Download using sheet data’ to download existing material transactions and associated components. You can then use one of the methods above to update information prior to loading into Oracle.
The following sections will describe each of the forms within Material Transaction Wizard and the additional functionality for loading material transactions.
