Springbrook Enhancement Lists

.NET 4.6

The Springbrook has been upgraded to use .NET 4.6, the latest version of Microsoft’s .NET framework. This change will ensure continued support for the framework the application is based on.

 

Springbrook Quick Launch

The Springbrook Quick Launch feature has been added for Version 7.18.0. This feature allows users to quickly access a specific maintenance record with just a few keystrokes. By pressing CTRL+Q and entering the quick launch code and account/code number, users can bypass the process of opening the module, expanding the palette, launching the selection window, and filtering the data to display the desired account. Quick Launch codes can be found in the help documentation.

The following maintenance records can be launched through the Quick Launch field:

• AP Vendor
• BP Permit
• BT Business
• FA Class
• FA Asset
• GL Account
• HR Applicant
• HR Employee
• HR Position
• HR Type
• IC Item
• LP Approval Type
• LP License
• PM Project
• PM Task
• PO Requisition
• PR Benefit
• PR Deduction
• PR Employee
• PR Pay Code
• PT Ticket
• SA Assessment
• SS Customer
• SS Lot
• UB Account
• UB Service Request
• WO Work Order

 

Active Toggle

The Active toggle has been added to a number of codes in the application in order to allow users to inactivate codes that are no longer in use. This change improves usability by reducing the time needed to sift through unused codes when searching. These codes will all be flagged as active by default. The codes affected by this change include:

• CR Category
• CR Type Code
• PM Project
• PM Task
• PM Task Group
• PM Type
• PM Misc

 

Query by Example Maintenance

The Query by Example Maintenance windows across the application have been enhanced to include the ability to Import and Export existing QBE reports.

The Export icon now includes a drop-down menu that allows user to choose either the previously-exiting Export Report option, which will export the selected report data to Excel, or the new Export Definition option, which will export the query, table, field and layout information as a report template. That report template can then be imported, using the new Import icon, and used by another organization.

 

Reports

Report windows across the application have been updated to allow users to export reports to Excel without the existing Springbrook formatting. The Excel (Formatted) option under the Print icon drop-down menu will export the formatted report, just like previous versions, producing an Excel report that uses existing Springbrook formatting. The Excel option under the Print icon drop-down menu will now export the report data to a spreadsheet without the Springbrook formatting. This enhancement was suggested by Springbrook users.

 

Error Logging

Application wide error logging functionality has been enhanced order to help Springbrook Support more efficiently investigate batch commit issues.

The authentication method for user logins on our online applications has been updated. Passwords for users of the online application suite will no longer be valid after an upgrade. Passwords can be reset in the Springbrook Application on an individual user basis or users can reset their password via the website.

 

Employee Self Service

Added the ability for users to enable or disable the Timeline, Awards, Work History, and Forms tabs on the ESS> Career page. These tabs can be enabled and disabled on SS> Web Application Setup> Employee Self Service> Page Access.

 

Updated the Employee Self Service W4 forecasting functionality to include the new W4 calculations mandated by the IRS. These calculations will rely on the new W4 fields added to the Taxes tab of the PR Employee Maintenance window.

1099s

The DBA (Doing Business As) field has been added to the Edit step of the 1099s process. This field allows users to view read-only DBA information about the 1099 recipient as entered on the AP Vendor Maintenance record.

 

The file generated in the Export step has been updated to meet various new state requirements. These updates include changes meant to meet new Iowa Code 19 and Oklahoma Code 40 reporting requirements.

 

The Settings step of the 1099s process has been enhanced to include the Misc, Int, G, and S Limit fields. These fields are used to specify individual limits for each of the 1099 types that could be included in the batch.

 

The Invoices step of the 1099s process has been enhanced to include the Vendor 1099 Type and Invoice 1099 Type fields. These fields are used to filter the 1099s by vendor and/or invoice 1099 types G, Int, Misc, and S. This field will default to All.

 

Computer Checks

Standard Springbrook Configurable Export functionality has been added to the Export step of the Computer Checks process. The new Configuration field is used to select a user-configured export file, which is created and maintained on the Export Configuration Maintenance window in the System Setup module. This enhancement allows users to create custom export file layouts for Positive Pay.

 

The Vouchers step has been updated to sort invoices by invoice number when a voucher includes multiple invoices.

 

The Print Vouchers step has been enhanced for clients set up to use NY Vouchers. The Print Vouchers report will now include the Check Date on the report.

 

Invoices

The Recurring Invoices process has been updated to improve general usability.

 

The Select All and Deselect All icons have been added to the Generate Recurring Invoices window. These icons allow users to select or deselect all of the displayed recurring invoices rather than requiring that users select them individually.

 

The Cycle field has been added to the Generate Recurring Invoices window. This field is used to filter the recurring invoices displayed in the data grid below by the cycle specified on the Recurring Invoice Maintenance window.

 

The Vendor Number column on the Generate Recurring Invoices window is now editable. This allows users to specify a vendor at the Generate step rather than requiring users to associate a vendor with each recurring invoice at the maintenance level. A vendor number MUST be specified for each recurring invoice before it can be processed, so vendor validation has been moved from the Recurring Invoices Maintenance window to the Generate Recurring Invoices window.

 

The Import step has been enhanced to include the option to import a standard AP Import Invoices configurable import file.

 

Recurring Invoice Maintenance

The Cycle and Home Department fields have been added to the Recurring Invoice Maintenance window. These fields are used to associate a cycle and a home department with a recurring invoice. These fields are related to the broader recurring invoices enhancements outlined above.

In a related change, users will no longer be required to specify a Vendor Number for a newly-created recurring invoice. This allows users to specify the vendor when generating the recurring invoices through the Invoices batch process.

 

Vendor Maintenance

The Sales Tax Rate field on the Details tab has been updated to handle five decimal places. This will allow users to specify more precise tax rates.

The Date From and Date To fields have been added to the AP History tab of the Vendor Maintenance window. These fields are used to filter the displayed AP vendor history by a specified date range.

 

Reports> Check Approval Report

Updated the Check Approval report to include the Fund option under the Sort By drop-down menu. This option allows users to sort and total the report by fund.

 

Reports> Detail by Account

The Detail by Account report has been enhanced to include the Subtotal for Department value at the bottom of each department when the report is set up to page break by department.

 

Reports> Outstanding Invoices Report

The Outstanding Invoices Report has been updated to include relevant voided invoices. The report will now include all voided invoices with a void date that falls after the To Date specified on the report. This will ensure all invoices in the system during the specified date range are included in the report.

 

Reports> Use Tax Report

The Local Tax Rate field has been updated to handle five decimal places. This change is related to the expansion of the Local Tax Percentage field on the AP Setup window.

 

Vouchers and Checks

The Vouchers and Checks process has been enhanced to include Check Number and Date data on printed vouchers.

 

Utilities> AP Setup

The Validation tab has been added to the AP Setup window. This tab was added to provide additional control when setting up validation rules in the AP module, such as granting one department the power to go over budget while another department is prevented from doing so.

In a related change, the Validation Behavior drop-down menu has been added and the Validate Variance and Maximum Variance Percentage fields have been removed from the Invoices tab.

 

The Local Tax Percentage field on the General tab has been updated to handle five decimal places. This will allow users to specify more precise tax rates.

 

Utilities> Vendor/Activity Export

The Vendor/Activity Export window has been added to the AP> Utilities palette. This window is used to generate an export file that includes either vendor master account information or cash disbursement activity information. These export files are designed to help organizations meet state auditing requirements.

 

Utilities> Import Vendor

Added the Import Vendor tool to AP> Utilities. This tool is used to import new AP vendor records via a user-configurable import file. This import file is configured in SS> Maintenance> Import Configuration.

Invoices> Import

The Import step has been added to the AR Invoices process. This step allows users to import AR invoice data via a user-configured import file.

 

Invoices> Proof List

The Invoices Proof List has been enhanced to include the Sort by drop-down menu. This field is used to sort the report by Invoice Number, Customer Name, or Account Number.

 

Reports> Aging

The Aging report has been enhanced to include the Report Type drop-down field. This field was added in order to allow users to choose the existing Summary report or the new, more comprehensive Detail report. This enhancement applies to the Aging report in the AR Past Dues process as well.

 

Reports> Balance by Date

The Balance by Date report has been added to the Accounts Receivable Reports palette. This is an audit report that provides a list of AR accounts with a balance by date based on the journal entry date, batch processing date, or transaction date.

 

Reports> AR Trial Balance Report

The Include Deposit Amount in Credits toggle has been added to the AR Trial Balance Report window. This toggle is used to include account deposits in the Unapplied Credits amount displayed on the report. When this toggle is checked, any Unapplied Credit that includes a deposit will be highlighted by an asterisk (*) in the Unapplied Credit column.

Clear Transactions

The interface between the Bank Reconciliation module and the Payroll module has been updated to prevent check records for direct deposits from being generated by more than one process in the application. Check records for direct deposits that were previously generated by the Clearing House module Direct Deposits process will now be generated exclusively by the Payroll module Computer Checks process. Please see the PR Setup item below for more information on how those records will be created.

 

Standard Springbrook Configurable Import functionality has been added to the Import Transactions step of the Clear Transactions process. The new Configuration field is used to select a user-configured import file, which is created and maintained on the Import Configuration Maintenance window in the System Setup module.

 

Utilities> Undo Cleared Checks

The Undo Cleared Check window has been updated to provide improved usability and to more closely align with other Springbrook utilities.

 

