Archive sales and purchase transactions

Note: This option is only available for On Premise deployments.

With this option, transactions that are fully allocated, and that have exceeded the number of months specified to keep transactions for are archived or removed when the relevant Account Maintenance option is run.

• If you have selected to archive your transactions in the Ledger settings, the transactions are moved to an archive file. Once archived they can be viewed on the relevant archived Transaction Enquiry screens and historical reports.
• If you have not chosen to archive your transactions, they are permanently removed from the Sage 200 database.

For example: You have chosen to keep your transactions for 3 months for all of your Accounts. You enter the Archive up to date as 30 November. All allocated transactions dated prior to 01 September are archived or deleted.

All outstanding transactions are kept, regardless of their age. Outstanding transactions are:

• Part allocated payments.
• Disputed transactions.
• Unpaid invoices.
• Part paid invoices.

With Balance Forward accounts, individual transactions are removed and replaced with a bought forward balance for each accounting period. The bought forward balance is created, when the relevant Account Maintenance option is run.

Each period's total balance is carried forward as a single balance figure and so the number of balances carried forward depends on the number of accounting periods that you have.

When transactions such as payments are posted for a previous period, they are allocated by period number, so the appropriate balance is amended. Queried transactions are kept on the account.

The advantage of this type of accounting is its economical use of disk space.

Note: Balance forward accounts cannot be used for foreign currency accounts.

With Automatic Allocation accounts any credit notes, payments or receipts are allocated to invoices when the relevant Account Maintenance option is run. The oldest outstanding invoices are allocated first. Queried invoices are not allocated.

Any debits or credits that are not allocated are carried over into the new period. If the transaction values do match exactly, the transactions are part-allocated.

Transactions that are fully allocated, and that have exceeded the number of months specified to keep transactions for can be archived or removed.

• If you have selected to archive your transactions in the Ledger settings, the transactions are moved to an archive file. Once archived they can be viewed on the archived transaction enquiry screens and historical reports.
• If you have not chosen to archive your transactions, they are permanently removed from the Sage 200 database.

• In On Premise deployments, allocated transactions on open item accounts are archived or deleted.
• All balance forward transactions older than the date specified, are archived or deleted and a brought forward balance is calculated.
• All individual balance forward transactions posted with a date later than the date specified, are carried over.
• For automatic allocation accounts, all outstanding credits are allocated to outstanding debits. Any debits or credits that are not allocated are carried over into the next period. Where the values do not match, the transactions are part-allocated.