Sage Accounts 2011 - Missing activities
Sage Accounts 2011 was working fine, but today it is missing all entries in the all the activities windows. I have restored from backup, but the problem still exists. Any ideas?
Missing Activities
Hi John
Thanks for responding.
I have run Check Data and there are no errors. All transactions are present in the Financials window.
Chloe
Activity
If you go Customers -> Activity and select a Customer who you know has transactions nothing comes up?
On the Activity screen, what appears in the 'Show' field?
If you've not already done so, run both ReIndex and Compress.
John
Lack of Activity
I chose 2 Customers with known transactions, one with a balance and one without - the Activitity screens on both are blank.
The 'Show' field is set to 'Custom Range' with a date range of '01/01/1980 to 31/12/2099', 'Type' set to 'All' and 'O/S only' is unchecked.
I have run ReIndex and Compress - still no activities.
Chloe
Is the box ticked?
Is the show "o/s only"box clicked/ticked - if there is no outstanding balance then no transactions will show. This is relevant to Sage 2010 and I haven't seen the screens for 2011 so sorry if this isn't relevant but I'm assuming it's pretty similar.
Activity
Is the show "o/s only"box clicked/ticked - if there is no outstanding balance then no transactions will show. This is relevant to Sage 2010 and I haven't seen the screens for 2011 so sorry if this isn't relevant but I'm assuming it's pretty similar.
The last post suggested that it wasn't ticked:
"and 'O/S only' is unchecked."
John
Sorry
So sorry - what an idiot
Activity
How strange, I don't have the option to Show 'All Transactions' - I only have:
'Last 30 days'
'Last 60 days'
'Last 90 days'
'This Financial Year'
'Custom Range'
Activity
The Activity Range screen settings are:
Transaction Range
From: 0
To: 0
Transaction Type:
Type to Display : All Transactions
Outstanding Transactions Only - box is unchecked
Date Range:
From: 01/01/1980
To: 31/12/2099
Activity
Transaction Range
From: 0
To: 0
Ah - that might be it then - the transaction range should default to a value of 1 for 'From' and the number of transactions to 'To' - as both settings are zero, nothing is being returned as there is no transaction 0.
Change the 'From' to 1 and set 'To' to 99999999 - the 'To' should then reset to the number of transactions.
I believe that will solve the problem.
John
Activity
It won't let me change either value.
It comes up with a Warning, displaying the message
'Transaction number greater than the total number of transactions'
Yet the Financials Report showing all the transactions!!!
Activity
Does the number of transactions in the 'To' field not change to the actual number of transactions once you OK that message?
If it does not and still defaults to 0 then it would suggest that, despite what Check Data is showing that there is a problem with the data. If you go to Help -> About -> System Information -> Directories, right click on the Data Directory and Open Folder.
In that folder there should be a file SPLITIDX.DTA - if that file is missing or has a legnth of zero bytes then you do have a problem with the data.
John
Activity
Both the 'To' and 'From' fields defaults to 0.
The file SPLITIDX.DTA, it's size is 20KB - which seems rather small to me - how big should it be?
Activity
Yes, s/w up to date including Update 3.
Thank you so much for your help and patience in dealing with this problem - all your efforts are much appreciated.
Do you believe it would help if I uninstalled the program and started from scratch?
Activity
Activity works as expected including changing the transaction numbers in Demodata.
Activity
That suggests that the problem is data related as, if it was a program issue I would have expected Demodata to fail as well...
If you'd be OK with sending me a backup I'd be happy to take a look, free of charge, to see if there are any problems not being reported by Check Data
John
Activity
John
I'd be eternally grateful if you would look at the data for me. Where should I send it to?
Chloe
Activity 1 thanks
As a footnote to this one in case anyone is interested, having had a look at the data, the problem turned out to be data corruption (fixable) albeit Check Data returned no problems so it took an awful lot of digging to find...
John
Activities 1 thanks
My sincere thanks to John for all his efforts in resolving this issue for me.
Chloe
-
Comments: 1
-
Comments: 14
-
Comments: 9
-
Comments: 3
-
Comments: 2
-
Comments: 4
-
Comments: 3
-
Comments: 2
-
Comments: 1
-
Comments: 1
Missing Activities
First thing - if you run Check Data are there any errors? If there are then you have data corruption that needs to be sorted out.
Assuming there are no errors, if you go to the Financials window, can you see all the transaction there?
I was also going to suggest that there may be some criteria set up but this would not affect all activity windows...
John