Purchase Invoice Details Report

This report shows details of purchase invoices. This detailed view breaks down purchase invoices by product. Use this report to see details of which products have been ordered and item quantity, product cost and total product cost per invoice.


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 to be used in the 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:

The following output fields are 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 identifying the purchase.
Invoice #Purchase invoice number.
Invoice DateDate when Invoice was created.
StatusPurchase status.
SupplierSupplier name who issued the invoice.
YearYear of invoice date.
QuarterQuarter of invoice date.
MonthMonth of invoice date.
LocationLocation this purchase intended for.
CategoryProduct category.
BrandProduct brand.
Product TagsComma-separated product tags.
FamilyProduct family name.
UnitProduct unit of measure.
CommentInvoice line comment.
Required ByDate when purchase needs to be delivered.
CurrencySupplier currency code this purchase is created in.
Invoice StatusStatus of the invoice
Supplier Additional Attribute 1-10Values of Additional supplier attributes.
Product Additional Attribute 1-10Values of product additional attributes.
Data Headers
Quantity
Invoiced quantity.
Price
Invoice price (without discount).
Total
Line Total for the product.


Did you find it helpful? Yes No

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