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 update button, report will refresh as per inputs selected. There are following output field 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.