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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / SQL query to pull Tran...
Microsoft Dynamics RMS (Archived)

SQL query to pull Transaction/Work Order Data

(0) ShareShare
ReportReport
Posted on by Community Member

 

  Anyone know the SQL query to pull the data from a Transaction or Work Order?  I want to build a delivery form/work flow in Sharepoint and need to be able to pull this information from the Database

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: SQL query to pull Transaction/Work Order Data

    use rmsdatabase

    select item.ItemLookupCode, item.Description,item.price, OrderEntry.QuantityOnOrder, OrderEntry.TransactionTime

    from dbo.item join dbo.OrderEntry

    on item.id = OrderEntry.ItemID

    where OrderID = '45'   --- find Work Order

    and comment = '*d'    ---  Comment items set for delivery

  • Community Member Profile Picture
    Community Member on at
    RE: SQL query to pull Transaction/Work Order Data

    Apologies item.price should be orderentry.fullprice to get the correct information in the SELECT statement.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans