Difference between revisions of "Accounting Finance:Amenity Healthcare-Weekly Report"
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
==File Adjustments Prior to sending File== |
==File Adjustments Prior to sending File== |
||
| − | #Change customer number to numeric '''(highlight the column ( |
+ | #Change customer number to numeric '''(highlight the column (A)→then Data→Test to Column→Delimited→Finish)''' |
#Delete any documents with the document type '''EFT''' |
#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) |
#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) |
||
Revision as of 13:09, 6 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 receive three files from IS for the week from Sunday to Saturday (i.e. September 3-September 9, 2017)
- 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