Flourish Inventory

Updated 6 days ago by John Shea

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:

  • Locked
  • Allocated
  • Used as an input to a manufacturing run in progress

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.

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.


How did we do?