Warehouse

Warehouse reports

Warehouse document report

Warehouse document. Appearance of the warehouse document with all information regarding the issue/receipt/transfer.

  • Original file name: WarehouseDocument.jasper

  • Report UUID: b737487a-3803-42b2-a154-7f04441cf998

  • The input file for the application is a file with the extension jasper.

Report input configuration

  • String documentUuid - UUID of the document to be generated

Flap

name description type

objects

document object

objects

number

Document number

string

stamp

date and time the document was created

date

signed_by

signed by

string

typee

Document type

string

reception_typee

document type receiveda

string

transfer_typee

shifted document typea

string

release_typee

issued document typea

string

destination

destinatione

string

recipient

recipient (for external)

string

taken_by

downloaded by a person

string

reserved_by

booked by person

string

waybill_number

bill of lading number

string

warehousee

warehouse name

string

warehouse_placee

warehouse storage location

string

warehouse_other

target/source warehouse (when shifted)

string

warehouse_place_other

destination/origin storage location (when shifted)

string

work_order

Work order name

string

item_manufacturer

stock item manufacturer

string

item_typee

stock item type

string

item_type_order_number

Item ordering number

string

item_count

number of items per documente

BigDecimal

item_unit_pricee

unit pricea

BigDecimal

item_unit

unita

string

item_warehouse_index

stock index

string

variables

name description type

sum_item_unit_price

sums the value of elements in the document

BigDecimal

Report of min/max levels exceeded for warehouse elements

A report indicating items with exceeded minimum/maximum stock levels

  • Original file name: ReportWarehouseLevels.jasper

  • Report UUID: 93aba014-4d33-4153-8445-de62d71c1605

  • The input file for the application is a file with the extension jasper.

Report input configuration

  • String warehouseUuid - UUID of the warehouse

  • String warehousePlaceUuid - UUID of the storage location

  • boolean onlyMinimum - show only minimal exceedances

  • boolean onlyMaximum - show only maximum exceedances

Flap

name description type

stamp

date and time of the report

date

warehouse_name

warehouse name

string

warehouseplace_name

storage location name

string

warehouseplace_account

account name for the storage location

string

item_type

item type name

string

item_type_order_number

ordering number

string

item_manufacturer

producer

string

item_unit_price

unit price

BigDecimal

item_unit

unit

string

item_current_count

current quantity in stock

BigDecimal

item_count

limit quantity

BigDecimal

item_warehouse_index

stock index

string

Variables

Lack.

Data source

No additional data.

Inventory consumption report

The report indicates the storage consumption and its goals.

  • Original file name: ReportWarehouseOutput.jasper

  • Report UUID: 26b84f6c-9274-443c-bb61-56d8332a791f

  • The input file for the application is a file with the extension jasper.

Report input configuration

  • String warehouseUuid - UUID of the warehouse

  • String warehousePlaceUuid - UUID of the storage location

  • String locationUuid - UUID of the location

  • String userUuid - UUID of the user

  • String workOrderUuid - UUID of the work order

  • boolean specificDate - whether a specific date is defined

  • Date dateFrom - specified date From

  • Date dateTo - specified To date

Flap

name description type

stamp

date & time of the event

date

date_from

start report date

date

date_to

final report date

date

warehouse_name

warehouse name

string

warehouseplace_name

storage location name

string

warehouseplace_account

account name

string

grouping

grouping text (user, location, work order)

string

location

location

string

work_order

Work orders

string

user

full username

string

item_type

name of the element

string

item_type_order_number

ordering number

string

item_manufacturer

producer

string

item_unit_price

unit price

BigDecimal

item_unit

unit

string

item_count

quantity

BigDecimal

item_warehouse_index

stock index number

string

Variables

Lack.

Data source

No additional data.

Stock report

Stock report. Indicates stock information for the day.

  • Original file name: WarehouseState.jasper

  • Report UUID: 9b4676d2-2011-4c9b-bbc7-d4370ca6722b

  • The input file for the application is a file with the extension jasper.

Report input configuration

  • String warehouseUuid - UUID of the warehouse to be analyzed

  • String warehousePlaceUuid - UUID of the storage location to be analyzed

  • String typeUuid - UUID of the item type to be analyzed

  • String contractorUuid - UUID of the contractor who is the main contractor of the work order to which the warehouse documents are attached

  • boolean onlyNegativeValues - only stock items with status (negative quantities)

  • boolean onlyPositiveValues - only stock items with status (adding quantities)

  • boolean withoutZeroState - only stock items that are not zero

Flap

name description type

stamp

Report generation date

date

warehouse_name

warehouse name

string

warehouseplace_name

storage location name

string

warehouseplace_account

account name for the storage locationa

string

item_type

Item type

string

item_type_order_number

ordering number

string

item_manufacturer

Type manufacturer

string

item_unit_price

The unit price of the item

BigDecimal

item_unit

unit of measure

string

item_current_count

current quantity in stock

BigDecimal

item_reserved_count

Quantity reserved

BigDecimal

item_minimum_count

The minimum quantity specified for a given assortment

BigDecimal

item_maximum_count

The maximum quantity specified for a given assortment

BigDecimal

item_warehouse_index

stock index

string

Variables

none.

Data source

No additional data.

Warehouse movements report

Stock report. Indicates stock information for the day. It results from the analysis of warehouse documents in the given period. If no period is given, it indicates the stock level as of today with the flow of information from the first document for a given warehouse.

  • Original file name: WarehouseDocument.jasper

  • Report UUID: 54bd9cad-ebec-4b33-852a-d06bdc70760a

  • The input file for the application is a file with the extension jasper.

Report input configuration

  • String warehouseUuid - UUID of the warehouse to be analyzed

  • String warehousePlaceUuid - UUID of the storage location to be analyzed

  • String typeUuid - UUID of the item type to be analyzed

  • String contractorUuid - UUID of the contractor who is the main contractor of the work order to which the warehouse documents are attached

  • DateFields dateFields - ALL, TODAY, YESTERDAY, TOMORROW, THIS_WEEK, LAST_WEEK, NEXT_WEEK, THIS_MONTH, LAST_MONTH, THIS_YEAR, LAST_YEAR - date selector

  • boolean specificDate - whether a specific event creation date is defined

  • Date dateFrom - specified date From

  • Date dateTo - specified To date

  • boolean onlyNegativeValues - only stock items with status (negative quantities)

Flap

name description type

stamp

Report generation date

date

date_from

analysis start date

date

date_to

analysis completion date

date

warehouse_name

warehouse name

string

warehouseplace_name

storage location name

string

warehouseplace_account

account name for the storage locationa

string

item_type

Item type

string

item_type_order_number

ordering number

string

item_manufacturer

Type manufacturer

string

item_unit_price

The unit price of the item

BigDecimal

item_unit

unit of measure

string

item_current_count

current quantity in stock

BigDecimal

item_count

Quantity in stock resulting from warehouse documents within FROM-TO dates

BigDecimal

item_warehouse_index

stock index

string

Variables

none.

Data source

No additional data.

Stock Inventory/Returns Report

  • Original file name: ReportWarehouseInventory.jasper

  • Report UUID: 4bda9e22-ad9c-44ad-ad41-3e1ce515d641

  • The input file for the application is a file with the extension jasper.

Report data

The report data comes from the data of the Stock Status Report inventory report. Refer to the documentation in that section. Only the appearance of the report is subject to change.