Utilities> Enter Checks

The Enter Checks window has been enhanced to include the Void Date field. This field allows users to specify the void date when voiding checks.

Module Wide

Infractions functionality has been enhanced to include additional infraction issuance, tracking, and reporting options across BT processes. See the Business Maintenance and Report items below for more information.

 

Adjustments

The Adjustments process has been updated to allow users to reverse Business Tax prepayments. This will allow organizations that require business tax prepayments to reverse those prepayment transactions and generate matching credit transactions that will be applied towards the end-of-period tax total.

 

The Adjustments process has been enhanced to prevent users from adding a single account into multiple open batches. The Target Business Number field on the Edit step will now be validated against open Adjustments, Cash Receipts, Redistribute, and Refunds batches to ensure the specified account is not in another open batch.

 

Letters

The optional Export step has been added to the BT Letters process. This step allows users to generate a user-configurable data file that can then be provided to third-party form printers. By using a configurable export, organizations can create a range of export files to meet the needs of many different taxpayer types.

 

Business Maintenance

The Activity Range section has been added to the Tax Type tab of the BT Business Maintenance window. This section is used to specify an active range for the tax type. This allows users to set up the system to automatically deactivate one tax type when another tax type is set to be activated. Tax types that are not active will not display in the return entry process, reports or letters. This enhancement was suggested by Springbrook users.

 

The Details section of the History tab has been updated to allow users to collapse the section. This enhancement will allow users to hide individual transaction details and display much more transactional history.

 

The History tab of the Business Maintenance window has been enhanced with additional infraction functionality. The new Add Infraction icon is used to add an infraction to a selected return record. After clicking this icon, the user will need to specify an infraction type and save in order to update the business record. In a related change, the Infractions section of the History tab now allows users to close an infraction by entering the Date Closed for the infraction. The new Comment column can be used to specify why the infraction was closed.

 

The Reconciliation tab has been added to the Business Maintenance window. This tab displays read-only reconciliation transaction data associated with the selected business.

 

Fee Maintenance

Minimum Net Profit functionality has been added to the Business Tax module. This feature allows an organization to receive a prepayment for a future year’s tax return while processing the current year’s tax return. That prepayment will be recorded as revenue received in the current year.

 

The Fee Maintenance window has been updated to include the Fee to Discount field, which is used to specify the fee code that will be discounted when processing a business’s tax return. The window has also been updated to include the Discount Next Tax Year toggle, which is used to instruct the system to automatically apply that prepayment amount to the tax return for the next tax year.

 

Form Maintenance

The Business_MaskedFederalTaxID field has been added to the available merge fields on the BT Form Maintenance window. This field will populate with the Federal Tax ID number for the selected business, but it will only display the last four digits of the number for security purposes. The first three digits of the ID number will be obfuscated and replaced with asterisks. For example: ***4567

 

Holiday Maintenance

The Holiday Maintenance window has been added to the BT module. This window is used to set up a holiday calendar that will be used when the system calculates BT-related interest, penalties and due dates.

 

Tax Type Maintenance

The Credit Fee field has been added to the Tax Type Maintenance window. This allows users to apply different credit fees to each tax type, rather than specifying a single credit fee in BT Setup.

 

The Use Reconciliation Period and Reconciliation Period fields have been added to the Tax Type Maintenance window. These fields are used to set up the tax type to be used in the Reconciliation process outlined below. When a tax type is set up for the Reconciliation process, the last period in the schedule will automatically be set as the reconciliation period.

 

The Tax Type Maintenance window has also been updated with additional due date functionality. The Avoid Holiday Due Dates and Avoid Weekend Due Dates toggles are used to set the tax type to avoid due dates that fall on holidays and weekends when that tax type is included in a BT process that assigns due dates, applies interest and applies penalties. When these toggles are checked and a BT process assigns a due date that falls on a holiday or weekend, the system will automatically adjust that due date to the next business day.

 

Past Due

The Edit step of the Past Due process has been enhanced to include the Delete, Select All, and Select None icons. These icons are used to allow clients to remove individual or selected groups of records from the Past Dues batch.

 

Reconciliation

The Reconciliation batch process has been added to the Business Tax module. This process is used by organizations that collect tax returns throughout the year. When the final year-end tax return is calculated, this process will reconcile the year-end return with the returns collected throughout the year and generate an invoice or credit record if a variance is discovered.

 

Redistribute

The Redistribution process has been enhanced to include the ability to calculate and apply penalties and interest. The Calculate icon on the Edit step can be used to calculate penalties and/or interest based on the due date and transaction date associated with the selected invoice. This new functionality allows users to calculate penalty and interest amounts that were not calculated when the returns and payments were initially processed.

 

The Prepayment column was added to the line items data grid on the Edit Redistribution window. This column will display the prepayment amount that will be applied to a return as part of the Minimum Net Profit functionality outlined above.

 

Refunds

The Add New Refund icon has been added to the Edit step of the Refunds process. This icon can be used to generate an Adjustment that will be used as a refund. Additionally, a new customer may be added to this step which is used when generating a special refund in which the payee is different than the BT account holder.

 

Reports> Alerts

The Alerts report has been added to the BT Reports palette. This report provides a list of accounts associated with a filtered set of alert codes, tax type, and status. This report can also be used to display all the alerts associated with a specified account.

 

Reports> Comments

The Comments report has been added to the BT Reports palette. This report provides a list of accounts associated with a filtered set of comment codes, tax type, and status. This report can also be used to display all the comments associated with a specified account.

 

Reports> Delinquent Filers

The Delinquent Filers report has been added to the BT Reports palette. This report is used to provide information on accounts that are delinquent in filing the required taxes.

 

Reports> Infractions

The Infractions report has been added to the BT Reports palette. This report provides a list of infractions associated with business returns and invoices. Displayed infractions can be filtered by infraction type, tax type, status, transaction date, closed date, period, and year.

 

Reports> Tax Type Listing

The Tax Type Listing report has been added to the BT Reports palette. This report provides a list of businesses associated with specified tax types during a specified date range.

 

Reports> Top Returns

The Report Total has been added to the bottom of the Top Returns report. This value represents the total value of the Amount column.

 

Reports> Waived Penalty and Interest

The Waived Penalty and Interest report has been added to the BT Reports palette. This report is used to provide information on penalty and interest amounts that were adjusted off of a set of accounts for a specified date range.

 

Utilities> BT Setup

The Warning Threshold field has been added to the Settings tab of the BT Setup window. This field is used to warn users when entering a BT Return receipt date that falls outside of the specified number of days before or after the current date.

 

The Credit Fee field has been relocated from the BT Setup window to the Tax Type Maintenance window. This change allows users to apply credit fees at the tax type level rather than module wide.

Contractor Listing Report

The Contractor Listing Report has been enhanced to include contractor phone number data. The Phone field has been added to the second column of the report and will display the business phone number associated with any included contractor.

Credit Card Terminal Functionality

The Cash Receipts module has been enhanced for this release to include credit card terminal functionality. Users can now use a point-of-sale credit card reader to process credit card payments directly in Cash Receipts. This functionality is designed to work with CivicPay, Springbrook's payment processing solution. Please contact Springbrook Support for more information on how to enable this functionality.

This enhancement includes updates to a number of CR windows, as outlined below.

 

Cash Receipts

The Cash Entry window has been updated to include the Pay with Terminal button, allowing users to generate a credit card terminal payment for the current receipt. This button will only be displayed if the user's station has been set up to use a credit card terminal. Users can also use the CTRL+T hotkey to create a terminal payment.

The Cash Receipts process has also been enhanced to allow users to add multiple UB accounts to a single cash receipt. This enhancement is designed to improve user workflows. Users can add multiple UB accounts to a receipt via the Add UB Accounts with Amount option under the Create New button drop-down menu on the Cash Entry window. This will open the Account Selection window.

 

The Account Selection window is used to filter UB accounts by customer information, to select multiple UB accounts to include on the receipt, and to specify how much to pay on each account. Users can search and select multiple times without overwriting the previously selected accounts. If an account is selected more than once, it will only be included on the receipt once and an alert will display for the user.

 

A Deleted UB Account Alert has been added to the Import Receipts and Receipts steps of the Cash Receipts process. This alert will warn users when they have imported or selected a Utility Billing account that is in Delete status. Users will still be able to make a payment against the account, but they will need to confirm their choice by clicking through the alert message before processing the receipt. This enhancement was suggested by Springbrook users.

 

The Import Receipts step has been enhanced to include Customer First Name and Customer Last Name data on imported receipts that do not include the Customer Number. This applies to miscellaneous CR receipts imported via user-configurable layout.

 

The Import Receipts window has been updated to include the Use record pay method toggle. When checked, this toggle will direct the system to ignore the pay method selected on the Import Receipts window and to instead use the pay method associated with the imported receipts.

 

The Create one receipt for all lines in file toggle has been added to the Import Receipts window. This toggle is used to allow users to import all the individual lines in the import file into a single receipt.

 

The Import Receipts validation parameters have been enhanced to allow users to import negative value receipts via configurable import when the Cash Receipts module is set up to allow negative amount receipts in CR> Utilities> Setup. Configurable import files were previously excluded from this functionality.

 

CR Receipt Alert functionality has been expanded to the Return Entry step of the Cash Receipts process. Alerts that were previously set up to display when a BT Business was added to a CR receipt will now also display when that business is added to a return. These CR Receipt alerts are set up on the Alerts tab of the BT Business Maintenance window. This enhancement was suggested by Springbrook users.

 

The Republic Bank PR option has been added to the Format drop-down menu on the Import Returns window. This import format generates a BT Return that omits units. The return value will equal the payment value included in the file and the return will be paid off immediately.

 

GL Cash Account Override functionality has been added to the Cash Receipts process. This allows users to override a cash account based on the selected pay method when processing Cash Receipts. This functionality is often employed by organizations that use a different cash account to track credit card payments. This enhancement was suggested by Springbrook users.

 

Drill-down functionality has been added to the Business Number column of the Select Return data grid. Users can now open the BT business master account by click the business number hyperlink.

 

The Prepayment column was added to the line items data grid on the Edit Returns window. This column will display the prepayment amount that will be applied to a return as part of the Minimum Net Profit functionality outlined in the Business Tax section above.

 

The Cash Receipts Proof List has been enhanced to offer additional error reporting. Users can now view detailed proof list error reports in the jobs viewer.

 

Pay Method Maintenance

The Cash GL Override field has been added to the Pay Method Maintenance window. This field allows users to specify an override account to be used when the pay method is selected on a receipt. This enhancement was suggested by Springbrook users.

 

Slip Maintenance

The Slip Maintenance window has been updated to include new and renamed merge fields to support new credit card terminal payment functionality. The Payment Provider (previously Web Provider), Payment ID (previously Web Transaction ID), and All Payments & Reference merge fields are now available when configuring a Cash Receipts slip.

 

Station Maintenance

The Station Maintenance window has been updated to include the Terminal IP Address and Terminal Port fields. These fields are used to set up a POS credit card terminal for the station. Once these fields have been populated, you can click the Credit Card Terminal button to test the connection.

 

Utilities> Activity Details

The Activity Details Export window has been added to the CR> Utilities palette. This window is used to generate an export file that includes CR activity information related to revenues received by the organization. This export file is designed to help organizations meet state auditing requirements.

 

Utilities> Setup

The CR Setup window has been updated to include the CivicPay Pad tab. This tab is used to activate and set up the interface between a CivicPay Pad credit card terminal and the Cash Receipts module. These settings should be configured when CivicPay Pad is implemented.

Electronic AP Proof List

The Electronic AP Proof List has been enhanced to include the Sort By drop-down menu. This field is used to sort the proof list by Vendor Name or Vendor Number.

 

Electronic AP Export ASCII File

The Export ASCII File step has been enhanced to include the Send Account Number in Company discretionary data field toggle. This toggle is used to include the bank account number in place of the company discretionary data in the header row of the export file.

 

Electronic AP Send Notification

The Electronic AP notification email has been enhanced to include the Vendor Account Number in the email header and the Invoice Description for each invoice included in the email details.

Reports

The Reports palette has been added to the Extended Budgeting module and the Extended Budgeting Report has been added to the Reports palette. This new report is used to report on EB budgets and entries.

Adjustments

The Major Repair adjustment type has been added to the FA Adjustments process. This adjustment type allows users to easily adjust values after major repairs are made on depreciating assets. This feature is meant to simplify the process when adding repair value to an asset.

 

Fixed Asset Maintenance

The Value tab has been added to the Fixed Asset Maintenance window. This tab displays a graphical representation of the depreciation and major repair value changes associated with the asset.

Budget Adjustments

The Import step has been added to the Budget Adjustments process. This step allows users to import budget adjustments via a user-configured import.

 

Governor’s Export

The Governor’s Export process has been added to the GL Module. This process is used by Kentucky clients to submit quarterly financial data files, per state requirements.

 

Multi-year Budgeting

The GL Module has been enhanced to include the Multi-year Budgeting functionality that existed in Springbrook V6. This will allow organizations to group accounts together and specify the length of the budget for that group of accounts. These budget groups are often used for capital projects that have multi-year budgets that are not rolled over at the end of the fiscal year. Please see the GL items below for more information.

 

Journal Entries

The Configuration field has been added to the Import step of the Journal Entries process. This field is used to select a user-configurable KVS import file, which is created and maintained on the Import Configuration Maintenance window in the System Setup module. This allows KVS clients to import the native KVS Journal Entry Export file.

 

The General Ledger module has been enhanced to enable interfund transfer functionality. The Edit Journal Entries window has been updated to include the Interfund Balance Transfer option under the Balance button. When selected, this will direct the system to automatically create balancing entries for cash-related line items after balancing the journal entry by fund.

 

The Journal Entries process has been enhanced to include Work Flow functionality. The optional Generate Work Flows and Review Work Flows steps will allow users to set up work flows controlling things such as notifications and approval requests when processing a Journal Entries batch.

 

The Journal Entries Proof List has been enhanced to display the full Description field for any accounts included in the report.

 

Budget Group Maintenance

The Budget Group Maintenance window has been added to the GL Maintenance palette. This window is used to create groups of GL accounts that share budget terms.

 

Chart of Accounts Maintenance

Tag security has been added to the Chart of Accounts Maintenance window. This enhanced security feature will prevent users or user groups from creating transactions on accounts that they do not have access to. This improved security paradigm replaces the GL Chart Security system used previously and will reduce the effort required to secure the Chart of Accounts.

 

The Budget Group field has been added to the General tab of the Chart of Accounts Maintenance window. This field is used to assign the account to a budget group.

 

Query by Example

Budget Group data has been added to the available fields under the GL Chart table in the Query by Example report.

 

Query Manager

The Budget Group column has been added to the Available Columns section of the Columns tab. When selected, the report will include a column that displays the budget group for each account included in the report.

 

The Budget Group field has been added to the Filters tab. This field is used to filter the accounts included in the report by budget group.

 

Trial Balance by Period

The Trial Balance by Period report has been enhanced to include the Include non-budgetable account toggle. This enhancement improves the functionality of the report by allowing users to report on accounts that are not marked as budgetable on the Chart of Accounts Maintenance window.

 

Utilities> Audit Data Export

Added the Audit Data Export tool to provide users with a method for exporting GL data for state auditing purposes. This tool generates a set of CSV files that can be submitted through state auditing processes. The tool will generate an export file for each of the following tables:

• Table: gl_acct_1, Filter: Fiscal Year
• Table: gl_acct_2, Filter: Fiscal Year
• Table: gl_acct_3, Filter: Fiscal Year
• Table: gl_account_type, Filter: All data in table
• Table: gl_chart, Filter: Fiscal Year
• Table: gl_history, Filter: Fiscal Year
• Table: pr_employee, Filter: All data in table
  • Exclude SSN from pr_employee export
• Table: pr_history, Filter: Batch Year
• Table: pr_deduction, Filter: All data in table
• Table: pr_pay_type, Filter: All data in table
• Table: ap_vendor, Filter: All data in table
  • Exclude account_no, fed_tax_id, state_tax_id, and other_tax_id from ap_vendor export.
• Table: ap_history, Filter: Expense Fiscal Year *or* Check Fiscal Year
• Table: cr_line_item, Filter: Batch Year
• Table: cr_receipt, Filter: Batch Year
• Table: cr_receipt_payment, Batch Year

 

Utah Transparency> Export

The Export step of the Utah Transparency process has been updated to display an Export Message window. This window provides a summary of the data included in the export file and can be used to verify that the exported file meets state requirements.

Personnel Action Forms> PAF

The PAF display window has been enhanced to include the misc user_ fields and their user-defined field labels to the available fields in the PAF data grid. These include user_character 1-6, user_integer 1-2, user_decimal 1-4, user_date 1-4, and user_logical 1-2.

 

The PAF display window has also been enhanced to allow grouping in the data grid.

Inventory Control - API Interface

The IC - API Interface has been added to the application. This interface will allow organizations to use third-party handheld scanners when managing inventory processes in the application.

 

Reorders> Generate

The Generate step of the IC Reorders process has been enhanced to include the Items with single vendor populate vendor information toggle. This toggle has been added in order to ensure single vendor data is automatically pulled into the batch when the IC item being reordered has a Last Price value of $0.00.

 

IC Setup

The Date Tolerance field has been updated to expand the date tolerance warning functionality. Users will now receive a warning message in the Inventory Transactions process when entering a past date that exceeds the Date Tolerance value, which is the previously existing functionality, as well as when entering a future date that exceeds the Date Tolerance value.

Form Maintenance

The Form Maintenance window has been enhanced to include additional Word merge fields. LP Word merge forms can now include:

• License_Type_Description – the description for the license type on the license
• License_FeeTotal – the total value of the fees in the fees collection
• Fees_BatchCurrentCharges_xxx – the collection of fees in the current batch
• All contact data associated with the licensed business (License Maintenance> Contact tab)
  • Contacts_SectionStart – the beginning of the contacts section
  • Contacts_XXX – any contact data that should be included
  • Contacts_SectionEnd – the end of the contacts section

 

Utilities

Added the Rebalance Licenses tool that allows users to rebalance LP licenses.

1099-Rs> Export

The Export step has been added to the 1099-Rs process in order to allow organizations to file 1099-Rs electronically. Only organizations that generate more 100 1099-R records are required to file electronically.

 

Updated the 1099-R process to include Date of Payment information now required by the IRS. Users can now use the Date of Payment field on the Edit step to specify the date payment was made for reportable death benefits on the 1099-R. That date will be displayed on the last line of the printed 1099-R form and will be included in the 1099-R export file.

 

