SageForum for UK versions of Sage 50- Help and support.

Afternoon all,

I am looking for some advice. We are running Sage 50 Accounts 2016 and have encountered an issue where a payment on account has been loaded against a customer account, yet nothing for it is showing in the activity page for the customer.

We have run a transaction listing report and the 'SA' payment for it shows for the correct amount and against the correct A/C, i have also filtered on the account code in the 'Transactions' tab and can see the payment on account.

Yet i go into the customer record and click 'activity' and the payment on account does not show. It shows two other service invoices raised, one payment and one credit...but no sign of the payment on account. The option for 'all transactions' is picked in the 'show' section so it's not down to it being filtered.

The other weird part is that the balance seems to have taken the payment on account into account and thus is correct, however the 'amount paid' figure is only counting the one sales receipt that is showing on the account, it is not including the payment on account. So strange that the balance seems to include it but the amount paid figure does not?

Has anyone come across this before? It is a little concerning that transactions are not showing as they should.

Any help or guidance would be much appreciated.

Thanks.

Sounds like data corruption.

Did you run Check Data to make sure your data is not corrupted.

If your data is damaged, then you should restore the last known good backup and rekey the lost work.

I strongly suggest you backup the current data before proceeding, should you be unable to restore a backup, or should the amount of work lost be considerable, we do offer a data fix service.

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

Do i do a data check via maintenance? Currently lots of users in using the system which means i can't access maintenance, assuming it's in there is it?

that is correct