|
|
|
Advanced Member
 
Group: Forum Members
Last Login: Today @ 1:27:58 AM
Posts: 46,
Visits: 320
|
|
I don't know if this is related to my attachment problem (previous post), ie another symptom of a corrupted database, but here's the problem.
I had done 8 bank reconciliations on three different bank accounts. All reconciliations went fine - all transactions showed up and were reconciled and all balances matched.
Then I decided to use the "view past reconciliations" feature - to see how a reconciliation printout would look. Here's what I found:
Account 1, four statement reconciliations:
Statement 1: fine, all four transactions shown
Statement 2: only one of six transactions shown (last one)
Statement 3: fine, all four transactions shown
Statement 4: first says "no records for this reconciliation" then, if you repeat, it shows two of three transaction and, if you keep repeating, it alternates between the "no records" and showing 2 of three.
Account 2, three statement reconciliations:
Statement 1: only five of eleven transactions shown
Statement 2: fine, all eight transactions shown
Statement 3: fine, all three transactions shown
Account 3, two statement reconciliations:
Statement 1: only four of fourteen transactions shown
Statement 2: fine, both of two transactions shown
In every case (whether the reconciliation shows correctly or not) the correct bank balance and zero difference is shown.
Also if you show reconciled transactions - all the transactions show up - its only when you use the "view past reconciliations" that the transactions get lost.
Again, I am getting increasingly worried about the integrity of this software/database - the whole reason for getting it was for reliable records and reporting and this is my second major problem in as many days.
I have now invested a lot of time in setting up the fund and inputing data and I urgently need to finish up the accounts for audit - so a speedy reply would be greatly appreciated.
Neil H.
|
|
|
|
|
Advanced Member
Group: Forum Members
Last Login: Today @ 1:27:58 AM
Posts: 46,
Visits: 320
|
|
A quick follow up which may/may not help you explain what the problem is.
I decided to experiment with a backup.
I deleted all the past reconciliations. Then I unreconciled all the transactions (by showing unreconciled then unchecking all then "reconciling" to make the change stick.
Then I started reconciling again - but checking on the past reconciliation printouts as I did so. The problem does not seem to be specific transactions so much as interaction between different reconciliations. Heres what happened:
I reconciled BW1 (14 transactions) & BW2 (2 trans) both went fine and the reconciliation retorts were fine.
I reconciled ING1 - still all OK
I reconciled ING2 - the first 5 transactions disappeared from the BW1 report
I reconciled ING3 - the next 5 transactions also disappeared from the BW1 report (leaving only 4 transactions showing)
I reconciled ING4 - hitting the print button on this gives either "no transactions against this reconciliation" or it shows just the last two of 3 transactions (repeated "print" attempts just shuttle between these two outcomes.
I reconciled CBA1 - only the last 5 of the eleven transactions show on the report. Also the first transaction disappeared from the ING2 report.
At this point, I gave up but no doubt if I had continued there would have been more interaction.
The only pattern I noticed up to this point was that when transactions start disappearing, it is the earliest transactions in a particular reconciliation which start disappearing from the reports first.
HELP!!!
Neil H.
|
|
|
|
|
MySF Administrator
Group: Administrators
Last Login: Yesterday @ 8:08:32 PM
Posts: 293,
Visits: 390
|
|
Hi,
The attachment problem outlined in your other post is a display level issue and your data is ok. There is a reply to that effect being posted by one of our staff right now.
The reconciliation problem described does sound very odd. It is not likely that there is any issue with the transactions, it is more likely that the reconciliation record itself (or possibly just the display) has some sort of a problem. Would you be able to send through your data file as an email attachment to info@mysf.com.au so that we can run some tests on it? This would help us to pinpoint why the recall of the past bank reconciliations is not showing the expected result.
Regards,
MySF
|
|
|
|
|
Advanced Member
Group: Forum Members
Last Login: Today @ 1:27:58 AM
Posts: 46,
Visits: 320
|
|
I have just emailed the file to you, as requested.
Note, I have done more transactions & reconciliations since my original post, so the display problems are somewhat different now. What seems to be constant is that for any reconciliation where some transactions are not displaying it is always the last transactions which DO show and the earliest transactions which DON'T show.
Current status for 15 reconciliations across 3 bank accounts - as it displays for me:
BW1 2 of 14 showing
BW2 1 of 2 showing
ING1 OK: 4 of 4 showing
ING2 1 of 6 showing
ING3 1 of 4 showing
ING4 Should have 3 but says there are no transactions (now say this consistently)
CBA1 5 of 11 showing
CBA2 OK: 8 of 8 showing
CBA3 OK: 3 of 3 showing
CBA4 8 of 15 showing
CBA5 OK: 1 of 1 showing
CBA6 OK: 1 of 1 showing
CBA7 5 of 15 showing
CBA8 Should have 4 but says there are no transactions (now say this consistently)
CBA9 Alternates between correctly showing 3 of 3 and saying no transactions.
Note also that your reply regarding the attachment problem does not explain everything that I observed (I have replied in detail in that thread).
Neil H.
|
|
|
|
|
MySF Administrator
Group: Administrators
Last Login: Yesterday @ 8:08:32 PM
Posts: 293,
Visits: 390
|
|
We have received the data and will check what is causing the results that you have described.
Results will be emailed to you and the descriptions of any changes will be posted here.
Regards,
MySF
|
|
|
|
|
Advanced Member
Group: Forum Members
Last Login: Today @ 1:27:58 AM
Posts: 46,
Visits: 320
|
|
Any progress on this yet?
Neil H.
|
|
|
|
|
MySF Administrator
Group: Administrators
Last Login: Yesterday @ 8:08:32 PM
Posts: 293,
Visits: 390
|
|
Hi,
We have tested the data you have sent through and have also received mixed results when recalling past bank reconciliations. At this point it looks like the error is likely to be display level only and data is not affected.
Unfortunately changes to this area of the software will not be included in the next update, but will be included in the following one.
Regards,
MySF
|
|
|
|
|
Advanced Member
Group: Forum Members
Last Login: Today @ 1:27:58 AM
Posts: 46,
Visits: 320
|
|
Unfortunately changes to this area of the software will not be included in the next update
Which was 4.0
but will be included in the following one.
Which is the recently released 4.0.1
However, I have upgraded to 4.0.1 and the problem still remains.
When do you plan to fix this - I agree with DESUPER's sentiments in that I would place a much higher priority on fixing existing problems than introducing a whole bunch of new features (and hopefully make sure the bugs are out of the new features before you release them!)
Neil H.
|
|
|
|
| | |