Accrual Adjustments

Bonus Accruals functionality has been added to the Accrual Adjustments process. This functionality allows users to automatically apply accrual adjustments to an account based on the transactions associated with another accrual. Please see the Accrual Maintenance item below for more information.

 

Computer Checks

The Bonus Accruals tab has been added to the Generate step of the Computer Checks process. This tab is used to set up any bonus accruals that could be applied in the batch. Please see the Accrual Maintenance item below for more information.

 

Added the Report Type drop-down field to the Checks Proof List window. This field allows users to generate the standard Summary report or to generate the Details with Codes report that includes pay, benefit and deduction code information for the included checks.

 

Standard Springbrook Configurable Export functionality has been added to the Positive Pay step of the Computer Checks process. The new Configuration field is used to select a user-configured export file, which is created and maintained on the Export Configuration Maintenance window in the System Setup module.

 

The Process Salary Adjustments toggle has been added to the Import Timecards window. This toggle is used to flag all the timecards included in the import file as salary adjustments. The system will then generate an additional timecard line item adjustment for each included employee if the timecard hours do not match the hours specified on the employee record.

 

Added the Page break by department toggle to the Timecard Proof List to enable users to generate the report with a page break between each included department.

 

Accrual Maintenance

The Bonus Accrual Code, Bonus Amount and Qualifying Amount fields have been added to the Accrual Maintenance window in order to enable Bonus Accruals functionality. This functionality allows organizations to award additional accruals to employees based on the usage of other accruals. For example, an employee might be awarded additional vacation time if the sick leave time they used during a specified period falls below a specified threshold.

The Bonus Accrual Code field is used to specify the accrual that will be awarded to the employee. The Bonus Amount field is used to specify the amount of bonus accrual that will be awarded if the employee’s usage of the current accrual is less than or equal to the Qualifying Amount value.

 

Aggregate Deduction Maintenance

The Aggregate Deduction Maintenance window has been added to the Maintenance palette. This window is used to create and maintain groups of aggregate deductions that will share annual and lifetime maximums, such as IRA contributions. These aggregate deductions can be set up so that the individual deductions included in the aggregate can be processed in any order desired.

 

Deduction Maintenance

The Order and Aggregate Code fields have been added to the General tab of the Deduction/Benefit Maintenance window. The Order field is used to determine the order in which the deduction will be processed when it is included in an aggregate deduction. The Aggregate Code field is used to assign the deduction to an aggregate code.

 

The MATRS and MATRT deductions have been added to the Deduction Maintenance window. These deductions are used in the Massachusetts Teacher’s Retirement process.

 

Employee Maintenance

The Confidential toggle has been added to the General tab of the Employee Maintenance window. This toggle will allow users to incorporate the Confidential tag in QBE reports or other custom local reports.

 

The Taxes tab of the Employee Maintenance window has been enhanced to include a number of new fields. The Dependent Dollar Amount, Other Income, Deductions, and Extra Withholding fields, as well as the Multiple Jobs and Use Updated W4 Calculations toggles, were added to meet new IRS requirements.

 

The Retirement tab of the Employee Maintenance window has been enhanced for New York clients in order to meet new New York state retirement requirements. The following fields are now available:

• Employment Instance (string)
• Status (bool) HR Trans Type (string)
• PT - FT Annual Pay Rate (decimal)
• Class (string) Retired (bool)
• Status Change Date Job Code (string)
• Regular/Temp (string)
• Retired Systems (string)

 

Pay Code Maintenance

Added the Override Fed W/H% and the Override State W/H% fields to the Advanced tab in order to provide more control over withholding percentages on one-time pay codes.

 

Query by Example Maintenance

The PR QBE report has been enhanced to include additional fields in the PR Employee Table. Users can now select the First Name, Middle Name, Last Name, Address 1, and Address 2 data fields when building a QBE report that includes the PR Employee Table.

 

Tax Table Maintenance

Tax table revision functionality has been added to the PR Tax Table Maintenance window. Users can now create tax table revisions on the General tab of the Tax Table Maintenance window. This tab will now display revision-specific details and tax rates. This enhancement will allow state-specific automatic updates that can be delivered via service pack.

 

The Revision Details section of the Tax Table Maintenance window has been enhanced to include the Round to nearest dollar toggle. When checked, this toggle will round the calculations for the selected tax revision up or down to the nearest dollar.

 

Time Off Approval Maintenance

The PR Vacation Approval window has been renamed the PR Time Off Approval window in order to more accurately reflect the terminology used by client organizations.

 

The Standard Deduction field has been added to the Revision Details section of the Tax Table Maintenance window. This field is used to enter the amount used in the new 2020 W-4 calculations IF the employee does not check the Multiple Jobs box in Step 2 of the W-4 process.

 

Manual Checks

Added the Report Type drop-down field to the Checks Proof List window. This field allows users to generate the standard Summary report or to generate the Details with Codes report that includes pay, benefit and deduction code information for the included checks.

 

PR> Multiple Worksites

The Multiple Worksites batch process has been added to the Payroll module. This process is used to report on employee quarterly wage data sorted by worksite or department. This process is also used to generate the Quarterly Census of Employment and Wages export file required by the Department of Labor.

 

Accrual Calendar

The Print Options section of the PR Accrual Calendar window has been updated to use “Time Off” in place of “Vacation” in order to more accurately reflect the terminology used by client organizations. The Data Source section will now include the Time Off Requests option and the Time Off Date From and Time Off Date To field labels have been updated.

 

Aggregate Deduction Order

The Aggregate Deduction Order window has been added to the Utilities palette. This window is used to set and display the deduction order for aggregate deductions.

 

Detail Distribution Report

The Detail Distribution report has been enhanced to include new filter options. Users can now filter the report by ALFRE, Fiscal Year, Account To, and Account From. Users can also use the new Page Break by Fund option to configure how the report is printed.

 

Deduction Register Report

The Show Fund Info toggle has been added to the Deduction Register report. This toggle is used to generate the report with report data grouped and totaled by Fund.

 

General Wage Report

The General Wage Report has been enhanced to include the Other option in the Subject Wages drop-down menu.

 

General Wage Export

The General Wage Export was added to PR Reports. This export is used to create a .csv export file that includes much of the information on the General Wage report. This export is designed to meet additional state-specific reporting requirements.

 

Pay Type Register Report

The Reporting Group field, Include Only Part-Time Employees toggle, and Exclude Void Checks toggle have been added to the Pay Type Register report. These enhancements provide additional filtering options for clients that need to report on this data.

 

Timecard Proof List

The Department and Pay Code fields have been added to the Timecard Proof List in order to allow users to generate the proof list for a specified set of departments and pay codes.

 

Retro Pay

Added the Report Type drop-down field to the Checks Proof List window. This field allows users to generate the standard Summary report or to generate the Details with Codes report that includes pay, benefit and deduction code information for the included checks.

 

Timesheets> Import Timesheets

The Import Timesheets tool has been added to the Timesheets palette. This tool is used to import timesheets via user-configurable import file.

 

Timesheets Approval> Timesheet Proof List

The Timesheet Proof List window has been updated to include the Show Timesheet Notes toggle. When this toggle is checked, the proof list report will display any notes entered on the timesheet during the Quick Time Entry step.

 

Utilities> PR Setup

The Create detail direct deposit records in BR toggle has replaced the Create uncommitted BR for Direct Deposit toggle on the Checks tab. When left unchecked, all direct deposits included in a committed Computer Checks batch will be sent to BR as a lump sum. When checked, all direct deposits included in a committed Computer Checks batch will be sent to BR as individual, detailed direct deposit records. This update is related to the BR Clear Transactions item described above.

 

Utilities> Rebalance Accruals

The Rebalance Accruals tool has been added to the Payroll module. This tool is used to apply accrual balance adjustments on individual employee records. This allows users to correct accrual issues by balancing accrual ending values for one period (current balance) with accrual beginning values for the next period (beginning balance).

 

Utilities> Federal Tax Table Update

The Federal Tax Table Update tool has been added to the Payroll module. This tool is used to update the existing FED Tax Table records to meet new IRS requirements.

 

Utilities> New York Multiple Job Codes

The New York Multiple Job Codes utility has been added in order to allow NY clients to quickly associate employees with job codes.

 

Utilities> New York New Employee Data Import

The New York New Employee Data Import utility has been added in order to allow NY clients to import and update SSN, NYSLRS, PERS, Employment Instance, and Job Code data.

 

Utilities> New York Reported Earnings Codes

The New York Reported Earnings Codes utility has been added to the Payroll module. This tool is used to create and maintain state-specific earnings codes for New York clients.

 

W-2s

The file generated in the Export step has been updated to meet various new state requirements. These updates include changes meant to meet new North Carolina RS record and Oklahoma RS and RV record reporting requirements.

 

Updated the Exceptions step of the W-2s process to include a new negative line item exception. This new exception will display when the batch includes an employee with a negative value line item. The exception will also provide the employee number and/or name so the user can address the issue and ensure that the exported W-2s file is not rejected by the SSA because of a negative line item.

 

Updated the printed W-2 form to meet updated IRS requirements. The Box 9 Verification Code field will now be grayed out on the generated W-2, as the IRS is no longer using this field.

 

State Reports

The Colorado Unemployment Export has been enhanced to include the Transmitter Contact, Transmitter Phone, and Transmitter Email fields in the Export Options.

 

