ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> overpay not reversed correctly
http://www.istechforum.com/YaBB.pl?num=1117143759

Message started by Laura Oliver on 05/26/05 at 13:42:39

Title: overpay not reversed correctly
Post by Laura Oliver on 05/26/05 at 13:42:39

A customer paid a huge number of invoices on a single check. Unfortunately they only sent 1 stub, so we could only account for about 1/3 of the invoices the customer was trying to pay for.

My helper had entered the check thru AR-C before she realised that she had no idea where to post some of the money. So she said she ended up posting it as an overpayment. A few days later the customer faxed us the other stubs. Well instead of going in to AR-C and using the credit created by the overpayment, she created another deposit using the amount of the other stubs.

Well this wrongly left me with a credit amt on the customers statement. And I couldn't post that deposit to the GL via GL-O because the amt included the original deposit and the (doubled) amt .

so I went into AR-C and entered a negative amt to "undo" the excessive stub amt. This allowed me to post the perfect deposit in GL-0 , but entering the negative amount did not correct the statement, it still shows the original overpay but doesn't reflect the negative amt I entered thru AR-c

Any help or ideas is greatly appreciated.

Thanks

Title: Re: overpay not reversed correctly
Post by lmk223a on 05/27/05 at 03:48:00

One suggestion is for the next time this happens, one could create an AR VOUCHER in AR-B to bill the customer for the duplicated deposit. Then offset this voucher with the customer credit in AR-C by entering a $0 deposit. This would make the AR statement correct as both items will clear the customer's account.

Sorry, I am not sure how to resolve your current situation.

Title: Re: overpay not reversed correctly
Post by Laura Oliver on 05/27/05 at 07:00:37

Why would going into AR-C and entering a negative amt fix this for GL-O but not correct the statement????

It seems like if it fixed it in one place it shuda fixed it everywhere.

Any all help appreciated.

Title: Re: overpay not reversed correctly
Post by Laura Oliver on 06/13/05 at 09:38:22

lmk223a suggested what I might to do "next time", which I appreciate, but I am still DESPERATE for help to fix the existing problem.

thanks,

Title: Re: overpay not reversed correctly
Post by JNAPIER on 06/13/05 at 09:46:06

Laura Oliver wrote:

lmk223a suggested what I might to do "next time", which I appreciate, but I am still DESPERATE for help to fix the existing problem.

thanks,

Does the cust aging look right? If so I know that the statement report as well as AR-R has issues with deposits and overpayments. If your aging is correct you need to do nothing except wait until the reports are fixed. You can also play with different settings when you print the statements. The aged format is great and they almost have it working correctly. Can you print it in a non aged format O.K.?

John

Title: Re: overpay not reversed correctly
Post by Laura Oliver on 06/14/05 at 06:18:51

Yes, I believe you are correct,

Just yesterday one of the girls posted a customer's payment to bank act#2 and it should have gone to bank act#1. I instructed her to reverse it as if it was an ISF. This worked with no problems.

Thanks,
Laura