Difference between revisions of "Accounting Finance:Central Drug Stores-Statement Detailed Report"
Jump to navigation
Jump to search
| (4 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
==Overview== |
==Overview== |
||
| − | After statements have been printed (twice a month), prepare the '''Statement Detailed Reports''' for each Central Drugs Store and email to ''' |
+ | After statements have been printed (twice a month), prepare the '''Statement Detailed Reports''' for each Central Drugs Store and email to '''finance@centraldrugs.ca'''. |
==Contacts== |
==Contacts== |
||
| − | *Cheryl de Beeld [mailto: |
+ | *Cheryl de Beeld [mailto:finance@centraldrugs.ca finance@centraldrugs.ca] |
==Store Accounts== |
==Store Accounts== |
||
*10139 Central Drug-Bowen |
*10139 Central Drug-Bowen |
||
*10144 Central Drug-Brickyard |
*10144 Central Drug-Brickyard |
||
| ⚫ | |||
| − | *10141 Central Drug-Commercial |
||
*10145 Central Drug-Dufferin |
*10145 Central Drug-Dufferin |
||
*10142 Central Drug-Dunsmuir |
*10142 Central Drug-Dunsmuir |
||
*10143 Central Drug-Lantzville |
*10143 Central Drug-Lantzville |
||
*12457 Central Drug-Pacific Station |
*12457 Central Drug-Pacific Station |
||
| ⚫ | |||
==Receiving File from Information Systems== |
==Receiving File from Information Systems== |
||
| Line 20: | Line 19: | ||
#Enter the correct dates '''1st-15th or 16th-31st''' and '''run''' |
#Enter the correct dates '''1st-15th or 16th-31st''' and '''run''' |
||
#Click '''Open''' |
#Click '''Open''' |
||
| + | #Delete the lines for '''EFT''' in worksheet |
||
| + | #Save the '''XML''' file as '''XLS''' file format and save the file in '''Common\AR\Central Drugs\Detailed Statements''' |
||
#Save the '''files''' to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files|\\superserver.unipharm.local\Accounting\common\AR\Central Drugs\Detailed Statements}} |
#Save the '''files''' to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files|\\superserver.unipharm.local\Accounting\common\AR\Central Drugs\Detailed Statements}} |
||
| + | #Rename the file |
||
==Emailing Files to Central Drugs== |
==Emailing Files to Central Drugs== |
||
| − | #Email reports to Cheryl de Bleed [mailto: |
+ | #Email reports to Cheryl de Bleed [mailto:finance@centraldrugs.ca finance@centraldrugs.ca] |
[[Category:Central Drugs]] |
[[Category:Central Drugs]] |
||
Latest revision as of 09:15, 17 November 2021
Overview
After statements have been printed (twice a month), prepare the Statement Detailed Reports for each Central Drugs Store and email to finance@centraldrugs.ca.
Contacts
- Cheryl de Beeld finance@centraldrugs.ca
Store Accounts
- 10139 Central Drug-Bowen
- 10144 Central Drug-Brickyard
- 10145 Central Drug-Dufferin
- 10142 Central Drug-Dunsmuir
- 10143 Central Drug-Lantzville
- 12457 Central Drug-Pacific Station
- 12546 Central Drug-Colvile
Receiving File from Information Systems
- 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 7 times, once per store)
- Enter the correct dates 1st-15th or 16th-31st and run
- Click Open
- Delete the lines for EFT in worksheet
- Save the XML file as XLS file format and save the file in Common\AR\Central Drugs\Detailed Statements
- Save the files to \\superserver.unipharm.local\Accounting\common\AR\Central Drugs\Detailed Statements
- Rename the file
Emailing Files to Central Drugs
- Email reports to Cheryl de Bleed finance@centraldrugs.ca