Home Reports

Reports

By Customer Success Team
• 26 articles

Other Reports

The Reports module houses reports that track activities throughout the Seed-to-Sale platform. However, Ample Organics also offers several reports that pull data for specific objects, like a specific Bulk Lot, harvest, or Packaging Run. Usually, you can access these reports from a module index or an object's profile page, rather than from the Reports module. Follow the links below for information on how to generate reports outside of the Reports module. Productions - Bulk Inventory Report - The Bulk Inventory Report pulls essential information about each Bulk Lot saved to the licence holder's Seed-to-Sale environment. For each Bulk Lot, the report lists the lot's associated production, packaged weight and volume, unpackaged weight and volume, QA status, location, type, cannabis form, and cannabinoid potencies. Note*: The Bulk Inventory Report is also accessible through the Inventory report types sub-tab in the Reports module.* - Packaged Inventory Report - A Packaged Inventory Report summarizes all bottles packaged through all EA Packaging Runs associated with a specific Bulk Lot. For each bottle, the report lists the bottle's ID number, associated Bulk Lot, grams packaged into the bottle, and the associated Packaging Run's ID number. The report also indicates whether or not each bottle has been destroyed or returned. - Forensics Report - After packaging bottles through a Packaging Run or Mass Packaging Run, a Packaging Associate can generate a bottling record to quickly pull all bottle ID numbers included in the run. A bottling record is useful for traceability in the event of a product recall. - Bulk Lot Weight Events Report - Anytime a Bulk Lot's weight changes, the change is recorded as a line item on the Bulk Lot's Weight Events tab. You can download this table into a spreadsheet. Work Orders - Work Order Report - A Work Order Report summarizes a Work Order's input and output weight and volume, as well as the input and output Bulk Lots. The Work Order must be Closed before you can generate a PDF report. Grow - Grow Inventory Report - The Grow Inventory Report provides a high-level snapshot of all living inventory in a licence holder's grow rooms. This includes the number of plants in each grow room, and details about every active batch. - Cutting Report - After Creating a Batch from Cuttings through the Grow module or Gun App, a Grow Technician may download and print a Cutting Report. The Cutting Report lists the total cuttings planted, the associated mother plants, and the staff member who took the cuttings. The report also includes fields for the Grow supervisor to sign off on the cutting event. - Seeding Report - A Grow Technician can generate and download a Seeding Report for any batch created from a Seed Lot. This allows grow room supervisors to approve and document all batch creations as they occur at their facility. - Batch Report - A Batch Report provides a Grow Technician with a snapshot of a batch's current status, including the number of plants in the batch, the batch's location, and information about each plant in the batch. - Harvest Report - After completing a harvest, a Grow Technician may wish to download a Harvest Report. The Harvest Report summarizes the batch and plants harvested, the destination Bulk Lot, and the total weight harvested and destroyed. The report also includes fields for the Grow supervisor to sign off on the harvest. - History Events Report - A Grow Technician can download a History Events Report for a specific plant, batch, or seed lot. The report summarizes all events in the object's history, including its creation, movement, and destruction. Destruction - Destruction Lot Report - Once a Destruction Lot is Closed, you can generate a destruction lot report that summarizes the weight of destroyed material in the lot, and the contents of each child lot/sublot. If the Destruction Lot has been Destroyed, the report also includes destruction details and fields for witnesses to verify that the destruction took place as indicated. Complaints - Complaint Report - When recording a complaint from a client, a CSR enters details of the complaint and tracks its investigation through the Complaint's Profile. Generate information about a specific complaint into a PDF document following the process below. Through the Reports module, you can generate a Monthly Reporting Template.

Last updated on Feb 03, 2026

Wholesale Reports

In the Reports module, open the Wholesale tab in the Report Types section to access Wholesale reports. Wholesale reports allow licence holders to track wholesale transactions that take place in the Wholesale application. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report, in CSV format. Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* mceclip0.png The Seed-to-Sale software currently offers two Wholesale reports: - Sales By Line Item - Received Inventory Sales By Line Item A record of sales to vendors by sales order line item. - Required Filter Fields: None - Optional Filter Fields: Start and End dates, and Province may be selected for the report. - Order: - Data Points Pulled: - The order's unique ID number - The date and time the order was placed - The shipment ID - Status of shipment - The date the order was shipped - The date the order was delivered - The vendor - Vendor ID - Vendor category - The person responsible - Order type - The purpose of the order - Cannabis type - Product name - SKU name - EA SKU GTIN - CS SKU TRIN - Production name - Bulk lot name - Purchase order reference ID - Total CS - Units per CS - Total number of units - Unit price - Price (CS) - Bulk cannabis form - Bulk weight (g) - Bulk volume (mL) - Bulk units (number of units) - Bulk price per gram - Bulk price - Name of any other charge - Other charge amount - Subtotal - HST (13%) - GST (5%) - QST (9.97%) - HST (15%) - Order total - Currency - Total THC sold (mg) - User who created the order - Ship To name - Ship To license - Shipping To address line 1 - Ship To address line 2 - Ship To city - Ship To province - Ship To postal code - Ship To phone number - Ship To email - Contact name of the recipient organization - Position title of the contact - Phone number of the contact - Email address of the contact mceclip12.png Received Inventory A record of inventory received from external sources within a specified time period. - Required Filter Fields: Start and End dates. - Data Points Pulled: - The received inventory's unique ID - The external order ID - The inventory's status - Options are Received, Reverted, and Returned - The date and time at which the inventory was created - The inventory's source - Options are Domestic, Return, or Other - The date and time at which the inventory was received - The user who received the inventory - The product received - The product's subclass - The SKU received - The inventory's associated Bulk Lot - The Bulk Lot's QA status - The total EA units (bottles) received - Total net weight (g) received - Total net volume (ml) received - The date and time at which the inventory was packaged - The inventory's expiry date - The date on which the inventory was returned, if applicable - The user who accepted the return, if applicable mceclip0.pngmceclip1.pngmceclip2.pngmceclip3.png Click through the other tabs in the Report Types section to access Client Reports, Physician Reports, Order Reports, Product Reports, Complaints Reports, Inventory Reports, Health Canada Reports, Grow Reports,and Destruction Reports.

Last updated on Feb 03, 2026

Destruction Reports

Enter the Reports module, and open the Destruction tab in the Report Types section to access Destruction reports. Destruction reports tracks activities related to the Destruction Lots and sublots saved to the licence holder's system. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report, in CSV format. Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight. mceclip0.png The Seed-to-Sale software currently offers two distinct Destruction reports: - Open Destructions - Closed Destructions Open Destructions A record of open Destruction sublots, and their contents, on a specific date. - Required Filter Fields: Start date - Optional Filter Fields: End date - Data Points Pulled: - The destruction sublot's name - The destruction sublot's location - The destruction sublot's creation date - The weight targeted for destruction, in grams. This refers to cannabis that has been discarded but not yet destroyed. - The volume targeted for destruction, in millilitres. This refers to cannabis that has been discarded but not yet destroyed. - The subot's tare weight mceclip0.png Closed Destructions A record of closed Destruction sublots, and their contents, within a specific date range. - Required Filter Fields: Start and end dates for the report must be selected to indicate a date range. - Order: By default, the report lists Closed Destructions in ascending order by the Parent Lot ID column. - Data Points Pulled: - The Parent Destruction Lot's unique ID number - The Parent Destruction Lot's unique name - The Parent Destruction Lot's creation date - The date the Parent Destruction Lot was closed - The date the Parent Destruction Lot was destroyed - The destruction sublot's unique name - The destruction sublot's location - The destruction sublot's creation date - The date the destruction sublot was closed - The name of the user who closed the destruction sublot - The total incoming weight in the destruction sublot, in grams - The gross closing weight of the destruction sublot, in grams - The sublot's tare weight, in grams - Net closing weight of the destruction sublot, in grams. This may be different than the gross closing weight if evaporation or drying has occurred in the lot. - The variance between incoming and closing weights - Net closing volume of the destruction sublot, in millilitres mceclip0.pngmceclip1.pngmceclip2.png Click through the other tabs in the Report Types section to access Client Reports, Physician Reports, Order Reports, Product Reports, Complaints Reports, Inventory Reports, Health Canada Reports, Grow Reports, and Wholesale Reports.

Last updated on Feb 03, 2026

Grow Reports

