ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> reversal inccorrectly shows on customer statement
http://www.istechforum.com/YaBB.pl?num=1552344457

Message started by Laura Oliver on 03/11/19 at 15:47:37

Title: reversal inccorrectly shows on customer statement
Post by Laura Oliver on 03/11/19 at 15:47:37

A new helper accidentally entered a January 2019 deposit incorrectly. I reversed it. Now I find that the statement reflects the reversal and it looks likes the customers owes us more money than they really do.
AR-F is correct but AR-E is wrong.
Any ideas on what I should do?
Thanks
Laura

Title: Re: reversal inccorrectly shows on customer statem
Post by Laura Oliver on 06/25/19 at 12:57:04

Any ideas?
All help appreciated.
Thanks
Laura

Title: Re: reversal inccorrectly shows on customer statem
Post by Laura Oliver on 09/16/19 at 15:20:44

Any ideas?
Thanks
Laura

Title: Re: reversal inccorrectly shows on customer statem
Post by Laura Oliver on 04/07/20 at 11:43:34

I went to BKARINVT. Searched by date 1-6-2019.
BARINVT showed
a payment for -36025.00
and a reversal for 36025.00 (this needs to be deleted)
also there is a NSF check for 210.00 (this needs to be deleted)

I think the problem could be fixed if i zeroed out:
BKAR.INVT. AMTRM shows 36025.00
BKAR.INVT. AMTRM shows 210.00

I am thinking about temporarily changing the two non zero amounts in BKAR.INVT. AMTRM to $1.00 each and see what happens. I dont really want to zero them out yet because i am thinking/hoping i discover whatever reciprocal action i really need to take and then i can go back and change the $1.00 to 36025.00 and $210.00 and take the correct action. But meanwhile temporarily changing BKAR.INVT. AMTRM to $1.00 will make my statement look closer to correct and shouldn't effect the AR Listing in AR-E.

I will think about this for a few days and in the meanwhile if anyone has any suggestions I would appreciate them.
Thanks
Laura

Title: Re: reversal inccorrectly shows on customer statem
Post by Laura Oliver on 04/08/20 at 14:10:24

I made the changes and I don't see any ramifications yet. Originally I said AR-F was perfect but I must have been overlooking the NSF for 210.00 or at least now AR-F shows:
NSF CHECK 100003 122 01/06/19 458 0.00 0.00 0.00 0.00 210.00 210.00

But AR-E is now closer because I changed the amounts in BKAR.INVT. AMTRM to .02 and .03 and these amounts do print out on the statement which is better than 36025.00 and 210.00
I will live with these .02 and .03 printing out on the statement for a while. My next project will be to fix AR-E so it doesnt reflect the NSF for 210.00
I did notice that BKAR.INVT.CLOSD had a zero date.