ERP Resources for Wine & Spirits Suppliers
The PLCB has implemented NEW SYSTEMS transforming its business from a traditional retail model to a wholesale/distribution, e-commerce and retail-focused business. Release 1 of Project New Horizon - our new enterprise resource planning platform - went live in January 2022, providing new finance and non-merchandise procurement systems. Release 2 went live July 2023, providing new systems that separate our wholesale and retail lines of business, changing the ways we procure wines and spirits, plan wholesale distribution, replenish stores and manage inventory and accounting. We also have a new Licensee Online Order Portal (LOOP) and a new and improved FWGS.com.
For information on how to access and use our self-service Oracle Supplier Portal and new Retail Special Order Portal, please refer to the training resources below.
For questions pertaining to use of the PLCB's new systems, please scroll to the contact list at the bottom of this page.
EXPLORE OUR TRAINING RESOURCES! We've developed a series of quick reference guides (QRGs), eLearning videos and step by steps for suppliers on how to use our new systems. In all, there are 39 new eLearning videos that will take 3-4 hours to review.
| Course Title | Course Description |
| Project New Horizon Release 2 Supplier Overview Video | This video highlights the major changes impacting suppliers in Release 2 of the PLCB's Project New Horizon. (5:31) |
|
Supplier - Wine, Spirits & Accessories Supplier (Merchandise Supplier) Registration QRG |
This course reviews how Wine, Spirits & Accessories Suppliers (Merchandise Suppliers) can register with the PLCB. Note: Skip this step if already registered. See related eLearning: Wine, Spirits & Accessories Supplier (Merchandise Supplier) Registration eLearning (6:29) |
| Supplier - Oracle Supplier Portal Basic Navigation QRG | This course reviews how to navigate the new Oracle Supplier Portal including information on logging in and navigating the Welcome Springboard; session timeout and sign out; navigating the Supplier Portal screen; search functionality; and a profile management overview.
See related eLearnings:
|
| Supplier - Manage Supplier Data in Oracle Supplier Portal QRG | This course reviews how to manage supplier data in the Oracle Supplier Portal including bank account data, tax information, contacts, addresses and change request tracking. See related eLearning: Supplier - Update Supplier Profile Using Oracle Supplier Portal eLearning (4:24) |
| Supplier - Create an Invoice in Oracle Supplier Portal QRG | This course reviews how to suppliers enter an invoice in the Oracle Supplier Portal. See related eLearning: Supplier – Create Invoice in Supplier Portal eLearning (5:19) |
|
Supplier – View Consumption Advice, Invoice and Payments in Supplier Portal QRG | This course reviews how suppliers view consumption advices, invoices and payments in the Oracle Supplier Portal. See related eLearning: Supplier - View Consumption Advice, Invoice and Payment in Supplier Portal eLearning (4:03) |
| Supplier - View Invoices and Payments in Oracle Supplier Portal QRG | This course reviews how suppliers view invoices and payments in the Oracle Supplier Portal. See related eLearning: Supplier - View Invoices and Payments in Oracle Supplier Portal eLearning (4:14) |
| Supplier - Create and Submit Items in Oracle Supplier Portal QRG | This course reviews how suppliers use the Oracle Supplier Portal to submit requests for stock items stored in a PLCB distribution center (DC) and for direct store delivery (DSD) items sent directly to Fine Wine & Good Spirits (FW&GS) stores.
See related eLearnings: |
| Supplier - Create and Submit Special Order Items in Oracle Supplier Portal QRG | This course reviews how suppliers will use the new Oracle Supplier Portal to submit requests for Special Order (SO) items for sale to licensees through the Licensee Online Order Portal (LOOP) and retail customers through FWGS.com, and for direct delivery or delivery to Fine Wine & Good Spirits (FW&GS) stores or Licensee Service Centers (LSC) for customer pickup. See related eLearnings: |
| Supplier - Supplier Special Order - Adding (Supplier) Members in LOOP QRG | This course reviews how authorized suppliers with an Administrator role, as designated by a licensee within the Licensee Online Order Portal (LOOP), can add additional team members from their supplier organization to create Special Orders (SOs) on behalf of the licensee to a licensee account. See related eLearning: Supplier - Supplier Special Order - Adding (Supplier) Members in LOOP eLearning |
| Supplier Create and Submit Item Updates in Oracle Supplier Portal QRG | This course reviews how suppliers use the new Supplier Portal to submit requests for updates to any item. See related eLearnings: |
|
Supplier - Licensee Special Order Fulfillment QRG NEW QRG with updates - effective date TBD | This course reviews how suppliers fulfill licensee Special Orders (SOs) using the Oracle Supplier Portal and includes information on how to search for a licensee SO to view or fulfill; update a promised delivery date; print a shipping label; create an advance shipment notice (ASN); create an invoice; and cancel a licensee SO. See related eLearnings:
|
|
Supplier - Retail Special Order Portal QRG NEW QRG with updates - effective date TBD | This course reviews how suppliers use the Retail Special Order Portal (RSOP) to fulfill and cancel Special Orders (SOs) placed by retail customers on FWGS.com.
|
| Supplier - Special Order Entry in LOOP QRG | This course reviews how suppliers enter a licensee Special Order (SO) in the new Licensee Online Order Portal (LOOP).
Suppliers must be authorized by licensees before they can create SOs in LOOP. See related eLearning: Supplier - Special Order Entry in LOOP eLearning (8:19) |
| Supplier – Sample Order Entry in LOOP QRG NEW QRG with updates - effective date TBD | This course reviews the sample order entry process for suppliers in the new Licensee Online Order Portal (LOOP). See related eLearning: Supplier – Sample Order Entry in LOOP eLearning (4:48) |
| Supplier - Manage Payment Method in LOOP QRG | This course reviews how suppliers manage payment methods in the new Licensee Online Order Portal (LOOP). See related eLearning: Supplier - Manage Payment Methods in LOOP eLearning (3:26) |
| Supplier – View the PLCB Item Number for Approved Items in Oracle Supplier Portal QRG | This course reviews how to find the Pennsylvania Liquor Control Board (PLCB) Item Number for approved items in the Oracle Supplier Portal. See related eLearning: Supplier - View the PLCB Item Number for Approved Items in Oracle Supplier Portal eLearning (1:53) |
| Supplier - Submit Responses and Monitor Negotiations QRG | This course reviews how suppliers use the Oracle Supplier Portal to respond to and monitor negotiations. The negotiation process will support the bi-annual item listing cycles as well as One-Time Buy (OTB) item negotiations. All stock items must have a corresponding negotiation created. See related eLearning: Supplier - Submit Responses and Monitor Negotiations eLearning (12:37) |
| Supplier - Oracle Supplier Portal Supply Chain Management (SCM) QRG NEW QRG with updates - effective date TBD | This course reviews how suppliers will use the Oracle Supplier Portal to review order forecasts; review purchase orders; manage min-max thresholds; create replenishment requests; create ASNs; review consumption advices; and manage supplier data. See related eLearnings:
|
Please direct questions pertaining to use of the PLCB's new systems as follows:
- For help updating your supplier profile (addresses, contacts, bank account data), contact ra-lbsupregreq@pa.gov.
-
For questions on item listing, creation, set up and maintenance in the Supplier Portal, contact
ra-LBProductSelect@pa.gov. - For assistance with forecasting, bailment and non-bailment PO fulfillment and inventory management functions, contact your PLCB Planner or email ra-LBMerchPOSupport@pa.gov.
- For status of invoice payment, contact ra-PLCBExceptionProcess@pa.gov.
-
For questions on Consumption Advices and creating invoices, contact RA-LBSUPPLINV@pa.gov.
- If you have questions about Special Order functionality, contact ra-lbslo@pa.gov.