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

  • 0
    SUGGESTED

    Hi Brian

    Not going to be much help here.

    i do not believe it is possible to archive specific transactions, its an all or nothing kind of deal.

    Which leaves you in my mind two choices.

    Option 1 Live with it and make your reporting take into account archived transactions.  Sage reports have 2 versions of most reports, one for current, one for archived.

    Option 2.  Restore and re-enter/import transactions.

    You can export data in many ways you can create excel reports that connect to the sql tables, export the data, and then you can format it as you want,  i would engage with your business partner if you choose this route, it may involve paying professional services fees, but they should be able to help.

  • 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