These instructions will help users with emailing banking file and other reports that can be emailed and steps to copy excel/csv data onto your local machine.

TABLE OF CONTENTS


Emailing Banking File



When processing creditor payments, within online banking file creation screen; Email Banking File (1) can be ticked and enter email address (2), then click on Create File (3)






 

 


Emailing Reports


There are multiple reports that can be emailed from Orion. 

A quick guide on how users can email reports.
  • When the report preview screen opens, click on the PDF button (1) followed by the email PDF check box (2) and add recipients email address (3) then click OK (4)


 






Some of the frequently used reports that can be emailed are: -


  • Debtors Aged Trial Balance
    • This is an ‘as at’ report, can be found in Accounts> Reports > Debtors,
      Historical ATB’s can be found under Enquiry > Archived Reports > select the relevant month folder and report (You can request this report from us)

  • Creditors Aged Trial Balance
    • This is an ‘as at’ report, can be found in Accounts> Reports > Creditors,
      Historical ATB’s can be found under Enquiry > Archived Reports > select the relevant month folder and report (You can request this report from us) 

  • Profit and Loss (Statement of Financial Performance) 
    • You can run this for any period from Accounts> Reports > General Ledger

  • Balance Sheet (Statement of Financial Position) 
    • You can run this for any period from Accounts> Reports > General Ledger

  • Workshop Stock Valuation
    • This is an ‘as at’ report, can be found in Workshop> Reports> Stock Valuation,
      historical valuations can be found under Accounts> Enquiry > Archived Reports > select the relevant month folder and report (You can request this report from us)
  • Parts Stock Valuation
    • This is an ‘as at’ report, can be found in Parts> Reports> Stock Valuation,
      historical valuations can be found under Accounts> Enquiry > Archived Reports > select the relevant month folder and report (You can request this report from us)

  • Work in Progress Valuation
    • This is an ‘as at’ report, can be found in Workshop> Reports> Work in Progress Valuation,
      historical valuations can be found under Accounts> Enquiry > Archived Reports > select the relevant month folder and report (You can request this report from us) 
  • Trail Balance Detailed / Summary
    • You can run this for any period from Accounts>Reports > General Ledger.


 Copying Excel/CSV Data

There are multiple reports that can be generated in excel/csv, below is a quick guide to help copy Excel/CSV data onto your local machine.


Reports with option to create MS Excel File can be generated and opened in Libre office from within Orion.
  • Tick Create MS Excel File (1) and click on Print (2)



     


  • Once the excel file path options comes up click on Yes (3)





  • Once the libre file opens, select all data by pressing CTRL+A on your keyboard (also can be highlighted using your mouse by left clicking) and then CTRL+C to copy (also can right click your mouse and click copy)

  • Open Excel on your local machine, press CTRL+V (also can right click your mouse and click paste).       


Some of the frequently used reports that can be generated in this way are as follows: -


  • Trail Balance Detailed / Summary (Accounts>Reports > General Ledger) 
  • Parts Stock Valuation (Parts> Reports> Stock Valuation)
  • Purchase Order Details (Parts> Reports> Purchase Order Details)
  • Work in Progress Valuation (Workshop> Reports> Work in Progress Valuation)
  • Labour Analysis Detailed / Summary (Workshop> Reports> Labour Analysis Detailed OR Labour Analysis Summary)
  • Debtors Aged Trial Balance (Accounts> Reports > Debtors)
  • Creditor Aged Trial Balance (Accounts> Reports > Creditors)
  • Sales Costing Report (Detailed) (Sales> Reports > Sales Costing Report)
  • Sales Report (Sales> Reports > Sales Report)
  • Rental Economic Life Report (Rental> Reports > Rental Economic Life Report)
  • Rental Contract (Rental> Reports > Rental Contract)
  • Rental Contract due for Invoicing (Rental> Reports > Rental Contract due for Invoicing)


Requesting Other Files

We can send you files you are not able to access E.g. Reports saved within archived folder.
Please email us at samsupport@sam.co.nz with any files you would like us to send you. We will then send the files through OneDrive and separately send you the password to access the files.