The ‘Purchase Order Receipt’ report can be used to generate a report that can cover a range of purchase orders, listing quantities received along with their value and other relevant information.

This report can be found under the ‘Purchasing’ header in the Jasper Reports suite, and if we select it we will see the following options for running it.

Here we have several options for what we want to report on, as well as what information we want to see here. These are:

• Report By: This affects which purchase orders we will see, depending on the options selected further down:
  • Purchase Order Number: Will report on the PO selected in the ‘Select Purchase Order (Optional)’ filter. If left blank this will report on all purchase orders regardless of any date range selected in the ‘From Date’ and  ‘To Date’ filters.
  • Receipt Date: Will report on all Purchase Orders that fall within the date range set in the ‘From Date’ and ‘To Date’ filters, regardless of the PO selected in the ‘Select Purchase Order (Optional)’ filter.
  • Both: Will use both the ‘Select Purchase Order (Optional)’ and ‘Date From’ and ‘Date To’ filters to report on any relevant Purchase Orders.

• Select Supplier: Can be used in conjunction with the filters described above to further narrow down to orders from a specific supplier.
• Show Q&A: Displays any Q&A events, along with operator responses.
• Show Default Supplier Image: Will display any default supplier images against the relevant commodities.
• Show Images of Received Lot: Will display any pictures taken of the received goods as they entered the facility.
• Show Supplier Details: Displays information such as supplier lot number and supplier lot number.
• Subtotal By Lot Number: Provides a running subtotal for each received lot.
• Show Summary: Enabling this option provides a simpler view of any purchase orders, removing order lines from the report.

If we run the report as we have set it up in the image above, we will generate one that looks like this:

Clicking on the lot number of a received lot will open a ‘Forward Traceability’ report for that lot. Clicking on a purchase order number will open a ‘Purchase Order‘ report for that order.