Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

SOP transaction is missing in SOP history tables

Posted on by 4,084

A sales batch got interrupted during posting. it seems it was partially posted but still showing as unposted. when I attempt to open It I got the message that this document already exist.

The transaction exist in all RM tables and SOP10100/SOP10200 but missing in SOP30200 and SOP30300

Is there any way to populate these 2 history tables or to clear the transaction from RM tables and then post it again?

Thanks 

Categories:
  • Verified answer
    Alaa Ramadan Profile Picture
    Alaa Ramadan 4,084 on at
    RE: SOP transaction is missing in SOP history tables

    Unfortunately it is not exactly the same scenario. I ended up clearing the reference to the subject transaction from the open tables and then repost it.

  • Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at
    RE: SOP transaction is missing in SOP history tables

    Hey Alaa,

    Thank you for your post!

    Thank you as well Richard for your fantastic feedback.

    Alaa, have you been able to continue with the direction noted by Richard?

    Please let us know, if the issue is now resolved, we'd love feedback on what your solution was and if possible you could verify Richard's answer.

    Wishing you and yours healthy and happy days ahead.

    Nicole Fiskum

    Support Engineer

    Microsoft Dynamics

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SOP transaction is missing in SOP history tables

    Check out this note first. There may be an issue with quantities on this invoice.

    https://community.dynamics.com/gp/b/dynamicsgp/posts/how-to-use-sql-to-troubleshoot-a-sop-order-that-did-not-move-to-history-when-it-was-fully-invoiced

  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,084 on at
    RE: SOP transaction is missing in SOP history tables

    Yes it shows under inquiry as an open and upon clicking on it a message with '' this document has been removed from SOP history'

    Reconcile/remove utility did not help.

    I guess my only option is to add this invoice into SOP30200/SOP30300 manually then remove the unposted batch  

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SOP transaction is missing in SOP history tables

    Under Inquiry->Sales->Sales Documents does this invoice show as being in unposted or history? Have you tried Tools->Utilities->Sales->Reconcile-Remove Documents to move this document to history? Is this does not work you will need to SSMS to move this document to 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

Product updates

Dynamics 365 release plans