This report shows invoice and credit notes summaries for given period including outstanding payment amounts.



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.



PO #

 Purchase Order Number the product is ordered by.

Invoice #

 Invoice number assigned by supplier.

Supplier

 Supplier name who issued the invoice.

Invoice Date

 Date when Invoice was created.

Status

 Purchase status.

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 invoice date.
Quarter
 Quarter of invoice date.

Month

 Month of invoice date.
Currency
 Supplier currency code this purchase is created in.

Invoice Due Date

 Date when Invoice is due.

Required By

 Date when purchase needs to be delivered.

Invoice Status

 Status of the invoice

Supplier Additional Attribute 1-10

 Values of Additional supplier attributes.