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) / Business Alert
Microsoft Dynamics GP (Archived)

Business Alert

(0) ShareShare
ReportReport
Posted on by Community Member

Hi, I'm trying to create a Business Alert that would tell me if an open sales order has passed it's requested ship date.  Having trouble finding the table.  Any recommendations?  It doesn't have to be through Business Alerts if anyone has a better suggestion.  Oh and I'm on Dynamics GP2010.  Thanks.

*This post is locked for comments

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

    Hi Angela,

    If you want to track for Saved order status, for the whole order's requested ship date from SOP10100 header table &  if you want to track each & every line items of your particular Sales Order then you can look on SOP10200 line table.

    To track from the Posted Sales documents, for the whole invoice requested ship date from SOP30200 header table &  if you want to track each & every line items of your particular Sales invoice then you can look on SOP30300 line table.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    The Requested Ship Date for the History(Posted/transferred) Sales Orders found in Sales Transaction History (SOP30200) table.

    For you reference, have a look on the below link.

    victoriayudin.com/.../sop-tables

    Hope this helps!!!

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