--- title: Dashboard | Compliance Report Tips and Troubleshooting - Ontario Customers description: Did you know that the AGCO has a learning module for compliance reporting? You can find it by clicking here Cannabis Retail Reporting E-Learning Module It is highly recommended that you toggle on Auto --- [Skip to content](https://help.blaze.me/can/home/tips#main-content) [![BLAZE-Logo-Blue.svg\]](https://help.blaze.me/hubfs/BLAZE-Logo-Blue.svg)](https://help.blaze.me/can/home?hsLang=en) - [BLAZE CAN Knowledge Base](https://help.blaze.me/can/home) Open main navigation Close main navigation - [BLAZE CAN Knowledge Base](https://help.blaze.me/can/home) Welcome to the Blaze Canada Knowledge Base! Find helpful reference by searching here... - There are no suggestions because the search field is empty. 1. [BLAZE CAN Knowledge Base](https://help.blaze.me/can/home?hsLang=en) 2. [Dashboard](https://help.blaze.me/can/home/dashboard?hsLang=en) 3. [Compliance](https://help.blaze.me/can/home/dashboard?hsLang=en#compliance) # Dashboard | 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](https://www.agco.ca/blog/cannabis/sep-2021/reminder-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. [![](https://help.blaze.me/hubfs/Knowledge%20Base%20Import/downloads_intercomcdn_comio557428082828ecd1507c9b134ffa911eaScreen+Shot+2022-08-03+at+2_36_45+PM-Jul-25-2023-05-27-36-8032-AM.png)](https://help.blaze.me/hubfs/Knowledge%20Base%20Import/Screen+Shot+2022-08-03+at+2_36_45+PM-Jul-25-2023-05-27-37-5730-AM.png?hsLang=en) ### 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. [![](https://help.blaze.me/hubfs/Knowledge%20Base%20Import/downloads_intercomcdn_comio5574125235dc3a8414415a1249f7fe9fdScreen+Shot+2022-08-03+at+1_02_37+PM-Jul-25-2023-05-27-38-6935-AM.png)](https://help.blaze.me/hubfs/Knowledge%20Base%20Import/Screen+Shot+2022-08-03+at+1_02_37+PM-Jul-25-2023-05-27-38-1362-AM.png?hsLang=en) ### 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** columncannot 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.   - [Getting started](https://help.blaze.me/can/home/getting-started?hsLang=en) - [Dashboard](https://help.blaze.me/can/home/dashboard?hsLang=en#main-content) - [General](https://help.blaze.me/can/home/dashboard?hsLang=en#general) - [Settings](https://help.blaze.me/can/home/dashboard?hsLang=en#settings) - [Products](https://help.blaze.me/can/home/dashboard?hsLang=en#products) - [Discounts](https://help.blaze.me/can/home/dashboard?hsLang=en#discounts) - [Inventory](https://help.blaze.me/can/home/dashboard?hsLang=en#inventory) - [Customers](https://help.blaze.me/can/home/dashboard?hsLang=en#customers) - [Employees](https://help.blaze.me/can/home/dashboard?hsLang=en#employees) - [Sales](https://help.blaze.me/can/home/dashboard?hsLang=en#sales) - [Purchase Orders](https://help.blaze.me/can/home/dashboard?hsLang=en#purchase-orders) - [Reports](https://help.blaze.me/can/home/dashboard?hsLang=en#reports) - [Compliance](https://help.blaze.me/can/home/dashboard?hsLang=en#compliance) - [POS (Tablet)](https://help.blaze.me/can/home/pos-tablet?hsLang=en#main-content) - [Getting Started](https://help.blaze.me/can/home/pos-tablet?hsLang=en#getting-started) - [General](https://help.blaze.me/can/home/pos-tablet?hsLang=en#general) - [Starting and Ending Shifts](https://help.blaze.me/can/home/pos-tablet?hsLang=en#starting-and-ending-shifts) - [POS Register](https://help.blaze.me/can/home/pos-tablet?hsLang=en#pos-register) - [POS (Browser)](https://help.blaze.me/can/home/pos-browser?hsLang=en#main-content) - [General](https://help.blaze.me/can/home/pos-browser?hsLang=en#general) - [Starting and Ending Shifts](https://help.blaze.me/can/home/pos-browser?hsLang=en#starting-and-ending-shifts) - [POS Register](https://help.blaze.me/can/home/pos-browser?hsLang=en#pos-register) - [BLAZE ECOM](https://help.blaze.me/can/home/blaze-ecom?hsLang=en#main-content) - [General](https://help.blaze.me/can/home/blaze-ecom?hsLang=en#general) - [ECOM Set-up](https://help.blaze.me/can/home/blaze-ecom?hsLang=en#ecom-set-up) - [Customization](https://help.blaze.me/can/home/blaze-ecom?hsLang=en#customization) - [ECOM Discounts](https://help.blaze.me/can/home/blaze-ecom?hsLang=en#ecom-discounts) - [SEO](https://help.blaze.me/can/home/blaze-ecom?hsLang=en#seo) - [BLAZEPAY](https://help.blaze.me/can/home/blazepay?hsLang=en#main-content) - [Getting Started](https://help.blaze.me/can/home/blazepay?hsLang=en#getting-started) - [General](https://help.blaze.me/can/home/blazepay?hsLang=en#general) - [BLAZEPAY Merchant Portal](https://help.blaze.me/can/home/blazepay?hsLang=en#blazepay-merchant-portal) - [Integrations](https://help.blaze.me/can/home/integrations?hsLang=en#main-content) - [General](https://help.blaze.me/can/home/integrations?hsLang=en#general) - [Payment Processing](https://help.blaze.me/can/home/integrations?hsLang=en#payment-processing) - [E-Commerce](https://help.blaze.me/can/home/integrations?hsLang=en#e-commerce) - [Data Analytics](https://help.blaze.me/can/home/integrations?hsLang=en#data-analytics) - [Menu](https://help.blaze.me/can/home/integrations?hsLang=en#menu) - [Other](https://help.blaze.me/can/home/integrations?hsLang=en#other) - [Hardware](https://help.blaze.me/can/home/hardware?hsLang=en#main-content) - [General](https://help.blaze.me/can/home/hardware?hsLang=en#general) - [Scanners](https://help.blaze.me/can/home/hardware?hsLang=en#scanners) - [Printers](https://help.blaze.me/can/home/hardware?hsLang=en#printers) - [Payments](https://help.blaze.me/can/home/hardware?hsLang=en#payments) - [BLAZE Sites](https://help.blaze.me/can/home/blaze-sites?hsLang=en#main-content) - [General](https://help.blaze.me/can/home/blaze-sites?hsLang=en#general) - [Customization](https://help.blaze.me/can/home/blaze-sites?hsLang=en#customization) - [SEO](https://help.blaze.me/can/home/blaze-sites?hsLang=en#seo) - [Widgets](https://help.blaze.me/can/home/blaze-sites?hsLang=en#widgets) - [Migrations](https://help.blaze.me/can/home/migrations?hsLang=en) - [Multi-Provincial Dashboard](https://help.blaze.me/can/home/multi-provincial-dashboard?hsLang=en) - [Mobile Apps](https://help.blaze.me/can/home/mobile-apps?hsLang=en#main-content) - [Getting Started](https://help.blaze.me/can/home/mobile-apps?hsLang=en#getting-started) - [Customization](https://help.blaze.me/can/home/mobile-apps?hsLang=en#customization) - [Growth](https://help.blaze.me/can/home/growth?hsLang=en#main-content) - [Getting Started With Growth](https://help.blaze.me/can/home/growth?hsLang=en#getting-started-with-growth) - [Growth Loyalty](https://help.blaze.me/can/home/growth?hsLang=en#growth-loyalty) - [Growth Outreach](https://help.blaze.me/can/home/growth?hsLang=en#growth-outreach) [![BLAZE-Logo-Blue](https://help.blaze.me/hubfs/BLAZE-Logo-Blue.svg "BLAZE-Logo-Blue")](http://blaze.me) BLAZE CAN Help Center Copyright © 2025, BLAZE Solutions Inc.