This report shows purchase invoice details. User can see all products invoiced during given period of time.



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 identifying the purchase.

Invoice #

 Purchase invoice number.

Invoice Date

 Date when Invoice was created.

Status

 Purchase status.

Supplier

 Supplier name who issued the invoice.

Quantity

 Invoiced quantity.

Price

 Invoice price (without discount).

Total

 Line Total for the product.

Year

 Year of invoice date.

Quarter

 Quarter of invoice date.

Month

 Month of invoice 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 purchase needs to be delivered.

Currency

 Supplier currency code this purchase is created in.

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.