This report compares what has been ordered vs what has been invoiced. Use this report to view discrepancies between order and invoice item quantity, order and invoice cost per item, and order and invoice total.
Data from this report can be exported in Excel, PDF or RTF format.
|Time Period||Allow user to select the time period from a list of options are set custom a custom date range.|
|Currency||Allow user to select Currency for report|
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving of a layout for potential future use.|
|Reset Layout||Resets layout to the default layout or selected saved layout.|
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
There are following output fields available for this report. You may have to open the More Fields dropdown menu to add some of them to your report.
|Product||The name of the product.|
|PO #||Purchase Order Number the product is ordered by.|
|Supplier||Supplier name who received the purchase order.|
|Year||Year of purchase order date.|
|Quarter||Quarter of purchase order date.|
|Month||Month of purchase order date.|
|Location||Location this purchase intended for.|
|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.|
|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.|