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.

  • Rejected inventory

    You can use LN to store and handle rejected goods in a 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.

  • Inventory disposition

    Inventory disposition is an alternative method to handle rejected inventory. After you receive an initial rejection for received items, you canmanage 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. There are two types of lot control:

    • Lot control (in inventory)

      The lot control (in inventory) method offers a high level of detail. LN generates separate receipt lines, inbound advice lines, outbound advice lines, and shipment lines for each lot. The specific location of the lot in inventory is also known. This method can lead to a administrative burden if mistakes were made in the lot quantities. Therefore, this method is less suitable for high-volume, low-value items, such as nuts and bolts.

    • Lot control (not in inventory)

      Lot control (not in inventory) is a special form of lot control intended for high-volume, low-value items. If you apply lot control (not in inventory) for a particular item, LN does not record the inventory for each combination of lot, warehouse, and location. You can still record information about each lot, such as lot number, buy-from business partner, manufacturer, and certificate number information that is used for quality assurance.

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