Difference between revisions of "Accounting Finance:Amenity Healthcare-Weekly Report"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
==Receiving File from Information Systems== |
==Receiving File from Information Systems== |
||
| − | #Each '''Monday''' you will |
+ | #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''' |
||
| + | #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 |
||
#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) |
||
Revision as of 17:30, 14 November 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
- Robert Swiscoski T:204-594-5881 rswiscoski@amenityhealthcare.com
- Payables payables@amenityhealthcare.com
Store Accounts
- 4001-Qualicum (12425)
- 4002-Nanoose (12426)
- 4003-Memorial (12424)
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)
- Log in Infonet. From Finance --> Custom A/R Detail Report
- 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
- Save the files to \\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)
File Adjustments Prior to sending File
- Change customer number to numeric (highlight the column (A)→then Data→Test to Column→Delimited→Finish)
- Delete any documents with the document type EFT
- 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)
- Look for blanks or missing invoices and enter text details for all blanks.
Email Files to Amenity
- Email reports to payables@amenityhealthcare.com