Sage Line 50 Vers 12 - Database repair

  • Posted:
  • Proposals: 1
  • Remote
  • #41227
  • Archived
Anita B. has already sent a proposal.
  • 0


Experience Level: Expert
We have a courrupt database that need attention.

Initially INVOICE.dta was showing as �corrupt� and Sage wouldn�t load or restore from backups.

We managed to get it to load and �checked data� and then �fixed� 4 of the ten errors automatically. The other 6 were fixed manually through maintenance functions.

Although original problem has now disappeared we are encountering further problems.

When entering receipts it appears that Sage is also placing the value received in foreign currency box. When viewed in File, Maintenance, Corrections there is a value in the receipt box which has been split between Net and VAT, whilst the total value received is placed in foreign currency, thus causing a matching problem.
No foreign currency is being entered, and the customer is set up as normal. No VAT registration number is set for either (be indicating to the system that these may be foreign?)

Also certain records previously used for customers � and for allocating invoices - are now not being recognised and Sage was creating an error stating that the header in the transaction did not match in the Sales Ledger
When viewing the sales list the records was missing, but when going into Customer Record option to recreate the record it already appeared as existing.
This occurred continually until a new record with a higher code number was created. The original record reappeared and the new record did not show on the customer list. Eg was creating ZOOL02 to replace ZOOL01 which was not showing. However when ZOOL02 was created ZOOL01 showed up, and the header/Sales ledger error disappeared.

General problem is that the system is exceptionally slow running any �check data� or system reports. Also the error message No Disk Space has appeared a number of times even though the server has lots of available space.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.