Grid output on all Standard Tabs

Report Sets for template-driven reporting in Excel

RADAR Reports (stored as-of sub-ledger reports)

Mouse zooming of all FACTGrids

Faster Benchmark reporting

Automatic 64/32 bit operation

Improved error messages throughout

Work Order Reporting

Budget Builder enhancements for multiple ratetables

New "Email Me" functionality

New Scheduled Reports functionality

10/8/2015 - Update for monthly average calculations.

9/28/2015 - Update to new FACT server.

7/13/2015 - Security update for closed Budget Builder datasets.

3/27/2015 - Bug fix for explosions by new FA attributes.

3/27/2015 - Update for enhanced Budget Builder functionality.

5/27/2015 - Update for JDE 9.1

Functionality to support the Job Cost and Forecast report.

Functionality to support inventory reporting.

Update to FACTFINDER to support indexing of data GL account balance

based on Cat Codes

Update FACT to support the following:

• FACT Drilldown functionality enhancement
  • JPS reporting drilldown to GL detail where applicable
  • F/A reporting drilldown to GL detail where applicable
  • Sub ledger reporting drilldown to GL detail where applicable
• Job Cost Report
  • Reporting rollup for LOD 4-7 where amounts are 0
• Inventory Reporting
  • Monthly spread
  • Long Inventory Reporting
  • Build Control
• Footer Suppression Control
• Foreign Currency Reporting
  • Period -Reporting prior periods results at foreign exchange rates applicable at the time
  • Native - Reporting of native exchange rate
• Improved help in tooltips
• Charting
  • Elements highlighted by clicking the data grid
• FACT Grids
  • Alternative method for sorting
• F/A Reports
  • Show correct year if changed
• FACT Administrative Items
  • Timeout functionality enhancements
  • Fix for Excel output for report with Super headers
  • Additional indexing on specific Cat Codes for performance
  • Detect drilldown on last year or budget data in monthly spread or benchmark & set data type accordingly.

Update FACT to correct the Excel Export on a drill down.

Add functionality to hold the active month for a build and default it into

the setup view.

Update FACT to correct the drilldown reporting on a benchmark report

drilldown.

Add numeric MCU column in the Export BU Catcodes to Excel report.

Enhanced warning before FACT exists due to inactivity.

Removed limit of maximum 5000 selections for a given selection field,

now limited by memory.

Fixed a bug drilling down on reports produced with report-by MCU.

Fixed a bug reporting on an OBJ / SUB value where the SUB was “E”

followed by a large integer.

Enhanced speed of report production for sub ledger reports with a

large number of columns.

Functionality to add reporting by millions as well as reporting rounded

to dollars, thousands and millions.

Total Line Drilldown Changes:

• The default drilldown is now a “pure” drilldown (without extraneous total lines, etc.)
• Checking the “Drill on each Detail Line” option drills down the way that it used to: showing the detail lines that lead to the total, each in drilldown detail.
• Added a new “Detail for Total Line” button to replace the previous “Only Underlying” checkbox. When clicked, this button shows the report lines that make up the total line that you clicked without any further drill-down, even if they were hidden by the report author.

The matching algorithm to find the F/A data when running combined

GL/FA reports has been updated improved (primarily for prior year selections),

and the FA build is now shown in the report selections where appropriate.

If “Business Unit” is selected as the only sort on a Job report, the report

runs with no grouping and subtotals at all.

In the report viewer, Ctrl-Mouse Wheel will zoom in and out.

A new user report history function showing users their reporting

activity over 4 different time periods was added.

Report-by and selection exclusions on the print form are now

highlighted to increase the visibility of these settings, which have a large impact on report output.

Fixed problem with embedded CR in account range specification

Updates to F/A ad Jobs reports to widen header line text

Update to F/A to show count of assets in total lines.

Fix issues with Multiple Selection form highlighting.

Update to the benchmark report to fix a report that contained

explosions.

Added logic that sizes report windows, so that it looks at the report

width and your current zoom factor and produces an appropriately sized view.

New standard reports including a format with descriptions on

the LHS and the functionality to substitute forecast data LT BA, B1, B2 and B3.

Updates to include user defined memorized reports on the main

screen

Update to be able to go back to or forward to report run

earlier in a session.

Update to allow the use of a report month in a formula.

Update to fix a report using custom columns with a column

break to apply the formula to the correct column.

Update to the way the system functions to select and entire

row with mouse in multi-selection columns.

Update to allow LTD reporting on F/A reports.

Renaming a Custom Column report will update all saved reports,

