Know the product details in the purchase invoice

The Purchase Invoice Details Report shows you the details of the products in each purchase invoice you added to the platform, helping you know the products purchased from a specific supplier, the volume of dealings with them, as well as matching the quantities added from the invoices and comparing the product cost over different periods or different suppliers.

#Accessing the Report

1. Go to Reports > Inventory > Purchase Invoice Details Report.

2. Click on the report to view the details.

#Searching in the Report

You can search using:

• Purchase invoice number.

• Supplier's name.

#Filtering Search Results

1. Click on "Filter".

2. You can filter the search results using:

   • Purchase invoice number.

   • Location.

   • Creation date.

   • Supplier code.

   • Supplier's name.

   • Product name.

   • Product code (SKU).

   • Quantity.

   • Product cost.

   • Tracking information.

   • Expiry date for the tracking method.

3. Click on "Apply".

#Setting the Time

1. Click on the time field.

2. Select the desired time frame:

• 24 hours (default setting).

• Choose a custom period (temporary or fixed).

To select a temporary period:

• Click on "Edit Temporary Period".

• Set the start time and end time.

• Click on "Apply".

To add a fixed period:

• Click on "Select Fixed Period".

• Add the period name.

• Set the period hours.

• Click on "Apply".

#Sorting Data

1. Click on the "Sort By" field.

2. Choose the appropriate order to display the data in the report.

#Report Data

Invoice Number

Purchase invoice.

Location

The branch you selected when adding the purchase invoice.

Creation Date

The date the purchase invoice was created.

Supplier Code

The code specific to the supplier.

Supplier Name

The supplier associated with the invoice.

Product Name

The name of the product added in the purchase invoice.

Product Identification Code (SKU)

The product code as recorded in the invoice.

Quantity

The new quantity of the product added in the purchase invoice.

Product Cost (including tax)

Unit/piece cost including tax.

Product Cost (excluding tax)

Unit/piece cost without tax.

Product Tracking Information (if available)

Batch number or serial number.

Expiry Date (if available)

The expiry date of the tracked product.

ℹ️ Note: The table contains several columns. Use the scroll bar below the table to see all columns.

#Exporting the Report

1. Click "Export".

2. Choose: xlsx.

3. An (Excel) file is downloaded to your device.

---

#Frequently Asked Questions

1. Why is the purchase invoice number repeated in the report?
   Because the report shows the details of each product in the invoice. The repetition of the number means there is more than one product in the same invoice.

2. Can I search for a specific product to know the purchase details over a specified period?
   Yes, click on the Filter option > Enter the product name > Select the time period > Click on Apply.
   ​

3. How do I know the products I purchase from a specific supplier?
   Click on the Filter option > Enter the supplier's name > Click on Apply > All products associated with this supplier will appear.

4. If I did not choose the supplier's name when adding the product to the inventory, will it appear in this report?

   Yes, the supplier's name will appear in this report based on the name registered in the purchase invoice.