As the name implies “Inventory Miscellaneous Transactions” are used for Miscellaneous reasons. Primarily we create Miscellaneous Receipts and Miscellaneous Issues to adjust the inventory on-hand quantity when actual quantity doesn’t match with the quantity represented by ERP system, Oracle Apps.

Business Scenario – 1: Actual quantity available in warehouse is more than on-hand quantity in the ERP system. In this case we need to increase the on-hand quantity in ERP system with out purchasing the item or manufacturing the item.

Let’s check current on-hand quantity of the item, erps_serial in M1 organization. This item, erps_serial is a locator controlled and serial controlled item but not Lot controlled item.

Miscellaneous Receipt:

In Inventory module every transaction is tied to a particular warehouse or organization. So select the Organization as M1 (not B1 in this example) and move forward.

In Type filed “select Miscellaneous receipt” as shown below and click button “Transaction Lines”

Enter Item, Sub inventory, Locator, UOM, Quantity, Account and click “Lot/Serial” button

drag scroll bar towards right to see more fields

Enter serial that you would like to assign. In this example we are receiving quantity 1 so we need only one serial number.

Click Done and Save your transaction.

Check on-hand quantity now.

You can see the increase in on-hand quantity.

Business Scenario – 2: Actual warehouse quantity is less than on-hand quantity in the ERP system. So we need to decrease the on-hand quantity in the system.

Miscellaneous Issue:

Navigation: Inventory responsibility > Transactions > Miscellaneous Transaction

Select “Miscellaneous Issue” in Type field.

Click Transaction Lines

Enter item, sub inventory, Locator, UOM, quantity, Account and click on Lot / Serial button

Enter serial number and click Done.

Save your transaction.

Check on-hand quantity now to see the change.