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
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!!!
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.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
