Accounting Finance:Central Drug Stores-Statement Detailed Report

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

1. Log in Infonet. From Finance --> Custom A/R Detail Report. This can only be done through the home/front page (not through uniVIEW).
2. Enter the Account Number for each of the stores (you would run this procedure 7 times, once per store)
3. Enter the correct dates 1st-15th or 16th-31st and run
4. Click Open
5. Save the files to \\superserver.unipharm.local\Accounting\common\AR\Central Drugs\Detailed Statements
6. Delete the lines for EFT in worksheet
7. Save the XML file as XLS file format into Common\AR\Central Drugs\Detailed Statements
8. Rename the file

Emailing Files to Central Drugs

1. Email reports to Cheryl de Bleed finance@centraldrugs.ca