Accidentally Archived Transactions

Suggested

Hello,

Our company has accidentally archived purchase transactions posted in 01/2025 but with invoice dates in the 2024 year.  The effect is that current year transactions are now excluded from the reports we export from SAGE to drive our reporting.

Transactions were archived using Account Maintenance as part of Year End Close, Profit and Loss only.

We are hoping to avoid a system restore because it has been three weeks since archive, meaning we would need to re-input significant amounts of purchase ledger activity (plus nominal activity, sales activity, changes to chart of accounts/supplier list/customer list/etc.).

Does anyone have any suggestions on how to get around this issue?

One solution I'm hoping to explore is whether you can archive specific transactions.  If so, that might allow us to re-enter the activity as a nominal entry with an exact offsetting entry, and archive the offsetting entry.  This would result in no nominal movement, but it would have the effect of adding the activity back into the reports.  Does anyone know whether specific transaction archiving is possible?

Another solution, if we do need to restore, is for us to import purchase ledger activity based on an export from the system today.  We use SICON with project coding.  SICON has a module which allows the import of purchase ledger transactions at the line item level with project coding.  However, the problem is for us to get the activity out of the system in the first place, in order to re-import it after system restore.  Does anyone know of a way to export purchase ledger activity at the line item level, including tax coding?  If there is a method that includes the project coding, even better, but this wouldn't be too difficult to re-create if needed, and it's the line items with tax coding we really need.

Thanks for any help or alternative suggestions.

Brian

Parents
  • 0

    I have found that (despite the warning that the Account Maintenance routine should be run immediately following a Year End routine) some customers are running this routine at a later date.

    Transactions have then been entered with transaction dates relating to the previous financial year, but posted to Period 1 as the Financial Year has been closed, then the Account Maintenance routine has been run and this actually archives transactions based on Transaction Date, not the Period Number in the new Financial Year.

    Could the program be amended to exclude archiving transactions with a posting date in the new financial year?

    Thanks,

    Eric

Reply
  • 0

    I have found that (despite the warning that the Account Maintenance routine should be run immediately following a Year End routine) some customers are running this routine at a later date.

    Transactions have then been entered with transaction dates relating to the previous financial year, but posted to Period 1 as the Financial Year has been closed, then the Account Maintenance routine has been run and this actually archives transactions based on Transaction Date, not the Period Number in the new Financial Year.

    Could the program be amended to exclude archiving transactions with a posting date in the new financial year?

    Thanks,

    Eric

Children