ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Problem reversing out a Payment on Account
http://www.istechforum.com/YaBB.pl?num=1085611851

Message started by kevind on 05/26/04 at 14:50:51

Title: Problem reversing out a Payment on Account
Post by kevind on 05/26/04 at 14:50:51

A Payment for a customer was entered to the wrong customer as a payment on account.

We tried to reverse it out by entering a negitive payment to the customer. AR-C asked if this was an NSF for Reversal. We chose Reversal. All the GL stuff looks correct.

In the customers aging, it still shows the payment on account with a negitive open amt and negitive Original Amt. This makes the aging incorrect. If we do a AR Listing and show paid and unpaid, there is a reversal entry that has a $0 amount in the open amt column and a positive amount in the Original Amt.

It looks like it should have had a positive amount in the Open Amt column also so that the payment on account could be washed against the reversal.

Now to really confuse the issue, In maintain database, I find that the Reversal transaction has a positive Original amount and a NEGITIVE Amount Remaining!

Should the amount Remaining have been positive??

Title: Re: Problem reversing out a Payment on Acc
Post by NovaZyg on 05/26/04 at 15:05:16

What is the ISTECH Enhancement date on your AR-C, We fixed this issue just recently.

Title: Re: Problem reversing out a Payment on Acc
Post by kevind on 05/27/04 at 07:13:50

Ok, you caught me. It's 01/16/04 :'(

Can I modify the remaining amount on the reversal transaction to patch up the database?

Title: Re: Problem reversing out a Payment on Acc
Post by Lynn Pantic on 05/29/04 at 06:52:55

Probably but you also need to look at BKART and see what is in there, that is actually what calculates for the Aging.

Title: Re: Problem reversing out a Payment on Acc
Post by kevind on 06/02/04 at 12:34:16

Lynn,
What should I be looking for in the BKART file??

This is what I see:
BKART_CUST=DS59
BKART_TRXN=68611
BKART_TYPE=O
BKAR_DISC=0
BKART_AMOUNT=-1912.97
BKART_POSTDATE=5/25/2004
BKART_CNTR=1
BKART_ENTDATE=5/25/2004
BKART_TRXNLINK=0
BKART_INVC=0
BKART_CHECK=0
BKART_NOTE=

This is the only line I can find with this dollar Amount.

Title: Re: Problem reversing out a Payment on Acc
Post by kevind on 06/02/04 at 12:45:18

Well, I went ahead and changed the amount remaining on the Check reversal transaction in BKARINVT to an amount that matched the transcation amount.

I then went into AR-C and applied the open credit against the Reversal and the Aging looks fine.

This did add a record to the BKART file that offset the Record listed above.

Seems to be OK. If I have missed something, please let me know.