Manual:Utilities

Fix Account Balance

Menu Locations:

Main / Utilities / Fix Account Balance

Accounting / General Ledger / Fix Account Balance

What It Does:

The Fix Account Balance Utility corrects erroneous account balances by deleting any ledger records that have not been attached to a journal entry from the system. These ledger records are then zeroed out on the relevant charts to give the correct account balance.

Fix AP Invoices

Menu Locations:

Main > Utilities > Fix AP Invoices

What It Does:

The Fix AP Invoices utility repairs the issue of an AP invoice being overlooked or incorrect for various reasons. These may be because the system has not assigned an invoice number to the invoice, a company has not been assigned to the invoice, or payments made to the invoice have been missed by the system. The tool finds the erroneous invoice and repairs these issues.

Fix AR Invoice Payments

Menu Locations:

Main > Utilities > Fix AR Invoice Payments

Accounting > Accounts Receivable > Utilities > Fix AR Invoice Payments

What It Does:

The Fix AR Invoice Payments utility finds and corrects invoices with incorrect credit and/or payment amounts.

Fix Inventory Quantity

Menu Locations:

Main > Utilities > Fix Inventory Quantity

Accounting > Inventory > Inventory > Utilities > Fix Inventory Quantity

Inventory > Inventory > Fix Inventory Quantity

What It Does:

The Fix Inventory Quantity utility corrects part numbers with erroneous inventory quantities. It does so by finding the quantity of the part in inventory and comparing it to what the correct quantity should be based off past inventory transactions. If a discrepancy is found, the part number's quantity is updated with the quantity given from past inventory transactions.

Fix Journal Entries

Menu Locations:

Main > Utilities > Fix Journal Entries

Accounting > Inventory > Inventory > Utilities > Fix Inventory Quantity

Accounting > General Ledger > Utilities > Fix Journal Entries

What It Does:

The Fix Journal Entries utility finds errors in the General Ledger by finding journal entries that are orphaned, meaning they are not attached to any account, and removing them.

Recalc Inventory Acct Balance

Menu Locations:

Main > Utilities > Recalc Inventory Acct Balance

Accounting > Inventory > Inventory > Utilities > Recalc Inventory Acct Balance

Inventory > Inventory > Utilities > Recalc Inventory Acct Balance

What It Does:

The Recalc Inventory Acct Balance utility runs a recalculation of the inventory account balances to correct any erroneous calculations.

Inventory Category Link

Menu Locations

Main > Utilities > Inventory Category Link

What It Does:

The Inventory Category Link utility will link a Category to every inventory item that is not assigned to one.

Update Inventory Pricing

Menu Locations

Main > Utilities > Update Inventory Pricing

What It Does:

The Update Inventory Pricing utility will update all inventory item prices based on the current markup percentage and cost of the item.

Efficiency Utility

Menu Locations

Main > Utilities > Efficiency Utility

What It Does:

The Efficiency Utility searches for efficiency records that have either no person or no department linked to them and gives the option to delete these records.