Advanced Utilities

The advanced utilities give you control over tasks such as batch deletions, search and replace, and data import.

Related Topics:

  • File Reconciliation Report
    Run the File Reconciliation report to view any discrepancies between a general ledger account balance or the balance of a group of mapped general ledger accounts and the detailed transactions that make up the balance.
  • Tolerance Report
    If your enterprise uses Organization Reporting and maintains separate balance sheets, debits and credits may post to separate organizations, which causes a tolerance. Use the Tolerance Report to find these discrepancies.
  • Multicompany Analysis Utility
    The Multicompany Analysis utility lets you generate a report that shows you where you need to provide additional Multicompany application setup information.
  • Open New W-2 Quarter Utility
    Use the Open New W-2 Quarter utility to open a new quarter for the purpose of tracking payroll data.
  • Open New Absence Year Utility
    Use the Open New Absence Year utility to start tracking time earned and taken for a new absence year. You can have only one active absence accrual year. You cannot have different active absence years for different employees.
  • Data Import Utility
    Use the Data Import utility to bring records from outside sources into the DPS database.
  • Posted Transaction Files Utility
    Use the Posted Transaction Files utility to access posted transaction files.
  • Undo Posting Utility
    Use the Undo Posting utility to reverse (undo) completed postings.
  • Locked Transaction Files Utility
    Use the Locked Transaction Files utility to unlock transaction files that were left in a locked state because an error occurred during posting.
  • Incomplete Postings Utility
    Use the Incomplete Postings utility to access incomplete or failed postings so that you can track them and resubmit them.
  • Project Closeout Utility
    The Project Closeout utility closes out projects, phases, and tasks and transfers the closed-out information to either another project, phase, or task of the same type or to a special completed project, phase, or task number. DPS then deletes the closed-out project, phase, or task, and associated information, from the DPS database.
  • AR Paid Utility
    If your paid Accounts Receivable data is out of sync, use this utility to correct it.
  • VO Paid Update Utility
    If your paid voucher data is out of sync, you can use this utility to correct it.
  • EX Paid Update Utility
    The EX Paid Update utility updates the Employee Expenses (EX) table by recalculating the most recent period when each employee expense voucher was paid in full.
  • Refresh PRSummary Table Utility
    Use the Refresh PRSummary Table utility to calculate and save project summary information.
  • Refresh GLSummary Table Utility
    Use the Refresh GLSummary Table utility to calculate and save General Ledger information.
  • Refresh Inventory Utility
    Use the Refresh Inventory utility to refresh inventory quantities and the average cost for all inventory items.
  • Batch Deletes Utility
    Use the Batch Deletes utility to delete or make inactive multiple hub records for both standard and user-defined hubs.
  • Search and Replace Utility
    The Search and Replace utility makes it possible for you to update fields globally for multiple hub records.
  • Change W2 Quarter/Year Utility
    Use the Change W2 Quarter/Year utility to adjust the W-2 quarter or the W-2 year for a payroll posting.
  • Audit Purge Utility
    Use the Configuration Audit Purge utility to remove data from configuration log records. The purged areas are Roles, Users, Screen Designer Security, and Exchange Rates.
  • Create Contracts from Fees Utility
    Use the Create Contracts from Fees utility to create contracts based on the existing fee amounts for multiple projects at one time.
  • Talent Management Web Service Utility
    Use the Talent Management Web Service utility to connect DPS to the Talent Management Web service and sync employee records between the two applications. To use this feature, you must have installed and configured Talent Management to work with DPS.
Parent Topic: Utilities (Desktop)