Set up active potency
You can set up a unique identifier for the potency attribute that the system must display as a lot of attribute for active quantity calculations.
To set up active potency tracking, follow these steps:
- Select the Search icon
, enter Advanced Attribute Setup, and then choose the related link.
The Advanced Attribute Setup page opens. -
On the General FastTab, in the Active Potency Lot Attribute field, select a lot attribute with Type field set to Decimal.
If the Active Potency Lot Attribute field value is left blank, active quantity calculation cannot be executed.
You can view the selected Active Potency Lot Attribute field value for production documents on the Lot Attribute Values page.
Configure on-hand tracking
You can configure the system to display active quantity on hand based on potency levels, enabling production planners to make informed decisions for sensitive formulas.
Calculate the active quantity for the selected items.
The system automatically calculates and displays the Active Quantity On Hand field value on the Lot No. Information List page using the following formula:
Active Quantity = Quantity On Hand × (Actual Potency / Target Potency)
The calculation process and related conditions,
Uses the Unit of Measure field value to find the related Item Unit of Measure conversion against the base unit of measure.
Multiplies the Quantity On Hand field values with the potency factor.
For Example: If the item's unit of measure setup has the target potency at 95% and the lot has an actual potency of 90%, and the quantity on hand is 10, then:
- Active Quantity = 10 × (90/95) = 9.47
- If the item unit of measure setup does not exist, the system does not calculate any value.
- If the unit of measure is not set up in the lot attribute, the system does not calculate any value.
The on-hand tracking is configured to show active quantities based on potency levels, allowing production planners to filter and select lots based on their active ingredient content.