Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Stuck SOP invoice
Microsoft Dynamics GP (Archived)

Stuck SOP invoice

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • Rennecia Barran Profile Picture
    Rennecia Barran on at
    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.

  • Melissa Sandrovich Profile Picture
    Melissa Sandrovich on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • Melissa Sandrovich Profile Picture
    Melissa Sandrovich on at
    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.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Stuck SOP invoice

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans