Purchase Order vs Invoice Report

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.


Prerequisite:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:


Time PeriodAllow user to select the time period from a list of options are set custom a custom date range.
CurrencyAllow user to select Currency for report
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets 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. 


Output:


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.


Fields
SKUProduct SKU.
ProductThe name of the product.
PO #Purchase Order Number the product is ordered by.
SupplierSupplier name who received the purchase order.
YearYear of purchase order date.
QuarterQuarter of purchase order date.
MonthMonth of purchase order date.
LocationLocation this purchase intended for.
CategoryProduct category.
BrandProduct brand.
Product TagsComma-separated product tags.
FamilyProduct family name.
UnitProduct unit of measure.
CurrencySupplier currency code this purchase is created in.
Supplier Additional Attribute 1-10Values of Additional supplier attributes.
Product Additional Attribute 1-10Values of product additional attributes.
Data Headers
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.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.