Sage Line 50 Vers 12 - Database repair
4939
£200(approx. $251)
- Posted:
- Proposals: 1
- Remote
- #41227
- Archived
Description
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.
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.
Peter F.
100% (20)Projects Completed
23
Freelancers worked with
20
Projects awarded
64%
Last project
16 Aug 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies