Deliveries

Order/Delivery/Complaint Reports

Complaint Report

The complaint report is a document reflecting the information about the complaint contained in the system.

  • Original file name: ComplaintDocument.jasper

  • Report UUID: f0095fbd-1f04-4ecb-a8ef-88c0bde5ff17

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

Report input configuration

  • String complaintUuid - UUID of the complaint to display

Flap

name description type

number

Complaint number

string

stamp

Date and time when the complaint was created

date

state

Complaint status

string

state_code

Complaint status - code CREATED, READY, SENT, IN_PROGRESS, CLOSED

string

created_by

Who created the complaint (Name and surname)

string

delivery_number

Related delivery number

string

description

Description of the complaint

string

ds_notesimages

data source for the list of images associated with the complaint

objects
name description type

item_manufacturer

The name of the manufacturer of the advertised item

string

item_type

type of advertised item

string

item_type_order_number

the order number of the advertised item

string

item_quality_count

number of quality complaints for a given item

BigDecimal

item_quantity_count

number of quantity complaints for a given item

BigDecimal

Variables

none.

Data source

No additional data.

Subreport

A subreport of the images associated with the NotesImagesDataSource object
name description type

img_row_1

First image in a row

java.awt.Image

img_row_2

Second picture in a row

java.awt.Image

Complaint list report

The complaint report is a document reflecting the information about the complaint contained in the system. Using the report, we generate a collective list of complaints.

  • Original file name: ReportComplaintList.jasper

  • Report UUID: 7078eaa5-aaec-4e7d-9e6c-defbfd66d729

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

Report input configuration

  • String contractorUuid - UUID of the contractor for whom we are generating the check

  • 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

Flap

Report fields the same as for the complaint document report, except for the complaint components (item_*)

Variables

none.

Data source

No additional data.

Subreport

No subreports.

Complaint completion time comparison report

The report compares the actual complaint handling time (from start to finish) with the time declared for a given contractor in the contract properties. Indicates delays in the time of processing the complaint.

  • Original file name: ComplaintTimes.jasper

  • Report UUID: f79ab663-c5d6-4f56-9c32-941a0465c096

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

Report input configuration

  • String contractorUuid - UUID of the contractor for whom we are generating the check

  • 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

Flap

name description type

number

Complaint number

string

supplier

Supplier Name

string

state

the current status of the complaint

string

start_date

date of submitting the complaint

date

last_activity

last activity in the complaint (comment)

date

resolution_time_diff

difference in solution time and declared time

Integer

ds_complaintitems

data source for complaint items

objects

Variables

none.

Data source

No additional data.

Subreport

ComplaintItemsDataSource Complaint Items subreport
name description type

item_manufacturer

Producer of the advertised item

string

item_type

Item type

string

item_type_order_number

Item ordering number

string

item_quality_count

Number of quality complaints

string

item_quantity_count

Quantity Complaint Quantity

string

Delivery report

The report shows delivery items identical to the view in the application.

  • Original file name: DeliveryDocument.jasper

  • Report UUID: f278c569-7d2b-4f43-95f5-58484867f343

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

Report input configuration

  • String deliveryUuid - UUID of the delivery to display the data

Flap

name description type

number

Delivery number

string

stamp

Delivery creation date

date

check_date

Delivery check date

date

delivered_by

Delivered by

string

checked_by

Checked by

string

state

delivery status

string

state_code

delivery status - LOADING_ON_SITE, IN_TRANSIT, TO_APPROVE, DELIVERED, REMARKS

string

type

delivery type (delivery/return)

string

type_code

delivery type - DELIVERY, RETURN, RENT_DELIVERY, RENT_RETURN

string

warehouse

source/destination warehouse

string

warehouse_place

source/destination storage location

string

order_number

Related order number

string

work_order

Work order name

string

show_preferred_workorders

Whether to show preferred work orders (the document is a return and the list of preferred work orders is not empty)

boolean

currency

current currency - set for delivery or set global currency of the instance

string

description

delivery description

string

ds_preferredworkorders

Data source for preferred orders for returns

objects

ds_notesimages

The data source for the images associated with the delivery

objects
name description type

item_manufacturer

Manufacturer of the delivered item

string

item_type

Item type

string

item_type_order_number

Item type ordering number

string

item_count

Quantity delivered

BigDecimal

item_checked_count

Quantity checked

BigDecimal

item_warehouse

The source/destination store for the item

string

item_warehouse_place

The source/destination storage location for the item

string

item_account

The account associated with the storage location

string

Variables

  • imgSignatureDelivery - supplier’s signature image (java.awt.Image)

  • imgSignatureReceiver - image of the recipient’s signature (java.awt.Image)

  • imgSignatureChecker - image of the checker’s signature (java.awt.Image)

Data source

No additional data.

Subreport

A subreport of the images associated with the NotesImagesDataSource object
name description type

img_row_1

First image in a row

java.awt.Image

img_row_2

Second picture in a row

java.awt.Image
Subreport of preferred orders for returns
name description type case "workorder_name": case "workorder_number": case "workorder_description": case "workorder_account": case "workorder_contract": case "workorder_contractscope":

img_row_1

First image in a row

java.awt.Image

img_row_2

Second picture in a row

java.awt.Image

Delivery list report

The delivery report is a document representing the delivery information contained in the system. Using the report, we generate a summary list of deliveries.

  • Original file name: ReportDeliveryList.jasper

  • Report UUID: 5cee833f-b423-4f97-9f67-1ba6ec3d91e2

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

Report input configuration

  • String contractorUuid - UUID of the contractor for whom we are generating the check

  • 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

Flap

Report fields the same as for the packing slip report, except for the delivery items (item_*)

Variables

none.

Data source

No additional data.

Subreport

No subreports.

Delivery Package List Report

The report shows delivery items identical to the view in the application.

  • Original file name: ReportPackageList.jasper

  • Report UUID: 97040dab-3a5b-4a1a-a31f-ea05d343df8e

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

Report input configuration

  • String contractorUuid - UUID of the contractor for whom we are generating the check

  • 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

Flap

name description type

number

Delivery number

string

packType

Package type

string

packDescription

Package description

string

packCode

Package code (shipping number)

string

packNumber

Package number

string

packWeight

Package weight

BigDecimal

packVolume

Volume

BigDecimal

packLength

Length

BigDecimal

packHeight

Height

BigDecimal

packWidth

Width

BigDecimal

packQuantity

Quantity

BigDecimal

packCarrierNumber

carrier number

string

packCarrier

Carrier

string

packCarrierUrl

Bundle/Carrier URL

string

oversizedTransport

Is the redundant package

boolean

craneNeeded

Do you need a crane

boolean

pumpNeeded

Do you need a pump

boolean

carPlate

Plate

string

carDriverName

Name/Surname of the driver

string

carDriverPhone

Call the driver

string

carDriverNote

Additional driver’s note

string

Variables

Lack

Data source

No additional data.

Subreport

Lack

Delivery Price Comparison Report

The report allows you to compare the prices contained in the delivery documents with the contract prices defined in the types of elements for a given instance of the system.

  • Original file name: DeliveryPriceDiff.jasper

  • Report UUID: e81dbcba-9ecd-4f7b-ac98-14d3d097fc46

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

Report input configuration

  • String contractorUuid - UUID of the contractor for whom we are generating the check

  • 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

Flap

name description type

contractor

Counterparty name

string

delivery_number

Delivery number

string

order_number

Order number

string

timestamp

Date and time of delivery

date

item_type

The name of the item type

string

item_price

Delivery price

BigDecimal

type_price

contract price

BigDecimal

Variables

none.

Data source

No additional data.

Order Report

The order report shows the order data identical to the view from the application.

  • Original file name: OrderDocument.jasper

  • Report UUID: 9ea5ecbe-c6c7-41dc-b43d-ee887db9f6c0

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

Report input configuration

  • String orderUuid - UUID of the order to display the report

Flap

name description type

number

Order number

string

stamp

Date and time the order was created

date

created_by

Person creating the order (Name and Surname)

string

created_by_phone

Creator - telephone

string

created_by_email

Creator - email

string

accepted_by

The person accepting the order

string

account

The destination account for the order

string

type

Order type

string

notebook

Order note

string

transport_units

Number of transport units

int

order_date

Order completion date

date

delivery_date

Expected delivery date

date

delivery_days

Number of days to delivery

int

supplier

Supplier Name

string

work_order

The name of the work order associated with the order

string

receiver_name

Surname and first name of the person designated as receiving the order

string

receiver_phone

Receiving person’s telephone number

string

receiver_info

Additional information from the receiving person

string

currency

current currency - set for delivery or set global currency of the instance

string

terms_and_conditions

order conditions or NULL if not specified

string

own_company_name

Own company name (owner)

string

own_company_street_and_number

Street and number of own company (owner)

string

own_company_postal_code

Own company zip code (owner)

string

own_company_city

City of own company (owner)

string

own_company_city_state

Province/state of own company (owner)

string

own_company_country

Own company country (owner)

string

own_company_tax_number

Own company tax identification number (owner)

string

own_company_email

Own company email (owner)

string

own_company_phone

Own company telephone (owner)

string

own_company_website

Own company website (owner)

string

contractor_name

Counterparty - name

string

contractor_street_and_number

Counterparty - street and number(s)

string

contractor_postal_code

Counterparty - zip code

string

contractor_city

Counterparty - city

string

contractor_city_state

Counterparty - Province/State

string

contractor_country

Counterparty - country

string

contractor_tax_id

Counterparty - tax number

string
name description type

item_manufacturer

Item manufacturer

string

item_type

Item type

string

item_type_order_number

Item ordering number

string

item_count

Quantity

BigDecimal

item_account

Account assigned to the item (for return orders)

string

item_account_workorder

The name of the order assigned to the account

string

item_unit_price

Unit price (contract)

BigDecimal

item_unit

unit of measure

string

Variables

none.

Data source

No additional data.

Order list report

The order report is a document that reflects the information about the order contained in the system. Using the report, we generate a summary list of orders.

  • Original file name: ReportOrderList.jasper

  • Report UUID: f4258892-f149-45dd-b461-3092bc1914b2

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

Report input configuration

  • String contractorUuid - UUID of the contractor for whom we are generating the check

  • 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

Flap

Report fields the same as for the order document report, except for the components (item_*)

Variables

none.

Data source

No additional data.

Subreport

No subreports.

Delivery Time Comparison Report

The report compares the actual execution of deliveries under orders with the required delivery times defined at the contract level for a given supplier.

  • Original file name: OrderTimeDiff.jasper

  • Report UUID: d116150e-aed7-4088-bbbb-5b24766ee98b

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

Report input configuration

  • String contractorUuid - UUID of the contractor for whom we are generating the check

  • 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

Flap

name description type

contractor

Counterparty name

string

delivery_number

Delivery number

string

order_number

The order number associated with the delivery

string

timestamp

Delivery creation time

date

check_date

delivery check time

date

order_date

The date expected to complete the order

date

Variables

none.

Data source

No additional data.