Introduction/Purpose:

The “Vendors by Order” report in a procurement system provides a comprehensive overview of vendors and their corresponding order information. The report includes the following details for each vendor:

• Vendor Name: The name of the vendor supplying the goods or services.

• Vendor Code: A unique code assigned to each vendor for identification purposes.

• Currency: The currency in which the orders are processed and displayed.

• Total Number of Orders: The overall count of orders placed with the vendor.

• Approved Orders: The number of orders that have been approved by the procurement system.

• Cancel/Reject Orders: The count of orders that have been canceled or rejected.

• Total Amount of Orders: The total monetary value of all orders placed with the vendor.

• Paid Amount: The total amount that has been paid to the vendor for the completed orders.

• Remaining Balance: The outstanding balance yet to be paid to the vendor.

• Last Order Date: The date when the most recent order was placed with the vendor.

In addition to the above information, the “Vendors by Order” reports typically offer several other features:

• Filter: Users can apply filters to customize the report based on specific criteria. For example, they can filter by vendor name, vendor code, currency, order status, or date range to narrow down the results.

• Refresh: This feature allows users to update the report with the latest data from the procurement system. By clicking the refresh button, the report will fetch the most up-to-date information.

• Clear Report Cache: In some cases, the procurement system may cache the report data to improve performance. The “Clear Report Cache” option enables users to clear the cached data and retrieve fresh data for the report.

• Export: Users can export the “Vendors by Order” report to various file formats such as Excel, CSV, or PDF. This enables them to save the report locally or share it with others