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: