Flourish Inventory
Overview
Flourish is your source of truth for all your Inventory, whether cannabis/hemp or non-cannabis/hemp. You'll find Inventory on the left menu for any facility type in your setup.
When you first enter the Inventory grid, you'll see all your cannabis and hemp packages with a unique Package ID for each. Each package is an item in your Item Master. There can be multiple packages of an item; if you're using lot numbers, various packages can be part of the same lot, even if they are different items.
By navigating to the top left under Inventory, find different views, including All Inventory which displays all items within Inventory (cannabis/hemp, supplies, raw materials). The default view is All Packages.
View only Available Only (unconsumed) inventory or All inventory:
Definitions
Each inventory line item under the "All Inventory" view will have multiple columns for quantities:
Column Name | Definition |
Qty | Total quantity for this item in the system. |
Locked | Total quantity that are locked and unavailable for use. Learn more about Managing Inventory Lock Codes. |
On Order | Total "ordered' - the quantity that is 'Ordered' on all sales orders not yet shipped. |
Allocated | Total quantity that has been actually been allocated on all sales orders not yet shipped. |
Non-available | Total quantity that meets one or more of the following criteria:
|
Available | Qty minus Non-available. |
Sellable | The quantity that is available to sell based on the definitions above. In other words: The total available quantity of the item in the facility that is not already on order, allocated, locked, or otherwise reserved. Flourish calculates the sellable quantity for an item according to the rules on the lock code; i.e., if the lock code rule “Allow allocation to outbound order” is enabled, then the locked package’s QTY is included in the sellable QTY of the item. Learn more about Sellable quantity and locked packages. |
Total Packages | Number of total packages under the item. |
Average Total Unit Cost | Weighted average of all packages of an item * total qty |
Average Available Unit Cost | Weighted average of all packages available packages |
Total Available Cost | Average Available Unit Cost * Total Available Qty |
Total Non-Available Cost | Weighted average of non-available packages of an item * Non-Available quantity |
Total Cost | Total on hand qty * Weighted Average of all On Hand Packages of an Item |
Sellable quantity and locked packages.
Flourish calculates the sellable quantity for an item according to the rules on the lock code.
When packages are locked;
The calculation of Sellable QTY takes into consideration the “Lock Code Rules”:
If “Allow allocation to outbound order” = TRUE:
- The Sellable QTY calculation ignores the QTY that is locked. The locked QTY is NOT removed from the total ‘Sellable.’
If “Allow allocation to outbound order” = FALSE:
- The Sellable QTY calculation does not ignore the locked QTY. The locked QTY decreased from the ‘Sellable.’
Learn more about Managing Inventory Lock Codes.
Package Status
The status of packages represents their condition in the supply chain.
General Statutes - apply to all environments
- Created - The initial Status after a package is created in the facility
- Assigned to order - The package is assigned to an outbound order but has yet to leave the facility.
- Shipped - A package shipped out of the facility via an order or a transfer.
- Consumed - A package with its entire quantity was used, not adjusted to zero quantity.
METRC retaliated Statuses
- Archived - A package that got discontinued in METRC - after the sync from METRC
- Canceled - Undo Package - Remove a created package that is out of sync - Set the out-of-sync package's status to Cancelled and remove it from inventory.
BioTrack retaliated Statuses
- Scheduled for Destruction - A Pckages scheduled for Destruction as a part of the BioTrack Inventory Destruction Workflow.
- Destroyed - The package was destroyed as a part of the BioTrack Inventory Destruction Workflow.
Picked - No In Use
