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.

  • 0
    SUGGESTED

    Hi Bruce,

    Thanks for using Sage City, and my apologies for the delay in this reply.

    As you describe, that was the old functionality, and there are no immediate plans to revert to it, however, I can understand why it would be desirable in the situation you describe. I would suggest adding it to the Wishlist / Ideas hub to see if oour developers will pick it up.

    Ideas hub > 

    Regards,

    Andy

    Sage UKI

  • 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.