AATRIX
•ENHANCEMENT - The State Unemployment Tax Rate was only showing 2 digits past the decimal place which was not working for some state rates and the rate had to be adjusted manually on the Aatrix tax form. This problem has been corrected and the tax rates will now extend up to 4 decimal places.
•ENHANCEMENT - Aatrix Tax Form Processing - A new menu option has been added to the Payroll > Controls menu titled Aatrix Settings which contains basic tax form fields for tax form processing along with new ACA Fields that will be required for the 2015 Calendar Year End
•ENHANCEMENT - Aatrix Tax Form Processing - A new menu option has been added to the Payroll Menu titled ACA Employee Records which will be used to track all employee health insurance information for the ACA reporting which is required for Calendar Year 2015
ACCOUNTS PAYABLE
•CORRECTION - The lookup fields on the invoice entry screen were corrected to show the full lookup value and automatically adjust the width of the drop down field instead of cutting off part of the description on larger fields. This change was made on the job field, phase field, gl account field, and the vendor field.
•CORRECTION - The tab order for the invoice approval screen was corrected to flow correctly from field to field.
•CORRECTION - The Hand Written Check screen was not displaying the job cost phase field properly for check entries that were linked to an invoice reference number. The phase code was posting correctly but the screen was not displaying the proper phase value. This was a cosmetic change and has been corrected
ACCUBUILD BLOG
•A new text file titled “AccuBuildBlogRSSFrameExecuteFailure.txt” is now written to the AccuBuild Program directory when a failure is encountered during the connection to the AccuBuild Blog Website.
•A new INI setting titled “UserAgent” was added to the AccuBuildRSS ini file which controls the AccuBuild Blog launch. The User Agent option is optional but allows you to overwrite the text setting for the HTTP component which is currently set to the following string by default:
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101 Firefox/12.0
ACCUBUILD DATABASE STRUCTURE UPDATE
•The Database Version has been updated to Version 9.4 for this release and includes some new fields for the Estimate Detail Items table and estimate import batch table along with several new company tables which are required for the new Affordable Care Act (ACA) reporting at the end of the 2015 Calendar Year:
oESTDETL – Added new fields for production unit tracking
oPRODTASKS - New Task Master List for Production Units by Detail Item Tracking
oAATRIXCOMPANYINFO - New Company Info Table for Aatrix Tax Form Fields
oAATRIXALEINFO - New Company Info Table for new ALE Information for ACA Reporting
oAATRIXAGGINFO - New Company Info Table for Aggregated ALE Groups for ACA Reporting
oAATRIXECVINFO - New Employee Health Insurance Coverage Info Table for ACA Reporting
oAATRIXECVTEMPLATE - New Health Insurance Policy Plan Master Table for Tracking ACA Health Plans
oAATRIXECIINFO - New Employee Dependent Coverage Info Table for ACA Reporting
oAATRIXOCPINFO - New Employee Other Coverage Info Table for ACA Reporting
oIMESTBAT – User Estimate Import Batch Table has new fields for production unit tracking
ACCUBUILD MOBILE
•ENHANCEMENT - New Mobile menu configuration settings have been added to the User Maintenance screen for Quick Timecards, Webflow, and Weekly Timecard. These menus can now be secured for individual users.
•ENHANCEMENT - Three new configuration options are now available for AccuBuild Mobile which are global settings for all users. These new options can be found on the Mobile Time Card Settings tab and include Equipment, Production Unit Settings, and Crew Settings:
Equipment List Settings – This option allows you to display the lookup equipment list based on the master list of all equipment, or just the equipment that is currently located on each project.
Production Unit Settings – This option allows you to set which type of production units are entered via the AccuBuild Mobile Program, either production units by Job Cost Phase, or Production Units by Detail Item.
Crew Settings for Daily Report Timecard Entry – This option can be set up for showing ALL Crews on the Crew List OR to only show Crews that the current user is a member of.
•ENHANCEMENT - Two new options have been added to the Mobile / Cloud Settings tab for AccuBuild Mobile which include a debug log and a timeout setting.
Debug Log Enabled - A new configuration option has been added to the AccuBuild Mobile Settings screen for enabling and disabling the SLQ Debug Log for AccuBuild Mobile. Check the box entitled Debug Logging Enabled to turn on the debugging feature and uncheck the box to turn the debugging log off. The debug feature will keep an audit trail of each stored procedure call from the AccuBuild Mobile product and will log the information in the SQLLOG Table located on the global dictionary connection of the AccuBuild Program.
WARNING – This log should only be enabled for short periods for debug purposes only and should NOT be left enabled for a long period of time as the debug table will accumulate a large number of records in a very short time.
Inactivity Logout Setting – This setting is used to set up the number of minutes the AccuBuild Mobile session will wait when there is no activity from the user before the user is automatically logged out of the mobile application.
•ENHANCEMENT - A new stored procedure called abm_DailyReportADMSFile_UploadSingle was added for uploading pictures to the Daily Report for AccuBuild Mobile 3.0.
•ENHANCEMENT - The Daily Report list was updated in an earlier release to only show the Daily Reports that were created by the logged in User. This procedure has been updated to show all daily reports regardless of which user created the report.
ACCUBUILD USER DATABASE DICTIONARY ENHANCEMENTS
•The User Database Dictionaries will now have permanent links available for connecting to the company (CoLink) and global (GlLink) dictionaries for processing SQL Script commands.
CLIENTS
•CORRECTION - The Acct Tab on the Clients Screen was not displaying the fields properly when they did not exist in the lookup controls for the default Job Cost Phase, G/L Expense Account, and the Payment Terms. These fields will now display the actual value for the selected client when they no longer exist in the associated lookup tables.
DOCUMENT ROUTING
•ENHANCEMENT - The AccuBuild screen viewer which handles the scanned and imported TIFF documents is now set up as a NON-MODAL form for the Routing Invoice Screen as well as the Invoice Approval Screen. This means you can now open up a scanned or imported form and have the screen open while entering AP Invoice entries or updating the Invoice Routing Information Screen. NOTE: Be sure to close the image viewer screen if you make any changes to the image so that the changes are saved with the document. If you do NOT close the image form, it will be closed automatically when the calling form is closed.
GENERAL LEDGER
•CORRECTION - The Description field in the General Journal Screen has been widened in order to fix the problem where some of the longer account descriptions were being truncated
JOB COST
•ENHANCEMENT - The tab order for the Estimate Detail items > Cost Estimate Tab has been modified to now include the G/L Expense Account field in the tabbing cycle BEFORE the Save Button is highlighted so the this field is included in the normal entry flow for estimate detail records.
•ENHANCEMENT - All of the Update Jobs > History Tabs will now automatically be refreshed when any History Tab option is selected for a job. The History Tabs will also be automatically refreshed when moving from job to job on the screen. These refresh options will now automatically handle the Contact Billing Lookup and the Miscellaneous AR Invoice Lookup as well without the need to click these respective lookup buttons.
•ENHANCEMENTS - Estimate Import
•The Estimate Import feature has been updated with 4 new field mappings:
▪ProdUnitTaskNumber – Production Unit Task Number
▪CORCategory – Change Order Request Category Number
▪UnitOfMeasureAbbr – Unit of Measure Abbreviation)
▪ProdUnitBidItemNotes – Production Units by Detail Item – Bid Item Notes
•New Business Rules were added to the estimate import process when importing Production Units by Detail Item to make sure duplicate Bid Item Numbers are not imported at the same time. Posting of the import records will be rejected if duplicate Bid Item Numbers are encountered.
•ENHANCEMENTS - Production Units by Detail Item
oThe Production Units by Detail Item Screen has been updated with several new enhancements including the ability to edit bid items and tasks, full audit trail lookup of detail item changes and improved grid navigation and color highlighting for recording production units and hours.
oThe Production Units by Detail Item Feature has been restructured to handle multiple sets of Master / Task records for the same Bid Item Number by using rolled up totals in the production units input screen.
oBusiness Rules for Estimate Detail Items - Changes were made so that billing detail items can no longer be edited if the items has been billed in the past. This is to prevent situations where users have removed the billing phase and billing amount from items that have been billed which causes the prior billed amount on the contract billing to be incorrect. In addition, detail items will also follow business rules that prevent posting to a closed period.
MY ACCUBUILD REPORTS
•CORRECTION - The “Job Cost Capsheet Report – Job / Phase / Contract Totals” had a problem with the formula calculation entitled “X ProjectedProfitLoss” which has been corrected in this update. (JCREP02D.510).
•ENHANCEMENT - Payroll Check Detail Reconciliation Report has been enhanced with new query totals that test for the payroll burden amounts between the Check Records (PRCHECKS) and the timecard records (TIMECARD) to report any differences. If any differences are encountered for the burden amounts, the will be identified at the employee total level as well as on the last page of the report as shown:
| PRREP14D.644 - Payroll Check Detail Reconciliation Report - Trans Date |
•CORRECTION - The check number field for certified payroll reports had to be widened in order to compensate for the new 700,000,000 check numbering series that is used for direct deposit checks. The following report files were updated for the check number field fix:
| PRREP06A.618 |
| PRREP06B.619 |
| PRREP06C.617 |
•CORRECTION - The following reports had a problem with the formula calculation entitled “X ProjectedProfitLoss” which has been corrected in this update:
oJCREP02D.506 – Job Cost Capsheet – Job / Phase / Account Totals
oJCREP2D1.511 – Job Cost Transactions – Posting Date / Contract Totals
oJCREP2D1.516 – Job Cost Transactions – Trans Date / Contract Totals
•ENHANCEMENT - The datapipe titled PMFormsJobInfo which is produced for all the MAR forms for the PM Log now contains the email address for all contact roles on the project
•ENHANCEMENT - The datapipes for the Production Units by Detail Item have been updated to include the task number field and the associated reports have been updated to sort the tasks in order by task number. The following report formats were updated:
oPMREP17.839 – Production Units by Detail Item PM Report
oPMPDNUN1.455 – Production Units by Detail Item PM FORM
ORDERS
•CORRECTION - For P/O A/P Invoices that are entered through the invoice routing process, the line items in the lower left side of the entry screen were not in order by item number. This issue has been corrected.
PAYROLL
•NEW FEATURE - Affordable Care Act - With the release of Version 9.4, AccuBuild is introducing several new screens and database tables which will be used for maintaining health insurance coverage information for ACA Reporting. This initial release of the ACA Tracking Screens will allow you to begin entering employee and employer information required for ACA Reporting.
In future updates for the 4th quarter of 2015, there will be additional enhancements to integrate the data gathered from these screens with the Aatrix Tax Software Program to produce the new series of ACA Forms. These new forms include Form 1094-B, Form 1094-C, Form 1095-B, and Form 1095-C.
Complete details on the new screens can be found in the FAQs section of Payroll Manual. Please use the link below to jump to the FAQs page.
|
ACA - Affordable Care Act |
•ENHANCEMENT - A new menu option has been added to the Payroll > Controls menu titled Aatrix Settings which contains basic tax form fields for tax form processing along with new ACA Fields that will be required for the 2015 Calendar Year End:
•ENHANCEMENT - A new menu option has been added to the Payroll Menu titled ACA Employee Records which will be used to track all employee health insurance information for the ACA reporting which is required for Calendar Year 2015
•ENHANCEMENT - The Payroll tax calculation routine has been updated to trap any entries where there NO Pay Transaction Records for an employee. For example, if a payroll check is generated for an employee to reimburse a deduction amount (negative deduction) and there are no other pay records associated with the timecard entries, the tax calculation process will now trap the problem. For this type of situation, you will need to add two offsetting pay transaction entries – usually a one cent positive amount and a one cent negative amount.
| Example: Use transcode 31 (manual rates) .01 (save entry) |
| Use transcode 31 (manual rates) -0.01 (save entry) |
•CORRECTION - When the payroll setting for “Unique Check Number Sequence for Direct Depost Checks“ is enabled for the first time, the assigned check number for direct deposit checks was starting at 1 instead of 700000000 This problem has been corrected.
•ENHANCEMENT - A new report class and report format was added to the existing Certified Payroll XML Report option. This new report will now respect linked jobs that are linked for Contract Status Purposes using the CS_JOB field and roll up the linked jobs into a single certified payroll report and a single XML File.
| PRREP06C.615 - Certified Payroll Reports - XML Format 1 - Linked Jobs – New certified report format for XML Export that combines linked job entries on the same certified payroll report and XML File. |
NOTE: In order to use this report option, you will need to make sure that the XML Project information for all linked jobs are set up with the same information so that the data can be linked correctly and rolled into a single XML file.
•CORRECTION - Certified Payroll XML Report - The XML File generation routine was updated to strip out any ampersand ‘&” symbols from the workClass field (AccuBuild Union Description field) in the XML file as this character is not acceptable for XML files.
PROJECT MANAGEMENT
•CORRECTION - On the Daily Report > Personnel Tab, the default employee fields were only working when the drop down arrow was used to select the employee. If the employee number was typed in manually, the defaults were being ignored. This problem has been corrected.
•CORRECTION - The time card entries on the Daily Report Screen will now set the rate type to Regular Pay (Type 1). Previously this field was left blank and had to be updated in the time card worksheet screen.
•CORRECTION - The COR Price Breakdown Screen had a problem with the CO Markup 1 field when a breakdown item was flagged as a Billing Item Only. The markup amount was being reset to zero each time a markup percentage or a markup amount was entered. This problem has been corrected.
•CORRECTION - The COR Contract Amount and COR Cost Amount fields were not being refreshed with the newest totals after the COR Price Breakdown Screen was closed. The problem was only an issue when the COR Breakdown Screen was opened using the right-click pop up menu on the COR Log. The totals will now be updated correctly.
•ENHANCEMENTS - COR LOG Enhancements
oCOR Cost Breakdown Screen - The requirements for billing phase and cost phase linking to the accounting system have been updated so that if the COR breakdown item is marked as COST ONLY, then only a Cost Phase is required, and if marked BILLLING ONLY, then only a Billing Phase is required. Previously, both cost and billing phases were required when either of these two check box options were selected.
oThe Accounting Links Button has been renamed to COR Links and a new option was added to the COR Links Button for Linking items to production unit tracking (Bid Items).
oAdded the COR Links Button pop-up menu to the bottom grid as a right-click pop- up menu option as an alternative to using the COR Links Button.
oThe Manual Link option for a single COR Breakdown Item has been updated to respect the new business rules for allowing an item to be linked so that Cost Only items will not require a Billing Phase and Billing Only Items will not require a Cost Phase.
oTwo new entry fields were added to the COR Breakdown screen for Estimated Units and Contract Units.
oThe COR Breakdown screen now integrates with the Estimate Import feature of AccuBuild which allows for spreadsheets to be imported directly to a Change Order Request (COR). The Estimate Import Screen for Changes orders has some slight changes on the user interface in order to accommodate the importing of records directly to the COR Breadown Records in Project Management
▪Change Order Request Info – This group box shows the job number, change order request (COR) number, and the Master PMID record number for the PROJMGMT table that the import records will be linked to during the import. Each of the imported records will be flagged as COR Breakdown records and automatically linked to the COR.
▪Post to COR – The post button process will post the records to the COR instead of posting directly to the job. Once the posting is complete, use the Close Button to close the screen and return to the COR Breakdown Screen.
▪Import Structure Change – The Import Structure has been updated with a new field so that you can include a COR Category number with the import if desired.
SYSTEM ADMINISTRATOR
•ENHANCEMENT - A new menu option has been added to the File Menu titled Enable Confirmation Dialog on Close of Program. When this option is checked (enabled), the user will be prompted with a confirmation screen before the program is closed. This can be very useful when you have several full size screens open and you accidentally close the AccuBuild Program by mistake.
•ENHANCEMENTS - If the “Current User Only” setting is enabled for AccuBuild Mobile, the user Employee Number field must be set up before the setting can be saved. Employee Numbers need to be associated with the User Settings in order to have this setting work properly for the AccuBuild Mobile Product.
•ENHANCEMENTS - Audit Trails on Company Tables
oThe SQL Scripts for the Audit Trails on Company Tables was updated to add specific error code handling with a new error code of -700 to help identify any exception errors that occur when a table audit trail is enabled and the audit trail functionally is causing problems with normal processing.
oThe Audit Trail Company Table selection has been updated to exclude the ESTDETL and JOBLIST tables from being audited as these tables already have built in audit tracking in the AccuBuild Program