Difference between revisions of "Accounting Finance:Central Drug Stores-Statement Detailed Report"
Jump to navigation
Jump to search
| Line 19: | 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''' |
||
| ⚫ | |||
| ⚫ | |||
#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 |
#Rename the file |
||
Revision as of 10:58, 2 July 2020
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
- 10140 Central Drug-Campbell
- 10145 Central Drug-Dufferin
- 10142 Central Drug-Dunsmuir
- 10143 Central Drug-Lantzville
- 12457 Central Drug-Pacific Station
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 into 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