Leases

Lease reports

Budget progress

The report displays the progress of the implementation of individual elements of the contract.

  • Original file name: BudgetProgress.jasper

  • Report UUID: 776c91bf-700e-46d5-892e-8192a84a7c60

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

Report input configuration

  • contractUuid - String - UUID of the contract

  • contractScopeUuid - String - UUID of the contract scope

  • reportDate - Date - report execution date

Flap

name description type

objects

work order java object

string

workorder_account

The name of the account assigned to the work order

string

workorder_name

Work order name

string

workorder_contract_name

The name of the contract associated with the work order

string

workorder_contractscope_name

The name of the contract scope associated with the work order

string

workorder_correctionfactor

Lease correction factor

BigDecimal

formworks_assumedpotentialcost

Takeoff value

BigDecimal

workorder_totalleasevalue

Lease value after adjustment

BigDecimal
Lease correction factor

  • total value of deliveries = 0 or total value of deliveries is less than the value of formwork (potential) for the construction element → correction factor = 0

  • in other cases, the coefficient is equal to dividing the value of shuttering (potential) by the total value of deliveries

Total value of deliveries - sum of all documents deliveries

The value of shuttering (potential) - the product of the accepted pre-invoice and the unit price of the shuttering (of a given construction element).

Takeoff value

Takeoff value calculations:

value = accepted take-off * unit price
usage time = number of rotations * days of rotation
takeoff value = value * time of use * lease factor / 30
Lease value after adjustment

Calculation of the lease value after adjustment:

lease value = adjustment factor * total lease value (from start to report date)

Variables

  • Lack

Subreport

  • Lack

The time of the lease to the contractor

The report shows information about lease times for a given work order compared to specified formwork lease parameters.

  • Original file name: ContractorLeaseTime.jasper

  • Report UUID: 6dff57fb-50e3-4040-af25-462858d16350

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

Report input configuration

  • contractUuid - String - UUID of the contract

  • contractScopeUuid - String - UUID of the contract scope

Flap

name description type

objects

work order object - java

string

workorder_account

The name of the account associated with this work order

string

workorder_name

Work order name

string

workorder_contract_name

Contract name

string

workorder_contractscope_name

The name of the contract scope associated with the order

string

formworks_usetime

The number of days of using the lease agreed with the supplier

int

formworks_agreedtime

Agreed number of lease days based on formwork data

int

workorder_timefromfirstdocument

The number of days from the first inventory document to the end date of the work order or today

int

workorder_dayswithleasemodification

The number of days the lease was held

int

workorder_actualvalueaccordingtoplan

The current value of the lease as planned with the provider

BigDecimal

workorder_actualvalueaccordingtoaggreement

The current value of the lease in accordance with the plan agreed with the subcontractor

BigDecimal

workorder_correctionfactor

Lease correction factor

BigDecimal

workorder_totalleasevalue

The total value of the lease including the adjustment factor

BigDecimal
Number of day of use
number = number of rotations * days of rotation
Agreed number of lease days
number = agreed number of rotations * agreed rotation days
The number of days since the first warehouse document

Number from the first warehouse document (any) assigned to the account associated with a given structural element

the number of days the lease was held

Number of days of lease hold in any period (no date range)

The current value of the lease as planned with the provider
value = accepted take-off * unit price
usage time = number of rotations * rotation time
assumed potential = value * time of use * lease factor / 30
_
number = assumed potential - total value of the lease until the report generation date
The current value of the lease as planned with the subcontractor
value = accepted take-off * unit price
time of use = agreed number of rotations * agreed rotation time
agreed potential = value * time of use * lease factor / 30
_
number = agreed potential - total value of the lease up to the report generation date
Lease correction factor

Explained in the 'Budget progress' report

The total value of the lease including the adjustment factor
number = correction factor * total lease value for the entire period

Variables

  • Lack

Subreport

  • Lack

Comparison report of the offer and the actual performance

Comparison report of the supplier’s offer and the actual performance on the construction site.

  • Original file name: OfferVsReality.jasper

  • Report UUID: 24cef3f3-92e2-4e4f-b1ce-c4abfeb7921d

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

Report input configuration

  • contractUuid - String - UUID of the contract

  • contractScopeUuid - String - UUID of the contract scope

Flap

name description type

objects

work order object - java

string

workorder_account

The account associated with the given work order

string

workorder_name

Work order name

string

workorder_contract_name

Contract name

string

workorder_contractscope_name

Contract scope name

string

formworks_usetime

The number of days of using the lease agreed with the supplier

int

formworks_totalvalue

Takeoff value

BigDecimal

formworks_assumedpotential

Accepted bill of quantities

BigDecimal

formworks_assumedpotentialcost

Cost of assumed potential

BigDecimal

workorder_timefromfirstdocumentwithoutleasemodif

The number of days from the first warehouse document without lease hold days

int

workorder_totaldeliverycost

Total value of deliveries

BigDecimal

workorder_totalarea

Total area of elements based on delivery documents

BigDecimal

workorder_totalleasevalue

The total value of the lease including the adjustment factor

