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 which products have been ordered, item quantity, product cost and total product cost per invoice.


Prerequisite


Table of Contents


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


Input:

Reporting PeriodAllows the user to select the reporting period from a list of options or set a custom date range. This report is filtered according to the purchase invoice date.
CurrencyAllows the user to select the currency to be used in the report.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets the 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 Configure Layout 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 the Invoice was created
StatusPurchase status
SupplierName of the supplier who issued the invoice
YearYear of the invoice date
QuarterQuarter of the invoice date
MonthMonth of the invoice date
LocationLocation this purchase is intended for
CategoryProduct category
BrandProduct brand
Product TagsComma-separated product tags
FamilyProduct family name
UnitProduct unit of measure
CommentInvoice line comment
Required ByDate when the 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 additional product attributes
Data Headers
Quantity
Invoiced quantity
Price
Invoice price (without discount)
Total
Line Total for the product


FAQs

[back to top]


Can you please tell me why PO-XXXX is missing from this report?

Usually, this is an issue with the date filters. By default the date filter is set to 'Last Month', however, if you are part-way through the next month, this may miss some recent POs. The Purchase Invoice Details report only shows purchases invoiced (not ordered) during a specific period. Try setting the reporting period to 'Last 30 days' or setting a custom date range instead. Missing entries can also be caused by cache problems. Try clearing your cache and refreshing to see if the issue persists.


The DEAR Advanced Purchase screeen shows a Purchase Invoice as "authorised" (not paid) yet the Purchase Invoice Details report shows it correctly as paid. Why is that? 

This is part of the design of the Advanced Purchase feature.  


Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

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