Welcome, Guest. Please Login.
05/14/25 at 16:00:00
News:
Home Help Search Login


Pages: 1
Send Topic Print
  Problem reversing out a Payment on Account (Read 781 times)
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
  Problem reversing out a Payment on Account
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??
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re:    Problem reversing out a Payment on Acc
Reply #1 - 05/26/04 at 15:05:16
 
What is the ISTECH Enhancement date on your AR-C, We fixed this issue just recently.
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re:    Problem reversing out a Payment on Acc
Reply #2 - 05/27/04 at 07:13:50
 
Ok, you caught me.  It's 01/16/04  cry
 
Can I modify the remaining amount on the reversal transaction to patch up the database?
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re:    Problem reversing out a Payment on Acc
Reply #3 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re:    Problem reversing out a Payment on Acc
Reply #4 - 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.
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re:    Problem reversing out a Payment on Acc
Reply #5 - 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.
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Pages: 1
Send Topic Print