Half Hourly Data Report

If you wish to view the half hourly data select the Half Hourly Generation Data report from the Reporting Menu. Once selected, enter a start and end date and then click the Display button.  The report shows the calculated values for each data point in the date range specified.  Note that the Period is numbered […]

Check for missing data

This process checks for data that is missing from the relevant tables for the period specified.  If this process reports any missing data, you will have to import the relevant files to complete the data sets. The options include All data sets or individual data sets as specified below. Actual Energy – Energex Checks the […]

Standard Access View

If you move the linked database ( TPSII_Data.mdb ) then you will need to open the UI database ( TPSII_Bill.mdb ) to specify where the linked database resides.  To do this you will need to open the UI database while holding down the Shift key.  This will stop the Macro from hiding the object window […]

Calculation Listing

Invoice Calculation

    NOTE: GST is hard coded in the VBA code at 10% for calculation purposes on the invoice report ( R012_PPA2_CALCULATION_SUMMARY, R060_PPA2_INVOICE, R063_COVERING_FAX ) in the Detail_Format subroutines.

Data Import

Email Setup

Manual Invoice

Reporting Menu

Import File Locations