Products |Customizations |Services |Videos |Partners |About |Contact |TCP Dispatch
TaiRox Software |Partners |About |Contact |Recent News
Products |Videos |Customizations |Services |TCP Dispatch
User Guide
Product Distribution File
Release Notes
Application Suite
Automate G/L Consolidation
Download Rates
Productivity Tools
SOX Check Approval
SOX User Management
TaiRox Collections
TaiRox CRM and Collections
Data Management Suite
Copy Company
Create Company
Fast Clear History
Fast Data Integrity
Fast DBTools
Optional Field Manager
SOX Backup Enterprise
SOX Backup Express
Specialized Programs
Automate Recurring Entries
Fast Duplicates Check
SOX Second Sight
Tax Converter
For Dealers Only
Fast Units of Measure Tool
G/L Account Repair
Restore G/L History
Install Check
Fast Clear History
Available for $995 + $250 per year, TaiRox Fast Clear History is a SQL Server specific utility that performs Sage 300 clear history operations in a fraction of the time taken using the Sage 300 user-interface forms. Fast Clear History will clear all Sage 300 core modules.
"Fast ... cleared 49 million records in about 75 minutes ... before this ... not even an option! Thanks TaiRox!!" Kelly Hummel, Net@Work. Show complete quote.
"Database is 187 GB ... standard OE clear ... [2 or 3 days] ... TaiRox OE clear ... [less than 2 hours]" Scott Davies, Equation Technologies. Show complete quote.
Tests on a 5Gb database show Fast Clear History deleting 98 thousand OE records and taking 29 seconds versus 1 hour, 37 minutes, 8 seconds: 197x faster!
Tests on a 20Gb database show Fast Clear History deleting 8 million OE records and taking 12 minutes and 26 seconds versus 7 hours, 12 minutes, 38 seconds: 35x faster!
*New* Support has been added for Sage 300 2021.
The Fast Clear History Console shows a tab for each supported & activated module in the selected company. Important Note: Before running Fast Clear History you must ensure that IC Day End has been run.
Accounts Payable Options:
fast-clear-history-console-ap.png fast-clear-history-console-ap.png
Accounts Receivable Options:
fast-clear-history-console-ar.png fast-clear-history-console-ar.png
Bank Options:
fast-clear-history-console-bk.png fast-clear-history-console-bk.png
General Ledger Options:
fast-clear-history-console-gl.png fast-clear-history-console-gl.png
Inventory Control Options:
fast-clear-history-console-ic.png fast-clear-history-console-ic.png
Order Entry Options:
fast-clear-history-console-oe.png fast-clear-history-console-oe.png
Purchase Order Options:
fast-clear-history-console-po.png fast-clear-history-console-po.png
Tax Options:
fast-clear-history-console-tx.png fast-clear-history-console-tx.png
A Summary Message will be displayed upon completion with the total number of rows that have been deleted. A progress window will appear during operation. A log file can be viewed for more details.
fast-clear-history-message.png fast-clear-history-message.png
Features and Benefits
• Performs a clear history operation many times faster than Sage 300.
• Includes options, like clearing unprinted posting journals, which are not available in Sage 300.
• Makes the same table changes as Sage 300 clear history.
• Deletes multiple rows in a table as a single SQL transaction.
• Detects triggers in affected tables and warns before proceeding.
• Supports Modules: AP, AR, BK, GL, IC, OE, PO, TX.
Platform Requirements
• Sage ERP Accpac version 5.6 or 6.0 or Sage 300 2012, 2014, 2016, 2017, 2018 or 2019
• A single executable program works with all platforms
• Microsoft SQL Server is required