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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SOP orders not closing

(0) ShareShare
ReportReport
Posted on by

  We have several Sales Orders that have been fully transferred to Invoice but we are unable to move them to History.  When reviewing the documents in the Sales Document Inquiry window there is a remaining subtotal showing for the Order even though all of the lines have been fully satisfied and no quantities are remaining to invoice.  In the SOP10100 table the same amount can be seen in the REMSUBTO and OREMSUBT columns.  The Invoices for all of the orders are in History.

We have reconciled the orders and run Checklinks on the Sales series but the orders remain open. Reconcile/Remove has no impact. 

Would the next step be to update the REMSBTO and OREMSUBT amounts in SQL to be 0.00 and then try Reconcile/Remove?  Thank you in advance!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi - are there any 3rd party modifications installed?

    If you look at the Sales Transaction Entry window  - is there a period at the start or at the end of the Window Name?

    How are Sales orders entered - manually or integrated in some way?

    Ian.

  • Community Member Profile Picture
    on at

    Hi Ian - just a follow up.  Most of the orders are integrated into GP.  We were able to narrow down the source to a few items and found that there had been some problems with these particular items on the orders initially in GP.  The SOP 10200 was still showing quantities for the lines - we were able to cancel the line quantities in GP which then allowed the orders to close.  Thank you for your response!  

  • Community Member Profile Picture
    on at

    How are you integrating sales orders? Using eonnect or a custom table integration?

    Best regards,

    Ian.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans