Daily, we receive two reports from one of our customers, OQ Chemicals into Freshdesk/CS4:
The first report we’ll work is the WATCO EMPTY TRANSIT report.
Open your report. You will need to hit the “Edit a copy” tab in the upper right hand corner above the spreadsheet:
Once you have the report open you will want to Hide some of the columns. Those columns are A, B, D-L, N & O. Highlight your columns at the top of the spreadsheet. You can do more than one at a time. Right click in your column field and hit “hide” in your drop down:
Next, filter column P to sort A to Z:
Search the white waybill queue for the car number in column C. If there is a waybill, confirm that the correct RWC is on the billing. All cars should come in as empties.
If you do not have a waybill, you will need to create one. Please see process on Creating Manual Waybills, located under CS4 Solutions in Freshdesk, using the spreadsheet provided.
To find the correct RWC from the spreadsheet, search the STCC code that is provided on the report using control F and typing in the STCC code:
Once you have located the correct RWC, copy the RWC and paste it into your RWC field when you create your manual waybill. Hit Enter and your waybill will open. You can then close it and your waybill has been created.
Continue through the report, creating waybills as needed.
Watco Empty Storage Report
Open the report.
Edit a copy, as described above.
Hide the following columns:
A-C, E-M, O-Q:
Using your white waybill queue, double check that that the cars are online and they have the correct commodity. If the cars aren’t online, please reach out to refugiocs@watco.com to see if we have the car in inventory and bring online if we do.