The Florida Retirement Export has been enhanced to include an indicator that the employee record is confidential or elected/appointed.

 

The Illinois Quarterly Filing export tool has been added to the Payroll module in order to allow Illinois users to export quarterly wage and withholding dollar amounts per Illinois state requirements. This export file will include the employee name, employee SSN, wages value, and withholding value for the specified quarter.

 

The Illinois Treasurer’s Report has been updated to improve clarity. The fund aggregate labels on the generated report have been relabeled “Beginning Fund Balance” and “Ending Fund Balance”.

 

The Kansas Retirement process has been added to the Payroll module. This process is designed to help Kansas clients generate state-required monthly retirement data.

 

The Massachusetts Town Retirement process has been added to PR module. This process is used to report on the earnings and retirement contributions of Massachusetts town employees.

 

The Minnesota Unemployment report has been enhanced to include the Exclude Rate Code Hours toggle. This toggle will allow users to exclude hours associated with a rate code on a history line that also includes a pay code. When this toggle is not checked, all hours will be included as with previous functionality.

 

The NH Retirement Export report has been added to the State Reports palette.

 

The NY State VDC Retirement process has been added to the PR module. This process is used to report on the New York Voluntary Defined Contribution program.

 

The NY Employee Master Listing and NY Payroll Activities exports have been added to the PR State Reports palette. These exports are part of the NYS Auditor reports required by the State of New York.

 

The NY Retirement Update Export tool has been enhanced to include an Export Type field that allows users to export Biographical Data Only, Job Status Change Only, or Biographical and Job Status data.

 

The NY Retirement process has been upgraded to include Enhanced Reporting functionality. This upgrade is designed to meet new state requirements:

The Generate step has been upgraded to include the Enhanced Reporting toggle in order to allow clients to report data for each employee totaled by specific Reporting Earnings Codes.

The Edit step has been upgraded to include additional data grid columns to display the data generated when the batch is set up to use Enhanced Reporting.

The Export step has been upgraded to include the additional data generated when the batch is set up to use Enhanced Reporting.

 

The Generate step of the Oregon Retirement process has been enhanced to include the Exclude Employees with no Retirement State toggle. This toggle is used to exclude any employee records that don’t include PERS data, per new Oregon state requirements.

 

The South Dakota Retirement process has been updated to generate a new file in the Export step. The file meets new export format requirements established by the state. The new export file has changed from a flat file to a comma delimited file and includes a number of small formatting updates.

 

The Washington Retirement process has been updated to reflect new state requirements. The Export file now displays additional retirement data, and that data also appears in the Washington version of the Retirement tab of the PR Employee Maintenance window.

 

The Washington Unemployment report has been updated with new formatting for export file. This update separates the employee name within the export file, per new Washington state requirements.

Query Manager Report

The Include detail lines with zero total amounts and zero hours toggle has been added to the PM Query Manager Report. When this toggle is checked, the report will function as it currently does and include all zero total amounts and zero total hours line items. By default, this toggle will be unchecked in order to exclude these line items and improve the general readability of the report.

Change Orders

The Tax Rate field on the Change Orders window has been updated to handle five decimal places. This will allow users to specify more precise tax rates.

 

The Change Orders batch process has been enhanced to improve usability. Clients can now use the CTRL and SHIFT keys to multi-select purchase orders during the Add/Remove Orders step. This multi-select process can also be used in the Change Orders step to select and close multiple purchase orders at once.

 

The Change Orders step has been enhanced to provide users with the ability to specify a purchase order closure date. When one or more purchase orders is selected and the Close all lines in the selected purchase order button is clicked, the Confirm PO Close Date window will open and a close date can be specified.

 

Recurring Purchase Orders Maintenance

The Recurring Purchase Orders Maintenance window has been added to the PO module. This window allows users to create a purchase order template that can then be used when frequently generating a purchase order that requires the same information be specified each time.

 

Purchase Orders

The Generate from Recurring icon has been added to the Purchase Orders step of the Purchase Orders process. This icon is used to generate a new purchase order based on a previously configured template saved on the Recurring Purchase Orders Maintenance window. While the newly created purchase order will automatically populate with the information specified on the template, that information can be edited before processing the purchase order.

 

The Tax Rate field on the Purchase Orders window has been updated to handle five decimal places. This will allow users to specify more precise tax rates.

 

The PO Purchase Orders step has been enhanced to improve efficiency when working with Inventory Control items. When an IC item is pulled into a PO line item, the IC Product Code and IC Item Description values associated with the item will automatically populate the Line Item Product Code and Description fields on the new purchase order line item.

 

The Purchase Orders batch process has been enhanced to improve usability. Clients can now use the CTRL and SHIFT keys to use multi-select functionality on the Purchase Orders step to select and close multiple purchase orders at once.

 

The Purchase Orders step has been enhanced to provide users with the ability to specify a purchase order closure date. When one or more purchase orders is selected and the Close all lines in the selected purchase order button is clicked, the Confirm PO Close Date window will open and a close date can be specified.

 

Purchase Order Statements

The Purchase Order Statement report has been enhanced to include the PO Item ID and Description for each PO line item group included in the report. This change also updates the Purchase Order report generated from the Purchase Orders process, the Change Orders process, and AP Vendor Maintenance.

 

Utilities> PO Setup

The Validation tab has been added to the PO Setup window. This tab was added to provide additional control when setting up validation rules in the PO module, such as granting one department the power to go over budget while another department is prevented from doing so.

Forms Maintenance

The PT Forms Maintenance window has been enhanced to include a number of new merge field options. These new merge fields allow users to include Fee data in PT Forms in the Collections, Excessive Tickets, and Past Dues processes. The new merge fields include:

• Penalties - the calculated penalty amount (this calculation will differ by process)
• Fees_XXX - various fees merge fields used to display data such as types, codes, descriptions, and amounts

 

Parking Tickets Maintenance

The Citation Date From and Citation Date To fields have been added to the Search Criteria section of the Parking Ticket Selection window. These fields are used to filter the tickets displayed in the data grid below by the specified citation dates.

Customer Maintenance

UB Account Designators displayed in the Accounts section of the Customer Selection window have been enhanced to improve clarity. Those designators will now be spelled out rather than displayed as single characters. “R” will be replaced with “Resident”, “O” will be replaced with “Owner”, and “B” will be replaced with “Bill To”.

The Confidential toggle has been added to the Customer tab of the Customer Maintenance window. This toggle will allow users to incorporate the Confidential tag in QBE reports or other custom local reports.

 

Export Configuration Maintenance

The Sorts tab has been added to the Export Configuration Maintenance window. This tab is used to set up sort properties, orders, and directions on export configurations. These sort properties will then be used to sort related export configurations, improving the user’s ability to quickly find and select the desired configuration.

 

The UB > Accounts option has been added to the available export configurations in the Definition field on the Export Configuration window. This option is used to configure the account export file used to export UB account data in the UB> Utilities> Account Export tool.

 

The Positive Pay option has been added to the available export configurations in the Definition field on the Export Configuration window. This option is used to configure the positive pay export file used in the AP Computer Checks Export step and the optional Positive Pay step of the PR Computer Checks process.

 

The Properties tab has been updated to allow users to export the same item in the Available Properties section more than once. This allows users to create export files that include the same data in multiple columns.

 

Constants functionality has been added to the Properties tab of the Export Configuration Maintenance window. This feature allows users to add a constant value to exported files, such as a bank code on a positive pay file or a city code on a meter reading file.

 

The Payee Name property has been added to the Available Properties section of the Properties tab on Positive Pay export configurations. This property utilizes conditional formatting in the Format field, allowing users to customize how payee name data will be displayed on the exported file.

 

The Mapping tab of the Export Configuration Maintenance window has been enhanced to allow the mapping of non-string items. This feature provides additional flexibility when mapping exported data to the desired values.

 

The UB Collections configurable export has been updated to include the Account Number Formattable field in the available properties.

 

The Export Configuration Maintenance window has been updated to include additional export file properties for the UB > Meter Readings > Export Meter Data export definition:

• Owner fields which pull data from the customer record associated with the lot where the meter is installed

• Account Number Formattable

• Cons Divisor

• Reading Divisor

 

The Account Balance, Service Address, Current Date Time, and Tax Lot fields have been added to the Available Fields section of the Properties tab for the UB Account Export Configuration.

 

The UB Meter Readings export configuration has been enhanced to include additional options. The Properties field on the Settings tab will now include a number of new fields, including the full range of fields from the Miscellaneous tab on the UB Device Maintenance window. The newly available fields include:

• ub_device.char_misc_4
• ub_device.int_misc_3
• ub_device.int_misc_4
• ub_device.dec_misc_1
• ub_device.dec_misc_2
• ub_device.dec_misc_3
• ub_device.dec_misc_4
• ub_device.date_misc_1
• ub_device.date_misc_2
• ub_device.date_misc_3
• ub_device.date_misc_4
• ub_device.log_misc_1
• ub_device.log_misc_2
• ub_device.log_misc_3
• ub_device.log_misc_4

• Account Number Formattable

• Cons Divisor

• Cons Multiplier

• Reading Divisor

• Reading Multiplier

 

The UB Meter Reading Export Configuration has been enhanced to include the Raw Device Size field in the available fields on the Properties tab.

 

