Forwarding from our accounting manager:
 
"I have a customer's deposit that is stuck on the Open Customer Deposits report as a "customer not found". It belongs to Gentex (code GENCORP). I looked up the customer code & it has not been deleted (or archived).
 
The payment would have been done under AR-C & listed as a "deposit on account" prior to posting it; which is not something new. We actually enter deposits on account through AR-C when it is included in a batch deposit (such as credit card payments). If it's a single customer deposit (such as a wire transfer or EFT), we will enter them through AR-N directly.
 
This issue is causing the Accounts Receivable aging to not coincide with the balance sheet. The difference is exactly the amount of the deposit in question.
 
Can we find out how this can be fixed? Does it need a maintain database? As you can see from one of the attachments, I am unable to edit the transaction in AR-N and there is no way to reverse it without an account code. I am pretty sure that deleting it from AR-N (if it allowed me to) would make the issue worse."
 
Also she mentions:  "The customer has been invoiced for the order, but it is the only thing on their account. The deposit is the full payment for the order, but I am unable to connect the two."
And when asked if it is attached to a SO she replies "No, I am unable to attach it to a Sales Order because of it's status. I usually have to do that after the fact by editing the deposit."
 
Any suggestions on how I fix this for her?
 
Kind regards,
 
Val

sorry, I don't have any external location to post attachments she provided to me. But to answer the question, as she states yes she does see it in AR-N but is unable to edit it.  Holly says " am unable to edit the transaction in AR-N and there is no way to reverse it without an account code. I am pretty sure that deleting it from AR-N (if it allowed me to) would make the issue worse."  
 
Any ideas?

Ok, I will try to get a moment and look at those.  Thanks!  Will let you know.
 
Val

The point (as I understand it) is that this deposit is NOT attached to the customer so the customer code in the record is blank and needs to be edited.

Problem solved: In our test company, I backed up then edited the BKARDEP table via Maintain DB and added the customer code to the record where it was missing. Then I let the accounting manager know, and she went in to attached the deposit.  Only issue was the sales order had already been invoiced and closed.  So she tried some thing (and I may be missing some steps in what she told me) where she re-opened the sales order, entered a random dollar value, released the order, posted the invoice, applied the payments and then credited the dummy invoice and now everything balances.  
 
So we did the same thing in the production company and same result, the issue is resolved.
 
Thanks for the help!
 
Val