I stumped PT Support - Help Me!

[bigjoshc]

Here's the events for a customer that I am having problems with:

3/31/03 $1,500 Prepayment
4/30/03 Invoice Entered for $3,161
5/16/03 Applied $1,500 Prepayment to Invoice in Receipts
5/30/03 Entered $1,661 customer payment in receipts & applied to the open invoice.

Now here's the problem:
The aged receivables shows a credit balance for this customer in the amount of $1,661. When I pull up the cash receipts journal and try to open the transaction, it says that the invoice doesn't exist. Yet, when I go to the sales journal & pull up the invoice, it shows paid in ful. I can not open the transaction that was on 5/30/03. I can not delete the invoice entered on 4/30/03. Integrity Check comes up with no errors. I reindexed the Jounal Header, Journal Rows, Customers. I also ran the Customer/Journal Check with no errors. I don't know what to do now. Peachtree Support actually said that they can't help me.

[dringstrom]

You may want to submit your company to a data recover service, such as the one listed at the top of the screen, for a free analysis to see if your company is corrupted in a fashion that the integrity check isn't finding. The only other thing that comes to mind for me is to try the Repair Company feature in Peachtree. This sometimes fixes things that the Integrity Check can't, but sometimes it makes the problem worse. Make sure to have a couple of back-ups before you try it.

Good luck! If this doesn't work for you, perhaps someone else will jump in with an opinion.

[Susan Weagle]

I've had the same problem with prepayments. I've tried data verification. Didn't expect it to help (and it didn't) but it was worth a try. Glad to hear I didn't waste the money on tech support since they can't help with this problem.

[TheWolf]

Originally posted by bigjoshc
Here's the events for a customer that I am having problems with:

3/31/03 $1,500 Prepayment
4/30/03 Invoice Entered for $3,161
5/16/03 Applied $1,500 Prepayment to Invoice in Receipts
5/30/03 Entered $1,661 customer payment in receipts & applied to the open invoice.

Now here's the problem:
The aged receivables shows a credit balance for this customer in the amount of $1,661. When I pull up the cash receipts journal and try to open the transaction, it says that the invoice doesn't exist. Yet, when I go to the sales journal & pull up the invoice, it shows paid in ful. I can not open the transaction that was on 5/30/03. I can not delete the invoice entered on 4/30/03. Integrity Check comes up with no errors. I reindexed the Jounal Header, Journal Rows, Customers. I also ran the Customer/Journal Check with no errors. I don't know what to do now. Peachtree Support actually said that they can't help me.

You got bad support. They actually have a document called "Non-Existing Invoice Errors". Basically it is a link that is broken that connects the receipt with the invoice. This is a form of data damage but not to the actual files. Recreate the invoice for a penny, using the same invoice number. If it says that invoice number has already been used then add a period after the number. Now pull the invoice up and you should get a message stating the original invoice number could not be found but the new one was and do you want to use it, select yes. Now delete the receipt, go back and delete both invoices. Now rekey the original invoice and attach the receipt to it again.