The Export Configuration Maintenance window has been enhanced to include "noQuote" functionality in the Format field on delimited export properties. When "noQuote" is entered into the Format field, the export property will not include quotes when the data string is included in the export file.

 

The UB> Export Assistance Accounts export option has been added to the available export configurations in the Definition field on the Export Configuration window. This export file configuration is used to export accounts for the UB assistance program.

 

Import Configuration Maintenance

The BR > Clear Transactions option has been added to the available import configurations in the Definition field on the Import Configuration window. This import file configuration is used to import Bank Reconciliation data into the BR Clear Transactions process.

 

The GL > Journal Entries and SS > Lot options have been added to the list of available configuration definitions on the Import Configuration Maintenance window. Both of these configuration can be customized to meet the specific needs of individual organizations. For example, the GL > Journal Entries definition can be used by KVS clients to import the native KVS Journal Entry Export file.

 

The UB > Meter Readings import configuration has been enhanced to allow users to create configurable layouts that can import readings via Device Serial Number.

 

The UB> Meter Management> Reading Import process will evaluate imported device serial number data and compare that data to active device connection data before processing the imported meter reading.

 

The Import Configuration Maintenance window has been enhanced to include the Link ID field in the available properties for the CR> Cash Receipts> Import Receipts import configuration. This field has been added in order to allow users to more accurately display imported multi-line receipts.

 

Import configurations have been enhanced to improve date import functionality. Previously, date formats were required to be in either the MMDDYY format or the MMDDYYYY format. This enhancement allows the system to recognize the other common date formats, such as YYYYMMDD or 19-Jan-01.

 

The Import Configuration maintenance window has been updated to include Pay Method as an available import property when creating a CR> Import Receipts import configuration. When this property is included in the import configuration, the pay methods associated with the imported receipts will overwrite any pay method specified on the Import Receipts step.

 

Added the AP> Utilities> Vendor Import option to the available Definitions on the Settings tab of the Import Configuration window. This import configuration definition is used to create a user-configured import file that can be used to import AP vendor records through the AP> Utilities> Import Vendors tool.

 

The Description field has been added to the available fields in the Properties window of the Settings tab. When the Description field is included in the import file, the value will populate the line item description when used for importing CR receipts and will populate the UB history description when importing UB receipts.

 

The GL > Budget Adjustments import configuration option has been added to the Definition drop-down menu on the Settings tab of the Import Configuration window. This option is used to create a user-configurable import file that can be used in the GL Budget Adjustments process.

 

The Import Configuration Maintenance window has been enhanced to include the Expressions tab. This tab allows users to create customized expressions, such as instructions for the application to skip certain lines, when processing an import file.

 

The PR> Timesheets import configuration option has been added to the Definition drop-down menu on the Settings tab of the Import Configuration window. This option is used to create a user-configured import file that can be used in the PR Timesheets Import process.

 

The AR> Invoices> Import option has been added to the available import configurations in the Definition field on the Import Configuration window. This import file configuration is used to import invoices into the AR Invoices process.

 

The PR> Computer Checks import configuration has been enhanced to include the full Debit Account and full Task Code fields in the available import file properties. The Debit Account field will display the full debit account that was previously only available when split into seven sections in the Debit Account 1 through Debit Account 7 fields. The Task Code field will display the full task code that was previously only available when split into two sections in the Task Code 1 and Task Code 2 fields.

 

The AP> Invoices> Import option has been added to the available import configurations in the Definition field on the Import Configuration window. This import file configuration is used to import invoices into the AP Invoices process.

 

The UB> Adjustments and Fees import configuration has been enhanced to include the Customer Number, Customer Sequence, and Description properties fields.

 

The UB> Assistance Accounts import option has been added to the available import configurations in the Definition field on the Import Configuration window. This import file configuration is used to import accounts for the UB assistance program.

 

The UB> Meter Change Out Import configuration has been enhanced to include the optional Reader Info property and the existing Register ID property has been updated to ensure it is no longer required for the configuration.

 

Lot Maintenance

The Alert tab has been added to the Lot Maintenance window. This tab will allow users to set up custom alert notifications that display when lot records are selected or edited from modules across the application. This enhancement was suggested by Springbrook users.

 

UB Account Designators displayed in the Accounts section of the Lot Selection window have been enhanced to improve clarity. Those designators will now be spelled out rather than displayed as single characters. “R” will be replaced with “Resident”, “O” will be replaced with “Owner”, and “B” will be replaced with “Bill To”.

 

The UB > Meter Change Out Import option has been added to the list of available configuration definitions on the Import Configuration Maintenance window. This import file configuration is used to import meter changeouts or updates in the UB > Meter Management > Meter Change Out Import window.

 

Report Layout Maintenance

The Report Layout Maintenance window has been enhanced to allow users to share existing configurable checks and report layouts. The Import icon has been added to the Report Layout Selection window. This icon is used to import an existing report layout. The Export icon has been added to the Report Layout Maintenance window. This icon is used to export an existing report layout.

 

The Report Layout Maintenance window has been enhanced to include a dollar sign ($) option. This option allows users to insert the dollar sign ($) to the immediate left of the Amount field on configurable checks, as required by some banks.

 

Security

The Security palette has been added to the System Wide Access module. This new palette has been added to the application in order to organize all the SS security features under one palette. The DB Security, GL Chart Security, Menu Security, PM Security, Role Maintenance, Tag Maintenance, User Maintenance and User Group Maintenance windows have been relocated from the SS Maintenance palette to the new SS Security palette. The Display Menu Security and Print User Permissions windows have been relocated from the SS Utilities palette to the new SS Security palette.

 

The security recalculation process has been updated to utilize the Job Scheduler in order to improve system performance. Updates to User and Group security settings will now generate a new scheduled job, thereby eliminating the heavy system resource usage previously encountered at the time of the change. This update also means that changes to these security settings will not take effect until that scheduled job is completed.

 

Tags

Tags have been updated with additional features to allow for handling GL Chart Security.

 

Utilities> Check Audit Display

Updated the Check Audit Display window to include the Miscellaneous Character 1 column for Wisconsin clients who need to report on WISSIS invoices.

 

Utilities> Lot Import

The Lot Import tool has been added to the Utilities palette. This tool is used to import a user-configurable file that includes a variety of lot details. These import file configurations are created and maintained on the Import Configuration Maintenance window in the System Setup module. Many clients will use this tool to import new lots and updates to existing lots for the purpose of GIS integration.

 

Utilities> My Reports

The Mark Selected Report as Read and Mark All Reports as Read icons have been added to the My Reports window. This functionality is designed to improve the usability of the My Reports window by giving users the ability to remove individual reports or all reports from the data grid.

 

SS> Statement Setup

The Display Deferred Amounts toggle has been added to the Billing Options tab of the UB Statement Setup window. When this toggle is checked, the billing statement will include the Deferred Amount for the current month and the Total Deferred Amount. This toggle is only enabled if the Budget billing amounts toggle is checked as well.

 

The Transfer Account tab has been enhanced to enable interfund transfers for additional modules. Users can now select the GL option under the System drop-down in the data grid to specify transfer accounts used to balance manual journal entries for cash-related line items processed through the Journal Entries process.

 

Web Application Setup> Employee Self Service

The Awards, Forms, Timeline, and Work History options have been added to the data grid on the Page Access tab of the Employee Self Service Setup window. Users can now enable or disable these options in order to determine which tabs display on the Careers page of the Employee Self Service online application.

 

The General tab of the Employee Self Service window has been updated to use “Time Off” in place of “Vacation” in order to more accurately reflect the terminology used by client organizations. The Time Off Approver field, Generate timesheet lines on time off approval toggle, and Notify department clerk on time off approval toggles have been updated to this new naming convention.

Utilities

Added the Rebalance Assessments tool that allows users to rebalance SA assessments.

Net Metering

Net Metering functionality has been added to the Utility Billing module. This allows organizations to bank consumption that the customer is providing back into the grid and credit that consumption at a later date. Additional details can be found in the items below.

 

Adjustments and Fees

GL Cash Account Override functionality has been added to the UB Adjustments and Fees process. This allows adjustments to UB accounts that were processed through Cash Receipts with an override cash account. This enhancement was suggested by Springbrook users.

 

The Redistribute Credit Balances process has been enhanced to exclude services that are set up to be excluded from redistribution on the Service Rates tab of the UB Account Maintenance window. This service exclusion is often required in energy assistance programs.

 

The Reset Net Meter Banks window has been added to the Adjustments and Fees palette. This Net Metering-related tool is used to credit banked solar credits to the eligible customer accounts and then to reset the banked solar credits associated with those accounts back to zero.

 

The Import step of the Adjustments and Fees process has been enhanced to allow for negative dollar amount imports. This new import capability provides clients with an additional method for applying credits to UB accounts in cases where a billing refund is required.

 

The Import step of the Adjustments and Fees process has been enhanced to include the Tran Date field and the Use Record Date toggle. These new options were added in order to proved additional date settings when importing adjustments.

 

Budget Billing

The Letters step has been added to the Budget Billing process in order to allow users to generate customized Microsoft Word-based form letters for budget billing customers.

 

Collections

The Cycles field has been added to the Generate step of the Collections process. This field is used to filter the accounts that will be included in the Collections batch by the billing cycle associated with those accounts.

 

