Manage active lot quantities

The Active Lot Quantities page provides a comprehensive view of lot-level inventory with potency and inspection status information. This page integrates with the extension to display lot-specific potency values and calculates active inventory based on these potency factors.

This page is read-only and displays data from the Aptean Advanced Attributes extension. Potency values are managed through the advanced attributes setup and lot attribute assignments, not directly on this page.

• The target potency or specification value defined for the item in Advanced Attributes configuration. This represents the expected or desired potency level.
• The actual tested potency value assigned to the specific lot through Advanced Attributes. This value comes from Certificate of Analysis (COA) testing results.
• The physical inventory quantity adjusted by the potency factor.
• Lots are displayed with inspection status codes that indicate availability. Black or olive colors indicate available lots; red indicates blocked lots.

View active lot quantities

You can view all active lot quantities to check potency values and availability across your active ingredient inventory.

On the Active Lot Quantities page, you can view the displayed lot information:

Field	Description
Item No.	Specifies the item number of the production component.
Location Code	Specifies the location code of the production component.
Lot No.	Specifies the lot number of the item.
Inspection Status Code	Specifies the inspection status of the lot number. Black and olive colors indicate available lots; red indicates blocked lots.
Variant Code	Specifies the variant code of the item.
Inventory	Specifies the physical inventory quantity of the lot.
Active Inventory	Specifies the active inventory of the lot (physical quantity adjusted by potency factor).
Target Attribute Value	Specifies the target attribute value (potency specification) from advanced attributes.
Actual Attribute Value	Specifies the actual attribute value (tested potency) from advanced attributes.
Total Quantity	Specifies the total quantity of the item in inventory across all locations.
Total Requested Quantity	Specifies the total quantity requested in all documents.
Current Pending Quantity	Specifies the quantity selected on the document but not yet committed to the database.
Total Available Quantity	Specifies the quantity available for request.
Current Reserved Quantity	Specifies the quantity reserved for the current line.
Total Reserved Quantity	Specifies the total quantity reserved on documents or entries.
Qty. to Handle	Specifies the physical quantity to handle for the lot.
Active Qty. to Handle	Specifies the active quantity to handle (adjusted by potency).
Could Use	Specifies how much can be pulled from that lot to contribute to the remaining required active amount.

You can view the Totals section with the following information:

Field	Description
Active Ingredient Quantity Required	Specifies the active ingredient quantity required for the current operation.
Active Qty. to Handle	Specifies the total active quantity to handle across selected lots.
Remaining Active Qty. to Handle	Specifies the remaining active quantity still needed.
Qty. to Handle	Specifies the total physical quantity to handle.

You can use filters to find specific lots:

• Filter by Item No. field to see all lots of a specific active ingredient.
• Filter by Location Code field to see lots at a specific location.
• Filter by Inspection Status Code field to show only available or blocked lots.

The Active Inventory and Active Qty. to Handle fields automatically calculate based on the potency factor from advanced attributes.