Showing posts with label Inventory. Show all posts
Showing posts with label Inventory. Show all posts

Sunday, 11 April 2021

Move order Tables?

MTL_TXN_REQUEST_HEADERS
Move order headers, this stores the move order number in column (REQUEST_NUMBER). It has a status, but this is not used as much as the lines status to drive functionality.


MTL_TXN_REQUEST_LINES
Move order lines, this is the one that drives most queries and status checks for the move order as each line can be transacted individually.

 

MTL_MATERIAL_TRANSACTIONS_TEMP
Pending material transactions table also called the transaction temporary table, this holds allocations that act like reservations on inventory. An allocation is where you pick a specific item in inventory down to the lot, locator, serial, revision to move, but you do not actually perform. The move yet.

Field move_order_header_id and move_order_line_id provided in this table, which related to

MTL_TXN_REQUEST_HEADERS and MTL_TXN_REQUEST_LINES.


MTL_MATERIAL_TRANSACTIONS
This is the store of transact move order transactions. And there were some queries related with it.

 

For some additional notes:

When a move order is allocated, a corresponding record is inserted into the pending table (MTL_MATERIAL_TRANSACTIONS_TEMP as well as lot/serial tables if required).

 

When the move order is transacted, the record moves from the pending table to the history table (MTL_MATERIAL_TRANSACTIONS).


Sunday, 27 November 2016

How many types of Inventory Controls:



Four Types of controls are there.
Serial Control.
Lot Control.
Stock Locators
Revision Control.

Consigned Inventory (CI):

Consigned Inventory is used to manage at the third party location, supplier places inventory in customer’ stores or warehouse and allows them to sell or consume it. Customer purchases the stock only after he sells the stock or consumes it.

Vendor Managed Inventory (VMI)



Vendor is responsible for maintain the stock levels.

What are Restrict Sub inventories and Restrict Locators?



Restrict Sub inventories: By using this can restrict item’s to specific sub inventory.
Restrict Locators: By using this can restrict item’s to specific sub inventory under specific locator.

What is the difference between Expense Item and Asset Item?




Expense Item
Asset Item
Costing flag is not enabled
Costing flag should be enabled
Inventory Item flag not enabled
Inventory item flag should be enabled