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 field 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.