This report shows pending purchase orders. Purchase order is pending if it has been authorised but invoice for ordered items hasn’t been processed yet and/or stock is not received.



Input:

Following are input for this report



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
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press the update button, the report will refresh as per inputs selected. 
There are following output fields 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.

Status

Purchase status.

Supplier

Supplier name who received the purchase order.

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.

Year

Year of purchase order date.

Quarter

Quarter of purchase order date.

Month

Month of purchase order date.

Location

Location this purchase intended for.

Category

Product category.

Brand

Product brand.

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.