web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / This document has been...
Microsoft Dynamics GP (Archived)

This document has been removed from Sales Order Processing history.

(0) ShareShare
ReportReport
Posted on by Renee Leung 6,775

This message appears when zooming into an SOP invoice that has a status of 'open'.  The GL shows that this trx's distributions have been posted.  If you zoom into a Detail Inquiry and click on 'source document', it takes you to a zoom of this posted trx.  But for whatever reason, you cannot access this same zoom if you go to Inquiry by Customer within Sales module or Inquiry by Document.  There is also an unposted batch containing a duplicate of this transaction.  So somehow the transaction got posted but still sits as unposted. You cannot open the unposted transaction.  The message 'This document number already exists" appears. But you can access the batch.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    It appears the transaction only partially posted, putting the entries in gl, adding the invoice number to the SOP key table, but not removing the invoice from the open table and putting it in the history table.  You are going to need a consultant with good SQL GP Surgical skills to go into the db and correct this.

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at

    That sounds like it.  However, the transaction should not be history if it has not yet been paid - correct? We can still access the open invoice in the Apply Documents window.

  • Tristan Clores Profile Picture
    Tristan Clores 2,812 on at

    Hi,

    I recommend running Reconcile - Remove Sales Documents (MDGP | Tools | Utilities | Sales | Reconcile - Remove Sales Documents) and use the Remove Completed Documents option.

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at

    No luck. We had already tried running the Reconcile-Remove Sales Documents using both options 'reconcile' and 'remove sales documents'. Any other ideas? We've tried CheckLinks as well on Sales Work, Sales History, Receivables Open Transaction Files and Receivables Transaction History Files

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    I faced same issue and it got resolved. Please find link below. I have document issue in my blog.

    sandipdjadhav.blogspot.com/.../error-this-document-has-been-removed.html

    Thanks

    Sandip

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at

    Thanks Sandip, but unfortunately no luck. Having a blank description doesn't make a difference - error still appears.  Filling the description with the same value as the invoice number doesn't make a difference - same error.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Wow. There is something going on Receivable Tables. Can you check RM20101 description column? After you make changes what it shows there?

    Try to match Master ID, TrxSource with SOP30200 or SOP10100 tables

    Thanks

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at

    The description column in RM20101 is blank.  The SOP30200 table does not hold a record for this.  SOP10100 does hold a record for this, but that is because there is an unposted duplicate of this trx.  Any ideas?

    Thanks

  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 957 Super User 2025 Season 2 on at

    Try setting the Transaction Description to be the invoice number (instead of blank).  That worked for me.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans