Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / sales transactions open
Microsoft Dynamics GP (Archived)

sales transactions open

(0) ShareShare
ReportReport
Posted on by Community Member

We are running GP 10.00.1727.  When running Smartlist Sales Transactions we are restricting to Document Status = Unposted, Void Status = Normal and when we double click on some of the transactions we get  the sales transaction entry screen to open but then get a pop up "This document has been posted"  The document does not show against the customer and can only be viewed through Inquiry Sales Documents.  We have about 20 invoices that are having this problem and none were posted as part of the same batch.  We have run checklinks and reconcile but the problem persists.

Thanks for any help you can provide.  Dave Ahalt

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: sales transactions open

    The customer ids exist for the records.  Users do not have rights to delete SOP transactions.   We have decided to remove the records at the SQL level.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: sales transactions open

    Check the record for that entry in those SOP tables - 10101 and 102, 104 etc.

    Do they have a customer id - or is that field blank?  Are users allowed to delete a SOP entry?

    I have seen this - where a entry was started but not completed and it cannot be deleted- and since the cust id is a required field they are simple orphan records that will need to be cleared via sql.

  • Community Member Profile Picture
    Community Member on at
    Re: sales transactions open

    Did some SQL digging and found about 12 transactions which have this problem.  They appear on the unposted Smartlist in GP.   In SQL there are records in the SOP10100, SOP10101,SOP10102 and RM20101 with valid dates in the GLpostdt field.  But the corresponding transactions do not exist in the GL20000 while other transactions from the same batches are there.

  • Community Member Profile Picture
    Community Member on at
    Re: sales transactions open

    All Financial batches are posted and there are no batches for recovery.  Doing a SQL query the transactions only exist in SOP10100 and SOP10200 voidstts=0 and sopstatus=0

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: sales transactions open

    Check if the Batches are sitting in batch recovery or in the General Ledger waiting to be posted

  • Community Member Profile Picture
    Community Member on at
    Re: sales transactions open

    It is only visible on the Sales Order Processing Document Inquiry and Sales Transaction Inquiry Zoom screens.  On the entry screens it says The document has been posted.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: sales transactions open

    When you get to the transaction is it greyed out or is it available to modify?

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans