Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trying to reconcile transaction

Status
Not open for further replies.

SpeedBWild

Programmer
Apr 29, 2004
117
US
Under Transactions -Financial-Reconcile click on Transactions then reconcile. The difference is $0.00 but the system is giving me the following message: "The difference must be zero before you can reconcile this checkbook"

How do I fix this. Where should I be looking?

 
I do not have access to the knowledge base. Is it possible to determine which back end tables this would affect or what the article suggests as a fix?

Thanks you,
 
I did and I fixed the decimal point, but I am still not able to reconcile. Any other ideas or places I should be looking? I am still getting the same error.
 
That value is correct. It is only to one decimal place.

Do you think that not being able to post a series could be part of the issue? Below is another posting I have. I'm not sure if the two are related or not.


Under Transactions -Financial - Series Posting I mark a batch and then click on post. I get a message starting I have not marked a batch for posting.
At that point I click on the batchId link which takes me to Batch Entry window. From there I try to select the batch in question. I get a message that the batch is being posted. I have tried the batch recovery process and that does not work. I looked in the SY00800 and SY00801 there are no entries in that table. In table wkpostingvalidationstate there are two entries. How do I know which one goes to the batch in question? Should I even be making changes to this table? What do I need to do to get this batch unstuck?
 
Most likely the 2 are not related. It's very difficult to diagnose this kind of stuff without seeing it....in general my personal feeling is to not touch the tables directly unless you are 100% sure of what you are doing. And no matter what, make backups before any changes!

For the batch issue, get everyone out of GP, make a backup of your DYNAMICS and company databases, then check the following tables, they should all be empty:

DYNAMICS..ACTIVITY
DYNAMICS..SY00800
DYNAMICS..SY00801
tempdb..DEX_LOCK
tempdb..DEX_SESSION

If everyone is out of GP, you can delete anything in those tables. If you're not sure, tell us what you see and we will help you figure out what it means.

Then take a look at SY00500 in the company database. Find the batch in question - ERRSTATE and BCHSTTUS should both be 0. If they are not, change them to 0, then in GP go the the Batch Entry window (Transactions > Financial > Batches), bring up that batch and print the Edit list (click the print icon in the upper right hand corner). That report should tell you if there will be a problem posting the batch. If there are no errors listed, post the batch again.

Again, I do not think the reconciliation issue is related, and if you've checked the CM20200 table and everything looks correct, then you may want to get some help with that from either your GP Partner or Dynamics GP support.

Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
 
On the Select Bank Transactions screen The adjusted bank balance reads $xxxxxxx.76 and the adjusted book balance reads $xxxxxxx.77, but the difference is reported as $0.00.

Where do I go to fix this? At this time, I am unable to reconcile.

Any help is appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top