[Gary Richardson]

We had a bank deposit that had a total of $3,439.10 but the deposit amount shows $3,439.11.  Not sure how this happened.  My issue is that my adjusted book balance for that month is off by .01.  It won’t let me do an adjustment for the .01.  I am attaching screen shots from the bank recon.  The adjusted bank balance is the correct number.

——————————
Debbie Dornhoefer
ATPE
Austin TX
——————————

[Deb Sletmoen]

We have seen this, it has to do with the temp files on local client machine.  The best fix is to void the deposit and recreate it, it will post with correct totals.  

——————————
Deb Sletmoen
Owner
Implementation Specialists (IS)
Hawley MN
——————————
——————————————-

[Gary Richardson]

Thanks for the advice.  I had actually already done this and it didn’t fix.

I voided each member payment, voided the original bank deposit and then entered the payments again and new deposit.  It is still out of balance.

——————————
Debbie Dornhoefer
ATPE
Austin TX
——————————
——————————————-

[Leslie Vail]

Dynamics GP stores all currency amounts with 5 decimals, both deposited and undeposited receipts are stored in table CM20300. If you look in this table, do you see any of your items with values in more than the first two decimals? I’ve had this happen to me and the culprit was a behind the scenes value in those decimal places. I do not know what caused it, but I simply changed the number at the SQL level and never had another problem.
Kind regards,
Leslie

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
——————————
——————————————-

[Arun Vijayakumar]

Run the following scripts against your company DB and verify if their is any mismatch with the transactions,

Select TRXAMNT,ClrdAmt,ORIGAMT,Checkbook_Amount,* from CM20200
where substring(str(ORIGAMT,10,5), patindex(‘%.%’,str(ORIGAMT,10,5))+3, 1) > 0

In case you modify transaction in above table, you need to change in this table as well

Select CURRBLNC from CM00100 
Select DOCAMT from PM30200, 
Select APFRMAPLYAMT, ActualApplyToAmount, APPLDAMT, ORAPPAMT from PM30300,

——————————
Arun Vijayakumar
Omaha NE
——————————
——————————————-