Distribution Centre:Purolator Invoice details processing

Background

Weekly we receive an email (to johnt@unipharm.com and geraldp@unipharm.com) from Purolator (ediff@purolator.com) that contains a zip file that when opened is a csv file of weekly invoice details. Below are the steps required to manually upload this data into Infonet for use in the "Freight to Sales Analysis" query.

1. Files are automatically saved on superserver in distribution centre\Richmond\geraldp\freight GP\Purolator\raw invoices (note: this is done by a process developed by IS department)
2. Files are going to uploaded on a monthly basis (typically in the first week of each month - for the previous month)
3. Go to superserver\distribution centre\Richmond\geraldp\freight GP\Purolator\raw invoices
4. Open first weekly file - Note: need to make sure that customer ref1 field is not blank (this is store number field), if blank, manually edit them.
5. Open second weekly file and copy / paste the details into first file
6. Repeat for the third and fourth weekly files
7. Save the finished file as "YYYYMMconsolidated.csv" file
8. Run macro "Purolator_Invoice_To_Template" - note: This will align various columns to fit our import template and will total surcharges and remove blank records.
9. Go to (and open) superserver\distribution centre\Richmond\geraldp\freight GP\skid lot tracking\miscyyyymm (template.csv)
10. Copy the details from "YYYYMMconsolidated.csv" into "miscyyyymm"
11. File save as "purYYYYMM.csv" - example: pur201709.csv
12. Ready to upload into Infonet