Version 10.2.0.0

This update requires database structure changes to your company database files. You will be prompted to update the database when the program is first opened after installing the 10.2 Release. There are at least three databases that will be updated with this update and possibly more if you have multiple companies and / or multiple users within each company. Database restructure processing is outlined below:

•BASEGLOB - AccuBuild Global Database - Updated when the AccuBuild Program is opened for the first time by any user. This process is only done ONE time per AccuBuild Program Installation.

•BASECOMP - AccuBuild Company Database - Updated the first time a company is opened by any user. This process is done ONE time per Company.

•BASEUSER - AccuBuild User Database - Updated the first time a user logs into a company. This process is done ONE time per User per Company.

Example 1: User Joe is the first user to log into the AccuBuild Program for Company “A” after the update is installed:

•BASECOMP is updated for new structure changes (one time for Company “A” database)

Example 2: User Sally is the second user to log into the AccuBuild Program for Company “A”:

Note: At this point, Joe and Sally will never be prompted for restructure going forward when they log into Company “A”. However, if Joe or Sally have user access to another company in AccuBuild, they will be prompted again for that company.

IMPORTANT - Before any database restructures are done, a backup of the company databases are made to a zip file in the company folder.

The AccuBuild System supports a seamless integration with the Procore Project Management System. The integration package contains features to synchronize the project related data between the two systems. This integration is being developed in two phases which include Job Cost Data (Phase One) and Project Commitment Data for Subcontract Payment Sheets, Purchase Orders and related Change Order amounts on these commitments (Phase Two). Phase One of the integration is supported in AccuBuild Version 10.2 and Phase Two will be supported in a future version.

Phase One - Job Cost Data - The Job Cost Phase totals in AccuBuild are pushed to the Procore Projects by lining up the costs with the Procore Budget Line Items which are tracked in Procore by cost code and cost category type. The budget line items in Procore will then include these costs along with the budget to cost variance amounts. Each time the cost data is synchronized to procore, the job to date cost accumulators in Procore are updated (overwritten) with the most recent cost totals. These costs can be sent from AccuBuild based on current cost to date totals, or based on a report cutoff date. The report cutoff date totals are very useful for Project Managers to have the same cost totals as the AccuBuild System for accurate cost to complete analysis at the end of an accounting period.

•Correction - Prior Period Transaction Date Validation for AR Invoices [PMID Ref No 22112]

The Miscellaneous AR Invoice posting routine was updated to check the transaction date on ALL invoices in the user batch when the Allow Prior Period Transactions option is disabled in the accounting control settings. Previously, the system was only checking the first record in the batch, however since the invoice batch allows for multiple transaction period entries, all of the records need to be tested. If any entry in the batch contains a prior period transaction, the posting process will be cancelled until the entry is corrected for the proper transaction date OR the Allow Prior Period Transactions setting is enabled.

The Fixed Pricing fields were being rounded to two decimal places instead of four each time the inventory parts master file was updated with new inventory receivers in the Purchase Order Module. All Fixed Pricing fields will now be rounded to 4 decimal places which includes the following fields:

•Correction - Fix Audit Trail Tracking in the Job Center Screen [PMID Ref No 23834]

The automatic audit trail tracking feature for all field changes to the JOBLIST and ESTDELT tables was not implemented in the new Job Center Screen when Version 10 of Accubuild was released. These audit trail features have now been added to the Job Center Screen and the field changes will now be logged to the TABLEAUDIT Table

•Correction - Fix the Production Units by Cost Phase "Unit of Measure" Control [PMID Ref No 24071]

When a new unit of measure was added to the Production Unit - By Cost Phase screen, the new entry was not saved to the dynamic list. This feature was available prior to Version 10 but was missed in the Version 10 conversion. This issue has been fixed in this release.

•ENHANCEMENT - New Financial Statement Format for Large Numbers in YTD [PMID Ref No 23826]

A new Crystal Report format is being distributed in the Report Folder of the AccuBuild Program Directory which has been enhanced to handle Large Amounts in the YTD Column. Use the File > System Administrator > Report Substitution option to replace GLFINANC.RPT with the new report: GLFINAN1.RPT.

The New York Taxes and Wage Reports have been modified to include a state code dialog search box with the state code set to 36 for New York State. In addition, the State Abbreviation is now included under the State Column as part of the state code:

•ENHANCEMENT - New Gender Setting for California Pay Data Reporting [PMID Ref No 22991]

