Skip to content

x Want to ask a question or reply? Click here to join the group.
Options
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 71 subscribers
  • Views 346 views
  • Users 0 members are here
Browse Forums
Announcements
850
topics
81
replies
Financial year end
159
topics
359
replies
General Discussion UK
9k
topics
24k
replies
General Discussion Ireland
293
topics
614
replies
Install your software
273
topics
705
replies
Making Tax Digital
328
topics
821
replies
Manage your VAT
273
topics
565
replies
Protect and repair your data
81
topics
227
replies
Run your accounts remotely
106
topics
291
replies
Working with the bank
221
topics
576
replies

Trying to upgrade data results in corruption

Ross Nicol
Suggested
Posted By

Hi,

I have a client who has upgraded their Sage from V28 to V34.

For 2 of the 3 companies they have, the conversion process has gone fine, but in the other company the data check on the upgraded data shows around 25,000 errors Disappointed

Looking at the report, they all seem related to the invoices in Sage with each invoice showing the following errors 100

Net amounts in item do not convert at it's exchange rate

Tax amounts in item do not convert at it's exchange rate

Has a self referencing item

Total base tax different from sum of item base tax values

Total base net different from sum of item base net values

and  so on.

I've tried re-indexing the data in V28 then converting again with the same result. I've also tried converting from V28 to V29, V30 & V32, all with the same result.

I'm guessing that I could delete the invoices using the data rebuild option and that might clear the errors, but also leave the client with no copy of their invoices.

Is that the best way to go, or could Sage support do anything, even though it's version 28?

Thanks

Ross

  • 0
    Suggested

    You can also just delete invoices.

    If you have an archive, you can find the invoices there should you ever need them.

    It is also possible that deleting the invoices will result in new errors, if that is the case you will need to call tech support

  • 0 in reply to Ken Fillmore 2

    Hi Ken,

    Thanks for the suggestion but as the errors are happening only when the data is converted, then as the archive will be converted to V34 when accessed I think it will just suffer the same problem.

    The client has called tech support today and they gave her a set of steps to follow including making sure Sage is up to date and restoring the last error free backup but because it then converts the backup then the problem just comes back.

    In times gone by I would have called on their behalf but I know that Sage's rules prevent that nowadays - hence me posting in here.

    Just to confirm that once the data is converted then if I use the rebuild option to delete the invoices then all the errors clear, so it's obviously the invoices that are at fault - it's just a pity they can't be imported with the standard Sage tools.

    I might have a look at Adept or similar to see if there could be a one off way of re-importing them.....

    Thanks

    Ross

  • 0 in reply to Ross Nicol

    Ross

    I appreciate that the Archive will corrupt, however I would expect that you would be able to read the invoices and as the data is read only, the corruption would not be an issue

*Community Hub is the new name for Sage City