When a payment was processed in AR-C the wrong checking account # was chosen.  This account # was corrected in GL-P & it was posted.  The check posted to correct checking accout & the A/R acct was credited.  Everything appeared to be okay.   But, now when I print out the "Accounts Receivable Payment History" report that particular payment shows as being debited to the original account (the incorrect one) & not to the correct bank account.  It shows up correctly in the GL accounts.  
 
So, I assume the G/L-Accounting side of things is correct while the A/R-Sales is not.  Is there a way to fix this?
 
In the future, is there a better way to correct this type of error rather than going through GL-P?

These kinds of things happen infrequently (because we're perfect; yeah right!! ) but nonetheless, one does forget how to correct   "!@#$ Happens" episodes.  I have corrected this type of thing by the CD GL entry in the past .  But it is hard to remember all of the fixes & their repercussions.
 
Quote:

 
Do you by any chance know ALL the files that need to be changed in MDB?
 
I changed it in BKARCHKF & BKGLCHK.  BKGLTRAN was already corrected by the GL-P transaction I did.  Do you know if I am missing anything that will come up & bite me later?
 
Thanks for your help,
LeAnn

Quote from David Waldmann on 03/02/07 at 07:23:46:

 
Thanks!!

Why not just reverse the payment in AR-C? That should remove the funds from the AR invoice and bank account? [/quote]
 
So, how would one go about reversing a transaction in AR-C?  Would I have to enter the check amount as a negative payment against the wrong bank account???  Will that mess up the customer's payment history record?

Quote from LeAnn Cucchiara on 03/14/07 at 05:43:12:

 
Just enter the invoice number, check number, amount and the system will prompt you if you would like to reverse this payment.
 
While it does leave an audit trail on the customer's account (the payment and its reversal), it will correctly reverse the transaction without manual intervention and the opportunity to make another mistake while editing.

[I try to avoid MDB]  I totally agree with you on that.  MDB is like the deep, dark ocean to me - it has lots of things that can come up & bite you when you least expect it!  You do something to correct things but one never knows if all files have been corrected.
 
Thanks for all the input.  I have really come to like using this forum - now if someone could just help me with my time management!!