Enter the Reports module, and open the Grow tab in the Report Types section to access Grow reports. Grow reports track all activities surrounding plant propagation, inventory and destruction. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report, in CSV format. Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* mceclip0.png The Seed-to-Sale software currently offers 14 distinct Grow reports: - Historical Plant Inventory - Historical Mother Inventory - Historical Batch Inventory - Historical Seed Inventory - Batch Destruction - Plant Destruction - Batch Inventory - Plant Inventory - End of Phase - Seed Inventory - Harvest Report - Plant Creation - Plant Movement - Marked for Wholesale Historical Plant Inventory A historical snapshot of plant inventory on a specified date. - Required Filter Fields: A Start date for the report must be selected. - Optional Filter Fields: Include Archived is selected by default; deselect this checkbox to exclude archived plant inventory. - Order: By default, the report lists plants in ascending order by the Plant Database ID column. - Data Points Pulled: - Unique plant ID - Source batch name - Source batch type - Prior name or ID for a plant that has migrated from another system - Plant's location - Plant's strain - Growth phase of the plant - Current pot size containing the plant - Change from prior pot size of the pot that contained the plant - Whether or not the plant is a Mother - Plant's creation date - Plant ID of the plant's Mother, as applicable - Seed Lot ID of the plant's source seed lot, if applicable - Plant's method of creation (Cutting/Seed/Wholesale) - Whether or not the plant is targeted for destruction mceclip1.pngmceclip2.pngmceclip3.png Historical Mother Inventory A historical snapshot of Mother plant Inventory on a specified date. - Required Filter Fields: None - Optional Filter Fields: A user can include archived plants - Order: By default, the report lists mother plants in ascending order by the Plant Database ID column. - Data Points Pulled: - Unique plant ID - Source batch's name - Source batch's type - Prior name or ID for a plant that has migrated from another system - Plant's location - Plant's strain - The plant's current growth phase - Current pot size - Prior pot size - Whether or not the plant is a Mother. This should be "Yes" by default. - Plant's creation date - Plant ID of the plant's Mother, as applicable - Seed Lot ID of plant's source Seed Lot, if applicable - Plant's method of creation (Cutting/Seed/Wholesale) - Whether or not the plant is targeted for destruction mceclip4.pngmceclip5.pngmceclip6.png Historical Batch Inventory A historical snapshot of batch inventory on a specified date. - Required Filter Fields: A Start date for the report must be selected. - Optional Filter Fields: Include Archived is selected by default; deselect this checkbox to exclude archived Batches. - Order: By default, the report lists Batches in ascending order by the Batch Database ID column. - Data Points Pulled: - Batch ID - Batch name - Batch type - Cutting date - Report date - Number of plants in the batch on the report date - Batch locations - Batch's strain - Stage of growth of the plants in the batch - Pot size for plants in the batch - Whether or not the batch is archived - Batch's date of creation - Name of the user who created the batch - Batch's harvest ID, if applicable - The batch's method of creation (Cutting/Seed/Wholesale) mceclip7.pngmceclip8.pngmceclip9.png Historical Seed Inventory A historical snapshot of Seed Lot inventory on a specified date. - Required Filter Fields: A Start date for the report must be selected. - Optional Filter Fields: Include Archived is selected by default; deselect this checkbox to exclude archived Seed Lots. - Order: By default, the report lists Seed Lots in ascending order by the Seed Lot Database ID column. - Data Points Pulled: - Unique Seed Lot Database ID - Unique Seed Lot Name - Seed Lot's Strain - Seed Lot's Location - Quantity of seeds in the Seed Lot - Weight of the Seed Lot - Name of the user who created the Seed Lot - The date the Seed Lot was created - Number of batches containing seeds from the Seed Lot - Number of plants grown from the Seed Lot's seeds - The Seed Lot's source (Produced, Received-Domestic, or Received-Imported) mceclip28.pngmceclip29.png Batch Destruction A record of all Batch-level destruction events within a specified date range. - Required Filter Fields: Start and End dates for the report must be selected. - Optional Filter Fields: Include Archived is selected by default; deselect this checkbox to exclude archived Batches. - Order: By default, the report lists Batches in ascending order by the Batch Name column. - Data Points Pulled: - Unique batch database ID - Unique batch name - Batch's type - Batch's strain - Reason for sestruction - Substance destroyed - Destruction Lot ID - Destruction Lot name - Destruction sublot ID - Destruction sublot name - Total number of plants destroyed mceclip2.pngmceclip4.png Plant Destruction A record of all individual plants destroyed within a specified date range. - Required Filter Fields: Start and End dates for the report must be selected. - Optional Filter Fields: Include Archived is selected by default; deselect this checkbox to exclude archived Plants. - Order: - Data Points Pulled: - Unique batch database ID - Unique batch name - Batch's type - Unique plant ID - Prior name or ID for a plant that has migrated from another system - Plant's strain - Plant's location - Growth phase of the plant - Whether or not the plant is a Mother - Date of the plant's destruction - Amount of batch weight destroyed - Amount of plant weight destroyed - Reason for destruction - Substance destroyed - Destruction Lot ID - Destruction Lot name - Destruction sublot ID - Destruction sublot name - Name of the user who destroyed the plant - Plant's date and time of creation - Plant's Mother ID, if applicable - Source Seed Lot's ID, if applicable - Plant's creation method (Cutting/Seed/Wholesale) mceclip5.pngmceclip6.pngmceclip7.png Batch Inventory The current batch inventory. - Required Filter Fields: None - Optional Filter Fields: None - Order: By default, the report lists Batches in ascending order by the Batch Database ID column. - Data Points Pulled: - The batch's ID number - The batch's name - Batch's type - Cutting date, if the batch was created via cuttings - Report date, if the batch was created via cuttings - Number of plants in the batch - Batch locations - Batch's strain - Stage of plants in the batch - Pot size(s) used - Whether or not the batch is archived - The batch's time and date of creation - Name of the user who created the batch - The batch's harvest ID, if applicable - The batch's method of creation (Cutting/Seed/Wholesale mceclip25.pngmceclip26.pngmceclip27.png Plant Inventory The current plant inventory. - Required Filter Fields: None - Optional Filter Fields: Select the Mother Plants Only checkbox to exclude all plants that are not mothers from the report. Inventory may also be filtered by Batch, Strain, Location, and Created Via field selections. - Order: By default, the report lists Plants in ascending order by the Plant Database ID column. - Data Points Pulled: - The plant's ID n umber - The source batch's name - The source batch's type - Prior name or ID for a Plant that has migrated from another system - Plant's location - Plant's strain - Plant's stage of development - Plant's current pot size - Plant's prior pot size - Whether or not the plant is a mother - Plant's creation date - ID of the plant's Mother, if the plant was grown from a cutting - ID of the source Seed Lot, if the plant was grown from a seed - The plant's method of creation (Cutting/Seed/Wholesale) mceclip0.pngmceclip3.pngmceclip4.png End of Phase A record of all destruction events involving plants of a specific stage. - Required Filter Fields: Plant Phase must be selected. - Optional Filter Fields: Destruction events may also be filtered by selecting a specific Batch. - Order: By default, the report lists Destruction Events in ascending order by the Batch Database ID column. - Data Points Pulled: - The batch's ID number - The batch's name - Batch type - The plant's ID number - Prior name or ID for a plant that has migrated from another system - Plant's strain - Plant's stage - Whether or not the plant is a Mother - Date of destruction - Destruction weight for the batch - Destruction weight for the plant - Reason for destruction - Substance destroyed - Destruction Lot ID - Destruction Lot name - Destruction sublot ID - Destruction sublot name - User who performed the destruction - Plant's creation date and time - Plant ID of the plant's Mother, if applicable - Seed Lot ID of the Plant's seed, if applicable - Plant's creation method (Cutting/Seed/Wholesale) mceclip0.pngmceclip1.pngmceclip2.pngmceclip8.pngmceclip3.png Seed Inventory The current seed inventory - Required Filter Fields: None - Optional Filter Fields: The seed inventory may be filtered by selecting a Strain for the report. - Order: By default, the report lists Seed Lots in ascending order by the Seed Lot Database ID column. - Data Points Pulled: - Seed Lot's ID number - Seed Lot name - The Seed Lot's strain - The Seed Lot's location - Quantity of seeds in the Seed Lot - Weight of the seeds in the Seed Lot - Name of the user who created the Seed Lot - The date and time of the Seed Lot's creation - Number of batches containing seeds from the Seed Lot - Number of plants grown from the Seed Lot - The Seed Lot's source (Produced, Received-Domestic, or Received-Imported) mceclip5.pngmceclip6.png Harvest Report A record of all plants harvested within a specified date range. - Required Filter Fields: Start and End dates for the report must be selected. - Optional Filter Fields: Harvests may also be filtered by Batch, Strain, and Location field selections. - Data Points Pulled: - Plant ID - Batch name - Batch type - Prior name or ID for a Plant that has migrated from another system - Plant's location - Plant's strain - Plant's current stage - Whether or not the plant is a Mother - The plant's date of creation - ID of the plant's Mother, if the plant was grown from a cutting - ID of the plant's source Seed Lot, if the plant was grown from a seed - The plant's method of creation (Cutting/Seed/Wholesale) - Harvest ID - Date of harvest - Destination Bulk Lot's name - Plant's harvest weight - Name of the user who harvested the plant mceclip9.pngmceclip10.pngmceclip11.pngmceclip12.png Plant Creation A record of all plants created within a specified date range. - Required Filter Fields: Start and End dates for the report must be selected. - Optional Filter Fields: Plants may also be filtered by Batch, Strain, and Created Via field selections. - Order: - Data Points Pulled: - Plant ID - Batch name - Batch type - Prior name or ID for a plant that has migrated from another system - Plant location - Plant strain - Plant's current stage - Plant's current pot size - Plant's prior pot size - Whether or not the plant is a Mother - The plant's birthday - ID of the plant's Mother, if the plant was grown from a cutting - ID of the plant's source Seed Lot, if the plant was grown from a seed - The plant's method of creation (Cutting/Seed/Wholesale) - The plant's source (Produced, Received-Domestic, or Received-Imported) mceclip14.pngmceclip15.pngmceclip16.png Plant Movement A record of all plant movement within a specified time range. - Required Filter Fields: Start Date and End Date - Optional Filter Fields: None - Data Points Pulled: - Plant ID - From Location - To Location mceclip0.png Marked for Wholesale A record of all plants removed from the inventory through the Mark for Wholesale feature. - Required Filter Fields: Start Date and End Date - Optional Filter Fields: None - Data Points Pulled: - The plant's unique ID number - The batch's unique ID number - The batch's name - The cannabis strain - The plant's stage–Propagation, Vegetation, or Flowering–when it was claimed for wholesale - The plant's age when it was claimed for wholesale, in days - The plant's location - The date the plant was marked for wholesale - The user who marked the plant for wholesale - The plant's date of creation - The plant's mother ID number, if the plant was created through cuttings - The plant's Seed Lot ID number, if the plant was grown from a seed - The method by which the plant was created mceclip1.pngmceclip2.png Click through the other tabs in the Report Types section to access Client Reports, Physician Reports, Order Reports, Product Reports, Complaints Reports, Inventory Reports, Health Canada Reports and Destruction Reports.

Last updated on Feb 03, 2026

How to Configure Facility Information Settings

At the end of each reporting month, the CTLS report pulls values from the Reports module's Settings tab to populate the report's Business Stats section. A licence holder should review and adjust these fields before the end of each month to ensure reporting accuracy. Note*: Only users with Admin access should have permission to update facility information.* Required permission(s): facility_information_read, facility_information_update 1. In the Reports module, open the Settings tab. mceclip0.png 2. Enter the licence holder's cultivation, processing, or medical licence ID number in the field provided. mceclip1.png 3. Configure employee totals and processing area information in the fields provided. - Number of Employees mceclip2.png - Management FTE: The number of full time employees in senior and middle management positions. - Production FTE: The number of full time employees in supervisory, production, and general labour positions. - Administrative FTE: The number of full time employees in financial, administrative, clerical, and support positions. - Sales FTE: The number of full time employees in retail, wholesale, and customer support positions. - Other FTE: The number of full time employees in miscellaneous. - Processing Areas mceclip3.png - Licensed Growing Area: The licence holder's licensed indoor growing area, in square metres. - Licensed Processing Area: The licence holder's licensed processing area, in square metres. - Total Building(s) Area: The licence holder's total building area, in square metres. - Licensed Outdoor Growing Area: The licence holder's licensed outdoor growing area, in hectares. 4. Click Save to update the facility information settings. Visit the Monthly Reports tab to Generate the CTLS Report.

Last updated on Feb 03, 2026

Health Canada Reports

In the Reports module, open the Health Canada tab in the Report Types section to access Heath Canada reports. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report in CSV format. Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* The Seed-to-Sale software currently offers one Health Canada report: Quarterly By Province Generates a quarterly report of patients by province, including patient, physician, prescription and shipment information. - Required Filter Fields: Start and End dates, and Province must be selected for the report. - Optional Filter Fields: None - Order: - Data Points Pulled: - Patient's full name - Patient's date of birth. - Patient's street address line 1 - Patient's street address line 2 - Patient's city - Patient's postal code - Patient's Province - Physician's title and full name - Physician's street address line 1 - Physician's street address line 2 - Physician's city - Physician's postal code - Physician's Province - Physician's license number - Grams per day in the patient's prescription - Duration of the prescription - Prescription start date - Total grams shipped to the patient - Date of shipment mceclip0.pngmceclip1.pngmceclip2.pngmceclip3.png Click through the other tabs in the Report Types section to access Client Reports, Physician Reports, Order Reports, Product Reports, Complaints Reports, Inventory Reports, Grow Reports, Destruction Reports, and Wholesale Reports.

Last updated on Feb 03, 2026

Inventory Reports

Enter the Reports module, and open the Inventory tab in the Report Types section to access Inventory reports. Inventory reports track all activities surrounding bulk inventory, including Bulk Lots, Work Orders and bottling. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report in CSV format. Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* mceclip0.png Ample Organics currently offers eleven distinct Inventory reports: - Bulk Inventory - Historical Bulk Inventory - Bottles Created - Historical Work Order Inventory - Work Order Inventory - Inventory Balance (current) - Inventory Balance (historical) - Last Date of Sale - Retained Inventory Report - Lab Samples Sent - Reclaimed Bottles Bulk Inventory The current inventory of each Bulk Lot, including the associated packaged and retained inventory. - Required Filter Fields: None - Optional Filter Fields: Select the Include Archived checkbox to generate a bulk inventory report, including archived product. - Order: By default, the report lists Bulk Lots in ascending order by the Lot ID column. - Data Points Pulled: - Bulk Lot's unique name - Bulk Lot ID - The Bulk Lot's type - The Bulk Lot's cannabis form - The lot's migrated ID - Total weight of cannabis in the Bulk Lot, in grams - Total volume of cannabis in the Bulk Lot, in millilitres - Total discrete units in the Bulk Lot - Total weight packaged from the Bulk Lot, in grams - Total volume packaged from the Bulk Lot, in millilitres - Total discrete units packaged from the Bulk Lot - The Bulk Lot's QA status - The Bulk Lot's location - Total grams retained from the Bulk Lot - Whether or not the Bulk Lot underwent a sterilization treatment - The Bulk Lot's archived status - The date and time at which lab report was created. - The date and time at which the lab report was marked as "released". - The Bulk Lot's THC potency result, in % or mg/ml - The Bulk Lot's THCA potency result, in % or mg/ml - The Bulk Lot's Total THC potency result, in % or mg/ml - The Bulk Lot's CBD potency result, in % or mg/ml - The Bulk Lot's CBDA potency result, in % or mg/ml - The Bulk Lot's Total CBD potency result, in % or mg/ml - The Bulk Lot's dried gram equivalency, in grams - The Bulk Lot's oil equivalency factor, in ml mceclip0.pngmceclip1.pngmceclip2.pngmceclip3.pngmceclip4.png Historical Bulk Inventory A snapshot of Bulk Lot inventory and associated packaged and retained inventory on a specified date. - Required Filter Fields: Start date for the report must be selected. - Optional Filter Fields: None - Order: - Data Points Pulled: - The Bulk Lot's unique name - The Bulk Lot ID - The Bulk Lot's type - The Bulk Lot's cannabis form - The Bulk Lot's migrated ID - Total cannabis weight in the Bulk Lot, in grams - Total cannabis volume in the Bulk Lot, in millilitres - Total discrete units in the Bulk Lot - Total EA units (bottles) packaged from the Bulk Lot - Total weight packaged from the Bulk Lot, in grams - Total volume packaged from the Bulk Lot, in millilitres - Total discrete units packaged from the Bulk Lot - The Bulk Lot's QA status - The Bulk Lot's location - The total weight taken from the Bulk Lot for retention, in grams - Whether or not the Bulk Lot underwent a sterilization treatment - Whether or not the Bulk Lot is archived mceclip5.pngmceclip6.pngmceclip7.png Bottles Created A record of all bottles created through Packaging Runs within a specified date range. - Required Filter Fields: Start and End dates for the report must be selected, - Optional Filter Fields: None - Data Points Pulled: - The source Bulk Lot's unique name - The Bulk Lot's type - Whether or not the Bulk Lot measures cannabis in discrete units - The Bulk Lot's cannabis form - The destination product's subclass - The destination SKU's ID number - The destination SKU's unique name - The source Packaging Run's ID number - The total bottles created in the Packaging Run - This total will not include reclaimed bottles that have been deleted. - The total bottles reclaimed from the Packaging Run - The SKU's net weight, in grams - The SKU's net volume, in millilitres - The SKU's quantity of discrete units per EA unit, if applicable - Total declared cannabis weight packaged into bottles, in grams - Total actual cannabis weight packaged into bottles, in grams - This accounts for minor discrepancies between the expected weight based on each bottle's net weight and the actual amount packaged. - Total declared volume of cannabis packaged into bottles, in millilitres - Total actual volume of cannabis packaged into bottles, in millilitres - This accounts for minor discrepancies between the expected weight based on each bottle's net weight and the actual amount packaged. - The user who created the Packaging Run - The date and time at which the run was created - The date and time at which the bottles were packaged mceclip1.pngmceclip2.pngmceclip3.png Historical Work Order Inventory A snapshot of all Work Orders, including input and output weights/volumes, on a specified date. - Required Filter Fields: Start date must be selected as the report's specified date. - Optional Filter Fields: None - Data Points Pulled: - The Work Order's Database ID number - The Work Order's name - The Work Order's type - The Work Order's location - The date the Work Order was opened/created - The user who opened/created the Work Order - ID(s) of input Bulk Lot(s) - Type(s) of input Bulk Lot(s) - The input Bulk Lot's cannabis form - The input Production - The Work Order's input weight per Bulk Lot, in grams - The Work Order's input volume per Bulk Lot, in millilitres - The Work Order's input discrete units per Bulk Lot - The Work Order's total input weight, in grams - The Work Order's total input volume, in millilitres - The Work Order's total input discrete units - Whether or not the Work Order was finalized on the specified date - The Work Order's total finalized weight, in grams - The Work Order's total finalized volume, in millilitres - The Work Order's total finalized discrete units - The ID(s) of the output Bulk Lot(s) - The output Bulk Lot type(s) - The output Bulk Lot's cannabis form - The output production - The output weight per Bulk Lot, in grams - The output volume per Bulk Lot, in millilitres - The output discrete units per Bulk Lot - The total output weight, in grams - The total output volume, in millilitres - The total output discrete units - The date the Work Order was closed - The user who closed the Work Order - The input Bulk Lot's name - The output Bulk Lot's name mceclip8.pngmceclip9.pngmceclip10.pngmceclip11.pngmceclip12.pngmceclip13.png Work Order Inventory Current Work Order inventory, including inputs and outputs. - Required Filter Fields: None - Optional Filter Fields: None - Data Points Pulled: - The Work Order's Database ID number - The Work Order's name - The Work Order's type - The Work Order's location - The date the Work Order was opened/created - The user who opened/created the Work Order - ID(s) of input Bulk Lot(s) - Type(s) of input Bulk Lot(s) - The input Bulk Lot's cannabis form - The input Production - The Work Order's input weight per Bulk Lot, in grams - The Work Order's input volume per Bulk Lot, in millilitres - The Work Order's input discrete units per Bulk Lot - The Work Order's total input weight, in grams - The Work Order's total input volume, in millilitres - The Work Order's total input discrete units - Whether or not the Work Order has been finalized - The Work Order's total finalized weight, in grams - The Work Order's total finalized volume, in millilitres - The Work Order's total finalized discrete units - The ID(s) of the output Bulk Lot(s) - The output Bulk Lot type(s) - The output Bulk Lot's cannabis form - The output production - The output weight per Bulk Lot, in grams - The output volume per Bulk Lot, in millilitres - The output discrete units per Bulk Lot - The total output weight, in grams - The total output volume, in millilitres - The total output discrete units - The variance weight (%) - The variance volume (%) - The variance discrete units (%) - The date on which the Work Order was closed - The user who closed the Work Order mceclip14.pngmceclip15.pngmceclip16.pngmceclip17.pngmceclip18.pngmceclip19.png Inventory Balance (current) A record of all inventory currently available for sale, at the time of the report's generation. - Required Filter Fields: None - Optional Filter Fields: None - Data Points Pulled: - The product's name - The SKU's unique name - The SKU's unit of measure–EA (each) or CS (case) - The product's subclass - The Base SKU's ID number - This only applies if the SKU is a Case (CS) SKU. - The quantity of base units in a case - This only applies if the SKU is a Case (CS) SKU. - The quantity of units on hand - The quantity of units reserved - Net difference between on hand and reserved quantities - The quantity of units available for purchase - The quantity of units packaged into cases - The product's unique ID number - The SKU's prescription deduction - This refers to the quantity of grams a single unit will deduct from a client's prescription. - The SKU's Dried Gram Equivalent - The SKU's wholesale price - The SKU's inventory value - This total is based on the quantity of units on hand multiplied by the wholesale price. - The SKU's net weight, in grams - The SKU's net volume, in millilitres - The SKU's quantity of discrete units per EA unit, if applicable - The SKU's unique retail name - This may be different from the SKU's internal name - The SKU's UPC number - The SKU's GTIN mceclip4.pngmceclip5.pngmceclip6.pngmceclip7.png Inventory Balance (historical) A record of all inventory currently available for sale on a specified date. This allows a licence holder to reconcile inventory values over time. - Required Filter Fields: Start Date - Optional Filter Fields: None - Data Points Pulled: - The product's name - The SKU's unique name - The SKU's unit of measure–EA (each) or CS (case) - The product's subclass - The Base SKU's ID number - This only applies if the SKU is a Case (CS) SKU. - The quantity of base units in a case - This only applies if the SKU is a Case (CS) SKU. - The quantity of units on hand - The quantity of units reserved - Net difference between on hand and reserved quantities - The quantity of units available for purchase - The quantity of units packaged into cases - The product's unique ID number - The SKU's prescription deduction - This refers to the quantity of grams a single unit will deduct from a client's prescription. - The SKU's Dried Gram Equivalent - The SKU's wholesale price - The SKU's inventory value - This total is based on the quantity of units on hand multiplied by the wholesale price. - The SKU's net weight, in grams - The SKU's net volume, in millilitres - The SKU's quantity of discrete units per EA unit, if applicable - The SKU's unique retail name - This may be different from the SKU's internal name - The SKU's UPC number - The SKU's GTIN mceclip4.pngmceclip5.pngmceclip6.pngmceclip7.png Last Date of Sale A record of all released Bulk Lots, including the last date of sale where applicable. This report determines how long a licence holder should keep retained samples. This is usually one year after the last date of sale or provision. - Required Filter Fields: None - Optional Filter Fields: None - Order: - Data Points Pulled: - The Bulk Lot's unique name - The Bulk Lot's migrated ID - The source production's name - The Bulk Lot's release date - The user who released the Bulk Lot - The Bulk Lot's last date of sale, if applicable - The final order's unique ID number mceclip32.pngmceclip33.png Retained Inventory Report A record of all retained Bulk Lot samples. - Required Filter Fields: None - Optional Filter Fields: None - Order: - Data Points Pulled: - The parent production's name - The retained sample's ID string - The Bulk Lot's unique name - The Bulk Lot's migrated ID - The sample's weight, in grams - The sample's volume, in millilitres - The sample's total discrete units - The sample's location - The date and time at which the retained sample was created - The date and time at which the retained sample was last updated mceclip22.png Lab Samples Sent A record of all lab samples sent for testing within a specified time frame. - Required Filter Fields: Start Date, End Date - Optional Filter Fields: None - Data Points Pulled: - The lab report's unique ID number - The date and time at which the lab report was created - The date and time at which the lab report was last updated - Whether or not the lab report is the Bulk Lot's active report - The lab report's status - The Bulk Lot's unique ID number - The Bulk Lot's migrated ID - The Bulk Lot's type - The Bulk Lot's cannabis form - Whether or not the sample has been sent - The date on which the sample was sent for testing - The sample's weight, in grams - The sample's volume, in millilitres - The sample's discrete units - Whether or not the sample underwent sterilization - Whether the test was external or internal - The method by which the sample was delivered to the lab - The sample's tracking number - The date on which the lab received the sample mceclip23.pngmceclip24.pngmceclip26.pngmceclip28.png Reclaimed Bottles Report A record of all bottles or EA units reclaimed during a given time period. - Required Filter Fields: Start Date, End Date - Optional Filter Fields: None - Data Points Pulled (per bottle): - The date and time at which the bottle was reclaimed - The bottle's unique ID number - The bottle's source Packaging Run/Received Inventory ID - The user ho reclaimed the bottle - The bottle's source production - The bottle's source Bulk Lot - The product - The SKU - The SKU's net weight - The SKU's net volume - The SKU's net discrete units mceclip29.pngmceclip30.png Click through the other tabs in the Report Types section to access Client Reports, Physician Reports, Order Reports, Product Reports, Complaints Reports, Health Canada Reports, Grow Reports, Destruction Reports, and Wholesale Reports.

Last updated on Feb 03, 2026

Complaints Reports

In the Reports module, open the Complaints tab in the Report Types section to access Complaint reports. Complaint reports track the number and nature of complaints filed by clients. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report, in CSV format. Data in the reports is refreshed once daily. By default, Historical reports display information on the day's opening inventory at 12:00 am local time, while standard reports display information based on snapshots taken at midnight. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report genera*tion. The seed-to-sale software currently offers one Complaints report: - Complaints Report: A record of all complaints filed within a given time period. For each complaint entry, this report includes the complaint type, the status of the complaint, and any clients, products, or orders to which the complaint pertains. - Required Filter Fields: None - Optional Filter Fields: Select a date for Start and/or End to generate a report for a specified time frame. - Order: By default, the report lists complaints in descending order by the Complaint ID column. - Data Points Pulled: - Unique complaint ID number - Whether or not the complaint is Open - The date the complaint was received - The date the complaint was initiated - Complaint category - Description of the complaint's status - Associated products - Associated lots - Identifies to whom the complaint is assigned for resolution - Identifies additional information–such as products, clients, or lots–pertinent to the complaint mceclip0.pngmceclip1.png Click through the other tabs in the Report Types section to access Client Reports, Physician Reports, Order Reports, Product Reports, Inventory Reports, Health Canada Reports, Grow Reports, Destruction Reports, and Wholesale Reports.

Last updated on Feb 03, 2026

Product Reports

Enter the Reports module, and open the Products tab in the Report Types section to access Product reports. Product reports track product inventory and sales information. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report, in CSV format. Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generati*on. mceclip0.png Ample Organics currently offers five distinct Product reports: - Product Inventory Breakdown - Product Inventory Breakdown 2 - Product Sales - Historical Product Inventory (units) - Historical Product Inventory (grams) Product Inventory Breakdown An inventory breakdown of each product, SKU–or Stock Keeping Unit–and Packaging Run. Cross-reference this report with the Prescription Tracker report, a Client Report, to determine if inventory supply meets prescription demand. - Required Filter Fields: None - Optional Filter Fields: None - Order: By default, the report lists product inventory items in ascending order by Product—>SKU—>Packaging Run, and the net weight per SKU. - Data Points Pulled: - Product—>SKU—>Packaging Run - Number of SKUs with a net weight of 0 grams - Number of SKUs with a net weight of 1 gram - Number of SKUs with a net weight of 1.5 grams - Number of SKUs with a net weight of 3.5 grams - Number of SKUs with a net weight of 5 grams - Number of SKUs with a net weight of 10 grams - Number of SKUs with a net weight of 15 grams - Columns will continue incrementally up to the highest net weight of all SKUs in the licence holder's inventory. mceclip0.pngmceclip1.png Product Inventory Breakdown 2 An inventory breakdown of each product and SKU–or Stock Keeping Unit–with comparison of units on hand versus units reserved. This report can be generated to determine if inventory supply meets demand. - Required Filter Fields: None - Optional Filter Fields: None - Data Points Pulled: - The product's name - The SKU's unique name - The product's subclass - The Base SKU - This only applies if the SKU is a Case SKU. - Quantity of base units per case - This only applies if the SKU is a Case SKU. - The SKU's quantity of On Hand units - This refers to total packaged units in the inventory, whether or not they have been released for sale. - The SKU's quantity of Reserved units - This refers to the quantity of units requested in orders that have not yet been fulfilled. - The SKU's quantity of Available units - This refers to packaged units that have been released for sale. - The SKU's quantity of Cased units - The SKU's prescription deduction - This refers to the number of grams a single unit will deduct from a client's prescription allowance. - The SKU's net weight, in grams - The SKU's net volume, in volume - The SKU's quantity of discrete units per EA unit - The SKU's unique retail name - This may be different from the SKU's internal name - The Bulk Lot associated with the SKU mceclip0.pngmceclip1.pngmceclip3.png Product Sales A general overview of all products and SKUs–or Stock Keeping Units– sold, including the total grams sold, the price of each SKU, and percentage of total sales each SKU is responsible for. If desired, specify a date range for the report. - Required Filter Fields: None - Optional Filter Fields: Start and End dates, and Referral Code may be used to filter report results. - Order: By default, the report lists each product and the product's SKUs in descending order by the product's Percentage of total sales. - Data Points Pulled: - The product, followed by each of the product's SKUs - Total weight–in grams–of the product sold, followed by grams sold per SKU - Product's sales as a percentage of total sales followed by per SKU sales as a percentage of the product's sales - Price per SKU - The SKU's retail name mceclip5.png Historical Product Inventory (units) A summary of the packaged inventory (in units) in stock on a given day, sorted by the associated Bulk Lot. - Required Filter Fields: None - Optional Filter Fields: Start Date - Data Points Pulled (per product): - The Bulk Lot - This serves as the source of the packaged inventory. - The Bulk Lot's Cannabis Form - The Bulk Lot's QA Status - The associated product's name - The associated product's type - The product's subclass - Total units in stock per SKU, sorted by net weight - The report will include a column for each net weight setting. - The total units of the product packaged mceclip4.pngmceclip5.png Historical Product Inventory (grams) A summary of the packaged inventory (in grams) in stock on a given day. - Required Filter Fields: None - Optional Filter Fields: Start Date - Order: - Data Points Pulled (per product): - The Bulk Lot - This serves as the source of the packaged inventory. - The Bulk Lot's Cannabis Form - The Bulk Lot's QA Status - The associated product's name - The associated product's type - The product's subclass - Total units in stock per SKU, sorted by net weight - The report will include a column for each net weight setting. - The total grams packaged across all the product's SKUs - The total kilograms packaged across all the product's SKUs mceclip6.pngmceclip7.png Click through the other tabs in the Report Types section to access Client Reports, Physician Reports, Order Reports, Complaints Reports, Inventory Reports, Health Canada Reports, Grow Reports, Destruction Reports, and Wholesale Reports.

Last updated on Feb 03, 2026

Orders Reports

Enter the Reports module, and open the Orders tab in the Report Types section to access Order reports. Order reports allow you to track order and sales data for a given time period. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report, in CSV format. Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* mceclip0.png The Seed-to-Sale software currently offers 12 distinct Order reports: - Refunds - Sales Report - Sales Report 2 - Sales Export - Shipped Orders - Unshipped Orders - VAC Order - Order Distribution - Discount Report - Strain Analysis - SKU Gram Analysis - Bottle Sales By SKU & Province Refunds A record detailing every refunded order. - Required Filter Fields: Start and End dates must be specified. - Data Points Pulled: - The refunded order's unique ID number - The amount refunded, with total for all refunded orders - The percentage refunded of the order's cost - The order's final cost, with total for all refunded orders - The date of the refund - The date the order was placed - The customer's full name mceclip0.png Sales Report An analysis of sales performance by SKU. - Required Filter Fields: Start and End dates must be specified. - Optional Filter Fields: This report can be generated for a selected Referral Code and/or for orders covered by the Veteran Affairs Canada–or VAC–policy. - Order: By default, the report lists sales in ascending order by Order Number. - Data Points Pulled: - The patient's full name - The patient's client ID - The patient's referral code, if applicable - The order number - The date and time the order was placed - The product and SKU ordered - The grams of cannabis ordered - The approximate cost per gram - The order's subtotal - The tax on the subtotal - The total tax applied to order - The order's shipping costs - The percentage discounted - The total value of any discounts - The order's total - The date the payment was received - The client's first name - The client's middle name - The client's surname - The prescribing physician's full name - The product's type - Source of order. This refers to whether the order was placed through the Client Portal or by a CSR. mceclip4.pngmceclip5.pngmceclip6.pngmceclip7.pngmceclip8.png Sales Report 2 An analysis of sales performance by SKU, plus additional order information including the order type–new or recurring–and payment method. - Required Filter Fields: Start and End dates must be specified. - Optional Filter Fields: This report can be generated for a selected Province. - Order: By default, the report lists patient orders in ascending order by Order ID. - Data Points Pulled: - The patient's full name - The patient's client ID - Client's province - The client's registration referral code, if applicable - The client's prescription referral code, if applicable - The order number - The product ordered - The SKU ordered - The associated Bulk Lot's number - Grams of cannabis ordered - Gross sales amount - Discount applied to the order item - Net sales total - Approximate cost per gram - Tax total - Discounts applied to the order - Discounts applied to the order after tax - Revenue from shipping - Cost for shipping - The product's type - The client's K # - Type of order: First or Repeat - Method of payment - Source of order. This refers to whether the order was placed through the Client Portal or with the help of a CSR. - The date and time of the shipment - Date of purchase - Date and time of purchase - Purchaser's full name - Shipping province - SKU's UPC - SKU's GTIN - SKU's retail price - SKU's wholesale price - SKU's Manufacturer Suggested Retail Price (MSRP) - Quantity of units sold - Delivery date - Total THC sold, in mg mceclip1.pngmceclip2.pngmceclip3.pngmceclip4.pngmceclip5.pngmceclip6.png Sales Export‌ A record of the licence holder's sales data. - Optional Filter Fields: Specify Start and End dates to generate this report for a date range. This report may also be filtered by Referral Code and/or Province. - Order: By default, the report lists patient orders in ascending order by Order Number. - Data Points Pulled: - The order's unique ID number - The date and time the order was placed - Client's full name - Client's ID - Client's province - Referral code, if applicable - Number of grams ordered - Cart total - Shipping cost - Discounts, in $ - Discounts percentage - Order subtotal - HST total - GST total - PST total - Order total - Amount covered by policies - Final order cost - Amount refunded - Method of payment - The date the payment was received - The date the order was delivered - The user who authorized purchase - The order's source. This refers to whether the order was placed through the Client Portal or with the help of a CSR. - The name of the client or CSR who placed order mceclip13.pngmceclip15.pngmceclip16.pngmceclip17.png Shipped Orders A brief overview of each shipped order’s total grams, sales totals, and shipping information. - Optional Filter Fields: Specify Start and End dates to generate this report for a date range. This report may also be filtered by Province. - Order: By default, the report lists shipments in ascending order by Shipped on date and time. - Data Points Pulled: - The order's unique ID number - Order's status - Client's full name - Client's province - Amount deducted from prescription per orde - Number of grams of cannabis sold per order - Volume of cannabis sold per order, in millilitres - Discounts, in $, per order - Subtotal per order - Shipping cost per order - Policy usage, in $, per order - Final cost per order - Date and time the order shipped - The shipping carrier - Shipment tracking number - Package dried weight, in grams - Packaged oil weight, in grams - Packaged oil volume, in millilitres mceclip26.pngmceclip23.pngmceclip24.pngmceclip25.pngmceclip27.png Unshipped Orders A brief overview of each unshipped order’s total grams, sales totals, and shipping selection. This report collects data on orders in the Placed status that have not yet shipped. - Order: By default, the report lists orders in ascending order by Order ID and date and time of purchase. - Data Points Pulled: - The order's unique ID number - Order's status - Date and time of purchase - The client's full name - Shipping carrier - Shipment tracking number - Picking status - Number of bottles picked mceclip28.pngmceclip29.png VAC Orders An overview of each unique order placed under the Veteran Affairs Canada–or VAC–policy type. - Optional Filter Fields: Specify Start and End dates to generate this report for a date range. This report may also be filtered by Referral Code. - Data Points Pulled: - The client's full name - The client's unique ID - Referral code, if applicable - Client's K # - Unique order ID - Quantity ordered per order, with total quantity for all VAC orders - Order total in $, with $ total for all VAC orders - Date of purchase - Date shipped - Date of first BlueCross order - The anticipated delivery date mceclip1.pngmceclip2.png Order Distribution An overview of each unique order that tracks each order's contents, shipping information, and order dates. - Optional Filter Fields: Specify Start and End dates to generate this report for a date range. This report may also be filtered by Referral Code and/or Province. - Order: By default, the report lists orders in ascending order by Order Number and Order Date. - Data Points Pulled: - The patient's full name - The patient's unique client ID - The patient's referral code, if applicable - Order number - Patient's date of birth - Shipping address - Order quantity in grams - Product's brand name - The source Bulk Lot's unique ID - Shipping carrier - Shipping number - Order date - Shipping date - The date the order was received mceclip34.pngmceclip35.pngmceclip36.pngmceclip37.png Discount Report An itemized record of all discounts applied to orders. - Optional Filter Fields: Specify Start and End dates to generate this report for a date range. - Order: By default, the report lists discounted orders in ascending order by Order ID and Order Date. - Data Points Pulled: - The discount's unique ID number - Date of order - The associated order's ID - The total amount discounted, in dollars - A note about the discount - Patient's full name - The discounted product's name, if applicable - The discounted SKU's name, if applicable - The discount's type - Discount code ID, if applicable - Discount code name, if applicable - Whether the discount was applied before or after tax mceclip38.pngmceclip39.pngmceclip40.png Strain Analysis An analysis of sales data organized by strain. This allows you to assess the most popular strains. - Required Filter Fields: Start and End dates must be specified. - Order: By default, the report lists products in ascending order by Product. - Data Points Pulled: - The product's name - The number of orders of the product placed within the timeframe - The product's base cost per SKU - The total amount of discount coverage across all orders that include the product - Total tax across all orders that include the product - Net sales total - Number of grams shipped - Number of bottles sold mceclip41.pngmceclip42.png SKU Gram Analysis Determines the popular method of sales of any particular product or SKU. - Required Filter Fields: Start and End dates must be specified. - Data Points Pulled: - The product - The strain's name - The SKU's name - The SKU's date of sale - Quantity of cannabis sold, in grams - The SKU's package/bottle ID number mceclip0.png Bottle Sales by SKU & Province An overview of bottle sales in the medical market, organized by SKU and destination province, within a given date range. - Required Filter Fields: Start and End dates must be specified. - Order: By default, the report lists products in ascending order by the Product—>SKU name. mceclip44.png Click through the other tabs in the Report Types section to access Client Reports, Physician Reports, Product Reports, Complaints Reports, Inventory Reports, Health Canada Reports, Grow Reports, Destruction Reports, and Wholesale Reports.

Last updated on Feb 03, 2026

Physician Reports

Enter the Reports module, and open the Physicians tab in the Report Types section to access Physician reports. Physician reports track data surrounding the prescribing physicians saved to the licence holder's system. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report, in CSV format. Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* The Seed-to-Sale software currently offers two distinct Physician reports: - Physician Tracker - Practitioners Physician Tracker An overview of physician information and the total number of clients prescribed by each physician on a given date. - Required Filter Fields: Start date. - Optional Filter Fields: Produce a report that tracks physicians by Referral Code. - Data Points Pulled for each physician: - Full name, including title - Business name - Address, including street, city, province, and postal code - Telephone number - Fax, if applicable - Licence number - Referral Code, if applicable - Number of patients associated to the physician - Number of active patients associated to the physician - Email address, if provided - Date the physician was added to the Seed-to-Sale software - Professional designation of the medical practitioner mceclip9.pngmceclip10.pngmceclip11.png Practitioners A record of the physician and prescription details for each unique order placed. - Required Filter Fields: None - Optional Filter Fields: Start Date and/or End Date may be selected to limit the report's date range, and this report can be produced for a single Province. - Data Points Pulled: - Full name of the client - Referral code, if applicable - The client's date of birth - The client's postal code - The client's province - Full name and title of the prescribing practitioner - The physician's address - Physician's licence number - Grams per day prescribed - Duration of the prescription - Start date of the prescription - Total grams shipped - The most recent shipment date - Professional designation of the medical practitioner mceclip15.pngmceclip16.pngmceclip17.png Click through the other tabs in the Report Types section to access Client Reports, Order Reports, Product Reports, Complaints Reports, Inventory Reports, Health Canada Reports, Grow Reports, Destruction Reports, and Wholesale Reports.

Last updated on Feb 03, 2026

How to Generate an Audit Report

Audit reports provide a line-by-line breakdown of transactional event histories that contribute to CTLS and CRA reports. This provides you with a method to verify report totals, identify erroneous transactions, and make adjustments before submitting the reports. For example, you can verify totals in the Seeds - Reductions columns on the CTLS report by generating the Unpackaged - Seeds audit report to see each time seed inventory was reduced within the reporting period. If one of the reduction events was created in error, you can adjust the totals on the CTLS report accordingly. 1. In the Reports module, open the Monthly Reports tab. mceclip0.png 2. Scroll down to the Event History section. mceclip2.png 3. Select the event type from the drop-down provided. Options include: - Unpackaged - Seeds: An itemized list of transactions that affected seed inventory within a reporting period. This provides an easy way to validate Unpackaged - Seeds row totals on the CTLS and CRA reports. - Unpackaged - Vegetative Cannabis Plants: An itemized list of transactions that affected vegetative cannabis plant inventory–plants in the Propagation and Vegetation stages–within a reporting period. This provides an easy way to validate Unpackaged - Vegetative Cannabis Plants row totals on the CTLS and CRA reports. - Unpackaged - Whole Cannabis Plants: An itemized list of transactions that affected whole cannabis plant inventory–plants in the Flowering stage–within a reporting period. This provides an easy way to validate Unpackaged - Whole Cannabis Plants row totals on the CTLS and CRA reports. - Unpackaged - Fresh: An itemized list of transactions that affected fresh post-harvest cannabis inventory within a reporting period. This provides an easy way to validate Unpackaged - Fresh Cannabis row totals on the CTLS report and fresh totals in Unpackaged - Dried/Fresh Cannabis rows on the CRA report. - Medical - Active Client Registration: A list of all clients who were active on the last day of the reporting month. This provides an easy way to validate Medical Information row totals on the CTLS report. 4. Indicate a reporting period in the field provided. mceclip3.png 5. Click Download the Report to generate the report in CSV format. From the Monthly Reports tab, you can also download the CTLS Report, Healthcare Practitioners Report, CRA Report, Monthly Weight Events Report, Batch Events Report, and Destruction Events Report.

Last updated on Feb 03, 2026

How to Generate a CTLS Reporting Template

A licence holder can download the CTLS Reporting Template on the first day of every month to pull data from the previous month. At midnight at the end of a reporting period–the final day of the month–Ample Organics takes a snapshot of the data in the licence holder's Seed-to-Sale environment and uses this data to populate the monthly report for the reporting period. Anytime you download one of these monthly reports, Ample Organics draws upon the most recent report snapshot for the selected month. This prevents you from generating reports with incomplete data halfway through a reporting period. You can, however, force the use of current data if the licence holder has made significant reporting corrections. Please note that the CTLS report generates all values in weight and volume fields to an accuracy of four decimal places. As the report can be submitted with values to a maximum of three decimal places, you will have to manually review the report each month and adjust the values before submitting the report. Kindly note that this report will not populate in full, and must be updated with data tracked outside of the Seed-to-Sale platform. Ample Organics has identified and acknowledged these gaps and will continue working towards supporting as much of the reporting requirements as we can throughout ongoing product updates. For a list of report columns that auto-populate each month, and an explanation of how Ample Organics gathers this data, visit the CTLS Report Data Breakdown. Required permission(s): report_hc_read 1. In the Reports module, open the Monthly Reports tab. mceclip0.png 2. In the CTLS Report sub-section, select a reporting month in the field provided. - If significant reporting corrections have been performed, check the Force use of current data box. This generates a new report based on current data and statuses. mceclip1.png 3. Click Download to generate and download the CTLS Reporting Template in CSV format. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* From the Monthly Reports tab, you can also download the Healthcare Practitioners Report, CRA Report, Monthly Weight Events Report, Batch Events Report, or Destruction Events Report. To verify the data pulled for monthly reports, download an Audit Report.

Last updated on Feb 03, 2026

How to Generate a Healthcare Practitioners Report

A licence holder can download the Healthcare Practitioners Report on the first day of every month to pull data from the previous month. At midnight at the end of a reporting period–the final day of the month–Ample Organics takes a snapshot of the data in the licence holder's Seed-to-Sale environment and uses this data to populate the monthly report for the reporting period. Anytime you download one of these monthly reports, Ample Organics draws upon the most recent report snapshot for the selected month. This prevents you from generating reports with incomplete data halfway through a reporting period. Kindly note that this report will not populate in full, and must updated with data tracked outside of the Seed-to-Sale platform. Ample Organics has identified and acknowledged these gaps and will continue working towards supporting as much of the reporting requirements as we can throughout ongoing product updates. Required permission(s): report_hc_read 1. In the Reports module, open the Monthly Reports tab. mceclip0.png 2. In the CTLS Health Care Practitioners Report sub-section, select the reporting month in the field provided. mceclip1.png 3. Click Download to generate the download the Healthcare Practitioners Report in CSV format. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* From the Monthly Reports tab, you can also download the CTLS Report, CRA Report, Monthly Weight Events Report, Batch Events Report, and Destruction Events Report. To verify the data pulled for monthly reports, download an Audit Report.

Last updated on Feb 03, 2026

Client Reports

In the Reports module, open the Clients tab in the Report Types section to access Client reports. Client reports allow the user to track clients–also known as patients–and their activities. Hover over a report heading to view the report's mandatory and optional filter fields, and click on the report heading to generate the report, in CSV format. Data in the reports is refreshed once daily. Historical reports display information on the day's opening inventory at 8:00 am local time, while standard reports display information based on snapshots taken at midnight. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* mceclip0.png The Seed-to-Sale software currently offers 21 distinct Client reports: - Inactive Patients - Patient Activity - Email Distribution - Marketing Email Unsubscribes - Patient Tracker - Patient Tracker 2 - Prescription Tracker - Referral Activity - Sales Channel - Order Availability - Client Order Count - Call Logs Report - Policy Type Report - Policy Usage Report - New Patients (Historical) - New Patients - AmpleCare Users - Client Prescription Expiry - VAC Active Patients - Symptoms & Ailments Report - Patient Prescription Extension Inactive Patients A record of inactive patients, defined by clients who were created in the system more than 90 days ago (from the date that the report is generated), but have not placed an order within the last 90 days. - Required Filter Fields: None - Optional Filter Fields: Include archived clients. - Order: By default, the report lists clients in ascending order by the Last Order column, so that clients who have been inactive for the longest time appear at the top of the report. - Data Points Pulled: - The inactive client's first name - The inactive client's last name - The client's ID string - The client's referral code (as applicable) - The date of the client's last order - The client's date of creation mceclip0.png Patient Activity A record of each client's activities since signing up with the licence holder, or during a specified date range. This report allows the user to track the volume of orders since the licence holder's inception, or during a specific time frame, enabling more accurate forecasting. - Required Filter Fields: None - Optional Filter Fields: Specify a date range using the Start and End date fields, or filter clients by Referral Code, Province, or Physician. Archived clients are excluded by default, but a user can also check the Include Archived box to include archived clients. - Order: By default, the report lists clients alphabetically by surname. - Data Points Pulled: - A client's full name - The client's ID string - The client's referral code (if applicable) - The number of orders placed to date or within the specified time frame - Whether or not the client's prescription is currently active - The client's registration status mceclip1.png Email Distribution A list of all client email addresses. - Required Filter Fields: None - Optional Filter Fields: Archived clients are excluded by default, but a user can also check the Include Archived box to include archived clients. - Order: By default, the report lists clients alphabetically by surname. - Data Points Pulled: - The client's full name - The client's email address - The client's referral code (if applicable) - The client's registration status - Whether or not the client is currently enabled mceclip2.png Marketing Email Unsubscribes A record of all clients who have unsubscribed from marketing emails, either since the licence holder's inception or within a specified date range. - Required Filter Fields: None - Optional Filter Fields: Specify a date range using the Start and End date fields. - Order: By default, the report lists clients alphabetically by surname - Data Points Pulled: - The client's full name - The client's email address - The date and time at which the client opted-out of receiving marketing emails. mceclip3.png Patient Tracker A detailed overview of existing clients, including personal information, prescription and registration information, and a record of the number of dollars spent and grams purchased by each client since registering with the licence holder. - Required Filter Fields: None. - Optional Filter Fields: Specify a date range using the Start and End date fields, or filter clients by Referral Code, Registration Status, or Physician. Archived clients are excluded by default, but a user can also check the Include Archived box to include archived clients. - Order: By default, the report lists clients alphabetically by first name. - Data Points Pulled for Each Client: - Personal Information - 16-digit ID number - K number, if applicable - Full name - Email - Primary Telephone - Primary Address - Referral code, if applicable - Prescription Information - Current prescription ID number - Doctor's name - Client's age - Monthly prescription allowance - THC and CBD potency limits, if applicable - The prescription's expiry date - Registration Information - Registration status - Days in current status - Client's date of creation - Client's date of registration - Client's date of re-registration (renewal) - Mailing address - Shipping address - Gender - Date of birth - First name - Middle name, if applicable - Last name - Sales Channels to which the client belongs - Order History - Total grams ordered - Total net dollars spent - Total net dollars spent within the last three months - Total net dollars spent within the last six months - Total net dollars spent within the last nine months - Total net dollars spent within the last twelve months - Prescription grams used within the last three months - Prescription grams used within the last six months - Prescription grams used within the last nine months - Prescription grams used within the last twelve months mceclip8.pngmceclip9.pngmceclip10.pngmceclip11.pngmceclip12.pngmceclip13.pngmceclip14.pngmceclip15.png Patient Tracker 2 A more concise version of the Patient Tracker report. This report does not include client address information, and filters out clients in the Lead status by default. Unlike the Patient Tracker report, Patient Tracker V2 indicates whether or not clients have a VAC policy. - Required Filter Fields: None. - Optional Filter Fields: Specify a date range using the Start and End date fields, or filter clients by Referral Code, Registration Status, or Physician. Archived clients are excluded by default, but a user can also check the Include Archived box to include archived clients. - Order: By default, the report lists clients alphabetically by first name. - Data Points Pulled for Each Client: - Personal Information - The 16-digit client ID number - K Number, if applicable - The client's Full name - Email - Province - Referral code, if applicable - Prescription Information - Whether or not the client has a VAC policy - Doctor's name - Client's age - Monthly prescription allowance - Script expiry - Registration Information - Registration status - Reason for refusal, if applicable - Whether or not the client has been transferred and returned - Days in current status - Client's date of creation - Client's date of registration - Client's date of re-registration (renewal) - Gender - Order History - Total grams ordered - Total net dollars spent - The client's preferred language mceclip0.pngmceclip1.pngmceclip2.png Prescription Tracker A detailed overview of existing prescriptions, including each prescription's gram and potency allowances, indoor and/or outdoor plant allowances, and basic physician and client information. - Required Filter Fields: None. - Optional Filter Fields: Specify a date range using the Start and End date fields, or filter clients by Referral Code, Registration Status, or VAC Only. Archived prescriptions are excluded by default, but a user can also check the Include Archived box. - Order: By default, the report lists prescription alphabetically by each client's surname. If a client has multiple prescriptions, the report sorts these prescriptions in ascending order by ID number. - Data Points Pulled for Each Prescription: - The associated client's 16-digit ID number - Prescription ID number - Client's name - Client's referral code, if applicable - Grams per day - Prescription start date - Prescription end date - THC limit, if applicable - CBD minimum, if applicable - Whether or not the client is using a renewed registration - Whether or not the prescription is active - The date and time at which the prescription was verified - The Ample Organics user who verified the prescription - Physician name - Consultation address - Client's MCR registraton number, if applicable - Max storage amount permitted for starting materials, in grams - Production area type - Max indoor plants permitted - Max outdoor plants permitted - Client's email - Client's mailing address - Client's K number, if applicable - Prescription referral code, if applicable mceclip7.pngmceclip8.pngmceclip9.pngmceclip10.pngmceclip11.png Referral Activity A record of all clients who registered with a referral code, and details of each client's subsequent purchases, within a specified date range. Use this report to ascertain how much revenue the licence holder has made as a result of each referral clinic. - Required Filter Fields: The user must specify a date range using the Start and End date fields - Optional Filter Fields: Filter results by selecting a specific referral code. By default, the report excludes archived clients, but a user can check the Include Archived box to include archived clients. - Order: By default, the report lists clients alphabetically by first name. - Data Points Pulled for Each Referred Client: - Full name - 16-digit ID number - Province - Physician - Cannabis strains purchased - Grams purchased - Purchase total ($) - Discount total ($) - Purchase total with discounts ($) - Referral code - K number, if applicable. mceclip12.pngmceclip13.png Sales Channel This report lists all clients within a specified sales channel, and summarizes each client's prescription and registration information. This is useful for analyzing or surveying clients who purchase specific types of products. - Required Filter Fields: The user must specify a sales channel using the Sales Channel drop-down menu. - Optional Filter Fields: By default, the report excludes archived clients, but a user can check the Include Archived box to include archived clients. - Order: By default, the report lists clients alphabetically by first name. - Data Points Pulled for Each Client in the Sales Channel: - 16-digit ID number - Full name - City - Province - Referral Code, if applicable - Doctor - Date of birth - Monthly prescription allowance - THC limit, if applicable - CBD limit, if applicable - Prescription expiry date - Registration status - Client's date of creation - Client's date of registration - Client's date of re-registration (renewal) if applicable - Email mceclip15.pngmceclip16.pngmceclip17.png Order Availability A record of all clients in the medical market with available grams in their current prescription period. This allows the licence holder to forecast upcoming purchases. - Required Filter Fields: None - Optional Filter Fields: Specify a date range using the Start and End date fields, or filter clients by Referral Code. Archived clients are excluded by default, but a user can also check the Include Archived box to include archived clients. - Order: By default, the report lists clients alphabetically by surname. - Data Points Pulled for Each Client: - 16-digit ID number - Registration status - Whether or not the client has a VA policy - Grams remaining under VA policy, if applicable - Referral code, if applicable - Grams available now - Grams available future (at the start of the client's next prescription period) - Date to order - Date on which last order was placed - Prescription expiry date mceclip18.pngmceclip19.png Client Order Count Total historical order count for each client with associated information. - Required Filter Fields: None - Optional Filter Fields: Archived clients are excluded by default, but a user can also check the Include Archived box to include archived clients. - Order: By default, the report lists clients in ascending order by the number of orders each client has placed. - Data Points Pulled for Each Client: - 16-digit ID number - First name - Last name - Email - Registration Status - Referral code, if applicable - Order count to date - Date of first order - Date of most recent order - The date of the first order placed using the client's active prescription mceclip0.pngmceclip1.png Call Logs Report A record of all recent call logs. This allows a licence holder to tally how long CSRs spend responding to calls from clients, and analyze the most common reasons clients call in. - Required Filter Fields: None - Optional Filter Fields: Archived clients are excluded by default, but a user can also check the Include Archived box to include archived clients. - Data Points Pulled for Each Client Call: - The ID number (two digits) of the client who called - The clent's 16-digit ID number - The client's first name - The client's last name - The client's phone number - The client's email - Last date of contact - Days since last contact - Call duration, in minutes - Call direction (inbound or outbound) - Call reason - A description of the call mceclip2.pngmceclip3.png Policy Type Report A high-level record of all policies. A user can filter this report to only display clients with a specific policy type. - Required Filter Fields: None - Optional Filter Fields: A user can filter this report to only display clients with a specific policy type. Policies that belong to archived clients are excluded by default, but a user can also check the Include Archived box to include archived clients. - Order: By default, the report lists policies by the associated client's surname, and then by policy ID number. - Data Points Pulled for Each Policy: - The client associated with the policy - The client's 16-digit ID number - The policy type name - The policy ID number - Whether or not the policy is enabled - Whether or not the policy is from Veteran's Affairs Canada - The policy number mceclip4.png Policy Usage Report A record of each unique order placed under a specified policy type within a specified date range. - Required Filter Fields: A user must specify a date range using the Start and End date fields. The user must also select a policy type from the drop-down menu provided. - Optional Filter Fields: Archived policies are excluded by default, but a user can also check the Include Archived box to include archived policies. - Order: By default, the report lists orders by ID number. - Data Points Pulled for Each Order partially covered by a Policy: - Order ID number - The client's 16-digit ID number - The date on which the order shipped, if applicable - The client's first name - The client's last name - The order's total cost before the policy deduction - The order's total cost after the policy deduction - The total amount of the order's cost covered by the policy - The total shipping cost - The total policy grams used - The total grams of cannabis in the order - The policy's ID number - The clients' referral code, if applicable. mceclip5.pngmceclip6.pngmceclip7.png New Patients (Historical) For generating a historical summary of new patients added to sales channels across several registration statuses. - Required Filter Fields: None. - Optional Filter Fields: A user may specify a date range using the Start and End date fields. - Order: The report lists sales channels by ID number. - Data Points Pulled for Each Sales Channel: - Number of clients added to the sales channel in the Approved status. - Number of clients added to the sales channel in the Renewed status. - Number of clients added to the sales channel in the Expired status. - Number of clients added to the sales channel in the Lead status. - Number of clients added to the sales channel in the Pending Registration status. mceclip0.png New Patients A record of all new patients, organized by date and associated sales channels. - Required Filter Fields: None. - Optional Filter Fields: A user may specify a date range using the Start and End date fields. - Order: The report lists sales channels by ID number. - Data Points Pulled for Each Sales Channel: - Number of clients added to the sales channel in the Approved status. - Number of clients added to the sales channel in the Renewed status. - Number of clients added to the sales channel in the Expired status. - Number of clients added to the sales channel in the Lead status. - Number of clients added to the sales channel in the Pending Registration status. mceclip1.png AmpleCare Users A record of clients imported using AmpleCare in a specified date range, as well as purchases placed by AmpleCare clients. - Required Filter Fields: A user must specify a date range using the Start and End date fields. - Optional Filter Fields: None. - Order: The report lists sales channels by ID number. - Data Points Pulled for Each Client created through AmpleCare: - The date at which the prescription was created - The prescription's ID number - The client's unique ID number - The client's last name - The client's first name - The client's date of birth - The client's phone number - The client's email - The client's referral code, if applicable - The order's ID number - The date the client purchased the products - The type of product purchased - The cost - The quantity of units ordered - The grams ordered - The client's registration status mceclip3.pngmceclip4.png Client Prescription Expiry A record of all clients with expired prescriptions within a specified date range. - Required Filter Fields: A user must specify a date range using the Start and End date fields. - Optional Filter Fields: Archived prescriptions are excluded by default. However, a user can check the Include Archived box to include archived prescriptions. - Order: The report lists sales channels by ID number. - Data Points Pulled for Each Client with an Expired Prescription: - Client ID - Full name - Email - Prescription ID number - Prescription end date–the date on which the prescription expired - Gram allowance per day - Prescribing physician - Prescription referral code, if applicable - Client referral code, if applicable - Current registration status - Date of birth mceclip2.pngmceclip3.png VAC Active Patients A list of all active clients registered with Veterans Affairs Canada and their registration information. - Required Filter Fields: None. - Optional Filter Fields: A user may specify a date range using the Start and End date fields. Archived clients are excluded by default. However, a user can check the Include Archived box to include archived clients. - Order: - Data Points Pulled for Each VAC Client: - First name - Last name - Policy ID number - Referral code, if applicable - 16-digit ID number - Prescription expiry date mceclip4.png Symptoms & Ailments A report of all clients who have symptoms and/or ailments identified in the Medical Profile tab on their Client Profile. This is useful for assessing the most common symptoms and ailments experienced across the client base. - Required Filter Fields: None. - Optional Filter Fields: None. - Order: - Data Points Pulled for Each Client: - Full name - 16-digit ID number - Date of birth - Postal code - Ailments selected - Symptoms selected - Average grams purchased in a single order - Medical condition(s) - Additional symptoms, if applicable - Dietary information, if applicable - Current medications, if applicable - Lifestyle information, if applicable - Cannabis preferences - Other notes mceclip6.pngmceclip8.pngmceclip9.png Patient Prescription Extension A report of all clients who have utilized the COVID-19 prescription extension. - Required Filter Fields: None. - Optional Filter Fields: None. - Data Points Pulled*:* - The client's unique ID number - The prescription's original expiration date - The prescription's extended expiration - The increase in days - The date the extension was granted - The user who extended the prescriptions. These reports contain sensitive information, so handle them with care. Click through the other tabs in the Report Types section to access Physician Reports, Order Reports, Product Reports, Complaints Reports, Inventory Reports, Health Canada Reports, Grow Reports, Destruction Reports, and Wholesale Reports.

