The Purchase Invoice Details Report shows you the product details for each purchase invoice added to the platform. It helps you track products purchased from a specific supplier, measure your transaction volume with them, match the added quantities with invoices, and compare product costs across different periods or suppliers.
Accessing the Report
Go to Reports > Stock Control > Purchase Invoice Details Report.
Click on the report to view details.
Searching in the Report
You can search by:
Purchase invoice number
Supplier name
Filtering Report Data
Click Filter.
You can filter results by:
Purchase invoice number
Location
Creation date
Supplier code
Supplier name
Product name
Product SKU
Quantity
Product cost
Tracking information
Expiry date (for tracked items)
Click Apply.
Sorting Data
Click on the Sort by field and choose the preferred order to display the data.
Report Data
Invoice Number | The purchase invoice number. |
Location | The branch selected when adding the purchase invoice. |
Issue date | The date the purchase invoice was created. |
Supplier Code | The code assigned to the supplier. |
Supplier Name | The supplier linked to the invoice. |
Product Name | The product name as listed in the purchase invoice. |
Product SKU | The SKU code of the product as recorded in the invoice. |
Product quantity | The newly added quantity of the product in the purchase invoice. |
Product Cost (Tax Inclusive) | The unit cost including Tax. |
Product Cost (Tax Exclusive) | The unit cost excluding Tax. |
Tracking Information | Batch number or serial number. |
Expiry Date | Expiry date for tracked products. |
ℹ️ Note: The table contains multiple columns. Use the horizontal scroll bar at the bottom to view all columns.
Exporting the Report
Click Export.
Select xlsx.
The Excel file will be downloaded to your device.
FAQs
Why does the purchase invoice number appear multiple times in the report?
Because the report shows the details of each product in the invoice. A repeated number means multiple products are included in the same invoice.Can I search for a specific product to see purchase details within a certain period?
Yes. Click Filter > Enter the product name > Select the desired time period > Apply.How can I know which products I purchase from a specific supplier?
Click Filter > Enter the supplier name > Apply. All products linked to that supplier will appear.If I did not assign a supplier when adding a product to inventory, will it appear in this report?
Yes. The supplier name in this report is based on the supplier recorded in the purchase invoice.