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.