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

From uniWIKI
Jump to navigation Jump to search
 
(4 intermediate revisions by 2 users not shown)
Line 10: Line 10:
 
*4002-Nanoose (12426)
 
*4002-Nanoose (12426)
 
*4003-Memorial (12424)
 
*4003-Memorial (12424)
  +
*Rita's Apothecary & Home Healthcare (11885)
  +
*Stony Plain Wellness & Comp. (11824)
   
 
==Receiving File from Information Systems==
 
==Receiving File from Information Systems==
 
#Each '''Monday''' you will download '''three''' files from '''IS''' for the week from '''Sunday to Saturday''' (i.e. September 3-September 9, 2017)
 
#Each '''Monday''' you will download '''three''' files from '''IS''' for the week from '''Sunday to Saturday''' (i.e. September 3-September 9, 2017)
#Log in Infonet. From '''Finance''' --> '''Custom A/R Detail Report'''
+
#Log in Infonet. From '''Finance''' --> '''Custom A/R Detail Report'''. This can only be done through the home/front page (not through uniVIEW).
 
#Enter the Account Number for each of the stores (you would run this procedure 3 times, once per store)
 
#Enter the Account Number for each of the stores (you would run this procedure 3 times, once per store)
#Enter the correct dates and download
+
#Enter the correct dates and '''run'''
 
#Save the '''files''' to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files|\\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files}}
 
#Save the '''files''' to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files|\\superserver.unipharm.local\Accounting\common\AR\Amenity\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)
Line 26: Line 28:
   
 
==Email Files to Amenity==
 
==Email Files to Amenity==
#Email reports to [mailto:payables@amenityhealthcare.com payables@amenityhealthcare.com]
+
#Email reports (including Rita's Apothecary) to [mailto:payables@amenityhealthcare.com payables@amenityhealthcare.com]
   
 
[[Category:Amenity]]
 
[[Category:Amenity]]

Latest revision as of 10:29, 30 July 2018

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)
  • Rita's Apothecary & Home Healthcare (11885)
  • Stony Plain Wellness & Comp. (11824)

Receiving File from Information Systems

  1. Each Monday you will download three files from IS for the week from Sunday to Saturday (i.e. September 3-September 9, 2017)
  2. Log in Infonet. From Finance --> Custom A/R Detail Report. This can only be done through the home/front page (not through uniVIEW).
  3. Enter the Account Number for each of the stores (you would run this procedure 3 times, once per store)
  4. Enter the correct dates and run
  5. Save the files to \\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files
  6. 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 (A)→then Data→Test to Column→Delimited→Finish)
  2. Delete any documents with the document type EFT
  3. 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 day of the following month)
  4. Look for blanks or missing invoices and enter text details for all blanks.

Email Files to Amenity

  1. Email reports (including Rita's Apothecary) to payables@amenityhealthcare.com