Last updated on Feb 03, 2026

How to Generate a Canada Revenue Agency (CRA) Report

Follow the process below to generate a template with data to facilitate monthly Canada Revenue Agency reporting. At midnight at the end of a reporting period–the final day of the month–Ample Organics takes a snapshot of the data in the licence holder's Seed-to-Sale environment and uses this data to populate the monthly report for the reporting period. Whenever you download one of these monthly reports, Ample Organics draws upon the most recent report snapshot for the selected month. This prevents you from generating reports with incomplete data halfway through a reporting period. You can, however, force the use of current data if the licence holder has made significant reporting corrections. Please note that the CRA report generates all values in weight and volume fields to an accuracy of four decimal places. As the report can be submitted with values to a maximum of three decimal places, you will have to manually review the report each month and adjust the values before submitting the report. Kindly note that these reports will not populate in full, and need to be updated with data tracked outside of the Seed-to-Sale platform. Ample Organics has identified and acknowledged these gaps and will continue working towards supporting as much of the reporting requirements as we can throughout ongoing product updates. For a list of report columns that auto-populate each month, and an explanation of how Ample Organics gathers this data, visit the CRA Report Data Breakdown. Required permission(s): report_hc_read 1. In the Reports module, open the Monthly Reports tab. mceclip0.png 2. In the CRA Report sub-section, select a reporting month in the field provided. - If significant reporting corrections have been performed, check the Force use of current data box. This generates a new report based on current data and statuses. mceclip1.png 3. Click Download Report to generate and download the CRA Report in CSV format. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* From the Monthly Reports tab, you can also download the CTLS Report, Healthcare Practitioners Report, Monthly Weight Events Report, Batch Events Report, and Destruction Events Report. To verify the data pulled for monthly reports, download an Audit Report.

