Skip to main content

Depot inventory by lot

A packaging lot is a batch of items that can belong to different product units but are collected into one package to be released (shipped) to the depot or for other logistic purposes. Thus, it is very convenient to have the inventory statistics organized by lots, so that to analyze how many items of each lot are accounted for in the depot.

The data in the By Lot table can be organized by product units or container units based on your study configurations.

Important

If no container units are configured in IWRS, then all operations in Inventory occur in product units.

Depot inventory statistics by lot
Figure 1. Depot inventory statistics by lot

Each value in the By Lot table that is not zero is an active link that you can select to navigate to the By Item tab for more detailed statistics on the items of a certain disposition.

In the following table, you can find the description of each element of the By Lot tab.

Element

Details

Shipping Unit/Product

Switch between these filters to display the inventory statistics either by both shipping units (containers and products) or only by products.

This filters are only available if container units are configured for your study.

Category

Represents one of the following:

  • Product: the item is a preconfigured product unit, the name of which you can see in the Item Unit column.

  • [Container category]: the item is a container unit. The container category names are configured upon adding container units to the system, for instance, Large Box and Medium Box.

Item Unit

Represents the name of the product.

The item units are not displayed for container units as they are enclosed within the container.

Shipment Buffer (Days)

Represents the buffer period in days set for the shipment of the product or container unit to prevent untimely drug expiry.

You can set the shipment buffer via the TREATMENT DESIGN > Supply Setting functionality.

Lot Number

Represents the identifier of the packaging lot to which the product or container unit belongs.

Expiration Date of Lot

Represents the default expiration date of the packaging lot to which the product or container unit belongs.

Total Number at Depot

Represents the total number of product or container units that are currently at the depot in various dispositions excluding the items of the Destroyed disposition.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed.

Available

Represents the number of product or container units that are available for shipment.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the Available disposition.

Expired

Represents the number of expired product or container units.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the Expired disposition.

Lost

Represents the number of lost product or container units.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the Lost disposition.

Quarantined

Represents the number of quarantined product or container units.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the Abnormal group of disposition.

Damaged

Represents the number of damaged product or container units.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the Abnormal disposition.

Pending Disposal

Represents the number of product or container units that have to be returned or are ready to be destroyed.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the Pending Disposal disposition.

Dispensed

Represents the number of product or container units that are dispensed from the depot.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the Dispensed disposition.

In Transit

Represents the number of product or container units that are currently transferred to different depots, sites, or elsewhere.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the In Transit disposition.

Returned

Represents the number of product or container units that are returned to the supplier by the depot.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the Returned disposition.

Destroyed

Represents the number of product or container units that are destroyed by the depot.

Select this number to go to the By Item tab, where the statistics for the item unit are displayed and filtered by the Destroyed disposition.

Important

There can be more columns in the table if any custom item dispositions are created for your study.

In this section:

An investigational product that is used in a study. In eClinical, it can be viewed as an equivalent to a drug name to distinguish items at all stages of their lifecycle—manufacturing, shipment, dispensation to subjects, or else.

Another name for the product unit in the IWRS system is item unit.

A warehouse that is used to store and distribute items (drugs) to another destination (other depots or sites).

container units

A batch of items collected into one package for shipment or other logistic purposes. Using packaging lots with their unique lot numbers gives depots and sites the ability to differentiate between different batches of drugs to track, for instance, release and expiration dates or other useful information.