web

You’re offline. This is a read only version of the page.

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,971

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!

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator 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;

Was this reply helpful? Yes No
joshtechsolutions 4,971 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?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator 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'

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 3,377

#2

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans