BeyondERP.Newsletter
Menu

Report page · Procurement and sourcing

Open purchase order lines by item report

A report that lists open purchase order lines by item.

Business process
Procure goods and services
Menu item
output:VendPurchOpenLinesByItem
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that lists open purchase order lines by item.
What you do hereUse this report to see which purchase order lines are still open for each item. In the dialog you choose where the report goes (screen by default), which records to include, and whether it runs in the background.
Open purchase order lines by item report page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processProcure goods and services
Menu pathProcurement and sourcing › Inquiries and reports › Status › Open purchase order lines by item report
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itWhen you need the status of incoming supply per item, for example for availability questions or planning reviews.
How oftenOn demand, whenever incoming supply per item is reviewed.
What the output showsOpen purchase order lines per item with vendor, delivery date and remaining quantity. Remaining quantity is what is still on order and not yet received.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Procurement and sourcing > Inquiries and reports > Status > Open purchase order lines by item report.
  2. Use Records to include to select the items or item groups whose incoming supply you want to see.
  3. Read the open quantity per item to see what is still on order, for example before you answer a customer about availability.
  4. Compare the open quantity with the item's demand; an item with demand but no open lines needs a new purchase order. The same report is on Purchase orders > Purchase order follow-up for expediting.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The report only shows open lines by item; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:VendPurchOpenLinesByItem Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itPurchasing manager TradePurchasingManagerAccounts payable manager VendInvoiceAccountsPayableManagerBuying agent TradeBuyingAgentProject manager ProjProjectManagerAccountant LedgerAccountantGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:VendPurchOpenLinesByItem
Everyone

7Sources