ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Deleting a customer payment
http://www.istechforum.com/YaBB.pl?num=1112989617

Message started by Mike_Habich on 04/08/05 at 11:46:57

Title: Deleting a customer payment
Post by Mike_Habich on 04/08/05 at 11:46:57

A customer payment was posted to the wrong bank account. I'd simply reverse it, but the %^&*%*( who made the initial mistake tried to fix it, and seems to have entered another positive payment under the same check number rather than a negative "payment" to reverse it. Since there are duplicate check numbers, I can't reverse the payment now.

I'd like to delete the "fix" so I can reverse the original mis-posted payment. It will have to be deleted from AR and the wrong bank account in GL, and from the check register in the wrong bank account. The best approach I can think of is to use Maintain Database, but on what tables? My guess:
BKAPCHKF

Title: Re: Deleting a customer payment
Post by Mike_Habich on 04/08/05 at 11:51:25

....
BKAPCHKF AR deposit
BKAPCHKH AR deposit history
BKARDEP AR deposits
BKAREIVT AR trans
others for bank accounts?

Better way to do this?

Thanks,
Mike

Title: Re: Deleting a customer payment
Post by aricon on 04/08/05 at 11:58:49

BKGLCHK for checks
BKGLTRANS for the GL postings

And no, I don't think there would be ANY other way.

Title: Re: Deleting a customer payment
Post by Mike_Habich on 04/08/05 at 12:38:47

BKAP... weren't relevant; A/P, of course. My mistake.

BKARDEP ...ok, deleted a customer deposit created in the "fix"

BKGLCHK...ok, deleted those

BKGLTRANS...that's for posted GL trans, and these haven't been posted...could they be deleted from G/L?

Anything else?

Title: Re: Deleting a customer payment
Post by Mike_Habich on 04/08/05 at 12:43:46

I mean GL-P, edit GL batch entries. It would certainly take care of the unposted GL transactions, but what about AR aging and such?

Title: Re: Deleting a customer payment
Post by Lynn Pantic on 04/08/05 at 14:32:07

AR aging uses BKARINVT and BKART and possibly BKARTNOT if there are deposits and other things involved. There are linked transaction numbers of the different BKART records so be careful, you can get yourself into trouble.

Also BKARCHKF - and the BKGLCHK and BKGLTEMP already mentioned. All in all, not a pretty picture!

Title: Re: Deleting a customer payment
Post by Mike_Habich on 04/08/05 at 16:45:49

No, it isn't. I figure that if I log onto the forum and see my name as last poster on more than one topic it hasn't been a good day.

Nobody did mention BKGLTEMP...I'm assuming that GL-P (edit GL batch entries) is the best way to fix that, and that it doesn't do anything else. Maintain Database for the rest. Monday...

Title: Re: Deleting a customer payment
Post by Lynn Pantic on 04/08/05 at 18:13:08

Your assumption about GL-P is correct. Assuming of course that none of the GL entries have been posted.

Title: Re: Deleting a customer payment
Post by Mike_Habich on 04/11/05 at 07:17:48

Almost there. Deleted unposted GL trans in GL-P, deleted records from tables listed above (being careful of linked records). Was then able to reverse original mistakes and correct through AR-C.

Aging, payment history, GL are all OK now.

When I query credit history on one customer, it shows a deposit. Deposit doesn't show in AR-N or anywhere else. Where is the deposit in the customer record?

Thanks again,
Mike

Title: Re: Deleting a customer payment
Post by Lynn Pantic on 04/11/05 at 07:31:16

Where exactly are you seeing the deposit? If you got it off the Aging, it should be gone.

Title: Re: Deleting a customer payment
Post by Mike_Habich on 04/11/05 at 07:48:51

AR-A or AR-Q, credit info button. Nowhere else that I've noticed.

Title: Re: Deleting a customer payment
Post by Lynn Pantic on 04/11/05 at 09:01:04

If you bring the customer up in AR-C, it should recalculate that. It is a total field in BKARCUST