Mass Credit Write-off functionality has been added to the UB Collections process. This process allows users to write-off credits that are not great enough to warrant a refund check. The Balance Type drop-down menu on the Collections> Generate step has been added in order to allow a collections batch to write off credits. When processing credit write-offs, the system will generate an adjustment transaction for any account that meets the filter criteria, has a negative account balance, and has no positive balance for any service.

 

The Due Date Prior or Equal To field has been added to the Generate step of the Collections process. This toggle is used to filter the accounts included in the batch by the due date on outstanding billings.

 

The Report Type field has been added to the Turnover Report window. This field is used to print either a Summary version or a Detail version of the report. The Summary version of the report is the same as the standard Turnover report available in previous versions. The Detail version of the report includes all of the data available in the Summary version of the report as well as Service, Service Code, Description, Tax Code, Fee Code, Group Code, and Amount.

 

The Group details by service group toggle has also been added to the Turnover Report window. This toggle is used to group transactions included in the detailed version of the report by the service group attached to the transaction.

 

The Export step has been added to the Collections process. This step is used to generate a user-configurable export file that includes the collections data from the batch. The export file has also been enhanced to include additional itemization details to meet new federal requirements. The file will now include the Itemization date, Balance as of itemization date, Interest and fees added since itemization date, and Payments since itemization date.

 

Final Billing

Deposit Refund functionality has been added to the Final Billing process. This process allows organizations to generate deposit refunds that can then be credited to the account or processed through the UB Refunds process so that an Accounts Payable check is generated. This enhancement was suggested by Springbrook users.

 

The Adjustments column has been added to the Final Billing Register report. This column will display refund amounts being applied and the related interest being calculated. This enhancement was suggested by Springbrook users.

 

Both New and Final Billing Statements have been updated to display budget billing details. When this feature is enabled in SS Statement Setup, the billing statements will display the budget billed amount that is due alongside the actual amount that would have been billed had the account not been set up for budget billing.

 

Tiered consumption data has been added to the Detail version of the Summary by Rate report. This data includes tier level number, tier billing amount, and total tier consumption.

 

The Include drop-down field has been added to the Export Addresses window. This field allows users to include or exclude statements in the batch based on the statements' hold status.

 

The Bill To Print drop-down menu has been added to the Statement Settings step of the Final Billing process. This field is used to select whether the UB Bill to Report will be printed to PDF or to Excel. For more information on the UB Bill to Report, please see the enhancement item above.

 

The Additional Date field has been added to the Statement Settings step of the Final Billing process. This field is used to include an additional, user-defined date on Final Billing statements. This field is enabled by specifying a value in the Additional Date Field Label field on the Billing Options tab of the UB Statement Setup window.

 

The Inline Quotes field has been added to the Export step of the Final Billing process. This field is used to how, or if, the export file will display quotation marks in included field values.

 

Account Maintenance

The Enrolled in Online Bills recurring payments toggle has been added to the General section of the Account tab. This is a read-only toggle that will only be checked if the account has been set up for recurring payments through the Online-Bills.com website. This enhancement was suggested by Springbrook users.

 

The Exclude from Redistribute toggle has been added to the data grid on the Service Rates tab. This toggle is used to exclude specific services from the redistribution process as is often required in energy assistance programs.

 

The Override the tax codes for this rate toggle has been added to the Service Rates tab of the Account Maintenance window. This toggle is used to specify an override tax code for the selected rate at the individual customer level. Once checked, the Add Tax Code to the Rate icon is enabled above and the user can select the tax code that will be the override code. This enhancement was suggested by Springbrook users.

 

The Calc Consumption column has been added to the Meter History sub-tab on the Devices tab of the Account Maintenance window. This column displays the multiplied or divided value of the consumption if there is a multiplier or divisor on associated with the device.

 

The Net Metering functionality-related Banked Cons column has been added to the Meter History sub-tab on the Devices tab of the Account Maintenance window. This column displays the consumption credits generated by any solar received meters attached to the account. This value will increase until it is credited back to the customer and reset.

 

The Account Comment report, accessible from the Comments tab of the Account Maintenance window, has been enhanced to include Customer Name, Phone Number, and Service Address data.

 

Final Account Wizard

Deposit Refund functionality has been added to the Final Account Wizard. This functionality allows organizations to generate deposit refunds that can then be credited to the account or processed through the UB Refunds process so that an Accounts Payable check is generated. This enhancement was suggested by Springbrook users.

 

Account History Report

Updated the Account History Report, accessible from the History tab of the Account Maintenance window, to include the Only display meter usage history toggle. When checked, the system will generate a meter usage report that excludes all other account history.

 

Device Maintenance

The Solar received meter toggle has been added to the Electric Meter tab of the Device Maintenance window. This toggle sets the current device to a Net Metering device. The consumption on a Net Metering device is used to track all the solar power generated on the account. This amount will then be credited during the next billing process or banked on the account so it can be credited in a later billing process.

 

The Calc Consumption column has been added to the Consumption tab of the Device Maintenance window. This column displays the multiplied or divided value of the consumption if there is a multiplier or divisor associated with the device.

 

The Net Metering functionality-related Banked Cons column has been added to the Consumption tab of the Device Maintenance window. This column displays the consumption credits generated by any solar received meters attached to the account. This value will increase until it is credited back to the customer and reset.

 

Device Type Maintenance

The MXU Type drop-down field has been added to the Device Type Maintenance window. This field is used to specify the MXU type associated with the meter, which enables organizations to export MXU and meter type data to third party meter software. In a related change, the Meter Types tab on the UB Setup window has been renamed Meter/MXU Types to more accurately reflect the data stored on that tab.

 

Device Type - Electric Maintenance

The Solar received meter toggle has been added to the Electric tab of the Device Type - Electric Maintenance window. This toggle is used to set up the Device Type to create Net Metering Electric devices. Please see the Device Maintenance item above for more information. This toggle is only enabled when the Electric Type field is set to KWH.

 

Forms Maintenance

Fields associated with the UB Budget Billing process have been added to the available Word Merge fields on the Forms Maintenance window. Forms that utilize these fields will be available in the new Letters step of the Budget Billing process.

 

Service Maintenance

The Service Group field has been added to the Service Maintenance window. This field is used to assign the selected service to a service group.

 

Service Group Maintenance

The Service Group Maintenance window has been added to the UB Maintenance palette. This window is used to create and maintain service groups.

 

Meter Management

The Meter Readings palette has been renamed the Meter Management palette. This name change is related to expanded meter read import and edit functionality. Through additional columns on the Edit window, users will now be able to identify and edit imported meters that were either unread or misread. The system will flag unread/misread meters based on the comparison details specified on the Device tab of the UB Setup window. These erroneous readings will display in red.

 

The Update step has been added to the Meter Management process. This window allows users to update the read date associated with one or more previously billed meter readings. This read date update to billed meter readings is limited to only the most recent billed meter reading. Prior billed meter readings cannot be edited.

 

The Meter Data Export tool has been added to the Meter Management palette. This tool provides support to organizations that utilize Advanced Meter Infrastructure (AMI) systems. Users can create configurable AMI exports in order to interface with a range of AMI system.

 

The Sensus Logic option has been added to the Layout field of the Readings Export window.

 

The Nsight 1 non-configurable export layout has been enhanced to include Device Size and Unit of Measure values and to include read date data for individual meter reads on the order status line of the file.

 

The Badger 4 export configuration has been added to the Meter Management Export options.

 

The Beacon 2 and 4 export configurations have been added to the Meter Management Export options.

 

The Neptune 360 Import and Export formats have been added to the Layout drop-down menu on the Readings Import and Readings Export windows.

 

The Meter Changeout Import tool has been added to the Meter Management palette. This tool is used to help organizations process a large group of meter change outs or meter updates.

 

The Meter Management process has been updated to allow users to import meter readings via UB device serial number. Users can now create a configurable import layout (SS> Maintenance> Import Configuration) that includes device serial number, meter reading, and read date. This update eliminates the need for custom meter reading import processes for those clients that import readings based only on device serial number.

 

The Meter Data Export tool has been enhanced to include a number of new available meter data fields. These fields are configured in SS Export Configuration Maintenance. The fields include:

• Reference No
• Customer Name
• Customer Address Care Of
• Last Bill Date
• Previous Consumption
• Second Previous Reading
• Second Previous Read Date
• Second Previous Consumption
• Account Connect Date

 

The Meter Readings Proof List has been enhanced to include the Primary Meter ID field and the Display all meter IDs toggle. The Primary Meter ID field is used to display the selected primary meter ID description in the report header with the ID value in the meter detail row below. The Display all meter IDs toggle is used to include the two primary meter IDs not selected in the Primary Meter ID field in a second meter detail row.

 

The Readings Export step of the Meter Management process has been enhanced to include the Send 0s for Read Sequence toggle. This toggle is only enabled for the Neptune 360 export configuration.

 

New Billing

The Adjustments column has been added to the New Billing Register report. This column will display refund amounts being applied and the related interest being calculated. This enhancement was suggested by Springbrook users.

 

Both New and Final Billing Statements have been updated to display budget billing details. When this feature is enabled in SS Statement Setup, the billing statements will display the budget billed amount that is due alongside the actual amount that would have been billed had the account not been set up for budget billing.

 

Water conservation data has been added to consumption graphs included on full-page billing statements. This data is used to provide detailed information about drought-related water use reduction targets to account holders. This data will display based on the configuration set up on the Statement Setup window.

 

Tiered consumption data has been added to the Detail version of the Summary by Rate report. This data includes tier level number, tier billing amount, and total tier consumption.

 

