ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Correction for AR-C Wrong GL Acct # Selected
http://www.istechforum.com/YaBB.pl?num=1172771588

Message started by LeAnn Cucchiara on 03/01/07 at 09:53:08

Title: Correction for AR-C Wrong GL Acct # Selected
Post by LeAnn Cucchiara on 03/01/07 at 09:53:08

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?

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by JNAPIER on 03/01/07 at 14:24:00

Well now that you have edited the acc #'s and posted, this won't help much. When we have the wrong account selected for a cash receipt, we leave it alone and do a CD GL entry to get the monies to the right account.

You are still going to face an issue when you reconcile that account with your bank statement. Your GL account balance is right, but the file for the bank rec is wrong. You will need to fix that with MDB >:(

John

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by LeAnn Cucchiara on 03/02/07 at 07:23:32

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:

You will need to fix that with MDB

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

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by David Waldmann on 03/02/07 at 07:23:46

This just happened to me (again :-[ ) this morning. I think you have fixed everything that needs to be fixed.

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by LeAnn Cucchiara on 03/02/07 at 07:32:20

David Waldmann wrote:

This just happened to me (again :-[ ) this morning. I think you have fixed everything that needs to be fixed.

Thanks!! 8-)

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by lmk223a on 03/14/07 at 05:03:34

LeAnn Cucchiara wrote:

Why not just reverse the payment in AR-C? That should remove the funds from the AR invoice and bank account? ::)

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by LeAnn Cucchiara on 03/14/07 at 05:43:12

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?

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by JNAPIER on 03/14/07 at 08:58:47

LeAnn Cucchiara wrote:

Why not just reverse the payment in AR-C? That should remove the funds from the AR invoice and bank account? ::)

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]

Yes, Their statement will show all the problems and solutions with reversals. Lots of ins and outs ;)

The method I described works and is invisible to your customer 8-)

John

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by lmk223a on 03/14/07 at 10:09:40

LeAnn Cucchiara wrote:

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.

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by cathyh on 03/14/07 at 10:49:26

And you can always do a little special action with the white out for that particular statement. ;)

My accounting department doesn't like anything to mess with the bank reconciliation, and I try to avoid MDB.

Title: Re: Correction for AR-C Wrong GL Acct # Selected
Post by LeAnn Cucchiara on 03/14/07 at 11:27:50

[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!!