BigDecimal
The number of days the lease is used
number = number of rotations * rotation time
Takeoff value
number = accepted take-off * unit price
Cost of assumed potential
number = accepted take-off
Number of days since the first warehouse document
number = number of days from the first warehouse document - number of hold days
Total value of deliveries

The sum of the values of all delivery receipts.

The total area of the elements

The sum of the area values of the elements based on the return documents.

The total value of the lease
number = adjustment factor * total lease value (without cut-off dates)

Variables

  • Lack

Subreport

  • Lack

Partial payment report

  • Original file name: PartialPayment.jasper

  • Report UUID: 6d924e04-3f2b-4041-b2b6-734807c11feb

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

Report input configuration

  • contractUuid - String - UUID of the contract

  • contractScopeUuid - String - UUID of the contract scope

  • workOrderUuid - String - UUID of the work order

  • dateAnalysis - Date- date of analysis (month/year)

  • specificDate - boolean - detailed analysis date

  • dateFrom - Date- date of starting the detailed analysis

  • dateTo - Date - date of completion of detailed analysis

  • showLeaseRateModifiers - boolean - show lease hold subreport

Flap

name description type

objects

work order object - java

string

workorder_account

The account associated with the given work order

string

workorder_name

Work order name

string

workorder_contract_name

Contract name

string

workorder_contractscope_name

Contract scope name

string

workorder_totalleasevalue

The total value of the lease for the specified period

BigDecimal

workorder_correctionfactor

Lease value adjustment factor

BigDecimal

workorder_totalleasevalue_corrected

The total value of the lease including the adjustment factor

BigDecimal

ds_leaseratemodifiers

The data source for the Lease Holds subreport

objects
The total value of the lease

IF we have given start and end dates, then this is the value of the lease in the given period of time

IF we only have the month of the analysis, then the lease value is the result of the sum of two periods:

  • from start to FRI date for a given month

  • approximation of the value from the FRI date to the end date of the analysis

Lease value adjustment factor

Explained in the 'Budget progress' report

Total lease value (with adjustment factor)
count = total lease value * adjustment factor

Variables

  • Lack

Subreport

Suspension of lease

  • Original file name: LeaseRateModifiers.jasper

name description type

name

string

date_start

string

date_end

string

modifier_percent

string

saved_amount

the value of the value saved against 100% - the value of the lease on given days MINUS the value resulting from the modification of the lease coefficient

string

Partial payment details

  • Original file name: PartialPaymentDetail.jasper

  • Report UUID: 65490789-6715-4c41-bfeb-1b839d725f54

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

Report input configuration

  • contractUuid - String - UUID of the contract

  • contractScopeUuid - String - UUID of the contract scope

  • workOrderUuid - String - UUID of the work order

  • elementTypeUuidList - String - UUID list (<1>,<2>) of element types

  • dateAnalysisFrom - Date - start date of the analysis

  • dateAnalysisTo - Date - date of completion of the analysis

Flap

name description type

objects

string

account

The account associated with the given work order

string

workorder_name

Work order name

string

workorder_contract_name

Contract name

string

workorder_contractscope_name

Contract scope name

string

document_number

Document number

string

document_item_type

Item type

string

document_item_count

Quantity

BigDecimal

document_item_price

unit price

BigDecimal

document_date

Document date

string

document_item_cost

Cost of items

BigDecimal

document_item_lease_days

The number of days of the lease

Long

document_item_lease_cost_days

Lease value for the specified period. Does NOT include lease hold

BigDecimal
The number of days of the lease
number = calculated number of lease days in the specified period WITHOUT taking into account (reduction) by lease hold
Lease value for the specified period
count = item quantity * unit price * lease factor / 30 * number of days of lease

Variables

  • Lack

Subreport

  • Lack

Potential report

Comparative report of the potential and values in individual areas of cost generation (plan, order, delivery).

  • Original file name: Potential.jasper

  • Report UUID: f1557649-dba6-4726-aef5-bbac0845e9ca

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

Report input configuration

  • contractUuid - String - UUID of the contract

  • contractScopeUuid - String - UUID of the contract scope

Flap

name description type

objects

work order object - java

string

workorder_account

The name of the account associated with this work order

string

workorder_name

Work order name

string

workorder_contract_name

Contract name

string

workorder_contractscope_name

The name of the contract scope associated with the order

string

formworks_totalvalue

The total value of the take-off

BigDecimal

workorder_totalplanvalue

The value of items based on the plan in the work order

BigDecimal

workorder_totalorderdeliverycost

The value of the elements based on the procurement documents

BigDecimal

workorder_totaldeliverycost

The value of the items based on the delivery documents

BigDecimal

workorder_correctionfactor

Lease adjustment factor

BigDecimal
The total value of the take-off
number = accepted take-off (potential) * unit price
The value of items based on the plan

The sum of the values of all elements for a given structural element that are entered in the plan (list of materials) for a given structural element.

The value of the elements based on the procurement documents

The sum of the values of all items in the delivery order documents.

Value of items based on doc. delivery

The sum of the values of all items in the delivery documents.

Lease adjustment factor

Explained in the 'Budget progress' report

Variables

  • Lack

Subreport

  • Lack