How to use the Cannabis Compliance Diagnostic Report

The report can be used to identify any missing values in your compliance data.

Column	Definition	Relevant Jurisdictions
Store/Location	The retail store where the report activity occurred.	-
Store SKU	The SKU associated with the product in GT.	-
Product	The name of the product as it appears in the GT Backend.	-
Compliance Code	The unique Universal Product Code (UPC) assigned to cannabis products.	Manitoba, Ontario
Supplier SKU	The unique product identifier assigned to cannabis products purchased from the supplier.	Alberta, Manitoba, Ontario, Yukon
POS Equivalent Grams	The grams that count towards the 30-gram legal purchase limit.	ALL
Compliance Weight	The weight that is referenced in the Health Canada and Stats Canada reporting.	British Columbia, Saskatchewan, Manitoba
Opening Inventory	The inventory level, in units, of a SKU at the start time of the reporting period.	-
Purchases from Suppliers (Additions)	The total number of units purchased and received into the inventory within the reporting period.	-
Returns from Customers (Additions)	The total number, in units, of a SKU returned by retail customers to a retail store in the reporting period.	-
Other Additions (Additions)	The total number of a SKU, in units, added to inventory that does not fall within the scope of purchases or returns from customers plus unaccounted/unreconciled physical inventory overage variance.	-
Sales (Reductions)	The total number of a SKU, in units, sold to customers in the reporting period.	-
Destruction (Reductions)	The total number, in units, of a SKU that has been destroyed in accordance with the governing standards.	-
Theft (Reductions)	The total number, in units, of a SKU that was subject to theft within the reporting period.	-
Returns to Suppliers (Reductions)	The total number, in units, of SKU that is returned to and physically received and acknowledged by the Supplier, within the reporting period.	-
Other Reductions (Reductions)	Any reduction(s) to inventory that does not fall within the scope of product sold, product destroyed, lost/stolen products, or returned to supplier.	-
Closing Inventory	The inventory level, in units, of a SKU at the end time of the reporting period.	-
Product URL	Quickly access the product by clicking the URL.	-
Inventory Transactions URL	Quickly access the entire transaction history for a product by clicking the URL.	-

What to do if values are missing?

Missing values in the Diagnostic Report indicate there is incomplete compliance data in your GlobalTill database.  Use the below guide to locate the blank data field(s) in the GT Backend and enter any missing information.

Compliance Code in a single store environment

• Look up the product in GlobalTill.

• Select Actions > Edit Product.

• Select the Other tab.

• Enter the Compliance Code in the Compliance Code field.

Compliance Code in a multi-store environment

• Look up the product in GlobalTill.

• Select the Supplier Info tab.

• Select Update on the relevant Supplier Card, e.g.:

  • Missing Compliance Codes in the AGCO diagnostic report are updated via the Compliance Code field on the OCS Supplier Card

  • Missing Compliance Codes in the LGCA diagnostic report are updated via the Compliance Code field on the MBLL Supplier Card, etc.

• Enter the Compliance Code in the Compliance Code field.

Supplier SKU

• Look up the product in GlobalTill.

• Select the Supplier Info tab.

• Select Update on the relevant Supplier Card, e.g.: 

  • Missing Supplier SKUs in the AGCO diagnostic report are updated via the Supplier Product Code field on the OCS Supplier Card 

  • Missing Supplier SKUs in the AGLC diagnostic report are updated via the Supplier Product Code field on the AGCO Supplier Card, etc.

• Enter the Supplier SKU in the Supplier Product Code field. 

POS Equivalent Grams

• Look up the product in GlobalTill.

• Select Actions > Edit Product.

• Select the Other tab.

• Enter the POS Equivalent Grams in the Equivalent g field.

Compliance Weight

• Look up the product in GlobalTill.

• Select Actions > Edit Product.

• Select the Other tab.

• Enter the Compliance Weight in the Compliance Reporting Weight field.