Sigma Online User Manual

Downloading/Exporting an Accounts Extract

Introduction

The Accounts Link Download Activity is used to view and download or export Files, Control Files and Summary Reports that have been generated using the Tenant Accounts Link Generator Activity.

Export File can be exported to FTP or downloaded and then  transferred to an external Financial System.
If invoices for Tenant Bills are generated externally to Sigma, the external Invoice IDs can be entered in Sigma using the Tenant Approve and Issue Bills Activity.

Note: The same Activity is also used to view and download Export Files, Control Files and Summary Reports that are generated using the standard Accounts Link Generator Activity.  These files relate to Supplier Invoices that have been validated and loaded against Accounts in Sigma.


Accessing the Accounts Link Download Activity

To access this Activity:

If you have just created the file in the Accounts Link Generator and are viewing it in the Accounts Link Download:

  • Click on the grey bar at the bottom to open the Accounts Link Generator File Browser section

        



If you have already closed the Activity and want to download the file(s):

  • Click Accounts Link Download in the Sigma Welcome Screen

         


Using either of the above opens the Accounts Link Download Activity


         


Within the Accounts Link Download screen it is possible to:

  • Download Export Files 
  • Export files to FTP
  • Delete Export Files 

Downloading an Export File

An Export File is generated when the Export Bills function is initiated from the Tenant Accounts Link Generator Activity.
Export Files are stored in a tree structure by date.


To download an Export File:

  • Expand the tree and click on the required date (these are in Year, Month and Day folders)

         


  • Select the Export File you want to either download or export to FTP

Downloading a file

  • Right click on the file to be downloaded
  • Click Open

          


Once the file has opened, save to your own PC to forward to Accounts Payable.

Exporting a file to FTP

  • Right click on the file to be exported
  • Click Export to FTP

         



Duplicate Files

If you attempt to export a file(s) that has already been exported, a prompt will appear:

          

There are 3 options

  • Send files except the above...
    • Use this option if you have selected more than one file and you want to export the other files, but not the duplicate
  • Send all files
    • Use this option if you have only selected one file and you still want to export it
  • Cancel
    • Cancels the export

Audit History

You will be able to see the Audit History for exported Files.

  • Click on 
  • All documents that have been exported to FTP from the Activity will show here

Deleting an Export File

To delete an Export File:

  • Select the Export File
  • Right click  Delete 

         

Downloading a Control File

A Control File is displayed when the Export Bills function is initiated from the Tenant Accounts Link Generator Activity and the report task is complete 
         


To download the Control File as an XLS file:

  • Click  Excel 

Downloading the Control File as a PDF file

  • Click on the PDF icon

Downloading the Summary Report

A Summary Report is displayed when the Run Summary Report function is initiated from the Tenant Accounts Link Generator Activity and the report task is complete 


         


To download the Summary Report as an XLS file:

  • Click Excel 




@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018