Need more help now? use pay-as-you-go support, call now 03333 445950

We offer rebates on Sage50 subscriptions, discounts on products, service sagecover (not renewals) and stationery.

We also provide Sage 50 integration and email/web services.

Customer Activity Page Anomaly

Sage 50 general help forum - Free help and support for all general issues
Post Reply
philthfc
User
User
Posts: 11
Joined: 18 May 2016, 18:42
Sage Version: Other

Customer Activity Page Anomaly

Post by philthfc » 08 Dec 2017, 12:57

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.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 3911
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Customer Activity Page Anomaly

Post by brucedenney » 08 Dec 2017, 13:03

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
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

philthfc
User
User
Posts: 11
Joined: 18 May 2016, 18:42
Sage Version: Other

Re: Customer Activity Page Anomaly

Post by philthfc » 08 Dec 2017, 13:10

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?

User avatar
brucedenney
Site Admin
Site Admin
Posts: 3911
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Customer Activity Page Anomaly

Post by brucedenney » 11 Dec 2017, 13:25

that is correct
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest