This report shows purchase orders made during given period of time and, optionally, status of the invoice.

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

Supplier

 Supplier name who received the purchase order.

PO #

 Purchase Order Number the product is ordered by.

PO Date

 Date of the purchase order.

Invoice Date

 Invoice Date of the purchase order.

Required By

 Date when purchase needs to be delivered.

Status

 Purchase status.

Order Total

 Total Ordered amount.

Invoice Total

 Total Billed amount. Includes Credit Note if any.

Paid Total

 Total Paid amount. Includes Credit Note refund if any.

Due

 Amount not yet paid. Due = Invoice Total - Paid Total

Year

 Year of purchase order date.

Quarter

 Quarter of purchase order date.

Month

 Month of purchase order date.

Currency

 Supplier currency code this purchase is created in.

Invoice #

 Invoice number assigned by supplier.

PO Status

 Purchase order status.

Invoice Status

 Status of the invoice

Supplier Additional Attribute 1-10

 Values of Additional supplier attributes.

a