News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV forum How do you locate a PO...

Microsoft Dynamics NAV forum

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

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!

Categories:

Development / Customization / SDK

Administration and Setup

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 70,124 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,025 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'
joshtechsolutions 4,235 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,025 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;

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2

Martin Dráb 228,651 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans