This report compares what has been ordered vs what has been invoiced. This will show all discrepancies between invoices and purchase orders.



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


SKU

 Product SKU.

Product

 The name of the product.

PO #

 Purchase Order Number the product is ordered by.

Supplier

 Supplier name who received the purchase order.

Order Quantity

 Ordered quantity.

Invoice Quantity

 Invoiced quantity.

Diff Quantity

 Difference between Invoiced and Ordered quantity.
Order Price
 Purchase order price without discount.

Invoice Price

 Invoice price without discount.

Diff Price

 Difference between Invoice and Order price.

Order Total

 Purchase order line total.

Invoice Total

 Purchase invoice line total.

Diff Total

 Difference between Invoice and Order line total.

Year

 Year of purchase order date.

Quarter

 Quarter of purchase order date.
Month
 Month of purchase order 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.

Currency

 Supplier currency code this purchase is created in.

Supplier Additional Attribute 1-10

 Values of Additional supplier attributes.

Product Additional Attribute 1-10

 Values of product additional attributes.