Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error on unposted SOP ...
Microsoft Dynamics GP (Archived)

Error on unposted SOP invoice

(0) ShareShare
ReportReport
Posted on by Josh P 2,895

Hi Community,

I have an error I have not yet encountered. SOP invoices are integrated using eConnect into a batch. All post except one. The error message is stating the document number already exists, but the document number is unique. It is also saved to the open SOP docs table. However, GP will not allow this document to be opened in the SOP Transaction Entry window. The batch will not post of course, and the edit list does not show this posting error.

I have run check links on the appropriate sales tables, and everything comes back with no errors. I have no batches in batch recovery, and SQL looks normal.

Anyone come across this before?

*This post is locked for comments

  • Josh P Profile Picture
    Josh P 2,895 on at
    RE: Error on unposted SOP invoice

    Thanks to you both for good suggestions. I was more wondering how this happened more than how to fix, but I suppose it will be a mystery for now.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Error on unposted SOP invoice

    I would go into SSMS and change the field for number of times printed to zero and then return to GP and delete it. This way all allocations will be removed properly.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Error on unposted SOP invoice

    Joshua,

    Yes, you can delete it from SOP10100 and SOP10200 and run check links, it will clear it from all the other SOP tables.

  • Josh P Profile Picture
    Josh P 2,895 on at
    RE: Error on unposted SOP invoice

    Hi Victoria,

    Unfortunately, it's not in the history table. That would be an easy fix. It is however in the open table SOP10100 in an unposted status.

    I would simply void this transaction from the batch, re-enter, and move on, but I cannot do this from the batch delete option since it has a print flag on it. I cannot get into the transaction entry window to void it.

    I wonder if I orphan the header / detail in SQL and run check links on it - will GP correct all the related problems?

    Thoughts?

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Error on unposted SOP invoice

    Joshua,

    I agree with Richard, my first reaction when I saw that error was to check to see if the SOP number is also in SOP30200. I have seen this exact error before when there was an issue with the posting and the SOP doc was posted and moved to the history tables, but it was not cleared out of the unposted tables.

    I am not 100% certain, but I am not sure if check links would catch this, and if it did, I am not sure what it would do about it.

  • Josh P Profile Picture
    Josh P 2,895 on at
    RE: Error on unposted SOP invoice

    Hi Richard,

    That is a good thought. Check links would have caught this error. I do have the invoice in the SOP10100 table, and everything looks normal. This is why the problem is so weird. Any other ideas?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Error on unposted SOP invoice

    I would start by looking in the SOP3020 table to see if that SOPNUMBE exist in there. Perhaps somehow there is an SOP document in history.

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