Purchasing reports and analytical tasks

Purchasing reports and analytical tasks give procurement and business professionals insights and statistics about current and past purchase activities.

Explore purchasing reports with Report Explorer

To get an overview of the reports that are available for purchasing, choose All Reports on your Home page. This action opens the Role Explorer, which is filtered to the features in the Reports & Analysis option. Under the Purchasing heading, choose Explore.

[Example of reports on a role center.]

To learn more, go to Finding reports with the Role Explorer.

Purchasing report overview

The following table describes some of the key reports related to purchasing. The reports help different roles in purchasing departments make informed decisions to optimize their operations.

To do thisOpen this report in Business Central (CTRL+select)Learn moreID
Use the report when a purchasing agent needs to send a formal purchase order to a vendor, so the vendor receives a document that confirms the items, quantities, costs, and delivery expectations.Standard Purchase - OrderAbout Standard Purchase - Order1322
Analyze vendor balances at the end of each period directly in Excel, by period (LCY), by Period (FCY), or an overview Due by Currencies. Monitor unpaid invoices, and prioritize payments for overdue accounts.Aged Accounts Payable ExcelAbout Aged Accounts Payable Excel4403
Analyze the effect of vendors on cash flow, and prioritize vendor payments.Vendor - Top 10 List ExcelAbout Vendor - Top 10 List Excel4404
Analyze and reconcile vendor balances at the end of a period.Vendor - Detail Trial BalanceAbout Vendor - Detail Trial Balance304
Analyze outstanding purchase orders to understand expected purchase volume. Forecast your monthly expected costs and expenses.Vendor - Order SummaryAbout Vendor - Order Summary307
Analyze outstanding purchase orders and understand expected purchase volume from vendors. Compare overall outstanding receipts with the expected receipt date and highlight overdue back orders.Vendor - Order DetailAbout Vendor - Order Detail308
Track vendor performance and ensure that your company gets the best value for money.Purchase StatisticsAbout Purchase Statistics312
Analyze item purchases per vendor to manage inventory procurement and improve supply chain processes. Assess the relationship between discounts, cost amounts, and volume of item purchases.Vendor/Item PurchasesAbout Vendor/Item Purchases313
Get a list of vendors by item or items per vendor.Vendor Item catalog

Note: This report isn't available in the United States, Canada, and Mexico. Instead, use the Item/Vendor Catalog (10164) report.
About Vendor Item catalog320
Analyze the closing balance of vendors at the end of the period and reconcile the vendor subledger against the payables accounts in the general ledger.Vendor - Trial BalanceAbout Vendor - Trial Balance329
Get a daily transaction overview for vendor postings, similar in intent to a vendor day book or a chronological audit-style listing of vendor postings.Day Book Vendor Ledger EntryAbout Day Book Vendor Ledger Entry2502
Explore the availability of items for shipment on purchase documents, such as return orders.Purchase Reservation AvailabilityAbout Purchase Reservation Availability409
Analyze outstanding purchase orders to understand the expected purchase volume for items. Compare overall outstanding receipts with the expected receipt date to highlight overdue back orders.Inventory Purchase OrdersAbout Inventory Purchase Orders709
Analyze your vendor purchases per item to manage inventory procurement and improve supply chain processes. Assess the relationship between discounts, the cost amount, and the volume of item purchases.Inventory Vendor PurchasesAbout Inventory Vendor Purchases714
Review or share vendor catalogs, compare vendor offerings, and support purchasing decisions.Item/vendor catalogAbout Item/vendor catalog720
Use the report when an accounts payable clerk or e-document administrator wants to preview a purchase invoice layout with sample vendor and line data before enabling it for live e-document processing.E-Doc Sample Purchase InvoiceAbout E-Doc Sample Purchase Invoice6102
This is a legacy report for vendor analysis. See report documentation for alternatives.Vendor - ListAbout Vendor - List301
This report is a legacy report for vendor analysis. See report documentation for alternatives.Vendor - Top 10 ListAbout Vendor - Top 10 List311
This is a legacy report for accounts payable. See report documentation for alternatives.Payments on HoldAbout Payments on Hold319
This is a legacy report for aged accounts payable. See report documentation for alternatives.Aged Accounts PayableAbout Aged Accounts Payable322

Analytical tasks in purchasing

The following articles describe some of the key tasks for analyzing the state of your purchasing:

Ad hoc analysis of purchasing data
Purchasing analytics overview
Setting up purchase
Purchasing overview

Find free e-learning modules for Business Central here