and the list of suggested custom column reports for a given layout.

Renaming a layout will update the list of suggested custom

column reports.

Fixes for the 3 subledger reports (Job Summary Report / Job

Summary by Cost Code/Detail Job Report) with issues following the fiscal year change.

Fixes for column filtering in grids with hidden columns

(where exclusions went to the wrong column, etc.)

Improve ability to filter to blank values in grids.

Performance enhancements, particularly with reports involving

F/A data, for job reports and for some custom reports.

Update to the latest version of Report Writer.

Update to support current month default for inventory.

Update to correct the inventory export to Excel on the Full

Continuity report.

Update to functionality to drill down on math lines.

Update to allow for drill down on AAID_Parent_number.

Update to allow for drill down on FA3_Cat_13.

Job Reporting – Update to accommodate specifications with

Subsidiary Accounts

Fix ratio calculation

Add ability to adjust the zoom factor to fit the report

on the screen horizontally

Improved handling of "super headers" in grids as they scroll

off-screen

F/A Reporting – Addition functionality to sort by code,

code and description and description

F/A Reporting – Addition of a grouping function

F/A Reporting – Drill down support for grouping function

F/A Reporting – Change GL drill down screen to expose the

unit number

F/A Reporting – Update to accommodate specifications with

Subsidiary Accounts

Benchmarking report export to Excel correction

Update to accommodate windows 8.1 screen display for reports

Update to accommodate drill down in prior month columns in

F/A reports

Update to correct benchmark reporting

Update the Column Spec Table to include a report number,

revision and category to improve the ability to sort, categorize and find reports.

Add total column for each year for data presented.

Add the ability to report data on the budget screen for B1,

B2 and B3 forecasts as well as prior year and BA Budget.

Update to enable the copy of a single cell to a single cell

Update to correct the actual amounts for the “Update Actual

and Budget Data” menu item.

Update to show budget buckets with no activity in the drop

down list.

Update to set the default utilization for rate groups to

“Low Utilization” rather than blank.

Update with functionality to allow contents of all Budget

Builder grids to be exported to Excel.

Update with functionality to allow entry of user comments in

all Budget Builder screens at Budget Bucket (or Management) level.

Update to provide for the revenue by risk report to be run

for each year of the forecast.

Charting Functionality

Enhancement to custom columns to include prior year

reporting to provide for example 5 year historical reporting

Addition of another period value in the monthly spread and

benchmark reporting called “Cash Flow YTD”. Note this

selection reports period change for Balance Sheet and

Income Statementaccounts. It excludes the beginning

balance from Balance Sheet accounts.

Development of the ClickOnce functionality to enable

local install and automated software updating. This

will provide an option to Citrix for main office installations.

Report improvements to reduce the tables that are being

created, read and transferred to improve performance for

local installs.

Added the ability to print build information to report footers.

The conversion of date values to date formats in the

BU Listing Report (Export BU catcodes to Excel).

Analysis worksheet export to Excel for layouts.

Functionality enhancements to the GL detail inquiry to the

document query and to filtering.

Functionality enhancements to the export to Excel to use less

memory and support larger exports.

Functionality to report the Detail Job Cost Report as

per specification.

Functionality to support forecasting of additional ledger

types including B1, B2, B3 etc..

Add find functionality to the Data Grid.

Performance improvements to improve report running times on

reports that report Object/Sub details.

Enhanced functionality for subledger reports.

Functionality to write PDF report to a users directory by

report by selection. Added the print and the PDF icon to the subledger reports.

Functionality to drill down to transactions in the GL on a

drilled down report.

Update to functionality to handle blank subsidiary accounts.

Update to fix the drill down to support column reordering.

Update to improve the way that exports to Excel are named.

Fix the per unit calculation so that amounts are not

reported when calculation ratio is set at N.

Rolling 12 month calculation for YTD; Ability to control a

line to report Training Twelve Months (e.g. Segmented Balance Sheet).

When we crossed the yearend date FACT made2011 the current

year and 2010 the prior year. We need to control this so that FACT reports on the prior fiscal year until the GL is closed.

Add Unit of Measure functionality.

Add Currency conversion functionality.

Add simple Joint Venture functionality.

Enable system functionality to identify a unit and amount in

an additional ledger type. i.e. JA, JU, HA, HU, XL, B1, B2 & B3.

Add functionality to control the BuildYear when requesting builds.

Add functionality to be able to include the Beginning/Original

Budget Balance (BORG) field from the account balance file (F0902).