Last updated on Feb 03, 2026

Audit Report Breakdowns

Audit reports provide a line-by-line breakdown of transactional event histories that contribute to CTLS and CRA reports. This provides you with a method to verify report totals, identify erroneous transactions, and make adjustments before submitting the reports. For example, you can verify totals in the Seeds - Reductions columns on the CTLS report by generating the Unpackaged - Seeds audit report to see each time seed inventory was reduced within the reporting period. If one of the reduction events was created in error, you can adjust the totals on the CTLS report accordingly. The Seed-to-Sale software currently offers five audit reports: - Unpackaged - Seeds - Unpackaged - Vegetative Cannabis Plants - Unpackaged - Whole Cannabis Plants - Unpackaged - Fresh - Medical - Active Client Registration Unpackaged - Seeds mceclip0.png The Unpackaged - Seeds audit report pulls an itemized list of transactions that affected seed inventory within a reporting period. Use this audit report to verify data in the Unpackaged - Seeds section on the CTLS report and the Unpackaged - Viable Seed section on the CRA report. Additions The Additions section lists every time seeds were added to the inventory within the reporting month. To verify CTLS & CRA report totals, check that the weight and quantity of each transaction is accurate and that the source is properly recorded. Reductions The Reductions sections lists every time seed inventory reduced due to processing–seeds were planted to produce vegetative plants–or destruction. To verify CTLS & CRA totals, check that the weight and quantity of each transaction is accurate. For reductions due to destruction, ensure a Destroyed On date is populated in column H. Seeds that have been targeted for destruction but not destroyed will not count towards reduction totals; seeds are not considered "destroyed" until its parent Destruction Lot is Closed. Unpackaged - Vegetative Cannabis Plants mceclip1.png The Unpackaged - Vegetative Cannabis Plants audit report pulls an itemized list of transactions that affected vegetative cannabis plant inventory within a reporting period. This describes living plants in the Propagation and Vegetation stages. Use this audit report to verify data in the Unpackaged - Vegetative Plants section on the CTLS report and the Unpackaged - Vegetative Cannabis Plants section on the CRA report. Additions The Additions section lists every time vegetative cannabis plants were added to the inventory within the reporting month. This describes any time the licence holder created a new batch, excluding batches created from wholesale plants received in the Flowering stage. To verify CTLS & CRA report totals, check that the number of plants created in each batch is accurate. Also, check that each plant's source is recorded accurately in the Action column. Plants created from seeds or cuttings are tagged as Additions - Produced. Plants created from wholesale plants are tagged as Additions - Received Domestic or Additions - Received Imported, depending on the plants' country of origin. Reductions The Reductions section lists every time vegetative cannabis plants reduced due to processing or destruction. Reductions to processing describes non-flowering plants that advanced to the Flowering stage within the reporting month. To verify CTLS & CRA totals, check that the quantity of plants in each reduction category are accurate. For reductions due to destruction, ensure a Destroyed On date is populated in column H. Plants that have been targeted for destruction but not destroyed will not count towards reduction totals; plants are not considered "destroyed" until its parent Destruction Lot is Closed. Unpackaged - Whole Cannabis Plants mceclip2.png The Unpackaged - Whole Cannabis Plants audit report pulls an itemized list of transactions that affected whole cannabis plant inventory within a reporting period. This describes living plants in the Flowering stages. Use this audit report to verify data in the Unpackaged - Whole Plants section on the CTLS report and the Unpackaged - Whole Cannabis Plants section on the CRA report. Additions The Additions section lists every time whole cannabis plants were added to the inventory within the reporting month. This describes any time plants in the Vegetation stage advanced to Flowering, or any time a batch was created from wholesale plants received in the Flowering stage. To verify CTLS & CRA report totals, check that the number of plants is accurate. Also, check that each plant's source is recorded accurately in the Action column. Reductions The Reductions section lists every time whole cannabis plants reduced due to processing or destruction. Reductions to processing describes Flowering plants that were harvested within the reporting month. To verify CTLS & CRA totals, check that the quantity of plants in each reduction category are accurate. For reductions due to destruction, ensure a Destroyed On date is populated in column H. Plants that have been targeted for destruction but not destroyed will not count towards reduction totals; plants are not considered "destroyed" until its parent Destruction Lot is Closed. Unpackaged - Fresh mceclip3.png The Unpackaged - Fresh audit report pulls an itemized list of transactions that affected unpackaged bulk fresh cannabis inventory within a reporting period. Use this audit report to verify data in the Unpackaged - Fresh section on the CTLS report and fresh totals in the Unpackaged - Dried/Fresh Cannabis - Flowering Material section on the CRA report. Additions The Additions section lists every time bulk fresh cannabis inventory increased within the reporting month. This describes each time fresh harvest weight was output to a Bulk Lot. To verify CTLS & CRA report totals, check that the weight of each output is recorded accurately. Reductions The Reductions section lists every time fresh bulk cannabis inventory reduced due to processing within the reporting month. This describes any time fresh cannabis underwent a Drying Work Order. To verify CTLS & CRA report totals, check that the weight output to each Work Order is recorded accurately. Medical - Active Client Registration mceclip4.png The Medical - Active Client Registration audit report pulls an itemized list of transactions that affected client registration totals within a reporting period. This includes a list of active registrations, transferred registrations, returned registrations, and refused registrations. Use this audit report to verify data in the Medical Information section on the CTLS report. Visit the CTLS Report Data Breakdown and CRA Report Data Breakdown for a detailed explanation of how each column or cell on each monthly report collects data.

