Sage 50 Clear audit trail behaviour

SUGGESTED

Clearing the audit trail requires all the transactions to have been paid, vat returned and bank recd, it also requires all linked transactons to also be paid, vat returned and bank recd.

In the old days this last part was not the case, you could clear the old transactions and the missing part would say something like "link removed"

I have a client with a very large data set, this is because customers pay on account and top up when they run low on funds, as a result there are long chains of linked transactions that never clear.

Is there a way to invoke the old behavior in these cases?

Is there a way to better manage this?

At the moment it appears the best thing I could do is to put on dummy transactions to match the outstanding part of any transaction match off and then reinstate things with a reversal of the dummy.   With over 2000 customer acocunts this is going to be a bit of a pain.

So asking here first.

Parents Reply Children
  • 0 in reply to Andy Rickeard

    I got around it by writing some code to externally manipulate the data.

    It is not great as I had to do it at year end before anythign for the next year was done, but it worked and getting rid of a million splits makes sage run a lot better.

    I also had issues with the year end crashing when there were 1.5 million splits, with the final part of the journal to 3200 not getting written.

    Saved the customer from throwing out sage and changing systems, they are now happy and we can repeat the process each year to keep things tidy and prevent the build up they had.