News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How do you locate a PO...

Small and medium business | Business Central, N...

Answered

How do you locate a PO in the SQL, what is the queries to check?

(0) Share

Report

Report

Posted on by joshtechsolutions

4,376

Hi Community,

I would like to locate PO in SQL and i wonder if you can help me to understand what are the SQL query I should be inputing.

Thank you!

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: How do you locate a PO in the SQL, what is the queries to check?

Hi, just to add a useful info

https://www.w3schools.com/sql/sql_where.asp

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: How do you locate a PO in the SQL, what is the queries to check?

Hi,

You can add one more filter with No.

SELECT *

FROM [Document No_]

where [Document Type] = 1 and [No_] ='YourPONohere'
joshtechsolutions 4,376 on at

Like (0)

Report

RE: How do you locate a PO in the SQL, what is the queries to check?

Thanks Nitin, what if I only wants to select one purchase Order?
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (1)

Report

RE: How do you locate a PO in the SQL, what is the queries to check?

Hi,

You can use below

SELECT *

FROM YourTablenamehere

where [Document Type] = 1;

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2

Martin Dráb 230,370 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans