We’re currently updating our website to a new platform. We’re still operating as usual, but some pages may be under construction. Thank you for your patience.
Jiwa Training Centre

Archiving

Use this section to archive older data in Jiwa while keeping it available for reporting.

What is archiving?

Archiving moves older, less-used data out of active system tables into history tables.
This helps improve system performance while keeping historical data accessible.

When to use archiving

Use archiving when:

  • your database has grown large

  • system performance is slowing down

  • older transactions are no longer actively used

  • you want to retain historical data without cluttering current records

Before you archive

Do not delete transactions manually (for example using SQL). This can damage your database and affect financial data integrity.

Before running any archive process:

  • confirm which data will be archived

  • understand how archived data behaves

  • check if any reports or processes rely on that data

  • run archiving during low system usage where possible

Archiving processes

Select the type of data you want to archive:

Sales

  • Archiving Sales Orders

  • What Happens When Sales Orders Are Archived

Debtors (future expansion)

  • Archiving Debtor Transactions

  • What Happens When Debtor Transactions Are Archived

Creditors (future expansion)

  • Archiving Creditor Transactions

  • What Happens When Creditor Transactions Are Archived

How archiving works

  • Data is moved to history tables

  • Archived data is still available for reporting

  • Some links between records may no longer work after archiving

  • Archived records are no longer part of active processing


After archiving

After running an archive:

  • review the History tab

  • check the archive log

  • open the report for details if needed

  • confirm no errors occurred


Common mistakes

  • Running archiving without reviewing criteria

  • Forgetting to enable the archive job

  • Not checking results after execution

  • Archiving data without understanding reporting impact

For more details, see: