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