Last updated on Feb 03, 2026

Monthly Reports

From the Monthly Reports tab, you can generate and download reports that pull data for a selected reporting period of one calendar month. Some monthly reports are to satisfy monthly reporting requirements as laid out by Canadian government bodies–Health Canada, the Canada Revenue Agency, etc.–while other monthly reports assist the licence holder with inventory management and internal record keeping. mceclip0.png The Monthly Reports tab splits into three sections: Regulatory, Event History, and Unfinished Inventory. Regulatory Reports mceclip0.png In the Regulatory section, you can generate report templates to satisfy monthly reporting requirements as laid out by Health Canada and the Canada Revenue Agency (CRA). At midnight at the end of a reporting period–the final day of the month–the Seed-to-Sale software takes a snapshot of the data in the licence holder's Seed-to-Sale environment and uses this data to populate the monthly report for the reporting period. Anytime a user downloads one of these monthly reports, the Seed-to-Sale software draws upon the most recent report snapshot. This prevents you from generating reports with incomplete data halfway through a reporting period. You can, however, force the use of current data if significant reporting corrections have been performed. Kindly note that these reports will not populate in full, and need to be updated with data tracked outside of the Seed-to-Sale platform. Ample Organics has identified and acknowledged these gaps and will continue working towards supporting as much of the reporting requirements as we can throughout ongoing product updates. CTLS Report The downloadable CSV file for the Cannabis Tracking Report Template is formatted as per the monthly report file specifications for single-file upload onto the CTLS website. To Generate a CTLS Report, select a reporting period in the CTLS Cannabis Tracking Report sub-section, and click Download. For a list of report columns that auto-populate each month, and an explanation of how the Seed-to-Sale software gathers this data, visit the CTLS Report Data Breakdown. Healthcare Practitioners Report The Healthcare Practitioners Report lists information about each health care practitioner associated with all new client registrations during the reporting period. The report populates using physician data entered in the Medical Settings and Clients modules. To Generate a CTLS Healthcare Practitioners Report select a reporting period in the CTLS Healthcare Practitioners Report sub-section, and click Download. CRA Report To Generate a CRA Report, select a reporting period in the CRA Report sub-section, and click Download. For a list of report columns that auto-populate each month, and an explanation of how the Seed-to-Sale software gathers this data, visit the CRA Report Data Breakdown. Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation. Furthermore, the CRA and CTLS reports generate all values in weight and volume fields to an accuracy of four decimal places. As these reports can be submitted with values to a maximum of three decimal places, users will have to manually review each report every month and adjust the values before submitting the reports.* Event History Reports From the Event History section, you can generate an event history audit report for a selected reporting period. Audit reports provide a line-by-line breakdown of transactional event histories that contribute to CTLS and CRA reports. This provides you with a method to verify report totals, identify erroneous transactions, and make adjustments before submitting the reports. For example, you can verify totals in the Seeds - Reductions columns on the CTLS report by generating the Unpackaged - Seeds audit report to see each time seed inventory was reduced within the reporting period. If one of the reduction events was created in error, you can adjust the totals on the CTLS report accordingly. mceclip3.png Audit report options include: - - Unpackaged - Seeds: An itemized list of transactions that affected seed inventory within a reporting period. This provides an easy way to validate Unpackaged - Seeds row totals on the CTLS and CRA reports. - Unpackaged - Vegetative Cannabis Plants: An itemized list of transactions that affected vegetative cannabis plant inventory–plants in the Propagation and Vegetation stages–within a reporting period. This provides an easy way to validate Unpackaged - Vegetative Cannabis Plants row totals on the CTLS and CRA reports. - Unpackaged - Whole Cannabis Plants: An itemized list of transactions that affected whole cannabis plant inventory–plants in the Flowering stage–within a reporting period. This provides an easy way to validate Unpackaged - Whole Cannabis Plants row totals on the CTLS and CRA reports. - Unpackaged - Fresh: An itemized list of transactions that affected fresh post-harvest cannabis inventory within a reporting period. This provides an easy way to validate Unpackaged - Fresh Cannabis row totals on the CTLS report and fresh totals in Unpackaged - Dried/Fresh Cannabis rows on the CRA report. - Medical - Active Client Registration: A list of all clients who were active on the last day of the reporting month. This provides an easy way to validate Medical Information row totals on the CTLS report. Complete the provided fields to Generate an Audit Report. Visit the Audit Reports Breakdown to learn how to use the audit repots to verify reporting data. Unfinished Inventory Reports mceclip1.png From the Unfinished Inventory section, you can generate an unfinished inventory report for a selected reporting period. These reports are useful for verifying data pulled to populate the monthly CTLS and CRA Reports. This section provides three options: - The Weight Events Report provides a method to verify all weight events across all Bulk Lots within a month, which allows them to reconcile inventory and verify other monthly reporting templates. - The Destruction Events Report provides a detailed view of every destruction weight event associated with Destruction Lots that were closed during the reporting period. - The Batch Events Report provides a detailed view of every history event that occurred across all batches during a given month. For more reporting options, Weekly Shipping Report, or Client Order Count Report. To configure facility information, visit the Settings tab.

