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.