Version 9.5.0.1 - October 26, 2016

AccuBuild Analytics - DEMO Version Release

●The new AccuBuild Analytics web based tool is being released as a trial demo version in conjunction with the 9501 release of AccuBuild.  This product was introduced are our 2016 User Conference and will now be available for those that requested the trial version at the conference.  This product comes with a standard library of 29 analytical cube designs covering the most critical areas of the AccuBuild System including Payroll, Job Cost, Customer Activity, Vendor Activity, Purchasing (Orders), Inventory, General Ledger, Equipment, Project Management, and Customer / Contact Information.

In addition to the cube library, the product supports user designed cubes with a similar interface to the AccuBuild MAR Product, but much more simplistic to use.  You can use this tool to design your own custom cubes to share with others in your company.  The product also supports custom SQL Scripts like the MAR product which means we can design tailored cube scripts to give you information you have never been able to get in a single report.

Enhancements and changes to the AccuBuild Analytics product since the initial preview at the user conference include the following items:

●Cube User Security List BUG FIX - the security list for cube security was showing users and groups from ALL companies and was not being filtered.  This issue has been corrected.

●Job Cost Transaction CUBE BUG FIX - The cube had a SQL Query error that showed up when the cube was updated with custom filters for limiting the transactions to a specific cutoff date.  The problem had to to with amount calculations for checks that were processed BEFORE the custom filter cutoff date and then voided AFTER the custom cutoff date.  This issue has been corrected.

●Added new Expiration Date in order to deploy trial version through 12/31/2016.  The expiration date on the trial version is displayed at the top of the screen and the user will be prompted with the days remaining each time the program is opened.

●The Pop Up menu options on the Cube Tree have been revised:

Export Cube Design to Disk - Saves the cube design to external files in the user folder for the cube data, the cube schema (layout design), and the sql query.  This can be helpful when manually moving a cube design from one company to another.  There currently is no automated process to do this but this feature makes it easier for an AccuBuild representative to help a customer setup a custom cube design in another company to avoid starting from scratch.

Save Cube Design - saves the current cube settings for a custom cube only.  Use this option to save the current changes on a custom cube. NOTE: you will also be prompted to save the current settings if you open another cube while working on a customer cube.

●Server Licenses now required - The AccuBuild Analytics product must now be launched from a browser and requires a licensed version of the AccuBuild Analytics product.  We will be issuing user licenses for the trial version so that it can be launched within these new server requirements.

Please contact AccuBuild for more information about AccuBuild Analytics product.

Accounts Payable - Invoice Routing Report Enhancement

●The MAR Report for Payable Invoice Routing was updated with new script and report layout to add exception notifications when multiple entries exist in a batch for the same PO Number and Item number.  This will help to catch entries that have been double entered BEFORE they are posted.  Any line item on a PO that has been entered more than once in the approved batch will be flagged to show multiple entries in RED on the right side of the report.

Accounts Payable - MAR Vendor Activity Report - Partial By Vendor Correction

●The partial run list for vendors on this report was only including vendors that were processed via payable invoices.  If the vendor was paid with a hand written check and did not have any associated payable invoices in the historical purchase journal file, then they were NOT included on the partial run list.  The report dialog will now show the entire client list which can now be filtered for all Vendors.

Payroll - Employee List BUG FIX

●The Employee List Screen was updated with new ERASE Speed Buttons next to all of the employee phone numbers including phone, cell, pager, and both emergency contact phone numbers.  The screen would not allow the phone number to be cleared and these new ERASE Buttons will now allow clearing of these fields.

Sub Online Payments - Enhancement

●A new settings option is available for the sop_setttings table that will allow a list of cost phases to be set up that are exempt from retention.  To enable this new feature, you will need to add a new setting in the ‘name’ field of the sop_settings table called ‘no_retention_scopes’ and then add a comma separated list of cost phases that are exempt from retention.  For example, set the ‘value’ field to 5001.00,5002.00,5003.00 to exclude retention on these 3 phases.