Master Class

Essential Reporting Knowledge

Shipped Stock

Summary

The ‘Shipped Stock’ report can be used to generate a report that shows items/products that have been shipped within a certain timeframe.

Report Setup

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

 
We have the following options here:

  • From Date – A date can be selected here from a drop-down calendar to set the start of our date filter.
  • To Date – A date can be selected here from a drop-down calendar to set the end of our date filter.
    • Note that if these fields are left blank then the report will look at today’s date.
  • Select Commodity – Allows filtering by a specific commodity. If left blank the report will show all commodities within the date range.
  • Select Lot Number – Used in conjunction with the commodity select to specify a lot of our chosen commodity. If left blank the report will show all lots of that commodity within the date range.
  • Select Customer – Allows us to search for items shipped to specific customers.
  • Select Sales Order – Allows us to filter by a specific sales order.
  • Show Pallets – If enabled this will show the associated pallet numbers of shipped items.

Sample Report

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

 

Links To

Clicking on a lot number will open a ‘Forwards Traceability’ report for that lot.

Was this page helpful?
YesNo