Reconcile Function Crashes SBA


B

bxwatso

Last night I sucessfully reconciled my CC account. This morning, when I
start to reconcile my checking account, SBA crashes. This happens after I
enter the closing balance and click on 'next.'

I have tried:
1. Repairing the data file (no errors found)
2. Rebuilding the company file
3. Restarting my compter

The crash causes a report to be sent to MS.

I sucessfully reconciled this account last month.

Any suggestions or tips would be appreciated, thanks.
 
Ad

Advertisements

B

bxwatso

I thought I'd update everyone on this item. It seems that somehow I got SBA
to accept a duplicate primary key for a credit card payment. After MS found
out which record was duplicated, I had to unreconcile and unmatch it within
SBA. That allowed the reconcile function to work.
 
T

Tom

I have this same problem...Did you contact MS to solve the problem or is
there a way to find the duplicated record on my own?
 
B

bxwatso

I had to escalate the problem to the development team and they said that they
thought that there was no way they could have found the duplicate key without
using SQL Server. I had to FTP them a backup file for them to inspect. It
tokk over 2 weeks to resolve the problem, but you might get it done faster if
you mention the case of Byron Watson.

That being said, it was a credit card payment, so you might try
unreconciling and un matching all of your credit card payment entries, just
for kicks.
 
T

Tom

Byron...Thanks for the feed back...I will mention the case and send it on to
them
 
Ad

Advertisements

B

bxwatso

I have figured out how to replicate this error on my machine:

1. Create a CC payment from cash using a Journal Entry
2. Match and reconcile the cash statement with this payment
3. Try to match and reconcile the CC account with the same payment.

It crashes SBA hard. The solution is to unreconcile and unmatch the cash
transaction.

I hope MS is reading this for SP3.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top