Trying to reconcile transaction

[SpeedBWild]

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?

 

[VictoriaYudin]

Usually this happens when you import transactions with more decimal places than the default for the currency is set to. Take a look at KB article 851301 for a resolution.

https://mbs.microsoft.com/knowledge...YYKSWTLKQNNOXUQTOKTOOQTURYSYMZWPQRVWKLRNYNKOK

Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

 

[SpeedBWild]

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,

 

[VictoriaYudin]

Take a look at the amounts in the CM20200 table.

Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

 

[SpeedBWild]

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.

 

[VictoriaYudin]

What about the CURRBLNC field in CM00100 for that checkbook? Does that have the right decimal places?

Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

 

[SpeedBWild]

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?

 

[VictoriaYudin]

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

http://www.flex-solutions.com/gpreports.html

 

[SpeedBWild]

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.

 

[VictoriaYudin]

What is the CURRBLNC in CM00100 for that checkbook?

Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html