======6.1. Inventory report======
The inventory report provides information about the current state of the inventory in warehouses managed by Produmex. \\
The inventory report is available through the menu: 
  * Produmex > Inventory report
  * Produmex > Reports > Inventory report. 

Add filters for the inventory report on the opening ‘Inventory report – selection criteria’ screen.

The inventory report can be opened directly by the following steps: 
  * Click on the ‘PMX Inventory’ button on the Item Master Data screen of an item. Only the stock of that item will be shown.
  * Click on the ‘Inventory’ button on the main screen of an Organizational Structure element. Only the stock of that element will be shown. 

**Inventory report – selection criteria** \\
{{ :implementation:wms:addonscreens:inventory_report_selection_criteria.png |}}

//Item Number From - To// \\ Enter the item code to the Item Number From field or select from a list after clicking on the {{:implementation:wms:addonscreens:icon.png|}} icon. The filter will get all stock of the selected item(s). \\
To filter the report for multiple items, add the first item to the ‘Item Number From’ field and the last item to the ‘To’ field. The filter will get all stock for items starting from the ‘From’ item to the ‘To’ item where the items are sorted alphabetically. 

//Item Group// \\ Select the item group. The filter will get all stock of items in the selected item group.

//Barcode// \\ Add the barcode. The filter will get all stock of items with the added barcode.

//Storage location from – To// \\ The ‘From’ – ‘To’ location. Enter a location code or click on the {{:implementation:wms:addonscreens:icon.png|}} icon and select a location from a list. Only stock stored on the selected location(s) will be listed on the inventory report. To filter on only one location, only enter it in the 'From' field.

//Warehouse// \\ Enter the warehouse code or click on the {{:implementation:wms:addonscreens:icon.png|}} icon and select the warehouse from a list. Only stock stored in the selected warehouse will be listed on the inventory report.

//Batch Number From – To// \\ The ‘From’ – ‘To’ batch number. Enter the batch number or click on the {{:implementation:wms:addonscreens:icon.png|}} icon and select the batch from a list. The filter will get all stock of items with the selected batch number(s). To filter on only one batch, only enter it in the 'From' field.

//SSCC// \\ Enter the SSCC number. The filter will only get stock linked to added SSCC number. 

//LUID// \\ Enter the LUID. The filter will only get stock linked to the added LUID.

//Supplier// \\ Enter the Card Code of the supplier click on the {{:implementation:wms:addonscreens:icon.png|}} icon and select it from a list. Only ‘vendor’ type business partners are listed. The filter will get all stock received from the selected vendor.

//Supplier pallet number// \\ The [[implementation:wms:businesspartner|specific pallet number]] belonging to a business partner. The filter will only get stock linked to the selected supplier pallet.

//Quality status// \\ Select a [[implementation:wms:qualitystatus|quality status]] from the list. Every quality status defined for the company will be listed. The filter will only get stock with the selected quality status.

//Master SSCC// \\ The Master SSCC number. The filter will only get stock linked to the added SSCC number.

//Master LUID// \\ The Master LUID. The filter will only get stock linked to the added LUID.

//Batch attributes// \\ Click on the ’...’ button to open up the ’Batch attributes control’ screen.

{{ :implementation:wms:addonscreens:batch_attributes_control.png |}}

  * Batch attribute: Select a batch attribute from the dropdown list. Every batch attribute type defined on the Batch attribute types user table will be listed. It is possible to select multiple batch attributes for filtering.
  * Value – Value To: Define the value range by selecting a start and an end value.
Press the ‘Update’ button to add the filter. After the filter has been added, it is marked with %%***%% on the ‘Inventory report – selection criteria’ screen. \\
Press the ‘Cancel’ button to close the screen without adding a filter.

//Group by// \\ Select a grouping option. By default the grouping option is ‘Detail’. Possible values: 
  * Item: Products with identical item code and quality status are grouped together. 
  * Warehouse: Products with identical item code and quality status, located in the same warehouse are grouped together. 
  * Batch number: Products with identical item code, quality status and batch details, located in the same warehouse are grouped together. 
  * Storage location: Products with identical item code and quality status, located in the same warehouse and storage location are grouped together.
  * Detail: Products with identical item code, quality status and batch details, located in the same warehouse and storage location and linked to the same LUID are grouped together. 

| |	**Item code** | **Quality status** | **Warehouse** | **Storage location** | **Batch details** | **LUID** |
| **Item** |  ✔  |  ✔  | | | | |
| **Warehouse** |  ✔  |  ✔  |  ✔  | | | |
| **Batch number** |  ✔  |  ✔  |  ✔  | |  ✔  | |
| **Storage location** |  ✔  |  ✔  |  ✔  |  ✔  | | |
| **Detail** |  ✔  |  ✔  |  ✔  |  ✔  |  ✔  |  ✔  |

Click on ‘Ok’ to open the inventory report or click on ‘Cancel’ to close the screen without opening the report.

**Inventory report** \\
List elements are sorted based on the following: 
  * If the Group by option is set to //Detail//, results are sorted based on the ‘Order by - Details’ setting of the [[implementation:wms:inventorycontroller|Inventory controller]]. 
  * If the Group by option is set to //Storage location//, results are sorted by: Item code - Warehouse - Storage Location
  * If the Group by option is set to //Batch number//, results are sorted by: Item code - Batch number - Quality status - Warehouse 
  * If the Group by option is set to //Warehouse//, results are sorted by: Item code - Quality status - Warehouse
  * If the Group by option is set to //Item//, results are sorted by: Quality status - Item code

{{ :implementation:wms:addonscreens:inventory_report.png |}}

//Item Code:// \\ The item code.

//Barcode:// \\ The barcode.

//Description:// \\ The item description.

//Batchnumber:// \\ The batch number.

//Batchnumber2:// \\ The second batch number.

//Best Before Date:// \\ The best before date.

//Batch ID:// \\ The batch ID.

//LUID:// \\ The LUID.

//SSCC:// \\ The SSCC number.

//Warehouse:// \\ The code of the warehouse where the stock is located.

//Storage location:// \\ The code of the storage location where the stock is located.

//Storage location name:// \\ The name of the storage location where the stock is located.

//Quality status:// \\ The quality status. 

//Quantity:// \\ The quantity measured in the inventory UoM. 

//Uom:// \\ The inventory unit of measure.

//Quantity2:// \\ The quantity measured in the second unit of measure.

//Uom2:// \\ The second unit of measure.

//Supplier pallet number:// \\ The [[implementation:wms:businesspartner|specific pallet number]] belonging to a business partner.

//Gr nr.:// \\ The document number of the Goods Receipt PO document linked to the stock.

//Gr date:// \\ The Goods Receipt PO document date.

//Supplier code:// \\ The Card Code of the vendor.

//Supplier:// \\ The name of the vendor.

//PMX warehouse:// \\ The Produmex warehouse code.

//Master LUID:// \\ The master LUID.

//Master SSCC:// \\ The master SSCC number.

//Is full pallet? (Y/N):// \\ Indicates whether something was removed from this logistic unit or not since it was created.

//ItmsGrpCod:// \\ The code of the item group where the item belongs.

Click on ‘Ok’ to close the screen. \\
Click on the {{:implementation:wms:refresh.png?20|}} icon on the Menu Bar to refresh the screen.

{{page>locking}}
{{page>change}}
{{page>printlables}}
{{page>move}}
{{page>show_bn_sn}}