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


Pages: 1
Send Topic Print
Deleting a customer payment (Read 946 times)
Mike_Habich
Full Member
***




Posts: 227
Deleting a customer payment
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
Back to top
 
 
Email   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Deleting a customer payment
Reply #1 - 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
Back to top
 
 
Email   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Deleting a customer payment
Reply #2 - 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.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Deleting a customer payment
Reply #3 - 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?
Back to top
 
 
Email   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Deleting a customer payment
Reply #4 - 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?
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Deleting a customer payment
Reply #5 - 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!
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Deleting a customer payment
Reply #6 - 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...
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Deleting a customer payment
Reply #7 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Deleting a customer payment
Reply #8 - 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
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Deleting a customer payment
Reply #9 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Deleting a customer payment
Reply #10 - 04/11/05 at 07:48:51
 
AR-A or AR-Q, credit info button.  Nowhere else that I've noticed.
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Deleting a customer payment
Reply #11 - 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
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print