Self-Serve Utilities - Overview

Overview

Updated 07/25/2022

This article serves as an overview of the available AQ utilities. Click the title of a utility to open its specific article.  The Self-Serve Utilities are available in version 17.1 and newer.

• Click here for information on Standard Reports
• Click here for information on Advanced Queries
• Click here for information on activating a Report or AQ

Import Templates
Utility Articles

Import Templates

Standard import templates are available for download at the bottom of this article. The spreadsheets are standard import templates useful with some of the utilities. At the bottom of this article, click an individual attachment to download it to your computer.

Utility Articles

Each link below opens an article dedicated to the specific utility. Each article contains description details, screenshots, and directions for use. 

Utility	Description
Add/Remove Super-User	This utility grants the super-user the ability to add or remove super-user access for other users in their current supplier. The Add or Remove option can be selected from the AQ’s parameters along with the username to be updated. This utility does not allow a user to grant themselves super-user access or remove permissions from their own user.
Insert Missing Employee Node	This utility allows a super-user to insert a missing branch for any employee who belongs to a branch to which the user also has access. Select the employee drop-down menu to display a list of employees without branches. The AQ allows the user to identify the record by name, EmployeeID, and SSN.
Next Available Check Number	This utility displays a maximum check number + 1 for each bank to which the the user has access. The user enters a bank from the drop-down menu and the AQ generates the next check number to be used.
Remove Global Cash Card Error	Allows the user to remove errors generated during the initial loading of a Global Cash Card. This utility only allows the removal of errors for the account type of “Global Cash Card.”
Remove Invoice Correction	This utility enables the removal of any invoice corrections in branches to which the user has access. This AQ also includes: run phases displaying what information will be updated or removed a table backup in the event the Support department has to restore any data afterward an option to remove associated payments to the invoice
Remove Invoice Merge Utility Invoice Merge article	In the event that you have performed an invoice merge in error, this tool can be used to undo the merge. This is useful as the Remove Invoice Correction tool does not unmerge invoices if there is no correction involved.
Remove Paycheck Correction	This utility is used to remove any paycheck corrections in branches to which the user has access. The AQ rolls back any deductions that were processed on the correction and updates Advance Bank balances back to their original, pre-correction value.
Remove Web Lockout	This utility is used to unlock a previously locked web user record (e.g. - reset from too many failed login attempts). A drop-down menu is provided to the user displaying all users who are currently locked out.
Update Check Date	Allows the user to update the check date for any payroll batch they currently have node level access to. An analysis run phase has also been added to allow the user to display the checks associated with the batch entered into the AQ’s run parameters.
Update Customer Tree	This will move Customer Departments into other Departments (of the same Parent Customer)
Update Invoice Date	Allows the user to update the check date for any billing batch they currently have node level access to. An analysis run phase has also been added to allow the user to display the invoices associated with the batch entered into the AQ’s run parameters.
Update Pay/Bill Complete	Intended for transactions without paychecks or invoices within the current open accounting period, this AQ allows the user to update the pay/bill complete flags on a transaction level for transactions which are either not included in a payroll or billing batch or both. The user enters the TransactionID from Time Entry and whether they wish to update pay complete, bill complete or both.
Utility Audit	This report is used to look up recent changes made by these utilities on a user level. Generated results show any updates made using the utilities described above within a provided date range. It can be run for all users or by individual users who share a supplier with the user currently running the report.
W2 Manual Modifications	This AQ is used to add information to Box 14 of the W2 or create W2s for 'S Corp' shareholders.