A significant number of agents are already participating in the LCBO's Information Sharing Program. This program provides you with the data you need to:
- Proactively react to inventory issues;
- Note how your suppliers are shipping;
- Confirm receipt dates; and
- Follow up with your supplier to resolve issues.
Four reports were developed with input from our industry partners who identified which information would be most useful to share. The reports are updated and sent to you each week by e-mail. You will require an Internet email capable computer with Microsoft Internet Explorer 5.5, Outlook 97 and Excel 97 (or later software versions) as well as an Internet provider. The Internet provider will supply an email account to which your specific reports will be directed. Each report is sent to you as a separate email attachment in both html and Excel formats.
Reports available are: Purchase Order Summary, Purchase Order Status, Purchase Order Tracker, and Inventory Report. To receive the reports, you will need to meet the technical requirements and complete a Terms and Conditions of Licence Form. The completed form should be sent to email@example.com
If you are already set up in the LCBO's Information Sharing Program and need to make any changes, please contact the appropriate category: LCBO Sales, Marketing & Insights.
If you are new to this program or are experiencing technical difficulties in receiving the Narrowcast reports, contact: firstname.lastname@example.org
If you list with both LCBO Wines, Spirits, Beer & Cider and VINTAGES, you may have a different Agent number for each. You will need to confirm with VINTAGES that your subscription is included in the LCBO Wines, Spirits, Beer & Cider.
There are 4 reports named Agent PO Status, Agent PO Summary, Agent PO Tracker and Inventory Summary. Detailed descriptions are below:
1) Agent PO Status is based on the PO Status = Open (O) or Sent to ROC (B) and excluding PO Line Status = Deleted with a Receiving Date within the last 14 days of the report execution date. This is because PO data is updated daily. This report displays the PO Status including Cases Ordered, PO Written Date and Scheduled Receival Date.
2) Agent PO Summary is based on the PO Written date within the last 8 days of report execution date and excluding PO Line Status = Deleted. This report displays the PO details by vendor including Cases Ordered, PO Written Date and Financial information.
3) Agent PO Tracker is based on the PO Status = Open (O) or Sent to ROC (B) with a Receiving Date within the last 14 days of the report execution date. This is because PO data is updated daily. This report displays PO information including PO No, PO Written Date and Scheduled Arrival Date by Facility Warehouse.
4) Inventory Summary is based on data for last week where the end of the week is a Saturday. This report displays Inventory On Hand and Inventory On Order, Inventory In Transit by all Retail stores, Depots and Warehouses.