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


Table of Contents


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


Input:

Reporting PeriodAllows the user to select the reporting period from a list of options or set a custom date range.
CurrencyAllows the user to select the currency to be used in the report.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets the layout to the default layout or selected saved layout.


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. You may have to open the More Fields dropdown menu to add some of them to your report.


Fields
SupplierName of the supplier 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 the purchase needs to be delivered
StatusPurchase status
YearYear of the purchase order date
QuarterQuarter of the purchase order date
MonthMonth of the purchase order date
CurrencySupplier currency code this purchase is created in
Invoice #Invoice number assigned by the 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. 


FAQs

[back to top]


PO-00XXX (advanced purchase) shows a lot under receiving that has actually been received. Please can you help identify why this is happening.

The payments and Stock are not marked as received. If this has been fully received and paid for, kindly click on the PO drop-down and mark as received. 


We are having a problem in the Purchase Order Summary where the Order Total reflecting one amount and in the actual Purchase Order is completely different. It repeats the order total to each stock receiving and invoicing, what inflates the total amount.

This is a feature of Advanced Purchases. Advanced purchases are designed to handle purchase orders where multiple invoices and stock deliveries are to be considered part of the same purchase. This results in multiple invoice lines which are attributed to the same purchase order. As shown below, each invoice line will show the order total for the entire PO. This is by design to show Order total in every row if there are multiple invoices.



Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

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