Purchase Order lines

(0) Share

Report

Posted on by BobbyHelp

105

Hi MS Community,

Is there a report that I can export that includes:

Purchase header:

1. Order Date or approval date

2. Purchase order number

Purchase line:

1. Item

2. QTY

3. Unit cost

4. Extended cost (QTY x Unit Cost).

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (11)

Answers (3)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

The closest report that I know is "Outstanding Purch.Order Status"

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

Run the page directly. It’s page 518. This gives you the method to do it: docs.microsoft.com/.../devenv-web-client-urls

Given you have a calculated field you might consider MahGah’s suggestion in combination with an Excel layout.

Other option would be to use power query in excel and you can layer in a custom column for your calculation. To do that publish page 518 as a web service and then use Excel’s “get data” option for OData. Paste in the URL you get after publishing a web service for page 518. Power BI offers up a similar possibility.

Was this reply helpful? Yes No
Suggested answer

Vinita_Kas 336 on at

Like (0)

Report

Hi

These are the only reports available in standard

docs.microsoft.com/.../purchase-reports

If this does not work then you can connect Power BI and get more reports from the system by adding the fields you need

Regards

Vinita

Was this reply helpful? Yes No
Verified answer

Davina Webb 25 on at

Like (0)

Report
Hi,

there is a workaround to view/extract purchase order lines in the system.

Open any purchase order and select a line.

Use the help function (Ctrl+ALT+F1 or see below):

Help (?)

Help and Support

Inspect Pages and Data

Then:

If a PO line is selected, you should see the table in the panel 'purchase order lines' and then you can click the link to view the table

This opens the entries with all the detail that you need and you can export to excel

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Hope the following helps.

https://yzhums.com/8876/

Thanks.

ZHU

Was this reply helpful? Yes No
BobbyHelp 105 on at

Like (0)

Report

Hi Davinna Webb,

I wasn't able to "click the link to view the table" as suggested. Is the link supposed to be located here (See the red circle in screen shot below).

Or somewhere else?

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

That option is based on having a specific permission set. It’s also only a good option for one offs. I’d urge you to review the other options with my consideration

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

I go to a specific item, drill on the Qty on Purch Lines field, then adjust my filters so that I have all purchase lines, then I can Export to Excel and do a little work.

Was this reply helpful? Yes No
Verified answer

Avinash B 1,455 on at

Like (0)

Report

I would suggest publish page 518 as web service, copy the OData url.

Create a new excel work book, go to Data > Get Data > From other sources > From Odata feed.

Enter the URL and provide the authentication.

The data will retrieved to the excel automatically.

Hope it helps.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

great idea!

Was this reply helpful? Yes No