cancel
Showing results for 
Search instead for 
Did you mean: 
Brian_
Level 1

Vendor Performance On-Time Delivery Report

In QB Enterprise (local server).

 

One of our internal Quality Reporting Requirements (ISO releated) is to report on Vendor Performance. Quality/Item Returns is not an issue for us as it is managed seperately, however on-time delivery is also a metric for performance determination.

 

What we need is a report that shows the difference between expected item receipt date from the Purchase Order, and the item actual receipt date. Is there a way to get this?

 

The dates/period on the report will obviously be variable, but information should summary on the primary group "Vendor". The Purchase Order record should be the driver (parent table), as there are always BILLS entered that do not have PO's asscoiated with them.

 

Any suggestions regarding this would be greatly appreciated.

1 Comment 1
MaryAnn_E
QuickBooks Team

Vendor Performance On-Time Delivery Report

Hi there, @Brian_.

 

The report that shows the difference between the expected item receipt date from the Purchase Order and the item actual receipt date is unavailable. As a workaround, you’ll need to pull up 2 reports so you can compare the purchase order and item receipts.  Then export to Excel file and combine the report.

Here's how:

 

  1. Go to the Reports menu and choose the Reports Center.
  2. Find and open the Purchases by Vendor Detail report and Transaction List by Vendor report.
  3. Select the Excel on the toolbar. 
  4. To create a new Excel workbook, select Create New Worksheet
  5. If you want to update an existing workbook with the data in the open report, select Update Existing Worksheet. If you want to format the data a specific way, select Advanced
  6. When you’re ready to export, select OK. To open the report in Excel, you can also select Export.

 

 I have here some articles about exporting MS Excel files in QuickBooks for your future reference:

 

Also, you can visit this article to learn about customizing reports: Customize reports in QuickBooks Desktop.

 

Should you have other concerns about your vendors' reports? Please let me know. I’ll just be here to help you. Have a great day!

Need to get in touch?

Contact us