Change the way a drill down on a account that explodes by

object or object/sub works so that it can drill down on an account that does not have a subsidiary without reporting the total in that object account.

Fix functionality to select a value from the "report by" drop

down menu with either a numeric keypad or the regular keyboard numbers.

Correct the treatment of the sign on the per unit calculation

in the custom column format so that it operates consistently with the standard reports when the sign is reversed.

Correct the variable titles reporting the report-by data from

the report selection when exporting to the PDF format.

Correct the selection button the viewer to place it on the

screen.

Correct functionality to enable exporting to separate

tabs in Excel from a Custom Column format.

Add security functionality to be able to control user access

by an administrator.

Add Chart of Accounts report.

Add a Cat Code audit report to report added BU’s and BU

field changes.

Contains a rollup of all previous updates, including:

Add new job report type to provide control of the account

range by column. This will facilitate Job Profit Summary reports.

To enable reporting of the forecast Ledger types including

B1, B2 and B3.

Add the ability in FACT to forecast from Budget and Last

Year to the Standard, Monthly Spread and Benchmarks formats.

Add the functionality in FACT to control a beginning balance

from the layout for Standard, Monthly Spread, Benchmarks and custom column formats.

JPS report change on the active functionality to report

job if active in any period of the selection.

Change the reporting of the foreign currency translation of

the virtual account so that it uses the income statement (YTD average) rate.

Change the forecast button so it is attached to the right

side of the screen.

Adjust the per unit calculations in the custom columns

(multiply by 1000) to report correctly.

Adjust the beginning balance functionality so that it does

not stop budgets from reporting after the B has been set in the layout.

Correct the Drill down reporting to obj/sub e.g. G&A report.

Asset Management Reporting functionality to reporting FA

amounts from the JDE F1202 file in a report layout. This includes the ability to filter and explode on fields in the Asset Management Master file F1201.

Asset Management Reporting functionality to report from the

JDE file F1202 in a Columnar format. The purpose of this report is to me able to report by Fixed Asset unit and to sort and subtotal by Cat Codes on the fixed asset master file F1201.

Functionality to Access JDE directly (or on a mirrored server)

as required to report the following:

• JDE Equipment Hours by Workdate
• Equipment Hours by GL date
• Labour Hours
• Hours by Home Company
• Job Summary by Job
• Summary by Cost Code
• Reconciliation
• Voucher
• Match
• Rec’d not Vouchered

Functionality includes the ability to filter by Business Unit,

Export to Excel and PDF documents, and to select date ranges when applicable

Correction to the handling of subsidiary accounts with “-“

such as JV-HCM.

Functionality to drill down to transactions in the GL.

Update to functionality to job reports to handle reporting

of prior month, prior quarter, and prior year.

Update to fix reporting of subsidiaries with special

characters such as “-“.

Addition of an AR and AP aged trial balance.

Add the field "MCSTYL" BU Type as well as field descriptions

to the following fields"MCMCUS" (Project Number); "MCSTYL" BU Type; "MCAN8" Address book Number; "MCAN8O" Address Book Number used for AR and AP; "MCCT" Commercial Terms to the Excel BU Table download.

Fix functionality to cutting and pasting rows in the layout

table.

Fix the report viewer to correct the placement of a page

break where there is a header accounts that is following by an amount line and there is nothing to report on the line.

Fix the errors that occur when running reports where a second

report is being run and the first one is closed during the process.

Enable printing of footers controlled on the layout.

Add description to the subsidiary/cost code level of reporting.

Since there is not consistency among BU's summarized reports will require a check for consistent use. Where the description amount BU's is not consistent the description “multiple descriptions” will be reported.

Add the following Ledger Types to the data pull, JA, JU,

B1, B2 and B3.

Add functionality to allow an administrator to set a file

to final for key monthends etc.

Add the Custom Column functionality to the application

along with several defined formats.

Functionality to assist log out inactive users automatically

in a set time period.

Fix to enable drilldown on a report exploded at the

Object/Subsidiary level or on a drill down at the Object/Subsidiary level.

Fix on a drill down total.

Fix on Date headers on 12 month spread to remove the year

on the last 3 months.

Fix to report totals on the Budget Variance and the Last

Year Variance selection of the 12 month spread.

Add new “report by” fields to FACT for Project Number, BU

Type, Customer Address; Supervisor Address and Commercial Terms fields and activate the drilldown.

Implementation of the Benchmarking format.

Change display of the drop down fields in the “report by”

section to limit at the bottom of the screen and avoid dropping out of site.