This page provides a list of monthly updates to EnergyCAP Enterprise and Express reports.
February 2012
-
BL12A, version 5: Fix the usage pie chart to show usage as global use.
-
BL23, version 3: Add Pay Amount filter.
-
BL23A, version 3: Add Pay Amount filter.
-
CAL01, version 3: Remove the start date/end date/days columns since this added confusion.
-
CAL04, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAL05, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAL09, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix format of report for decimals.
-
CAL10, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix format of report for decimals.
-
CAL14, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAL14A, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAL16, version 2: Add UOM to the report. Fix calculations for determining area cost per day and area use per day.
-
CAL17, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Add topmost cost center name filter.
-
CAL18, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAL23, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAL24, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAL25, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAL26, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix stored procedure to accept long account codes. Fix the 12th month to show the value for the month.
-
CAL27, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix stored procedure to accept long account codes. Fix the 12th month to show the value for the month.
-
NORM01, version 3: Removed the start date/end date/days columns since this added confusion. Removed accounting related filters.
-
NORM02, version 3: Removed accounting related filters.
-
NORM03, version 3: Removed accounting related filters.
-
NORM04, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Removed accounting related filters.
-
NORM05, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Removed accounting related filters.
-
NORM06A, version 1: Add normalized report similar to YY01A.
-
NORM07A, version 1: Add normalized report similar to YY01A.
-
SU30, version 2: Fix the display for the Cost Center Name.
-
WTHR02, version 6: Fix issue with filters not being recognized.
-
YY04, version 3: Fix calculation for determining area cost per day and area use per day.
January 2012
-
AN01, version 3: Fix fiscal year logic issue.
-
AN02, version 4: Add summary page to the end of the report. Fix fiscal year logic issue.
-
AN03, version 3: Fix fiscal year logic issue.
-
AN05, version 3: Fix fiscal year logic issue.
-
AN06, version 3: Fix fiscal year logic issue.
-
AN06A, version 3: Fix fiscal year logic issue.
-
AN08, version 4: Fix the x-axis of the charts to show all labels. Fix the precision for the y-axis.
-
AN09, version 3: Fix fiscal year logic issue.
-
AN10, version 2: Fix usage per area to use floor area at time of the bill.
-
AN12, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL01B, version 2: Fix report to show the correct demand.
-
BL01C, version 2: Fix report to show the correct demand.
-
BL02B, version 2: Fix report to show the correct demand.
-
BL04, version 3: Fix stored procedure to run without truncating the sql statement.
-
BL08, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL08C, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL09, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL10A, version 3: Fix pie charts that were cut off by the margins.
-
BL11, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL11A, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL11B, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL15, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL16, version 3: Fix report to print on a landscape. Remove overlap of columns. Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL16A, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL17, version 2: Fix report by adjusting columns to not overlap. Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL18, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL19, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL20, version 6: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL21, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL22, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL31, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL32, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL33, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Remove adjustments from the report.
-
BL33A, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Remove adjustments from the report.
-
BL34, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix column size of temporary table; long vendor names were causing the report to fail.
-
BL35, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL36, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL37, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL38, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
BL39PT, version 5: Fix the billing period to be displayed instead of truncated after the first letter.
-
BL40, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAP06, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CAP10, version 3: Fix report to show usage when there is no cost.
-
CAP15, version 1: Created report to show the energy reduction impact through cost avoidance.
-
CH01, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CH02, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CH03, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CH04, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CH05, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CH06, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CH07, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
CH08, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
GHG02PT, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
IN01, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU01, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU01A, version 3: Fix report to use stored procedure instead of inline query. Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU02, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU03, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU04, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU08, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU15, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU25, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU26, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU28, version 2: Improve report by limiting data to a user's topmost place permissions. Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU33, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU34, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU35, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU37, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU38, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU39, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU40, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU41, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU42, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU43, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU44, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU45, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU46, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU48, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix report's failure to use filter.
-
SU48A, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix report's failure to use filter. SU49, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU50, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU51, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU52, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU54, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU55, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU56, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
SU58, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
WTHR02, version 5: Fix report to return results for running as a shared report. Fix fields from overlapping in Crystal Report 2008 Viewer.
-
WTHR03, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
YY02, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
YY03, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
YY04, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
YY05, version 5: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
YY05A, version 2: Add filters for meter name and code. Fixed overlap of fields in web reports.
-
YY06, version 5: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
YY11, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
YY13, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
YY14, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
-
YY15, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
December 2011
-
AN01, version 2: Add the fiscal start month filter.
-
AN02, version 3: Add the fiscal start month filter.
-
AN03, version 2: Display total demand instead of the bill with the highest demand. Add the fiscal start month filter.
-
AN06, version 2: Correct issue with the table showing averages instead of totals. Add the fiscal start month filter.
-
AN06A, version 2: Correct issue with table showing averages instead of total values. Add the fiscal start month filter.
-
AN07, version 3: Change Energy Use per Area to two decimal places.
-
BL10, version 2: Add the grand totals to the report.
-
BT05, version 2: Fix to supplier charges not being included.
-
BT06, version 2: Fix to supplier charges not being included.
-
BT06A, version 2: Fix to supplier charges not being included.
-
BT06B, version 2: Fix to supplier charges not being included.
-
BT07, version 2: Fix to supplier charges not being included.
-
BT07A, version 2: Fix to supplier charges not being included.
-
BT07B, version 2: Fix to supplier charges not being included.
-
BT08, version 2: Fix to supplier charges not being included.
-
BT08A, version 2: Fix to supplier charges not being included.
-
BT08B, version 2: Fix to supplier charges not being included.
-
CAP01C, version 3: Fix to report not running when commodity filter was set.
-
CAP11, version 2: Correct Fix to report not running when commodity filter was set.
-
SU01A, version 2: Add contract start, end, renewal date filters. Add renewal date to the report display.
-
SU48A, version 1: New report. Lists the meters assigned to a rate. If a meter has historical rate assignments, it may be listed multiple times. The report can be filtered so only current rates display.
-
YY05, version 4: Fix to inflated values for use and cost.
November 2011
-
AN01PT, version 3: Modify stored procedure to honor topmost place security and place filters.
-
AN04, version 5: Research ticket from last month. Modified CREATE table column PLACECODE to be same size as Place. PLACECODE. Remove Grand Total averages from the grid as this report is not defined for providing Grand Total averages.
-
AN05, version 2: Modify report to be filterable and printable for fiscal years.
-
AN09, version 2: Modify report to be filterable and printable for fiscal years.
-
AN13PT, version 2: Modify stored procedure to honor topmost place security and place filters.
-
AN14PT, version 2: Modify stored procedure to honor topmost place security and place filters.
-
AN15PT, version 2: Modify stored procedure to honor topmost place security and place filters.
-
AN17PT, version 3: Modify stored procedure to honor topmost place security and place filters.
-
AN18PT, version 2: Modify stored procedure to honor topmost place security and place filters.
-
AN20, version 6: Add a filter for filtering by LogicalDevice.
-
AN25PT, version 2: Modify stored procedure to honor topmost place security and place filters.
-
AN26PT, version 2: Modify stored procedure to honor topmost place security and place filters. Fix join to include cost for bills without usage.
-
BL08C, version 2: Rename stored procedure appropriately for BL08C report.
-
BL10A, version 2: Change datatype from DATE to DATETIME. This is to support SQLServer 2005.
-
BL12A, version 4: Change datatype from DATE to DATETIME. This is to support SQLServer 2005.
-
BL14, version 2: Remove the decimal values from the grid to allow more space for the more significant values.
-
BL36, version 2: Change the SQL join for the BATCH from an INNER JOIN to a LEFT OUTER JOIN. This will allow clients not using batches to still get results. Update filter displays to show the filter value instead of the length of the filter.
-
CAP01B, version 4: Remove explicit DSN from rpt header.
-
CAP14, version 4: Show headers for all issues.
-
GHG02PT, version 2: Modify stored procedure to honor topmost place security and place filters.
-
YY01A, version 2: Change datatype from DATE to DATETIME. This is to support SQLServer 2005.
-
YY02A, version 2: Change datatype from DATE to DATETIME. This is to support SQLServer 2005.
-
YY17PT, version 2: Modify stored procedure to honor topmost place security and place filters.
-
YY18PT, version 2: Modify stored procedure to honor topmost place security and place filters.
October 2011
-
AN20, version 5: Update issue with production total for a place/organization.
-
AN22CC, version 5: Enhance report by adding filters for base year and counter type. Group the report by place/counter type/commodity. For places with multiple counters, the counter name will be listed as "All <counter type> Counters".
-
BL04, version 2: Update report to show one record for each account's billing period cost/use. This corrects inflated day values for multiple meters per account.
-
BL08C, version 1: New report similar to BL08. This report will show billing periods that do not contain bills at an account/meter level.
-
BL10A, version 1: New report similar to BL10. This report will also include the account charges.
-
BL12A, version 1: New report similar to BL12. This report will also include the account charges.
-
BL16, version 2: Update report to show account level charges.
-
BL20, version 5: Update report to allow system defined bill messages to be available in the Bill Message Key filter.
-
BL27, version 4: Fix issue with message being truncated on some bill messages.
-
BL39PT, version 4: Modify report's stored procedure to correctly summarize by place type when a topmost place is defined for the user or when the topmost place filter is defined. Correct total results for use/area and cost/area.
-
IN01, version 2: Add filter for customer code.
-
YY01A, version 1: New report for showing comparisons similar to YY01 at the commodity level.
-
YY02A, version 1: New report for showing comparisons similar to YY02 at the commodity level.
-
YY06, version 4: Correct inflated values when filtering with a topmost place.
-
YY12, version 3: Show the filters for the web client report.
-
YY16A, version 1: New report to show comparisons at a meter level. Similar to YY16.
September 2011
-
AN02, version 2: Add additional commodity filter options.
-
AN20, version 4: Correct issue with production value for a topmost place node filter.
-
AN22CC, version 4: Display the base year in the chart. Currently the base year is the year prior to the "Current" year, or the year of interest.
-
BL01B, version 1: Shows individual bills for each meter, organized by building. Includes demand/cost/use information. Similar to BL01 but also includes Commodity use/cost. This report is limited to showing the current rate for the account.
-
BL01C, version 1: Similar to BL01B but includes G/L code. Shows individual bills for each meter, organized by building. Includes demand/direct cost/use information. Use is expressed in common units. Very similar to BL02.
-
BL02B, version 1: Shows individual bills for each meter, organized by building. Use BL23 to export this type of data to Excel. Very similar to BL01. Also shows Local Distribution Company and Supplier use and cost separately.
-
BL27, version 3: Make the Begin date visible.
-
BL39, version 3: Add Account Period and Batch Number filters. Correct issue with non-accessible topmost place nodes being returned on Place Type of Organization.
-
BL39PT, version 3: Add Account Period and Batch Number filters. Remove "divide by 0" error from report of buildings with floor space of "0" sq. ft.
-
CAP01B, version 3: Removed accrual, accrual reversed, and void filters.
-
CAP01BU, version 2: Removed accrual, accrual reversed, and void filters.
-
CAP01C, version 2: Removed accrual, accrual reversed, and void filters.
-
CAP01E, version 2: Removed accrual, accrual reversed, and void filters.
-
CAP02, version 2: Removed accrual, accrual reversed, and void filters.
-
CAP07, version 2: Removed accrual, accrual reversed, and void filters.
-
CAP08, version 2: Correct values in Meter Code column from being displayed as false to the correct values of commodity/metercode. Removed accrual, accrual reversed, and void filters.
-
CAP10, version 2: Modified grid to display records on billing period. This will remove multiple records for different bills on the same billing period that have different start and end dates. Removed accrual, accrual reversed, and void filters.
-
CAP13, version 2: Removed accrual, accrual reversed, and void filters.
-
SU03, version 2: Change column from Bill Cycle to Service Dates.
-
WTHR01, version 2: Remove values from dates that don't exist in the respective months.
-
WTHR02, version 4: Modify query to allow filtering on Place.
-
YY01, version 4: Update report to rollup to MMBTU when multiple commodities are defined in the commodity filter.
-
YY02, version 3: Update report to rollup to MMBTU when multiple commodities are defined in the commodity filter. Increase cell width in grand total for cost. Remove comma from base/current year labels near the grand totals.
August 2011
-
AN08, version 3: Increase Energy/Area to be three decimals. Modify the Energy/Area column header to show the same UOM as the energy column. Also adjust the total value to be reflective of the UOM/area. This was an impact in the Web Reports/ECO.
-
AN08A, version 3: Increase Energy/Area to be three decimals.
-
AN20, version 3: Updated query to remove inflation of production counts.
-
AN22CC, version 3: Modify chart legend to not put a comma (,) in the year value.
-
BL11, version 2: Filters out historical serial numbers.
-
BL12, version 3: Filter topmost place code missing from displayed filters if defined. Modified Billing Period and Billing Period Year to be displayed too.
-
BL15, version 2: Modify the report to show the rate that was assigned to the meter at the time of the bill.
-
BL40, version 1: New report to show Usage and Cost from Submeter Readings.
-
GHG02, version 1: New report to show GHG Emissions by Place Type.
-
SU55, version 2: Modify query to remove all split accounts from the report.
-
YY01, version 3: Modify report column header for global unit rollup to correct when the rollup was not being shown.
-
YY05, version 3: Modify report for new procedure to support YY05A.
-
YY05A, version 1: New report requested by clients for monthly comparison by meter.
-
YY06, version 3: Modify report to return results for filtering with topmost place name/code.
July 2011
-
AN17, version 3: Updated stored procedure. Adjusted logic order of code.
-
AN20, version 2: Updated query to remove inflation of cost and use values.
-
AN22CC, version 3: Updated chart data and legend (RPT-115).
-
BL08, version 2: Renamed title of report. Added Commodity and Gap filters. Added meter level grouping.
-
CAP14, version 3: Added Issue No. to the report.
-
SU53, version 3: Corrected meter count for meters assigned to inactive accounts and meters assigned to multiple accounts.
-
SU59, version 1, new report: New Unit System Report.
-
WTHR02, version 3: Modified stored procedure to adjust place from 16 to 32 characters for placecode.
-
YY05, version 2: Updated stored procedure. Added cost center view to remove duplication of records.
June 2011
-
AN01PT, version 2: Fix for web report failing.
-
AN17PT, version 2: Fix for including historic floor areas in floor area totals.
-
AN25PT, version 1, new report: Summarizes a group of buildings at the place type level. Provides monthly usage details for a twelve month period.
-
AN26PT, version 1, new report: Summarizes a group of buildings at the place type level. Provides monthly cost details for a twelve month period.
-
BL20, version 4: Fix for total being inflated when a bill has multiple messages.
-
BL39PT, version 2: Fix for including historic floor areas in floor area totals.
-
GHG02PT, version 1, new report: Displays total by place type for usage and equivalent CO2 of greenhouse gas emissions.
-
YY14, version 2: Fix for multiple serial numbers on a meter inflating values.
-
YY17PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc) from lowest to highest use/area. Compares use and use per area in a base year to a current year.
-
YY18PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc) from lowest to highest cost/area. Compares cost and cost per area in a base year to a current year.
May 2011
-
AN01PT, version 1, new report: A version of AN01 that summarizes a group of buildings at the place type level. Displays three years of data, all of which are selectable by the user.
-
AN13, version 4: Fix for inflated values
-
AN13PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc.) from lowest to highest use/area. Use the "Summary by Place Type" filter to specify the place type. Whereas report AN13 ranks each individual building, AN13PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
-
AN14PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc) from lowest to highest cost/area. Use the "Summary by Place Type" filter to specify the place type. Whereas report AN14 ranks each individual building, AN14PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
-
AN15PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc.) from lowest to highest cost/unit. Use the "Summary by Place Type" filter to specify the place type. Whereas report AN15 ranks each individual building, AN15PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
-
AN17PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc.) from lowest to highest annualized use/area. Use the "Summary by Place Type" filter to specify the place type. Whereas report AN17 ranks each individual building, AN17PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
-
AN18PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc.) from lowest to highest annualized cost/area. Use the "Summary by Place Type" filter to specify the place type. Whereas report AN18 ranks each individual building, AN18PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
-
BL21, version 2: Fix for overlapping columns in web report
-
BL39PT, version 1, new report: Shows a summary of use, demand, cost, and unit cost by place type and commodity.
April 2011
-
AN07, version 2: Add billing period range to the top of the report. Change from hard-coded BTU to user unit of measure
-
AN08, version 2: Fix billing period range at the top of the report. Change from hard-coded BTU to user unit of measure
-
AN08A, version 2: Fix billing period range at the top of the report. Change from hard-coded BTU to user unit of measure
-
AN13, version 3: Add billing period range to the top of the report
-
AN14, version 2: Add billing period range to the top of the report
-
AN17, version 2: Add billing period range to the top of the report
-
AN18, version 2: Add billing period range to the top of the report
-
AN19, version 2: Add billing period range to the top of the report
-
BL01, version 2: Fix for report displaying duplicates if a vendor has more than one contract
-
BL12, version 2: Add billing period range to the top of the report
-
BL22, version 2: Change from always using billed demand to using actual demand and then billed demand if actual is not available
-
BL23, version 2: Added secondary descending sort by bill end date. Fixed alignement of Excel export
-
BL23A, version 2: Added secondary descending sort by bill end date. Fixed alignement of Excel export
-
BL33, version 2: Fix for web report not showing filters in report footer
-
CAP06, version 2: Fix for incorrect ordering of days
-
SU53A, version 1: new version of SU53 with additional metrics
-
YY01, version 2: Display the current and base year values instead of generic text. Add demand unit of measure. Fix first month filter
-
YY02, version 2: Display the current and base year values instead of generic text. Add usage unit of measure. Fix first month filter
-
YY06, version 2: Display the current and base year values instead of generic text. Fix first month filter
March 2011
-
BL07, version 2: Fix for incorrect address fields
-
BL20, version 3: Add account name and service address to display
-
BL27, version 2: Add account name and service address to display
-
BL39: Fix for web report not showing filter selections in report footer
-
WTHR02: Fix for incorrect total comparisons
February 2011
-
AN13, version 2: Fix for divide by zero error
-
AN22CC, version 2: Fix for report failing with place filter set
-
BL16A, version 2: Fix for incorrect total line unit cost
-
CAP14, version 2: Added issueID to output of stored procedure
-
SU32, version 2: Fix for report never returning results
-
YY10 to YY13, version 2: Fix for 4th year column header displaying incorrect year
-
YY16, version 2: Fix for report failing when it contains place codes longer than 16 characters
January 2011
-
BL20: Fix for long bill messages, causing the report to fail
-
CAP01B: Fix for X axis not labeling every bar
-
SU53: Added ownerID restrictions to the query
December 2010
-
AN08: Fix for web report always giving an error
-
AN08A: Fix for column heading label displaying global units when a single commodity is selected in the filter
-
AN11A: New report. Single year trend, month-by-month line graph and summary table of cost/area per building. Same as AN11, but one page per building.
-
BL07: Fix for intermittent duplication of line it
-
BL12: Changed billing period filter setting from previous fiscal year to current fiscal year
-
BL14: Fix for report displaying in common usage units when "One Of" operator is used on commodity filter
-
BL15: Fix for report dropping bills not in batches
-
BL31: Changed billing period filter setting from previous fiscal year to current fiscal year
-
BL38: Fix for report dropping bills not in batches
-
CH09: New report. Checks usage derived from monthly meter readings prior to generating bills with the Calculate Bills Processor.
-
SU01: Fix for "Status" column header spilling onto two lines
-
SU06, SU08, SU48: Added ownerID restrictions to the query
-
YY05: Fix for report returning no results when topmost place or topmost cost center filters are used. Fix for incorrect calculations in all totals.
-
YY10: Fix for filters not displaying on web report
-
YY10: Changed end year filter setting from previous fiscal year to current fiscal year
November 2010
-
All reports with date filters: Fix for "between" operators now including last day.
-
AN02: Fix for the chart's values and unit of measure being different from the table's values and unit of measure
-
BL01: Expanded the cost column to allow for more digits
-
BT01 to BT04B: Fix for cost center and topmost cost center filters causing inflated values
-
CAP01BU: New report; new version of CAP01B that shows avoided usage at the place level (instead of avoided cost)
-
SU41: Fix for report always failing with a blue screen
October 2010
-
AN20: Fixed issue of places and commodities starting in the middle of a page instead of on a new page
-
BL19: Report now includes all line items whose caption contains "late". Previously the report only included line items with observation type of "latefee" and caption of "late fee".
-
BL25: To clear up confusion over which fiscal year the chart was referring to, added a label to the legend that says, "year beginning".
-
BL26: To clear up confusion over which fiscal year the chart was referring to, added a label to the legend that says, "year beginning".
-
CAP10: Added grand totals for usage values when the commodity filter is set to equals.
-
YY14: Fix for duplicate rows displaying when there was greater than one serial number for a meter
-
All reports: The "like" and "not like" operating were working like a "begins with operator". They were returning results that match the beginning of the string. Now you can return results that contain the search sequence anywhere in the string. Use the directions in the User Manual.
September 2010
-
AN20: Fix for issue of extra white space and multiple blank pages.
-
BL16: Fix for the meter code column overlapping the column to its right. Web version only.
-
BL23A: Fix for the billing period column not being populated.
-
BL32: Fix for the account column overlapping the column to its right. Web version only.
-
BL33, BL33A: Fix for report not including all meters.
-
BT02A, BT02B, BT03A, BTO3B, BT04A, BT04B, BT06A, BT06B, BT07A, BT07B, BT08A, BT08B: New reports. These are forecasting and unit cost reports that mirror the existing budget reports.
-
CAP10: Fix for place code longer than 16 characters causing an error.
-
SU53: Fix for weather station still being counted as part of the total after it has been deleted.
-
WTHR02: Added filters for topmost place and place. When either of these filters are set, the report will be one page per place. If neither the topmost nor the place filters are set, then the report will function as it previously did.
August 2010
-
AN08A, CH01, CH02: Fix for blank first page
-
CAP14: Fix for report filtering out issues not associated with a bill
-
WTHR02: Fix for report not returning results when filtered by weather station name
July 2010
-
AN02: Fix for report displaying in wrong unit of measure
-
AN10, AN10A: Fix for data table missing and data table displaying zeros
-
AN22CC: Fix for report displaying base year data for current year
-
BL01: Added space between consumption data and unit of measure
-
BL30: Removed locked filter on place type of building and store. Added place type code and place type name filters.
-
CAP01C: Fix for topmost cost center filters causing the report to fail
-
SU53: Fix for report displaying data twice. Fix for active meter count being inflated by multi-account meters
-
YY10: Changed first column to wrap onto multiple lines so it doesn't overlap the second column
-
YY12: Fix for report not displaying data when commodity filter was set to "one of"
June 2010
-
AN04: Fix for report not including records without common usage
-
AN08, AN08A: Fix for extra white space and blank pages
-
AN09: Made the place name column wider
-
AN10A: Fix for data table always showing zero values
-
BL02: Fix for incorrect meter subtotal cost/day and use/day being incorrect in dereg situations
-
BL02CC: Fix for report not incuding records without common usage
-
BL06: Fix for inflated bill counts and cost totals
-
BL21: Fix for issue of duplicate results on multi-meter accounts
-
BL32: Added place code to the display
-
WTHR02: Fix for base year, current year, station name, and station code filters not working. Fix for non-weather stations being displayed.
-
SU53: Fix for too many weather stations appearing on report
May 2010
-
AN01: Changed size of line marker on web report to be consistent with other reports
-
AN20: Fixed issue of report failing of no status filters were set
-
BL07: Fixed issue of statement date and next reading date not displaying; added meter code filter
-
BL10: Removed unnecessary filters
-
BL16: Changed caption text on filter from "Bill Line Unit Value" to "Bill Line Value"
-
BL34: Added account info to the display
-
CH07: Added status filters
-
SU15: Fix for report not returning results
-
YY16: Fixed issue of place group and meter group filters causing the report to fail
April 2010
-
AN08, AN08A: Moved charts from side by side to on top of eachother so that they have more room. Fix graph and table being sorted differently.
-
AN09: Fix for report not displaying in common usage when it should display in global usage.
-
BL24: Fix for report skipping certain meters.
-
BL30: Fix for report ignoring supplier bills.
-
BL37: Fix for report giving false positives.
-
BL38: Fix for paramter prompt and duplicate records.
-
CAP07: Fix for cost avoidance percent being wrong on the last page.
March 2010
-
BL01: Fixed export to Excel issues; usage column missing and data not lining up with headers
-
BL11B: Added place and topmost place filters •BL12: Set the place group filters to use only "equals" and "all operators" • BL34: Fixed intermittent dll error •CAP07: Fixed issue of actual cost and cost avoidance numbers being incorrect
-
CAP08: Fixed issue of web report returning error
February 2010
-
AN01: Changed label from "Cost in US Dollars" to "Cost"
-
AN15: Fixed issue of use and cost bing multiplied by the number of floor area entries
-
AN20: Fixed issue of use and cost bing multiplied by the number of floor area entries
-
BL09: Fixed issue of Topmost cost center Code filter causing report to fail
-
BL17: Fixed issue of Bill Entry Date filter causing report to return no results
-
BL23: Fixed issue of Bill Entered By filter causing report to return no results
-
BL27: Fixed issue of Bill Entry Date filter causing report to return no results
-
BL39: New report that shows a summary of use, demand, cost and unit cost by place type and commodity.
January 2010
-
AN07: Fix for square footage label was displaying unit for common use instead of the area unit
-
AN15: Fix for web report error "Error Occured Reading Records. One or more fields could not be found in the result set."
-
BL02: Removed decimals from totals line. It was showing "xxxxx" due to lack of room.
December 2009
-
AN04: Added unit of measure to usage display
-
AN08: Fixed web report error. Error message was "Runitmie formula uesd to change values in a chart or graph"