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.
Before you start
Data from this report can be exported in Excel, PDF or RTF format.
Input:
| Reporting Period | Allows 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. |
|---|---|
| Currency | Allows the user to select the currency to be used in the report. |
| Layout | Set to the Default layout. Allows selection of saved layouts, if any. |
| Save Layout As | Allows saving a layout for potential future use. |
| Reset Layout | Resets 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 Cin7 Core 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
| SKU | Product SKU |
|---|---|
| Product | The name of the product |
| PO # | Purchase order number identifying the purchase |
| Invoice # | Purchase invoice number |
| Invoice Date | Date when the Invoice was created |
| Status | Purchase status |
| Supplier | Name of the supplier who issued the invoice |
| Year | Year of the invoice date |
| Quarter | Quarter of the invoice date |
| Month | Month of the invoice date |
| Location | Location this purchase is intended for |
| Category | Product category |
| Brand | Product brand |
| Product Tags | Comma-separated product tags |
| Family | Product family name |
| Unit | Product unit of measure |
| Comment | Invoice line comment |
| Required By | Date when the purchase needs to be delivered |
| Currency | Supplier currency code this purchase is created in |
| Invoice Status | Status of the invoice |
| Supplier Additional Attribute 1-10 | Values of additional supplier attributes |
| Product Additional Attribute 1-10 | Values of additional product attributes |
Data headers
| Quantity | Invoiced quantity |
|---|---|
| Price | Invoice price (without discount) |
| Total | Line Total for the product |
FAQs
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 Cin7 Core Advanced Purchase screeen shows a Purchase Invoice as "authorized" (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 Cin7 Core support.