Inventory Reporting
You can use Inventory Reporting to generate all kinds of reports and inquiries about inventory, specific inventory transactions, and cumulative item issue by period and warehouse. You can also record the current inventory position at various inventory levels and multiple entities.
The inventory position is recorded at the following inventory levels:
- Item
- Warehouse
- Location
- Inventory date
- Lot
- Serial Number
Inventory is displayed for the following entities:
- Multi-company inventory
- Projected inventory
- Rejected inventory
- Consignment inventory
- Negative inventory
- Committed inventory
You can use Lot Control to trace the origin of the incoming and outgoing lot and serialized items and find the location where they are used.
Transactions that influence inventory positions or movements in a warehouse are recorded and archived. You can use this information to track and trace the inventory movement.
-
Negative inventory
Negative inventory is displayed for a specific entity. If you allow negative inventory, you can deliver goods for an order when goods are physically available, but not yet registered in LN.
-
Pegged inventory
You can define safety stock for mandatory project pegged items, and planning can be performed for pegged safety stock. You can view and maintain project pegged safety stock in the Safety Stock by Project Peg (whwmd2114m000) session.
-
Quarantine inventory
You can use LN to store and handle rejected goods in a quarantine warehouse. Rejected inventory can also be stored and handled in a specific location, which is called a reject location. LN handles rejected inventory against the specification as determined in the original purchase order and purchase order line.
-
Quarantine inventory payable to supplier
Quarantine inventory payable to supplier is an alternative method to handle quarantined inventory. After you receive an initial rejection for received items, you can manage follow-up activities such as scrapping, reworking, returning, or using the inventory "as is."
-
Lot control
Lot control enables you to trace the origin of incoming and outgoing lots, and to find out where these lots are used. You can record information about each lot, such as lot number, buy-from business partner, manufacturer, and certificate number. This information is used for quality assurance. If the item is not lot controlled, effectivity units are not recorded in the warehouse inventory.
In general, expensive items are produced and handled in relatively low quantities, whereas the goods flow of less expensive items involves higher quantities. In LN, this concept is modeled in the low volume and the high volume scenarios that provide various options to register and track lot and serialized items.
-
Lot price by enterprise unit
Lot prices can be determined by enterprise units.
When a lot is received in a warehouse, the enterprise unit of the warehouse is linked to the lot. Therefore, multiple enterprise units can be present for a lot if the items belonging to a particular lot are received in warehouses belonging to different enterprise units. For each enterprise unit linked to the lot, pricing and other lot data can be different.
-
Serialized items
The need to track items by means of serial numbers arises from the items' cost. The more expensive the item, the more closely you want to monitor the item during its life cycle.
In general, expensive items are produced and handled in relatively low quantities, whereas the goods flow of less expensive items involves higher quantities. In LN, this concept is modeled in the low volume and the high volume scenarios that provide various options to register and track lot and serialized items.
-
Inventory in transit
Inventory in transit includes goods in transit and in-transit inventory.
Goods in transit are purchased items listed on ASNs related to purchase orders or purchase schedules that are issued by the supplier but have not yet been received in the own warehouse.
In-transit inventory is inventory listed on transfer orders that is issued from the ship-from warehouse but that is not yet received in the ship-to warehouse.
-
Printing in-transit inventory
The Print In Transit Inventory (whinr1410m300) session is used to print overviews of inventory that is on its way from one warehouse to another. The report displays item quantities listed on transfer orders. The items are issued from the origin warehouse but have not yet been received in destination warehouse. These items are loaded onto trucks or other means of transport, or located at pooling points such as harbors or airports.