Thursday, October 25, 2018

Inventory Module Inventory Miscellaneous Transactions

Inventory Miscellaneous Transactions

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.
Inventory Miscellaneous Transaction
Miscellaneous Receipt:
Inventory Miscellaneous Transaction
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.
Inventory Miscellaneous Transaction
In Type filed “select Miscellaneous receipt” as shown below and click button “Transaction Lines”
Inventory Miscellaneous Transaction
Enter Item, Sub inventory, Locator, UOM, Quantity, Account and click “Lot/Serial” button
Inventory Miscellaneous Transaction
drag scroll bar towards right to see more fields
Inventory Miscellaneous Transaction
Enter serial that you would like to assign. In this example we are receiving quantity 1 so we need only one serial number.
Inventory Miscellaneous Transaction
Click Done and Save your transaction.
Check on-hand quantity now.
Inventory Miscellaneous Transaction
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.
Inventory Miscellaneous Transaction
Click Transaction Lines
Inventory Miscellaneous Transaction
Enter item, sub inventory, Locator, UOM, quantity, Account and click on Lot / Serial button
Inventory Miscellaneous Transaction
Enter serial number and click Done.
Save your transaction.
Check on-hand quantity now to see the change.
Inventory Miscellaneous Transaction

No comments:

Post a Comment

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...