Sage 300 2012 reconcile statements error

[mlnick]

I haven't used bank services ever or really ever had a problem in it, so I am quite new to it, but not to Sage 300 in general.

When opening Reconcile Statements or pressing "Calculate" an error comes up with "Invalid input. The total Cleared Amount for the deposit must be the same as the sum of the receipts that are cleared in the Deposit Details window."

I've looked at tables BKTRANH and BKTRAND and I can't find the issue. Obviously I am missing something and as I mentioned, I have not dealt with the bank services module much in the past.

Any help with this issue would be greatly appreciated.

 

[ettienne]

Run a data integrity check on bank services with the fix option checked.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[mlnick]

I tried that and it showed the error, but didn't fix it. I made sure to check the fix option in the "Application Options" section too.

We are using Product Update 1 and it appears they are up to PU5. I will try updating and then running the integrity again, but I will have to wait until tomorrow.

Thank you for the extremely quick reply.

 

[ettienne]

What's the error?
The product update will not fix it.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[mlnick]

From the errors.log file

Cross Checking Totals....
Processing Bank 1204 ...
Processing Bank 1205 ...
Processing Bank CASH ...
Processing Bank CONVERT ...
Processing Bank TD ...
E: Invalid input. The total Cleared Amount for the deposit must be the same as the sum of the receipts that are cleared in the Deposit Details window.


This same error pops up when opening the reconcile statements screen and pressing the "Calculate button

 

[ettienne]

Ok, then you need to fix the deposit total amount in BKTRANH, or get someone to fix it.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net