California has a new Pay Data form requirement that is similar to the Federal EEO reporting and requires new ethinic codes for Non-Binary gender settings. The Employee Center Screen has been updated with a new Non-Binary checkbox in order to comply with the new reporting requirements. The Gender Setting should remain set for Male / Female options which is required for Federal reporting, however, the Non-Binary opition is available for Employers that have California Employees.

NOTE: The checkbox should be dark black when the Non-Binary setting is enabled. A light checkbox or blank checkbox indicates that the setting is disabled:

oThe payroll withholding tables for the 2021 Calendar Year have been updated for the following states

▪New York - The withholding tax tables for New York State and the Yonkers City Tax have been updated for new tax rates which are effective as of 07/01/2021.

▪Idaho - new rates issued by the state on 07/07/2021. The tax brackets have been reduced from eight to six.

•ENHANCEMENT - New Aatrix Form for California Pay Data (EEO) Reporting [PMID Ref No 22991]

oThe Aatrix Integration in AccuBuild has been updated with the new California Pay Data Report. This report can be accessed using the Tax Forms / E-File / W2s menu option of the Payroll main menu. You will need to select the Federal Forms option on the Aatrix Dialog to locate the form:

You will want to review the Personal Tab on the Employee Center Screen to make sure each employee is set up correctly for the related EEO fields: Gender, Ethnic Code, & EEO Job Category.

When generating this form, Aatrix will prompt you to select a pay period from a drop down list.

• If you choose a specific date, then Aatrix will display only those employees that received a check on that date. The hours will be the total of all hours for the reporting year (regular, overtime and PTO hours) not just for the selected pay date.

• If you choose the 'No payroll within snapshot' option, then ALL employees that had earnings for the reporting year will be displayed. The hours will be the total of all hours for the reporting year (regular, overtime and PTO hours).

•ENHANCEMENT - New Field Settings for ACA Health Insurance Screens [PMID Ref No 22991]

The Affordable Care Act (ACA) Screens for Employee Health Insurance Information have been updated to support the new codes for the Policy Origin Code and the Offer of Coverage Code. These changes have been made on the Employee Coverage Template Settings Screen, the Employee ACA Health Insurance Information Screen, and the Health Insurance Plan Master List Screen.

The Company Stored Procedure Library has been updated with two new stored procedures which will be used during the implementation process of the SOP Module. These procedures are documented below:

•sop_BuildBaseSecurity - This procedure will create the initial security records for the following company tables:

Technical Note: This procedure will only be used by an AccuBuild Technician during the implementation process for the SOP Module: BASECOMP.sop_BuildBaseSecurity (Class 7773000 - Seq No 155).

•sop_UpdateCompanyForVer10_2 - This procedure will update the company database with the new tables and structure changes required by the SOP Module for AccuBuild Version 10.2. Several new SOP tables will be added to the company database as detailed below:

Technical Note: This procedure will only be used by an AccuBuild Technician during the implementation process for the SOP Module: BASECOMP.sop_UpdateCompanyForVer10_2 (Class 7773000 - Seq No 160).

•Documentation Update - File Structure Help Update on Company Database Dictionaries

With the release of AccuBuild Version 10.2, new index files have been introduced for the DMFLDIST document management company table which are used by the Invoice Approval Process in Document Management. When you are using the SQL Dictionary Comparison Utility (File Menu), you may encounter a message indicating that 5 of the 6 index files are missing for the DMFLDIST Table as shown:

In order to create these indexes for your company, you can open the Document Routing Screen from the Documents Menu and you will be prompted to create these index files:

Once these index files have been created, you can run the SQL Dictionary Comparison Utility to compare the Company Dictionary files, and the missing index messages for the DMFLDIST table should be corrected.

The new Read Only Licenses introduced in Version 10.1.0.6 were not allowing the MAR Reports to be previewed - The Preview Button was disabled in the security settings. This issue has been corrected however you will need to update one of the read only users in the system in order for the security settings to be refreshed which can be done as follows:

Open the User Maintenance Screen and select one of the read only users, uncheck the Reporting / Dashboard User option and then check the option again. This will trigger a refresh of the new security settings for ALL read only users. Close the User Screen and then log in under one of the read only users to test the MAR Reports. If the read only user has been set up for report security on any MAR Report, the report will be enabled for previewing.

The settings for the chart data connections were not saving correctly for charts that contained multiple series such as multiple bars in the same chart. This issue has been corrected in this release.

Version 10.2.0.0 - July 30, 2021