Difference between revisions of "Accounting Finance:Amenity Healthcare-Weekly Report"

From uniWIKI
Jump to navigation Jump to search
m
m
Line 12: Line 12:
   
 
==Receiving File from Information Systems==
  
==Receiving File from Information Systems==
−
#Each '''Monday''' you will receive '''three''' files from '''IS'' for the week from Sunday to Saturday (i.e. September 3-September 9, 2017)
 +
#Each '''Monday''' you will receive '''three''' files from '''IS''" for the week from Sunday to Saturday (i.e. September 3-September 9, 2017)
 
#Save the files to {{unc|\\superserver.unipharm.local\Monthly Sales\2018 Fiscal\Amenity Group\Weekly files|\\superserver.unipharm.local\Monthly Sales\2018 Fiscal\Amenity Group\Weekly files}}
  
#Save the files to {{unc|\\superserver.unipharm.local\Monthly Sales\2018 Fiscal\Amenity Group\Weekly files|\\superserver.unipharm.local\Monthly Sales\2018 Fiscal\Amenity Group\Weekly files}}
−
#Save a '''second copy'' with the same name and adding '''Amenity''' at the end, as this becomes the working file for making the file '''adjustments''' (i.e. 4001-Qualicum (Sep 03-Sep 09, 2017)-Amenity.xlxs)
 +
#Save a '''second copy"'' with the same name and adding '''Amenity''' at the end, as this becomes the working file for making the file '''adjustments''' (i.e. 4001-Qualicum (Sep 03-Sep 09, 2017)-Amenity.xlxs)
   
 
==File Adjustments Prior to sending File==
  
==File Adjustments Prior to sending File==

Revision as of 12:03, 10 October 2017

Overview

Each Monday or the next business day after a statutory holiday, prepare the weekly reports and email to payables@amenityhealthcare.com the same day.

Contacts

Store Accounts

  • 4001-Qualicum (12425)
  • 4002-Nanoose (12426)
  • 4003-Memorial (12424)

Receiving File from Information Systems

  1. Each Monday' you will receive three files from IS" for the week from Sunday to Saturday (i.e. September 3-September 9, 2017)
  2. Save the files to \\superserver.unipharm.local\Monthly Sales\2018 Fiscal\Amenity Group\Weekly files
  3. Save a second copy" with the same name and adding Amenity' at the end, as this becomes the working file for making the file adjustments (i.e. 4001-Qualicum (Sep 03-Sep 09, 2017)-Amenity.xlxs)

File Adjustments Prior to sending File

  1. Change customer number to numeric (highlight the column (AQ)→then Data→Test to Column→Delimited→Finish)
  2. Change date columns (E & F) to recognize the cell as a date type (highlight the two date columns (E & F)→then press CTRL-F to bring up the Find and REplace dialog box, put a hyphen (-) in the Find what box and a bacslash (/) in the REplace with box and press the REplace All button. This will immediately replace all of the hyphens with slashes and in doing so will allow excel to recognize the dates as dates.
  3. Delete any documents with the document type EFT
  4. Check for duplicate invoice numbers on account types CVM and ELC (ELC should be the last day of the month and CVM should be the first date of the following month)
  5. Look for blank or missing invoices and enter text details

Email Files to Amenity=

  1. Email reports to payables@amenityhealthcare.com
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:Amenity_Healthcare-Weekly_Report&oldid=9544"