Error messages in check data

[Binnieman]

Hi
Can anyone help with this please. Every time I run check data prior to back up I get the following errors:
1. Our prodcut code - "last transaction mismatch". This happens for three different product codes. I have been back in and checked the transactions for the product codes stated and cannot find anything wrong?
Have tried "Fix it" but this does nothing
Many thanks

[brucedenney]

You need to give the exact message that error checking supplies.

Please also give what version of Sage 50 you are running

please read this post viewtopic.php?f=1&t=49

[Binnieman]

Sorry, we are running Sage Line 50 2008 version 14.012.153 the error message we have are:
Transaction header record 56739 does not link to any splits
Net amount in header 0 disagrees with total net in splits
Tax amount in header 0 disagrees with total in tax splits
Foreign net amount in header 0 disagrees with total net in splits
Foreign tax amount in header 0 disagrees with total tax in splits
Stock code "xxxxxxxx" has last transaction mismatch

(xxxxxxx) represents one of our product codes. This message repeats three times for thre different code numbers

Many thanks

[brucedenney]

You will need to restore a backup, data has been lost

look for transaction 56739 in the audit trail and you will find nothing when you drill into it.

If you are really lucky and it is only one transaction and it relates to a prior year or if you know what is should be it might be possible to delete it and if need be repost it.

You are looking at a couple of hundred pounds to get the data repaired.

[Binnieman]

Hi
I have managed to sort all error messages apart from the ones relating to the stock codes last transaction mismatch.
I resolved the others by drilling down via financials and found that the ame index hd ben given to two different transactions - one being a payment receipt and the other being a sales invioce. I deleted the payment reciept and reposted then ran the re-index and compress and hey presto sorted. Any thoughts on the stock code mismatches would be welcomed?
Thanks

[brucedenney]

The only way to remove the transaction would be to clear stock.

Depending on how you are using Sage this could be virtually inconsequential or catastrophic.

[Binnieman]

I am confident that in our case this would be catastrophic. It is odd how the three errors appeared from nowhere with no feasable explanation. I have checked index and evey linked transaction for each of the code numbers affected and can find nothing any different to all other transactions.
Thanks

[brucedenney]

Just reminds you how important it is to check data.

[Binnieman]

Frustrating thing is we run data check every night and back up every night.
Where the error states Stock Code "XXXXX" has last transaction mismatch followed by Stock Code "XXXXX" quantity in stock disagrees with history by XXX I have found in stock code audit that a transaction is completely missing rom the product code activity.
A sales order was created properly and then allocated and despatched. Invioce was created properly and all shows in customer activity however nothing shows in the product.
I believe that here lies our problem however I have no idea as to why?
Any sugestion would be welcome - or is this looking like a corruption that requires more detailed fix?
You have also mention "on line support" but I am nervous about sharing our company data?
Thanks

[brucedenney]

Sounds like it would need a bit more of a fix that you can do as an end user.

You should be nervous about sharing company data, I would be concerned if you were not. If online support is something you would like to consider, then please give me a call and we can have a chat, I can give you some existing clients you can call to "verify" me.

[Helpsage]

Having the problem similar to yours, how did you delete the sales receipts. Can you let me know in detail please.

[brucedenney]

I suspect he did not.

Data corruption of this sort really needs expertise and tools to be fixed.

If you don't have a backup to go back to, it can be fixed.. but it is not a cheap option.

http://www.makingithappen.co.uk/sage-su ... ervice.htm