Compliance Report Tips and Troubleshooting - Ontario Customers

This document will assist you in the basic troubleshooting and understanding of your Ontario compliance reports.

Did you know that the AGCO has a learning module for compliance reporting?

You can find it by clicking here AGCO Cannabis Retail Reporting E-Learning Module

Dashboard Inventory Settings

It is highly recommended that you toggle on Automatic restock for refunded cannabis products in your dashboard Settings > Inventory.

This will help resolve issues that cause a In Related cells: one = "0" & other not "0" error that will present itself when either a unit value or a wholesale dollar value is missing from the Returns from Customers columns of your monthly report.


Landing Page

If you would like your CRSA number(s) and location name(s) to automatically populate on the Landing Page and the Incoming and Outgoing Transfer sheets of your reporting template, populate the License ID field that can be found under Settings > Locations > Click into location > License ID in your BLAZE dashboard.

Ensure the format is correct - - CRSA1212121

Note that the location names which you see in this section of the dashboard will also appear in the Incoming and Outgoing Transfer sheets of your monthly compliance report only if interstore transfers have occurred in the reporting month.

These location names can be edited under Settings > Locations > Click into location > Location Name. After making edits, be sure to click Save beneath the Phone Number field.

Worksheet Dependencies

  • Every pair of columns (vertical rows) in your Federal sheet correspond to the unit value and wholesale dollar value for each of the column headers.

  • Cannabis products CANNOT be sold for $0.00. The minimum that the monthly reporting template will accept is $0.01 per unit.

  • All $CA columns in the Federal sheet are calculated using the wholesale unit value of the product, except for the Quantity Sold columns which are calculated based on the retail price at the time of sale.

  • Every column (vertical row) in the Federal sheet directly relates to another sheet in the reporting template, except for the Returns from Customer columns.

  • If manual changes are made to any cell on the Federal sheet (other than the Returns from Customer columns) then an equal change would need to be made on the corresponding sheet.

    • For example;

      • A change of 1 to 2 is made to the amount of Other Additions on the Federal sheet for an individual SKU from. You would also need to adjust the total of all entries of that SKU in the Inventory Adjustments sheet to match the new Other Additions total in the Federal sheet.

Inventory Adjustments Worksheet

  • The Inventory Adjustments sheet has a column called Balance Per Physical Count. The value of the Balance Per Physical Count column cannot be a negative value.

Destructions Worksheet

  • Every column of the Destructions sheet needs to be filled in except for the OCS Incident # if there wasn't one.

  • The Method of Destruction columns requires a moderately detailed description of how the product was destroyed.

Troubleshooting

My report isn't downloading and I keep getting a Status Fail: Please select location(s) in one time zone at a time error.

  • You can only select and report on locations if they are set to the same time zone.

  • Check your dashboard Settings > Locations > Click into location > Timezone to see if all your locations are within the same time zone.

  • Note that when a new location is created, BLAZE sets the timezone to PST by default.

I received an error message that a product is missing a barcode or SKU.

  1. Locate the product(s) in question in your dashboard product list and populate the missing data and save.

  2. Re-download your report and the missing data will be populated.

Why am I seeing an error saying that the SKUs/UPCs are not found in other sheets of the reporting template?

  • BLAZE records the SKU and barcode for all products at the time of inventory movements. If a SKU or barcode was changed during a month, you may see issues between your Federal sheet and Monthly Sales sheets for example.

  • To correct this you will want to edit all sheets containing the affected products in the reporting template to match the SKU and barcode that is on the Federal sheet.

I have a product that has a $CA Value of zero, but there are units in the adjacent cell.

  1. The product likely did not have a wholesale cost assigned to it when the compliance report was generated.

  2. Locate the product in your dashboard Product List and enter the wholesale unit cost.

  3. Re-download your report and the missing data will be populated.

I have negative opening and/or closing values, how do I fix this?

  • All negative inventory values should be audited to zero before 11:59 pm on the last day of every month.

What is the naming convention I need to use when I save my monthly compliance reporting file?

  • CRSANumber_CAN_MMYY

Note:

  • BLAZE always advises that stores to do a FULL INVENTORY AUDIT on all cannabis products during the last week of every month in order to ensure that their reported quantities are correct.

  • For security and accountability purposes, BLAZE cannot modify historical inventory values in your dashboard. As a result, it will be up to your store to explain the negative value to the provincial regulator and modify the template file manually before submission.