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 fields 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