Why Archiving Matters in Sage 200 - A Guide for Growing Businesses

As your business grows, so does the amount of data stored within your ERP system. Over time, this can impact performance, reporting speed, and overall usability. One of the most effective ways to maintain a healthy Sage 200 environment is through regular archiving and data management.

In this article, we explore why archiving is important, how it works within Sage 200, and best practices to ensure your system continues to perform efficiently.

Archiving is a housekeeping process that moves older transactional data from your live system into a history file. This allows you to retain access to historical information while keeping your main database lean and responsive.

Archiving helps to:

• Improve system performance
• Speed up reporting and list views
• Reduce database size
• Keep your operational data focused on current transactions

Importantly, archived data can still be viewed through historical reports and archived workspaces within Sage 200.

It’s important to understand the distinction between archiving and purging.

Archiving

• Moves older data into a history file
• Data remains accessible through reports and enquiry screens
• Helps maintain performance without losing information

Purging

• Permanently removes archived data from the database
• Reduces storage requirements on the server
• Data cannot be recovered once removed

Before purging data, it is recommended to take a backup and create an archive company so that historical data can still be referenced if needed.

Within the Sales, Purchase, and Nominal Ledgers, Sage 200 allows you to define how long transactions remain in the live system before being archived.

This is configured within:

Utilities → Ledger Setup → Ledger Settings

Here, you can specify the number of months to retain transactions in the current ledger before they are archived.

When the Account Maintenance routine is run, the system archives transactions based on those settings.

The account maintenance process can:

• Archive fully allocated transactions for open item accounts
• Run period maintenance for balance forward accounts
• Automatically allocate credits to outstanding debits

Once archived, transactions can still be viewed through historical reports and archive workspaces.

The Nominal Ledger can also be archived through the Account Maintenance routine.

During this process you can:

• Archive balance sheet and profit & loss transactions
• Specify the date range for archiving

Archived transactions remain accessible through archived reports and enquiry screens.

Archiving isn’t limited to financial ledgers. You can also archive Sales Orders and Purchase Orders, which can significantly improve the speed of order list views.

Orders can be archived from:

Utilities → File Maintenance → Archive Orders & Returns

Only orders with a status of Completed or Cancelled will be archived; live orders remain in the system.

When orders are archived:

• They no longer appear in standard list views
• Delivery and despatch details are removed
• Documents and attachments are removed
• Invoices and credit notes can only be viewed through archived reports

If your organisation retains stock movement history, the database can grow rapidly over time.

Archiving stock history allows you to:

• Reduce database size
• Maintain performance
• Keep historical stock transactions accessible through archive reports

Archived transactions are still included when running retrospective stock valuation reports, ensuring financial accuracy.

For businesses using batch or serial number tracking, archiving can also help with data management.

Archiving batch or serial records:

• Moves them to an archive file
• Allows them to still be viewed through archived enquiry screens
• Enables reuse of old batch or serial numbers where required

These records can later be purged if permanent removal is needed.

The transaction audit trail records every entry made within Sage 200, across both financial and commercial modules.

Over time this file can become extremely large.

Sage 200 allows you to:

• Print audit trail entries
• Archive them to a CSV file
• Remove entries once they have been printed

This helps control database size while retaining an external record of activity.

To keep your Sage 200 system performing optimally, we recommend:

✔ Regularly reviewing ledger retention settings
✔ Archiving completed transactions periodically
✔ Backing up your data before purging
✔ Creating an archive company for historical reference
✔ Scheduling housekeeping as part of your system maintenance routine

Archiving is a simple but powerful way to maintain the health and performance of your Sage 200 system. By regularly managing historical data, organisations can ensure faster reporting, improved usability, and a more efficient ERP environment.

If you’d like guidance on implementing archiving or improving your Sage 200 housekeeping routines, download our Pinnacle Archiving Guide Here