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.

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

Currency

Allow user to select Currency for 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

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.

Status

Purchase status.

Supplier

Supplier name who received the purchase order.

Quantity

Ordered quantity.

Price

Ordered price (without discount).

Total

Line Total for the product.

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.

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.