This report shows pending purchase orders. A purchase order is pending if it has been authorised but the invoice for ordered items has not been processed yet and/or stock is not received. Use this report to see PO status and number of items ordered, still to invoice, and still to receive for a supplier or PO #.
Data from this report can be exported in Excel, PDF or RTF format.
|From||Allow user to select a date i.e. beginning date of required report|
|To||Allow user to select a date i.e. closing/end date of required 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.
|SKU||Product SKU, ordered but not yet fully billed.|
|Product||The name of the product, ordered but not yet fully billed.|
|PO #||Purchase Order Number the product is ordered by.|
|PO Date||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.|
|Required By||Date when stock is expected to be received.|
|Supplier Additional Attribute 1-10||Values of Additional supplier attributes.|
|Product Additional Attribute 1-10||Values of product additional attributes.|
|Ordered||Quantity of the product being ordered.|
|To Invoice||Quantity of the product not yet billed.|
|To Receive||Quantity of the product not yet received.|
NOTE: If you have added an Additional Attribute set to your purchase process, the attributes will appear as additional report fields.