Purchase Order Summary Report

This report shows a summary of purchase orders. This summary view displays purchase orders without product details. Use this report to see order totals, invoice totals and amount due for each supplier order. 


Prerequisite:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

FromAllow user to select a date, i.e. the beginning date of the report
ToAllow user to select a date, i.e. the closing/end date of the report
CurrencyAllow user to select currency to be used in the report


Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 


Output:

The following output fields are available for this report.


Fields
SupplierSupplier name who received the purchase order.
PO #Purchase Order Number the product is ordered by.
PO DateDate of the purchase order.
Invoice DateInvoice Date of the purchase order.
Required ByDate when purchase needs to be delivered.
StatusPurchase status.
YearYear of purchase order date.
QuarterQuarter of purchase order date.
MonthMonth of purchase order date.
CurrencySupplier currency code this purchase is created in.
Invoice #Invoice number assigned by supplier.
PO StatusPurchase order status.
Invoice StatusStatus of the invoice
Supplier Additional Attribute 1-10Values of Additional supplier attributes.
Data Headers
Order Total
Total Ordered amount.
Invoice Total
Total Billed amount. Includes Credit Note if any.
Paid Total
Total Paid amount. Includes Credit Note refund if any.
Due
Amount not yet paid. Due = Invoice Total - Paid Total


NOTE: If you have added an Additional Attribute set to your purchase process, the attributes will appear as additional report fields. 




Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.