Distribution Centre:Purolator Invoice details processing

From uniWIKI
Jump to navigation Jump to search

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 (column CU) is not blank (this is store number field), if blank, manually edit them.
  5. Open second weekly file and copy / paste the details (from columns A to GC) into first file (as above, check column CU)
  6. Repeat for the third and fourth weekly files (as above, check column CU)
  7. Save the finished file as "YYYYMMconsolidated.csv" file
  8. Run macro (View tab - Macros - View Macros) "Purolator_Invoice_To_Template" - note: This will align various columns to fit our import template and will total surcharges and remove blank records. Run.
  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. Close the "YYYYMMconsolidated.csv" file but DO NOT SAVE.
  12. File save as "purYYYYMM.csv" in Purolator folder - example: pur201709.csv
  13. May need to manually add any credits (dollars only) received from Purolator into the pur201709.csv (example) file. Important to get store number and waybill reference information. Note: dollars should be entered as negatives.
  14. Ready to upload into Infonet - note: after uploading will need overnight processing to update information for viewing
  15. Move "purYYYYMM.csv" to "yyyy files" folder (eg. 2017 files)
  16. Move all (from Raw Invoices) completed and consolidated files into "Archived Folder"
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Distribution_Centre:Purolator_Invoice_details_processing&oldid=10016"