Effective July 1st, 2024, new AGCO standards relating to regulatory reporting requirements - the Registrar’s Standards for Cannabis Retail Stores using the Point-of-Sale Data Reporting Platform - will require notifications for data reconciliation errors that may require resolution to be shown. What this means is that as part of the POS Data Reporting Platform, which automatically receives data for your required provincial and federal regulatory reporting from your POS system, you may receive data reconciliation error notifications that will require you to review and resolve.
The following is a table of various error messages that you may receive, a definition of the error message and resolution step that needs to be taken to correct the error message.
Error Message | Error Message Definition | Resolution |
SKU could not be matched SKU [<SKU>] could not be matched. | This error message indicates that we are unable to match this SKU. | Please validate the SKU and update the information in your system. |
UPC barcode could not be matched UPC Barcode [<UPC_BARCODE>] could not be matched. | This error message indicates that we are unable to match this UPC. | Please validate the UPC and update the information in your system. |
SKU and UPC barcode could not be matched SKU [<SKU>] and UPC Barcode [<UPC_BARCODE>] could not be matched. | This error message means that both the SKU and/or UPC are invalid. | Please validate both the SKU and UPC and update the information in your system. |
Negative inventory Observed negative inventory for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>]. | This error message indicates that aggregation of your data is displaying a negative inventory status. | Please validate your on-hand inventory and update your system. |
Transfers not balanced (sender) Observed transfer imbalance for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>] sent to CRSA [<COUNTER_PARTY_CRSA>]. | This error message indicates that the transfer has not been received on the receiving end. | Please validate that the Counter Party CRSA is correct. If any changes need to be made, please contact your POS Provider for assistance. |
Inventory position quantity does not match observed quantity Observed Inventory Position imbalance for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>]. | This error message indicates that the aggregation of events does not equal the values in the Inventory Position. | Please validate your on-hand inventory and update the information in your system. |
Invalid SKU transfer (unexpected CROL) Observed a transfer to unexpected CROL for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>]. | This error message indicates that we are unable to complete the transfer transaction as the Counter Party CRSA can not be validated. | Please validate that the Counter Party CRSA information is correct. If any changes need to be made, please contact your POS Provider for assistance. |
Invalid SKU transfer (same CRSA) Observed a transfer between same CRSA for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>]. | This error message indicates that the transfer is occurring with your own location, which is not permitted. | Please validate that the transfer information is correct. If any changes are required, please contact your POS Provider for assistance. |
Invalid SKU transfer (invalid CRSA) Observed a transfer to invalid CRSA for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>]. | This error message indicates that we are unable to complete the transfer transaction as the Counter Party CRSA can not be validated. | Please validate that the Counter Party CRSA information is correct. If any changes need to be made, please contact your POS Provider for assistance. |
Transfers not balanced (recipient) Observed transfer imbalance for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>] received from CRSA [<COUNTER_PARTY_CRSA>]. | This error message indicates that the transfer has not been sent on the sender’s end. | Please validate that the Counter Party CRSA is correct. If any changes need to be made, please contact your POS Provider for assistance. |
SKU and UPC barcode mismatch SKU [<SKU>] and UPC Barcode [<UPC_BARCODE>] were matched for different products. | This error message indicates that both the SKU and UPC for this transaction reference different products. | Please validate the SKU and UPC and update the information in your system. |
If you have any questions about specific error messages, please reach out to our Customer Support. For questions about regulatory requirements, please refer to the standards at the location online indicated above or reach out to the AGCO at [email protected]. If you would like to update your primary contact for receiving data reconciliation error emails, please reach out to the OCS Customer Care Team by calling 1-877-627-1627 or contact them through their chat.