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:

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.

  • 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.

  • 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.