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) / Remove from unposted s...
Microsoft Dynamics GP (Archived)

Remove from unposted status

(0) ShareShare
ReportReport
Posted on by Community Member

Details:

 The order came in fine from the CRC, processed to ASC and back to GP, at some point after the successful fulfill of the order from GP to ASC, someone deleted item on the order.

 

  I instructed SOP’s to add the line item again, manually fulfill and invoice. They did completing invoice A1443176.

The order remained in Unposted with no line detail and in History with the line detail. The invoice is fine.

 Typically, when this is seen; order in unposted and history, I reconcile the order and remove completed documents to clear the unposted presence.

  I did this, but no change.

 Then I took the issue in Check Links, but running the Sales Work Check Link. I ran this when no one was in GP.

 Still did not affect the unposted presence.

Any help is greatly appreciated.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at

    It seems that you might need to delete the duplicated order from the sales work header table SOP10100 using SQL.

    This script will help you to confirm if there duplicated SOP documents in your company database:

    select SOPTYPE, SOPNUMBE, COUNT(*) as [COUNT] from
    (
    select SOPTYPE, SOPNUMBE from SOP10100 W
    UNION ALL
    select SOPTYPE, SOPNUMBE from SOP30200 H
    ) C
    group by SOPTYPE, SOPNUMBE
    having COUNT(*) > 1

    Thanks

    Jorge

  • Community Member Profile Picture
    Community Member on at

    Thanks Jorge!

    Do you have a script to delete the duplicate order?

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at

    No problem, but before sending it to you, can you pls send me the result of the script I send you.

  • Community Member Profile Picture
    Community Member on at

    Thanks!

    SOPTYPE SOPNUMBE COUNT

    2 092935711             2

    2 H38115               2

    2 H38276               2

    2 ORD00000000000658     2

    2 SO122984             2

    2 SO30312               2

    2 SO31195               2

    2 SO31219               2

    2 SO31225               2

    2 SO31241               2

    2 SO31308               2

    2 SO31312               2

    2 SO31452               2

    2 SO34681               2

    2 SO35475               2

    2 SO42269               2

    2 SO53815               2

    2 WEB01371932           2    ----This the order stuck

    2 WEB01673767           2

    2 WEB0993391           2

  • Verified answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at

    The SQL script you need is very simple:

    DELETE FROM SOP10100

    WHERE SOPTYPE = 2 AND SOPNUMBE = 'WEB01371932'

    It is always a good idea to do database backup before deleting any data.

    Thanks

    Jorge

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