Corrupt Supplier Account

[geordie]

All,

One of the businesses I support had someone shut down the server whilst a sage user was running through and amendment.

This has caused that suppliers account to lock up and whilst you can view balances it won't go into the transaction history.

My first thought was to delete the supplier and then create them a new account with the previous balance however the software will not allow you to remove an account with a balance and we cannot zero the balance.

How do we work around this, the backup hasnt run for at least 2 weeks so restoring it is a no no.

Any and all help greatly appreciated.

Many Thanks

[brucedenney]

You are in serious trouble if it is half written and the linkages between transactions is broken.

Take a backup before you try anything.

Check to see if you can find the transactions in the audit trail for that account.

If you can find transactions then sounds like linkages problem.

Try running File Maintenance BUT BACKUP FIRST it does make things worse sometimes.

If that fails I could probably fix it for you, but it will cost.

Contact me via the feedback form on the website...

http://www.makingithappen.co.uk/feedback.htm

[geordie]

We have tried sorting it through maintenance mode and that locks up on one of the checks as well.

What kind of money are we talking about? No fix No fee?

Thanks

[brucedenney]

Did you backup the data before you ran maintenance?

The cost will depend on how long it takes which depends on what and how much is broken. It is possible that the data is beyond repair. It might be possible to recover the last few weeks and glue them onto your older backup. I need to have a look first to be able to tell.

If I can't fix it for less than what you consider an acceptable cost then there would be no fee.