Clear Out the Clutter
It may feel like winter, but meteorological spring arrived March 1st. And with spring comes the perfect excuse for a little cleaning. Just as a good spring refresh brightens your home, decluttering your database can boost performance and help you maintain a clear and efficient workflow.
- Old Transactions
Historical transactions that no longer serve an operational purpose can slow down daily processing. Archiving or removing them helps your system run more efficiently and reduces processing delays. See related article. - Inactive Customers and Vendors
Outdated or unused customer and vendor records clutter reports and make analysis harder than it needs to be. By making them inactive, you can exclude them from lookups and many reports and inquiries..
To help determine whether an account is active:
- Use the Customer Credit Report (CCR) to review sales activity
- Use the Vendor Listing (VL) to review last PO and payment dates
You can quickly update customer and vendor records by exporting them (using CMXML and VMXML) to Excel, making changes, and importing the updated records back into PowerShift. Stale Data? Use Excel to Bring it Up-to-Date! provides a detailed example of the import and export process.
- Item Status Codes
Many PowerShift reports and inquiries have options to include only active items and/or enable you to exclude items with particular status codes. You can use item status codes to identify samples, prototypes, items you're phasing out, and so forth -- and control whether or not an item can be purchased, sold, manufactured or have its inventory adjusted.
The Intentory Activity History (IAHR) and Inventory Sales/Usage (IHUR) reports are useful in helping to determine whether an item's status should be changed. - Stale Orders
Old POs, manufacturing orders and sales orders that should be closed often linger in the system. Closing them out reduces noise, improves reporting, and ensures open order balances reflect reality. These reports and inquiries offer date options that can be especially helpful:
- VPL: Parts On Order Listing
- MOOL: Open Manufacturing Order List
- OL: Sales Order Listing
- OSAQ: Shipment Inquiry
- Lingering AP and AR Invoices
Unresolved accounts payable and accounts receivable invoices create confusion and distort financial visibility. Addressing these items—whether by resolving, writing off, or reclassifying—helps maintain clean ledgers and accurate aging reports. Date options in the AP Aged Trial Balance (NTB) and AR Aged Trial Balance (RT) reports make them particularly useful.
Taking measures to keep your data current and relevant streamlines operations and boosts productivity. If you have any questions or comments, contact helpdesk.
