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.
Data from this report can be exported in Excel, PDF or RTF format.
|From||Allow user to select a date, i.e. the beginning date of the report|
|To||Allow user to select a date, i.e. the closing/end date of the report|
|Currency||Allow 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.
The following output fields are available for this report.
|Product||The name of the product|
|PO #||Purchase Order Number the product is ordered by|
|PO Date||Date of the purchase order|
|Invoice #||Purchase Invoice Number|
|Invoice Date||Invoice Date of the purchase order|
|Supplier||Supplier name who received the purchase order|
|Year||Year of purchase order date|
|Quarter||Quarter of purchase order date|
|Month||Month of purchase order date|
|Location||Location this purchase intended for|
|Product Tags||Comma-separated product tags|
|Family||Product family name|
|Unit||Product unit of measure|
|Comment||Invoice line comment|
|Required By||Date when stock is need to be delivered|
|Currency||Supplier currency code this purchase is created in|
|PO Status||Purchase order status|
|Invoice Status||Status of the invoice|
|Supplier Additional Attribute 1-10||Values of Additional supplier attributes|
|Product Additional Attribute 1-10||Values of product additional attributes|
|Cost||Ordered cost (without discount)|
|Total||Line 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.