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

From uniWIKI
Jump to navigation Jump to search
Line 20: Line 20:
 
#Click '''Open'''
  
#Click '''Open'''
 
#Delete the lines for '''EFT''' in worksheet
  
#Delete the lines for '''EFT''' in worksheet
−
#Save the '''XML''' file as '''XLS''' file format into '''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'''
 
#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

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. 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=13232"