You should receive an email named: 

       Advanced Ship Notice # #############

  1. Download attached load sheet from emails from HSLAdmin@bc.com
  2. Save load sheet in 
    1. S:\Production\productionscans\Scanned Load Sheets\BC_<prodregion>_<yyyymmdd>.pdf 
    2. Use the year of the Print Date on the load sheet
  3. In Leads app, 
    1. Go to Loads / Trailers
    2. Click Add BC Load button
      1. Load Date: Use the Print Date 
      2. Select Region
      3. Scheduled Arrival: Use the Ship Date
    3. Click Create Load
      1. For each item:
        1. Copy and paste SO ID 
          1. Press Tab and confirm the Cust PO is generated and the customer last name is displayed and matches. 
            1. If not, the SO ID on the FO record may need to be added or corrected.
        2. Copy and paste Item #
          1. Press Tab, confirm item description is displayed. 
            1. If prompted, copy and paste item description and click OK
        3. Copy and paste Unit ID
          1. Ensure the Qty is added correctly foreach unit
        4. Click Add
    4. Close the Load Sheet
    5. Close the Boise Cascade Load screen
    6. Click Refresh on the Loads screen
      1. Select the region for the newly added load
      2. Click Load Sheet on the newly added load to make sure it loads the new load sheet


You can confirm that the data has been uploaded properly by running this query to get the reports detail:

SELECT *
FROM BoiseOrderItem
WHERE LoadId = (
    SELECT id
    FROM [LeadsDB1].[dbo].[Load]
    WHERE Region = 'HOU'
      AND TrailerNumber = 'BC'
      AND LoadDate >= '2026-04-30'
)