Stuck SOP invoice

(0) Share

Report

Posted on by Community Member

We posted a SOP invoice that appears to be stuck. I checked the SOP 10100 and SOP10200 tables and the records exist.

When I checked the SOP 30200, 30300, and 30201 tables, the record is not there.

When I do an inquiry of the invoice, it still shows as "Unposted" and not under history.

If I go to Transactions>Sales>Sales Transaction, I can see the record. But if i select to view it or post it, it says "This document number already exist. please enter a new document number".

What can I do to post this record through?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

Re: Stuck SOP invoice

Have you run Checklinks on the SOP Transactions tables yet? That would be the first thing to try.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Stuck SOP invoice

Yes, I ran checklinks but this did not resolve it. Apparently, the record for this sales invoice are also on the RM Tables as well. It just seems like the SOP invoice never made it to the SOP 30200 and other history tables.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Re: Stuck SOP invoice

Derrell,

Try running the Sales Utility 'Reconcile - Remove Sales Documents'. When you open the utilities window, select the radio button next to 'Remove Completed Documents'.

Kind regards,

Leslie

Was this reply helpful? Yes No
Melissa Sandrovich on at

Like (0)

Report

Re: Stuck SOP invoice

I just had this same issue come up with a customer. I tried checklinks and removed completed docs, but it didn't push to history. The one difference is they also use AA, however it looks as though that has also posted to completion. It just didn't finish the invoice move to SOP history.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Stuck SOP invoice

Sorry, I forgot to update this case. We found the root cause of this issue. These transactions were imported from eConnect. Some of these transactions had Line Item Comments. If the values execeeded the 500 character limit, this caused the posting issue. As a result, we had to delete some characters from the comment to post. Furthermore, we had to fix the eConnect Stored Procs so it truncated the values.

Was this reply helpful? Yes No
Melissa Sandrovich on at

Like (0)

Report

Re: Stuck SOP invoice

We don't have any comments on this document. Just seems to not have finished the posting process and we can't pull up the AR invoice nor the unposted SOP invoice.

Was this reply helpful? Yes No
Rennecia Barran on at

Like (0)

Report

Re: Stuck SOP invoice

I am getting the same problem. The invoice is unpaid. Will the "remove completed documents" move the document to status "HIST"? I do not want that to happen. When i go to the Sales Inquiry window the document has a status of "OPEN". However it is showing up in the sales transaction entry lookup window as though it is waiting to be posted however, i cannot select the document from the list. it says "This document number already exists. Please enter a new document number."

So my question essentially is: what will remove completed documents do for me? i do not want it to go to a status of "HIST" as it is unpaid.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Stuck SOP invoice

I don't think it will move it to HIST since it is not paid. if you have this issue, it may be that the record exist both in the SOP10100 and SOP30200 table. You should first check if your inventory and GL is updated. If so, then it was probably posted successfully, but you just need to clear the record from the SOP open table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Stuck SOP invoice

Hi! take a look into TX30000 table (COMPANY..Tax History)

I made a script debugger with the same error:

stmt(53318992):*/

{CALL GP.dbo.zDP_TX30000F_1('xxxxxxxxxxx',3,1,0.00000,-2147483648,'xxxxxxxxxxx',3,1,0.00000,2147483647)}

Thanks

Was this reply helpful? Yes No