Blogger
Share this content
0
5
760

Sage Remove Journals with incorrect dates

Our accounts contain a lot of transactions created many years ago with a date of 2099. These were subsequently corrected but I'd like to remove them from the accounts as they're preventing me from deleting old suppliers etc.

As far as I can see you can old remove journals with dates in the past. Is there a way?

Thanks for any help.

Replies

Please login or register to join the discussion.

avatar
08th Feb 2013 12:23

Journals?

You mention that they are preventing you from deleting old suppliers but journals entries cannot appear on a supplier account...

To remove old transactions (regardless of their type) you need to run the Clear Audit Trail routine (Tools -> Period End) and that will remove transactions that meet the following criteria:

1. Prior to the date entered

2. Where appropriate they are VAT reconciled and Bank Reconciled.

3. Where both 'sides' meet the criteria by which I mean if you have a sales invoice that meets all be above criteria but the sales receipt that paid it does not, then the invoice will not be removed.

John

 

Thanks (0)
avatar
08th Feb 2013 13:44

Journals

Hi John

Thanks for your help.

However problem is that the date is 2099 (should have been 1999) and as far as I can see I would have to set the period end to 31/12/2099 which would also delete current reconciled transactions and I don't want to delete transactions in the current date range even if they are reconciled.

Ken

 

 

Thanks (0)
avatar
08th Feb 2013 14:03

Ah...

Apologies, I read it as 2009 rather than 2099.

As you can't change the date of journals within the program (although it possible for a developer who knows what they are doing to it) then those transactions will stay, essentially, forever.

Having said that, as they are journals which, as I mentioned, can be posted to a supplier account anyway, they wouldn't affect your ability to remove supplier accounts once the Audit Trail was cleared to remove the supplier transactions.

John

 

Thanks (0)
avatar
08th Feb 2013 14:25

Journals

Hi John

But how do I clear the Audit Trail for future dates without clearing it for current dates?

Ken

 

 

Thanks (0)
avatar
08th Feb 2013 14:34

You can't...

You can't but, if was you've said, these transactions are journals, they will not affect your ability to delete supplier accounts, but they will, as it stands, stay on the Audit Trail until 2100...

John

 

Thanks (0)