Material Transaction Line
This set of columns provides the Material Transaction Lines information.
To enter Material Transaction Line details double-click in the ‘Transaction Lines’ section of the worksheet below row 10, or choose the ‘Material Transaction Line’ form button from the Material Transaction Wizard ribbon.
Or alternatively you can press ‘<<Header’ to be transferred to the ‘Material Transactions - Header’ Form. Press the ‘Cancel’ button if you wish to revert to the values at the time you opened the form.
The following form will display:
Enter the required information:
LPN
Receipting and Issuing both have certain scenarios which you may come across.
Receipting:
• Receipting into an empty LPN – Once the LPN number has been entered, you will designate the Subinventory (must be LPN enabled) and Locator where this LPN will be stored. If uploading multiple items into an LPN, all Subinventory/Locator fields must match.
• Receipting into an LPN with items already assigned – Once the LPN number has been entered, the Subinventory and Locator will automatically populate and should not be changed. If they are changed for any reason, uploading will result in an error.
Issuing:
• Issuing an empty LPN – This cannot be done. This will cause an error to occur.
• Issuing an LPN with items assigned – When the LPN number is entered into the lines form, the Subinventory, Locator and UOM fields will be populated automatically and no further information is required in this form (except Account#, if not entered in the header form).
• If issuing into a Subinventory that is not LPN enabled, the LPN will unpack automatically.
Note – Lot and Serial transactions are not currently available for use with LPN functionality.
Item
Enter an inventory item to issue or receive, then click the ‘
’ button. If your transaction is a WIP Job completion then the item defaults from the WIP Job assembly and cannot be changed. If you are transacting a WIP Component Transaction then you are warned if the component doesn’t exist for the WIP Job.
Revision
Enter the Revision for the item to issue or receive. You must enter a value in this field if the item is under revision control.
Subinventory
Enter a Subinventory. For an issue transaction, you cannot enter a Subinventory that does not have Quantity Tracking turned on.
Locator
You must enter a value here if you established locator control for the item.
Quantity
Enter the Quantity of the inventory item to issue or receive, based on the unit of measure you specified. You can only enter a quantity greater than the available quantity if Negative Inventory is allowed for the Organization you are transacting in.
For WIP Job Completion transactions the available quantity is based on the quantity in the ‘To Move’ step of the last operation. For all other transactions it is the quantity available to transact, which differs from the on-hand quantity as the on-hand quantity doesn’t include reservations.
Unit of Measure
By default this is the primary unit of measure. However you can choose other units of measure, except in the case of a WIP Job Completion.
Unit Cost
If using average costing, optionally enter the unit cost of the item to receive or issue. Leave this field blank to use the system average cost at the time of the transaction. This is only applicable to some transactions.
Reason
Optionally, enter a reason code for the transaction.
Reference
Optionally, enter up to 240 characters of free text that describe the transaction.
General Ledger Account and Transportation Cost
This is the Account to charge for the item to use in the transaction. If a default account is entered in the transaction header then it defaults to the account code in the lines form. If this field is blank then the custom account generator is invoked (Optional).
For inter org transfers you must enter a Transportation Cost, the account is used for the transportation cost, not for the cost of the material transaction itself. This is defined by the shipping network and intercompany accounting functionality in Oracle.
Note: You can change or default this account only for miscellaneous issue/receipt or user–defined transaction types or inter org transfers with a transportation cost.
Operation Sequence
If you are transacting a WIP Component Issue/Receipt then the ‘Operation’ field is required. The list of operations for the WIP Job is available in the drop-down list.
If you are completing a WIP Job then the last operation defaults into this Operation field and cannot be updated.
Final Completion
The Final Completion check box is enabled for WIP Job Completion transactions. Check this box if the transaction is the final completion you are making.
Subinventory To
If you are transacting a Subinventory Transfer you must enter the ‘Subinventory To’. This is the subinventory where the goods will be received into.
Locator To
As per the locator field, if the subinventory is locator controlled then you must enter a location.
Once you have entered your data, click the ‘Ok’ button to transfer the information back to Excel. Click the ‘Cancel’ button if you wish to revert to the old values.
Refer to section:
