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