The Include drop-down field has been added to the Export Addresses window. This field allows users to include or exclude statements in the batch based on the statements' hold status.

 

The Bill To Print drop-down menu has been added to the Statement Settings step of the New Billing process. This field is used to select whether the UB Bill to Report will be printed to PDF or to Excel. For more information on the UB Bill to Report, please see the enhancement item above.

 

The Additional Date field has been added to the Statement Settings step of the New Billing process. This field is used to include an additional, user-defined date on New Billing statements. This field is enabled by specifying a value in the Additional Date Field Label field on the Billing Options tab of the UB Statement Setup window.

 

The Summary by Rate report in the UB New Billing process has been enhanced to include Actual Consumption values. In a related update, the Consumption column has been relabeled as the Billable Consumption column in order to clarify the difference between actual and billable consumption.

 

The Inline Quotes field has been added to the Export step of the New Billing process. This field is used to how, or if, the export file will display quotation marks in included field values.

 

Past Dues

The Generate step of the Past Due process has been enhanced to ignore any credits on UB services that are marked to Exclude from Redistribution. This will ensure that those specific credits are not applied to other services, thereby improperly preventing the system from flagging those services as past due.

 

The Waive Penalty Fee field has been added to the Generate step of the Past Due process. This field is used to set up the process to waive the first past due penalty fee on an account based on credit history or good standing status.

 

The Select/Update step has been updated to include additional functionality in the Select All and Deselect All icons. These icons now include drop-down menus that include options to select/deselect all items in the data grid for selection, print, or IVR.

 

The Shut Off option has been added to the Layout field on the Export Past Due window. This option is used to export relevant account shut off data.

 

The Include drop-down field has been added to the Export Addresses window. This field allows users to include or exclude statements in the batch based on the statements' hold status.

 

The Bill To Print drop-down menu has been added to the Statement Settings step of the Past Dues process. This field is used to select whether the UB Bill to Report will be printed to PDF or to Excel. For more information on the UB Bill to Report, please see the enhancement item above.

 

The Inline Quotes field has been added to the Export step of the Past Dues process. This field is used to how, or if, the export file will display quotation marks in included field values.

 

Refunds> Proof List

The UB Refunds Proof List window has been enhanced to include the Print Mailing Address toggle. When selected, this toggle will include Customer Mailing Address data in the report.

The report has also been updated to include both the first and last name in the new Customer Name column.

 

Refunds> Commit:

The Commit step of the UB Refunds process has been enhanced to generate more useful AP History records. The Description field associated with the AP History records generated in the Refunds process will now include customer number, customer sequence, and service address information.

 

Reports> Accounts by Tax Code Report

The Accounts by Tax Code report has been added to the UB Reports palette. This enhancement is related to the Override Tax Code option in the Account Maintenance item above. This report displays accounts and rate codes that have the tax override option selected. Exempt accounts will display in red.

 

Reports> Labels by Zip Code Report

The Labels by Zip Code Report has been enhanced to include the Print service address toggle. This toggle was added in order to allow users to print the service address associated with the lot rather than the standard address on the UB or customer account.

 

Reports> Payments by Past Due Report

The Payments by Past Due Report has been added to Utility Billing in order to report on payments made on UB past due accounts.

 

Reports> Top Users Report

The Top Users Report has been enhanced to improve report filtering capability. The report now includes a Service Rates field that allows clients to filter the accounts included in the report by the service rates attached to those accounts. The Calculate By drop-down field has also been enhanced to include the Calculated Consumption option in order to allow clients to report on top users when applying UB device consumption multipliers or consumption divisors to the consumption values.

 

Reports Consumption> Summary by Service Rate

Tiered consumption data has been added to the Detail version of the Summary by Service Rate report. This data includes tier level number, tier billing amount, and total tier consumption.

 

The Summary by Service Rate report has been enhanced to include the Batch Number field in the Print Options section. This field allows users to generate the report for a specific committed or uncommitted New Billing or Final Billing batch. When a specific batch is selected, the Cycle, Date Type, Date From, and Date To print options will be disabled.

 

Service Requests

The Service Requests process has been enhanced to include the Include Reference Number toggle. This toggle allows users to include the UB Account Reference Number on printed service requests.

 

The Request Code field on the Print Service Requests has been updated from a single request code field to a toggle field that displays all the request codes available in the system. This enhancement allows users to generate the Service Requests report for more than one request code at a time.

 

Utilities> Account Export

Configurable Export functionality has been added to the Account Export window. The Account Statuses and Configuration fields have been added to the window and the File Type field has been renamed Layout. The Account Statuses field is used to filter the accounts included in the export file by status. The Configuration field is used to which export file configuration to use when exporting the account data. A KVS-specific export configuration has also been added to the available configurations.

As a result of this enhancement, the Account Export process may require more network resources and should therefore be scheduled for non-business hours.

 

Utilities> Add/Remove Bill Tos

The Add/Remove Bill Tos tool has been added to the Utilities palette. Previously, user were required to update bill to records on each individual account. This tool is used to efficiently update bill to records en masse.

 

Utilities> Import Assistance Accounts and Export Assistance Accounts

The Import Assistance Accounts and Export Assistance Accounts tools have been added to the Utilities palette. The Import tool is used to enroll accounts in to or out of the UB category code-based assistance account program. The Export tool is used to export account, consumption, and billing data for accounts enrolled in the assistance program.

 

Utilities> UB Setup

The Comparison Method, Months for Average, and Variance Alert Percent fields have been added to the Device tab of the UB Setup window. These fields are used to specify if and how the system should compare current period meter readings to prior period meter readings in order to identify unread and misread meters.

 

The Automatically Fail Payment Plans Daily toggle has been added to the General tab of UB Setup window. When this toggle is checked, the system will roll through all active payment plans every night and automatically change the payment plan status to FAIL if the account holder has not met the payment plan requirements.

 

Utilities> Statement Setup

The Past Due Statement - 4 to a page option has been added to the available statements users can configure in UB Statement Setup. This past due statement allows users to print four postcard-sized past due statements on a single sheet. Organizations should consult state and local guidelines regarding past due notices before implementing 4 to a page past due statements.

 

The Adjustment Details toggle has been added to the Billing Options tab of the Statement Setup Maintenance window. This toggle is used to display additional adjustment information on the UB-Billing Statement. When toggled, each adjustment included in the billing period will be displayed on the billing statement next to the related adjustment description. This enhancement was suggested by Springbrook users.

 

The Budget billing amounts toggle has been added to the Billing Options tab of the Statement Setup Maintenance window. When this toggle is checked, new and final billing statements will include budget billing amounts alongside the actual billing amounts for the month.

 

Water conservation data has been added to the Consumption Graphs tab of the Billing Statement Setup Maintenance window. This feature allows organizations to provide detailed information about drought-related water use reduction targets on standard full-page billing statements.

 

The Additional Date Label field has been added to the Billing Options tab of the Statement Setup window. This field is used to specify a custom label for an optional, user-configured additional date field that can be displayed on standard billing statements in the New Billing and Final Billing processes.

 

The Exclude Payment Plan Details and Payment Plan Message fields have been added to the Billing Options tab of the Statement Setup window. The Excluded Payment Plan Details drop-down field is used to specify how standard billing statements generated in the New Billing or Final Billing processes will display payment plan details. When enabled, users can specify a more generic Payment Plan Message to display on the billing statements rather than the full payment plan details.

 

The Include Aged Balances on Statement toggle has been added to the Past Due options tab. When this toggle is checked, the generated Past Due statement will include a past dues table that displays past due balances that are 0-30-60-90-120+ days old.

 

The General tab of the Statement Setup window has been enhanced in order to improve clarity on billing and past due statements. If the Checks Payable To field is populated, the statements will continue to display the “MAKE CHECKS PAYABLE TO” message as usual. If the Checks Payable To field is not populated, the message will be suppressed, thereby simplifying the statements and improving clarity.

 

The Billing Options tab of the Statement Setup window has been enhanced to include the Period Dates as Meter Read Dates toggle. This toggle allows users to display read dates as the period dates at the top of the statement.

 

Water Allocation

A new premium Water Allocation batch import process has been created to allow California agencies to create allocation amounts for lots. The import file must be in .csv format. The first column is lot number, the next columns are periods 1-12. Up to 12 allocation amounts can be assigned to a lot. The period equals the reading period in the meter history. The allocation amount for a given period stays active indefinitely until it is modified to 0. If there are any exceptions to the import process, a message box will pop up with detail on import completion and the details are retrievable in the job scheduler. If there are no exceptions to the import process, no pop up will display and the batch process will advance to the edit step. The edit step will allow agencies to see all of the data that was processed through the import and to manually change any of the values. There is a proof list for verification and a final commit step.

 

Winter Averaging> Proof List

The UB Winter Averaging Proof List window has been enhanced to include the Include average for the date range toggle. When selected, the Detail version of the report will include a Date Range Average value and indicate which months or periods contribute to the Winter Average value.

Module Wide

The Work Orders module has been enhanced to integrate with Accela CRM. This enhancement will allow organizations that use both Springbrook and CRM to automatically generate Springbrook work orders through CRM issues.

 

Audit Data Report

The Audit Data Report has been enhanced to include additional filter criteria. Users will now be able to specify a range of fiscal years, to include time sheet notes, and to filter by Assigned To Type and Assigned To values.