Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Exporting the Tenant Bills

When exporting Tenant Bills, it is possible to:

  • Generate an initial PROOF Export File which contains a new unique Batch Number 
  • Regenerate a new PROOF Export File using the same Batch Number as the initial PROOF Export File 
  • Generate a FINAL Export File using the same Batch Number as the initial PROOF Export File 

PROOF and FINAL Export Files can be used in a business process, for example:

  • Generate an initial PROOF Export File and navigate to the Accounts Link Download Activity. View the PROOF Export File and note the new Batch Number. Check the Control File to ensure all required Tenant Bills are included.
  • Regenerate the PROOF Export File (if needed) using the same Batch Number and navigate to the Accounts Link Download Activity. Check the Control File to ensure all required Tenant Bills are included. Repeat this step until details in Control File are as expected.
  • When details in Control File are as expected, generate the FINAL Export File using the same Batch Number and navigate to the Accounts Link Download Activity. Download the Control File and send it to the external Financial System.

Generating Initial PROOF Export File

To generate an initial PROOF Export File:

With the required batch of 'Issued' Tenant Bills displayed in the Bills table, click Export BillsClick Image Added

The Setup Report Rules for Exporting pop-up opens.

Image RemovedImage Added

Setup the following reporting rules:

Ensure the date range defined by the Start date and End date fields

...

are the same as entered in the Tenant Accounts Link Generator Activity

Tick the Live run checkbox

Image Removed

Scroll down and setup the following reporting rules:

...

Leave

...

Image Removed

Leave all other reporting rules in the Setup Report Rules for Exporting pop-up unchanged.

...

The Setup Report Rules for Exporting pop-up closes and the Accounts Link Download Activity opens in a new Sigma browser tab. From here it is possible to view/download the Export File  and Control File 

Regenerating PROOF Export File

To regenerate a PROOF Export File:

With the required batch of 'Issued' Tenant Bills displayed in the Bills table, clickExport Bills 

The Setup Report Rules for Exporting pop-up opens.

Image Removed

Setup the following reporting rules:

  • Ensure the date range defined by the Start date and End date fields covers the creation dates of the Tenant Bills to be exported.
  • Untick the Live run checkbox.

Image Removed

Setup the following reporting rules:

  • Untick the Generate new batch number checkbox.
  • Enter the Batch Number from the initial PROOF file in the Enter the correct batch number for live run field.
  • Leave all other reporting rules in the Setup Report Rules for Exporting pop-up unchanged.

Image Removed

Click OK 

The Setup Report Rules for Exporting pop-up closes and the Accounts Link Download Activity opens in a new Sigma browser tab. From here it is possible to view/download the Export File and Control File 

Generating FINAL Export File

To generate a FINAL Export File:

With the required batch of 'Issued' Tenant Bills displayed in the Bills table, click  Export Bills

The Setup Report Rules for Exporting pop-up opens.

Image Removed

Setup the following reporting rules:

  • Ensure the date range defined by the Start date and End date fields covers the creation dates of the Tenant Bills to be exported.
  • Tick the Live run checkbox.

Image Removed

Setup the following reporting rules:

  • Untick the Generate new batch number checkbox
  • Enter the Batch Number from the initial PROOF file in the Enter the correct batch number for live run field
  • Leave all other reporting rules in the Setup Report Rules for Exporting pop-up unchanged

Image Removed

Click OK

...


Accessing previously run Tenant Billing Accounts Link Files

Open the Accounts Link Download Activity 

Image Added

Click on the files on the left hand side to open the Year, Month and Date

The file shows on the right hand side

Image Added




Right click on the file

Click Open

Image Added

The file will be downloaded