Purchase Order Details Report

This report shows details of purchase orders made during given period of time and, optionally, status of the invoice. User can see all products ordered during the period. However, it will not include Purchase Orders cloned via the Clone (Keep PO) option.


Use this report to see details of which products are ordered and item quantity, product cost and total product cost per 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
SKUProduct SKU
ProductThe name of the product
PO #Purchase Order Number the product is ordered by
PO DateDate of the purchase order
Invoice #Purchase Invoice Number
Invoice DateInvoice Date of the purchase order
StatusPurchase status
SupplierSupplier name who received the purchase order
YearYear of purchase order date
QuarterQuarter of purchase order date
MonthMonth of purchase order date
LocationLocation this purchase intended for
CategoryProduct category
BrandProduct brand
Product TagsComma-separated product tags
FamilyProduct family name
UnitProduct unit of measure
CommentInvoice line comment
Required ByDate when stock is need to be delivered
CurrencySupplier currency code this purchase is created in
PO StatusPurchase order status
Invoice StatusStatus of the invoice
Supplier Additional Attribute 1-10Values of Additional supplier attributes
Product Additional Attribute 1-10Values of product additional attributes
Data Headers
QuantityOrdered quantity
CostOrdered cost (without discount)
TotalLine Total for the product (Quantity x Cost)


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.