Pending Purchase Orders Report

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 #. 


Prerequisite:


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


Input:

FromAllow user to select a date i.e. beginning date of required report
ToAllow 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. 


Output:


The following output fields are available for this report. 

Fields
SKUProduct SKU, ordered but not yet fully billed.
ProductThe name of the product, ordered but not yet fully billed.
PO #Purchase Order Number the product is ordered by.
PO DateDate 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.
Required ByDate when stock is expected to be received.
Supplier Additional Attribute 1-10Values of Additional supplier attributes.
Product Additional Attribute 1-10Values of product additional attributes.
Data Headers
OrderedQuantity of the product being ordered.
To InvoiceQuantity of the product not yet billed.
To ReceiveQuantity 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. 

Did you find it helpful? Yes No

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