Difference between revisions of "Accounting Finance:Central Drug Stores-Statement Detailed Report"

From uniWIKI
Jump to navigation Jump to search
 
(9 intermediate revisions by 2 users 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 '''central.office@medicinecentre.com'''.
 +
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:central.office@medicinecentre.com central.office@medicinecentre.com]
 +
*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
⚫
*10140 Central Drug-Campbell
  
−
*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
  ⚫
*12546 Central Drug-Colvile
   
 
==Receiving File from Information Systems==
  
==Receiving File from Information Systems==
−
#Each month on the '''16th & 1st ''' you will download '''eight''' files from '''IS''' for the current statement period '''1st-15th & 16th-31st''' (i.e. March 01-March 15, 2019)
  
 
#Log in Infonet. From '''Finance''' --> '''Custom A/R Detail Report'''. This can only be done through the home/front page (not through uniVIEW).
  
#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 8 times, once per store)
 +
#Enter the Account Number for each of the stores (you would run this procedure 7 times, once per store)
−
#Enter the correct dates 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 '''files''' to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Central Drugs\Detailed Statements
  
  +
#Save the '''XML''' file as '''XLS''' file format and save the file in '''Common\AR\Central Drugs\Detailed Statements'''
−
#Email files to Cheryl de Beeld (central.office@medicinecentre.com)
  
  ⚫
#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 [mailto:central.office@medicinecentre.com central.office@medicinecentre.com]
 +
#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

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

  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. Delete the lines for EFT in worksheet
  6. Save the XML file as XLS file format and save the file in Common\AR\Central Drugs\Detailed Statements
  7. Save the files to \\superserver.unipharm.local\Accounting\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
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:Central_Drug_Stores-Statement_Detailed_Report&oldid=14136"