Category:IT/Web/Programming > Other
ID:41227
Title:Sage Line 50 Vers 12 - Database repair
Location:Anywhere
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.
Type:Fixed Price
Budget:£50 - £200 (Approx $78 - $314)
Attached Files: None
Bidding ends:Bidding Closed
Job Posted:19/10/2010 14:29
Stay safe: Read our safety guidelines before bidding
Bidding has ended for this project, the client has accepted the bid(s) below:
Accepted Bid #1Amount: $172 Fixed Fee
Country of Freelancer: 
United Kingdom
Estimated Start Date: Within 1 Business Day
If you are in doubt of the legitimacy of a Job and or Client, let us know by Reporting the Job.
For further support on preventing and reporting fraud please contact the UK’s National fraud reporting centre at http://www.actionfraud.org.uk/ or outside the UK Fraud Watchers at {fraudWatchers}
$
£ GBP
€ EUR