Last updated on Feb 03, 2026

CRA Report Data Breakdown

Below is a breakdown of data pulled to populate each column in the monthly CRA reporting template. Some columns on each report are outside the scope of the Seed-to-Sale software's function, so these reports do not populate in full. For each report, columns that auto-populate each month are highlighted in light teal. The Logic column describes how the Seed-to-Sale software collects this data. The Stock Report Validation column lists other reports that pull the same data. Please note that the CRA report generates all values in weight and volume fields to an accuracy of four decimal places. As the report can be submitted with values to a maximum of three decimal places, you must manually review the report each month and adjust the values before submitting the report. Click on one of the links below to jump to a specific section of the CRA Report. - Cannabis Product Inventory – Unpackaged - Unpackaged – Dried/Fresh Cannabis – Flowering Material - Unpackaged – Dried/Fresh Cannabis – Non-Flowering Material - Unpackaged – Whole Cannabis Plant - Unpackaged – Viable Seed - Unpackaged – Vegetative Cannabis Plant - Unpackaged – Pure Intermediates - Unpackaged – Finished Cannabis Extracts - Unpackaged – Finished Edible Cannabis - Unpackaged – Finished Cannabis Topicals - Cannabis Product Inventory – Packaged - Packaged – Dried/Fresh Cannabis - Packaged – Cannabis Plant Seeds - Packaged – Cannabis Plants - Packaged – Cannabis Extracts - Packaged – Edible Cannabis - Packaged – Topicals - Sales - Sales – Dried/Fresh Cannabis - Sales – Cannabis Plant Seed - Sales – Cannabis Plants - Sales – Cannabis Extracts - Sales – Edible Cannabis - Sales – Cannabis Topicals Cannabis Product Inventory – Unpackaged Unpackaged – Dried/Fresh Cannabis – Flowering Material Validate fresh cannabis totals with the Unpackaged - Fresh Cannabis Audit Report. | | | | | | --- | --- | --- | --- | | Cell Name | UoM | Logic | Stock Report Validation | | Opening Inventory | kg | The sum weight in kg of unpackaged dried and fresh cannabis–in both discrete and non-discrete forms–in the inventory on the first day of the reporting month. This includes dried and fresh Bulk Lots, retained samples and tote weight from dried and fresh lots, dried or fresh Work Order input weight in Work Orders that are not closed, and dried and fresh weight in Destruction sublots that have not been closed. Note that tote weight is not counted separately from Bulk Lot weight, as a tote is a subset of a Bulk Lot. | Pull the Historical Bulk Inventory report, with the Start Date set to the first day of the reporting month. | | Additions to Inventory | | Total Production | kg | The sum–in kg–of fresh and dried cannabis weight produced during the reporting month. This includes the total weight output to fresh Bulk Lots from harvests–considering all harvest methods–within the reporting month. This also includes the total dried weight output from Work Orders that use the "Convert Fresh to Dried" function, where those Work Orders were closed during the reporting month. | For dried flower, use the Work Order Inventory report, setting the date range as the reporting month, to find Work Orders where the input lot type is Fresh and the output lot type is Dried. Look at the output weight. For fresh flower, use the Harvest report to look at Harvested Weight (taking into account the differences in harvesting methods, e.g. total weight vs. weigh individual plants). | | Quantity received in Canada | kg | | | | Quantity imported into Canada | kg | | | | Reductions to Inventory | | Quantity packaged | kg | The sum–in kg–of weight packaged from dried Bulk Lots into dried EA SKUs, considering all packaging methods, within the reporting month. | Pull the Bottles Created Report. | | Quantity taken for further processing or planted | kg | The sum–in kg–of fresh and dried cannabis weight sent for processing during the reporting month. This includes the total weight from dried Bulk Lots input to Work Orders that were closed during the reporting month, where the output lot type was Pure Intermediates. This also includes the total weight from fresh Bulk Lots input to Work Orders that were closed during the reporting month, where the output lot type was not fresh. | Pull the Work Order Inventory report, setting the date range as the reporting month to find Work Orders where the input lot type is Dried and the output lot type is Pure Intermediates, and Work Orders where the input lot type is Fresh and the output lot type is any other class of cannabis. In both cases, consider the input weight. | | Quantity delivered in Canada | kg | | | | Quantity exported outside Canada | kg | | | | Quantity incurred as drying or processing loss | kg | | Pull the Work Orders Inventory report. | | Quantity destroyed | kg | | Pull the Destructions Weight Events report. | | Quantity sent for analysis | kg | The sum–in kg–of lab report samples created from dried Bulk Lots, where the lab report's "Sample Sent" setting is set to "Yes", and the "Date Sent" is within the reporting month. | Pull the Lab Samples report. | | Quantity taken to produce low-THC cannabis products and prescription cannabis drugs | kg | | | | Other | kg | | | | Closing Inventory | | Closing Inventory | kg | The sum weight in kg of unpackaged dried and fresh cannabis–in both discrete and non-discrete forms–in the inventory on the last day of the reporting month. This includes dried and fresh Bulk Lots, retained samples and tote weight from dried and fresh lots, dried or fresh Work Order input weight in Work Orders that are not closed, and dried and fresh weight in Destruction sublots that have not been closed. Note that tote weight is not counted separately from Bulk Lot weight, as a tote is a subset of a Bulk Lot. | Pull the Historical Bulk Inventory Report, and look at the first day of the month after the reporting month. | Unpackaged –Dried/Fresh Cannabis – Non-Flowering Material The Seed-to-Sale software does not currently pull data to populate this section of the CRA report. This will be addressed in an upcoming release. Unpackaged – Whole Cannabis Plant Validate these totals with the Unpackaged - Whole Cannabis Plants Audit Report. | | | | | | --- | --- | --- | --- | | Column Name | UoM | Logic | Stock Report Validation | | Opening Inventory | Units | The quantity–in units–of flowering plants in the inventory on the first day of the reporting month. This includes any plants in the Flowering stage in living batches or in open Destruction sublots. | Pull the Historical Plant Inventory, and look at the first day of the reporting month. | | Additions to Inventory | | Quantity received in Canada | Units | The quantity–in units–of flowering plants created via Wholesale within the reporting month where the Source is set to "Received-Domestic". | Pull the Plant Creation report, with the date range set to the reporting month. Filter by Created Via and Phase. | | Quantity transferred from vegetative cannabis plant | Units | The quantity–in units–of plants that matured from the Vegetation stage to the Flowering stage within the reporting month. | Pull the Plant Creation report, with the date range set to the reporting month. Filter by Created Via and Phase. | | Reductions to Inventory | | Plant harvested | Units | The quantity–in units–of flowering plants harvested within the reporting month. | Pull the Harvest report, and set the date range to the reporting month. | | Quantity delivered in Canada | Units | | | | Quantity exported outside Canada | Units | | | | Quantity destroyed | Units | The quantity–in units–of flowering plants in Destruction sublots that were closed during the reporting month. | Pull the Plant Destruction report with the date range set to the reporting month. Filter by Phase. | | Quantity sent for analysis | Units | | | | Other | Units | | | | Closing Inventory | | Closing inventory | Units | The quantity–in units–of flowering plants in the inventory on the last day of the reporting month. This includes any plants in the Flowering stage in living batches or in open Destruction sublots. | Pull the Historical Plant Inventory report to look at the first day of the month after the reporting month. | Unpackaged – Viable Seed Validate these totals with the Unpackaged - Seeds Audit Report. | | | | | | --- | --- | --- | --- | | Column Name | UoM | Notes / Logic | Stock Report Validation | | Opening Inventory | Units | The quantity–in units–of seeds in Seed Lots on the first day of the reporting month. | Pull the Historical Seed Inventory Report, with the Start Date set to the first day of the reporting month. | | Additions to Inventory | | Total Production | Units | The quantity–in units–of seeds in Seed Lots created within the reporting month, where the source is set to "Produced". | Pull the Historical Seed Inventory and Seed Inventory reports. | | Quantity received in Canada | Units | The quantity–in units–of seeds in Seed Lots created during the reporting month where the Source is set to "Received-Domestic". | Pull the Historical Seed Inventory and Seed Inventory reports. | | Quantity imported into Canada | Units | The quantity–in units–of seeds in Seed Lots created during the reporting month where the Source is set to "Received-Imported". | Pull the Historical Seed Inventory and Seed Inventory reports. | | Reductions to Inventory | | Quantity packaged | Units | | | | Quantity taken for further processing or planted | Units | The quantity–in units–of seeds converted to plants within the reporting month. | Pull the Plant Creation report, with the date range set to the reporting month. Refer to the total plants that were created via "seed". | | Quantity delivered in Canada | Units | | | | Quantity exported outside Canada | Units | | | | Quantity destroyed | Units | The quantity–in units–of seeds in Destruction sublots that were closed during the reporting month. | Pull the Destruction Weight Events report and look for the source "Seed Lot". | | Quantity sent for analysis | Units | | | | Other | Units | | | | Closing Inventory | | Closing Inventory | Units | The quantity–in units–of seeds in Seed Lots on the last day of the reporting month. | Pull the Historical Seed Inventory report, with the Start Date set to the last day of the reporting month. | Unpackaged – Vegetative Cannabis Plant Validate these totals with the Unpackaged - Vegetative Cannabis Plants Audit Report. | | | | | | --- | --- | --- | --- | | Column Name | UoM | Notes / Logic | Stock Report Validation | | Opening Inventory | Units | The quantity–in units–of non-flowering plants in the inventory on the first day of the reporting month. This includes any plants in the Propagation or Vegetation stages in living batches or in open Destruction sublots. | Pull the Historical Plant Inventory report with the start date set to the first day of the reporting month. Filter by Stage. | | Additions to Inventory | | Total Production | Units | The quantity–in units–of non-flowering plants produced during the reporting month. This describes all plants created via cuttings or seeds within the reporting month. | Pull the Plant Creation report with the date range set to the reporting month. Filter by Phase and Created Via. | | Quantity received in Canada | Units | The quantity–in units–of non-flowering plants created via Wholesale within the reporting month where the Source is set to "Received-Domestic". | Pull the Plant Creation report with the date range set to the reporting month. Filter by Phase and Created Via. | | Quantity imported into Canada | Units | The quantity–in units–of non-flowering plants created via Wholesale within the reporting month where the Source is set to "Received-Imported". | Pull the Plant Creation report with the date range set to the reporting month. Filter by Phase and Created Via. | | Reductions to Inventory | | Quantity packaged | Units | | | | Quantity delivered in Canada | Units | | | | Quantity exported outside Canada | Units | | | | Quantity destroyed | Units | The quantity–in units–of non-flowering plants in Destruction sublots that were closed during the reporting month. | Pull the Plant Destruction report with the date range set to the reporting month. Filter by Phase. | | Quantity sent for analysis | Units | | | | Quantity transferred to whole cannabis plant | Units | The quantity–in units–of plants that matured from the Vegetation stage to the Flowering stage within the reporting month. | Pull the Plant Creation report with the date range set to the reporting month. Filter by Phase and Created Via. | | Other | Units | | | | Closing Inventory | | Closing Inventory | Units | The quantity–in units–of non-flowering plants in the inventory on the last day of the reporting month. This includes any plants in the Propagation or Vegetation stages in living batches or in open Destruction sublots. | Pull the Historical Plant Inventory report and look at the first day of the month after the reporting month. | Unpackaged – Pure Intermediates | | | | | | --- | --- | --- | --- | | Column Name | UoM | Notes / Logic | Stock Report Validations | | Opening Inventory | kg | The sum weight in kg of unpackaged Pure Intermediates cannabis in the inventory on the first day of the reporting month. This includes Pure Intermediates Bulk Lots, retained samples and tote weight from Pure Intermediates lots, Pure Intermediates Work Order input weight in Work Orders that are not closed, and Pure Intermediates weight in Destruction sublots that have not been closed. Note that tote weight is not counted separately from Bulk Lot weight, as a tote is a subset of a Bulk Lot. | Pull the Historical Bulk Inventory report, with the Start Date set to the first day of the reporting month. Filter by Lot Type. | | Additions to Inventory | | Total Production | kg | The sum–in kg–of Pure Intermediates cannabis weight produced during the reporting month. This describes the total Pure Intermediates weight output from Work Orders that were closed during the reporting month. | Pull the Work Order Inventory report, with the date range set to the reporting month. Filter by Output Lot Type. | | Quality received in Canada | kg | | | | Quantity imported into Canada | kg | | | | Reductions to Inventory | | Quantity taken for further processing or planted | kg | The sum–in kg–of Pure Intermediates cannabis weight sent for processing during the reporting month. This includes the total weight from Pure Intermediates Bulk Lots input to Work Orders that were closed during the reporting month, where the output lot type was Edibles-Solids, Edibles-Non-solids, Extracts-Ingested, Extracts-Inhaled, Extracts-Other, or Topicals. | Pull the Work Order Inventory report, with the date range set to the reporting month. Filter by Input Lot Type and Output Lot Type. | | Quantity delivered in Canada | kg | | | | Quantity exported outside Canada | kg | | | | Quantity incurred as drying or processing loss | kg | | | | Quantity destroyed | kg | | Pull the Destruction Weight Events report and set the date range to the reporting month. Sort by source material. | | Quantity sent for analysis | kg | The sum–in kg–of lab report samples created from Pure Intermediates Bulk Lots, where the lab report's "Sample Sent" setting is set to "Yes", and the "Date Sent" is within the reporting month. | Pull the Lab Samples report and set the date range to the reporting month. Filter by Bulk Lot Type. | | Quantity taken to produce low-THC cannabis products and prescription cannabis drugs | kg | | | | Other | kg | | | | Closing Inventory | | Closing Inventory | kg | The sum weight in kg of unpackaged Pure Intermediates cannabis in the inventory on the last day of the reporting month. This includes Pure Intermediates Bulk Lots, retained samples and tote weight from Pure Intermediates lots, Pure Intermediates Work Order input weight in Work Orders that are not closed, and Pure Intermediates weight in Destruction sublots that have not been closed. Note that tote weight is not counted separately from Bulk Lot weight, as a tote is a subset of a Bulk Lot. | Pull the Historical Bulk Inventory report, with the Start Date set to the last day of the reporting month. Filter by Lot Type. | Unpackaged – Finished Cannabis Extracts The Seed-to-Sale software does not currently pull data to populate this section of the CRA report. This will be addressed in an upcoming release. Unpackaged – Finished Edible Cannabis The Seed-to-Sale software does not currently pull data to populate this section of the CRA report. This will be addressed in an upcoming release. Unpackaged – Finished Cannabis Topicals The Seed-to-Sale software does not currently pull data to populate this section of the CRA report. This will be addressed in an upcoming release. Cannabis Product Inventory – Packaged Packaged – Dried/Fresh Cannabis | | | | | | --- | --- | --- | --- | | Cell Name | UoM | Logic | Stock Report Validation | | Opening Inventory | kg | The sum weight in kg of packaged dried and fresh cannabis–in both discrete and non-discrete forms–in the inventory on the first day of the reporting month. This includes bottles in the available inventory, bottles reserved on medical orders that have not been fulfilled, and bottles in cases that have not yet been sold. | | | Additions to Inventory | | Additions to inventory | kg | The sum weight in kg of dried cannabis bottles added to the inventory through Packaging Runs and Received Inventory within the reporting month. | Pull the Bottles Created report, with the date range set to the reporting month. Consider the Total Bottles. | | Reductions to Inventory | | Quantity delivered to a purchaser in Canada | kg | The sum weight in kg of dried cannabis bottles sold through medical and wholesale orders to clients or vendors in Canada within the reporting month. | For medical orders: Pull the Sales Report V2, and set the date range to the reporting month. Assess the Grams Ordered. For wholesale orders: Pull the Sales by Line Item report, and assess the Gross Net Weight. | | Quantity destroyed | kg | The sum weight in kg of dried cannabis bottles destroyed during the reporting month. | Pull the Destruction Weight Events report, with the date range set to the reporting month. Sort by Source Material. | | Other | kg | | | | Closing Inventory | | Closing Inventory | kg | The sum weight in kg of packaged dried and fresh cannabis–in both discrete and non-discrete forms–in the inventory on the last day of the reporting month. This includes bottles in the available inventory, bottles reserved on medical orders that have not been fulfilled, and bottles in cases that have not yet been sold. | Pull the Historical Packaged Inventory report, with the date range set to the reporting month. | Packaged – Cannabis Plant Seeds Ample Organics does not collect data to populate this section, as the Seed-to-Sale software does not accommodate packaging seeds. Packaged – Cannabis Plants Ample Organics does not collect data to populate this section, as the Seed-to-Sale software does not accommodate packaging living cannabis plants. Packaged – Cannabis Extracts Ample Organics does not currently collect data to populate this section. | | | | | | --- | --- | --- | --- | | Cell Name | UoM | Logic | Stock Report Validation | | Opening Inventory | mg (of total THC) | | | | Additions to Inventory | | Additions to inventory | mg (of total THC) | | | | Reductions to Inventory | | Quantity delivered to a purchaser in Canada | mg (of total THC) | | | | Quantity destroyed | mg (of total THC) | | | | Other | mg (of total THC) | | | | Closing Inventory | | Closing Inventory | mg (of total THC) | | | Packaged – Edible Cannabis Ample Organics does not currently collect data to populate this section. | | | | | | --- | --- | --- | --- | | Cell Name | UoM | Logic | Stock Report Validation | | Opening Inventory | mg (of total THC) | | | | Additions to Inventory | | Additions to inventory | mg (of total THC) | | | | Reductions to Inventory | | Quantity delivered to a purchaser in Canada | mg (of total THC) | | | | Quantity destroyed | mg (of total THC) | | | | Other | mg (of total THC) | | | | Closing Inventory | | Closing Inventory | mg (of total THC) | | | Packaged – Cannabis Topicals Ample Organics does not currently collect data to populate this section. | | | | | | --- | --- | --- | --- | | Cell Name | UoM | Logic | Stock Report Validation | | Opening Inventory | mg (of total THC) | | | | Additions to Inventory | | Additions to inventory | mg (of total THC) | | | | Reductions to Inventory | | Quantity delivered to a purchaser in Canada | mg (of total THC) | | | | Quantity destroyed | mg (of total THC) | | | | Other | mg (of total THC) | | | | Closing Inventory | | Closing Inventory | mg (of total THC) | | | Sales Sales – Dried/Fresh Cannabis | | | | | | --- | --- | --- | --- | | Cell name | UoM | Logic | Stock Report Validation | | Alberta | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Alberta through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to Alberta through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Alberta through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | British Columbia | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to British Columbia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to British Columbia through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to British Columbia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Manitoba | | | | | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Manitoba through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to Manitoba through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Manitoba through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | New Brunswick | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to New Brunswick through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to New Brunswick through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to New Brunswick through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Newfoundland and Labrador | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Newfoundland and Labrador through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to Newfoundland and Labrador through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Newfoundland and Labrador through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Northwest Territories | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to the Northwest Territories through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to the Northwest Territories through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to the Northwest Territories through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Nova Scotia | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Nova Scotia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to Nova Scotia through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Nova Scotia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Nunavut | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Nunavut through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to Nunavut through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Nunavut through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Ontario | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Ontario through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to Ontario through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Ontario through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Prince Edward Island | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Prince Edward Island through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to Prince Edward Island through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Prince Edward Island through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Quebec | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Quebec through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to Quebec through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Quebec through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Saskatchewan | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Saskatchewan through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to Saskatchewan through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to Saskatchewan through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Yukon | | | Sales | $ | The sum value of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to the Yukon through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | kg | The sum weight, in kg, of packaged fresh and dried cannabis–both discrete and non-discrete–sold to the Yukon through medical and wholesale orders during the reporting month. Weight totals are calculated based on the actual weight of each bottle, rather than by using each SKU's Net Weight value. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Packages sold | units | The sum quantity of packaged Dried/Fresh EA units–both discrete and non-discrete–sold to the Yukon through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | Sales – Cannabis Plant Seeds The Seed-to-Sale software does not collect data to populate this section. This will be addressed in a coming release. Sales – Cannabis Plants The Seed-to-Sale software does not collect data to populate this section. This will be addressed in a coming release. Sales – Cannabis Extracts | | | | | | --- | --- | --- | --- | | Cell name | UoM | Logic | Stock Report Validation | | Alberta | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to Alberta through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to Alberta through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | British Columbia | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to British Columbia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to British Columbia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Manitoba | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to Manitoba through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to Manitoba through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | New Brunswick | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to New Brunswick through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to New Brunswick through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Newfoundland and Labrador | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to Newfoundland and Labrador through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to Newfoundland and Labrador through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Northwest Territories | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to the Northwest Territories through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to the Northwest Territories through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Nova Scotia | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to Nova Scotia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to Nova Scotia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Nunavut | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to Nunavut through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to Nunavut through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Ontario | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to Ontario through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to Ontario through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Prince Edward Island | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to Prince Edward Island through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to Prince Edward Island through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Quebec | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to Quebec through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to Quebec through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Saskatchewan | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to Saskatchewan through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to Saskatchewan through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Yukon | | | Sales | $ | The sum value of packaged Extracts EA units–both discrete and non-discrete–sold to the Yukon through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged extracts EA units–both discrete and non-discrete–sold to the Yukon through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | Sales – Edible Cannabis | | | | | | --- | --- | --- | --- | | Cell name | UoM | Logic | Stock Report Validation | | Alberta | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Alberta through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to Alberta through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | British Columbia | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to British Columbia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to British Columbia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Manitoba | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Manitoba through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to Manitoba through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | New Brunswick | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to New Brunswick through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to New Brunswick through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Newfoundland and Labrador | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Newfoundland and Labrador through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to Newfoundland and Labrador through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Northwest Territories | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Northwest Territories through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to the Northwest Territories through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Nova Scotia | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Nova Scotia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to Nova Scotia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Nunavut | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Nunavut through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to Nunavut through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Ontario | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Ontario through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to Ontario through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Prince Edward Island | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Prince Edward Island through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to Prince Edward Island through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Quebec | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Quebec through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to Quebec through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Saskatchewan | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to Saskatchewan through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to Saskatchewan through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Yukon | | | Sales | $ | The sum value of packaged Edibles-Solids and Edibles-Non Solids EA units–both discrete and non-discrete–sold to the Yukon through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged edible cannabis EA units–both discrete and non-discrete–sold to the Yukon through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | Sales – Cannabis Topicals | | | | | | --- | --- | --- | --- | | Cell name | UoM | Logic | Stock Report Validation | | Alberta | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to Alberta through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to Alberta through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | British Columbia | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to British Columbia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to British Columbia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Manitoba | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to Manitoba through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to Manitoba through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | New Brunswick | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to New Brunswick through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to New Brunswick through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Newfoundland and Labrador | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to Newfoundland and Labrador through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to Newfoundland and Labrador through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Northwest Territories | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to the Northwest Territories through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to the Northwest Territories through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Nova Scotia | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to Nova Scotia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to Nova Scotia through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Nunavut | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to Nunavut through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to Nunavut through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Ontario | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to Ontario through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to Ontario through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Prince Edward Island | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to Prince Edward Island through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to Prince Edward Island through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Quebec | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to Quebec through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to Quebec through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Saskatchewan | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to Saskatchewan through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to Saskatchewan through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | | Yukon | | | Sales | $ | The sum value of packaged Topicals EA units–both discrete and non-discrete–sold to the Yukon through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | | | | Sales | mg of Total THC | | | | | Packages sold | units | The sum quantity of packaged topicals EA unit–both discrete and non-discrete–sold to the Yukon through medical and wholesale orders during the reporting month. Sales are determined to be within the reporting month based on the order's shipment date. | Pull Sales Report V2 for the whole reporting month. Filter by Province and tally the number of units of SKUs of the specific subclass shipped. | Visit the CTLS Report Data Breakdown for a detailed list of each column on the monthly CTLS Report that auto-populates, and how each column collects data.

Last updated on Feb 03, 2026

Reports Module

The Reports module houses data exports necessary for business reporting and regulatory compliance. Data in the reports is refreshed once daily. Historical reports display data based on snapshots taken at 8:00am local time, while standard reports display data based on snapshots taken at 12:00am local time. Monthly reports display data based on a snapshot taken at the end of each reporting month. mceclip0.png The Reports module splits into five tabs: Reports, Weekly Shipping, Client Order Counts, Monthly Reports, and Settings.Opening the Reports module brings you to the Reports tab by default. Reports On the Reports tab, you can generate and download a diverse menu of custom reports in CSV format. Here, reports are categorized by Report Type: Clients, Physicians, Orders, Products, Complaints, Inventory, Health Canada, Grow Reports, Destruction,and Wholesale. Select a Report Type and hover over a specific report to view filtering options for the report. Required fields for the report will be highlighted in red, while optional fields will be highlighted in green. Filter fields that are not highlighted are not applicable to the report and will not affect report filtering. Select a report to Generate a Custom Report. mceclip3.png Note*: Generating a report with a large date range may take several minutes while data is collected. Try downloading reports periodically or wait until off hours for report generation.* Weekly Shipping The Weekly Shipping tab enables quick configuration of shipping reports and displays tracking information, carrier, and shipping date. Select a date range and shipping provider for full report control. mceclip1.png Fill out the fields provided to Generate a Weekly Shipping Report. Client Order Counts The Client Order Counts tab provides lists of patients who have placed 0 to 5 orders. Open the drop-down menu to filter clients by order count. mceclip2.png For more reporting options, visit the Monthly Reports tab.

Last updated on Feb 03, 2026