Deleted Invoice posted on Revenue, but not on AR ??

(0) Share

Report

Posted on by Community Member

Hello,

So I was in the middle of creating an invoice, found an error and deleted it before posting.

But I still found this entry as posted in the revenue account. The most weird thing is that this invoice is not there on the AR account.

Does anybody know why GP is doing this? We had another employee who had the same issue. I am wondering if this is a SQL problem or maybe the setting I should fix.

Thank you!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

GMA 1,074 on at

Like (0)

Report
Copy link

Link copied!

What happens when you review Financial Detail for the revenue account; find the entry that posted, select it and then click the "Journal Entry" link to open the entire Journal Entry?

Do you see the entire journal entry or do you just see half (as you describe in your question)? This will tell us if it was a SQL issue or not; because GP shouldn't allow a one-sided entry unless there was an issue during posting.

Another question is that you mention deleting the invoice before posting. If it didn't post, it shouldn't show up in the system at all. Only an interruption during posting will cause a one-sided entry. So I may be missing some details. Does the invoices show up in the Sales module when inquiring for the customer?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

So when I create the invoice, I used deferral, for example for 01/01/15-12/31/15. I used deferred revenue to me amortized to Revenue. so I only see debit deferred rev credit revenue entry on GL. There is no AR and Def Rev entry. when I click on the JE to track down to the invoice, it says unavailable to open.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Grady, to answer your last question, I do not see the invoice when I pull up the client in the Sales module. On the Sales module, it's completely deleted. but somehow it got posted on GL on the revenue side.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Have you tried to run Checklink against Sales transactions. Please take a backup before doing this. If you are 100% sure the invoice is not posted please check it on inquiry by customer as well as receivable statement after the check link, then reverse the sales journal manually to remove it from revenue.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

While I agree with the step taken to run check links, I think you need to do this in Financial and then reconcile the batches as well.

If the transaction did not post then it should not be anywhere, let alone Sales.

If it 'partially' posted and then failed - I would try to hunt it down.

Run Check Links, Financial and then see what happens when you look for the JE.

Was this reply helpful? Yes No