Calculation Field Logic

Modified on Mon, 22 Jun at 2:13 PM

Invista’s logic based fields


Invista’s asset management module has certain logic based fields. Refer the below table for details:


S.no.

Field Name

Logic

1

Inspection needed every

If Equipment Type:

  1. Portable Tank, then Inspection needed every = “2.5”

  2. Chassis, then Inspection needed every =“1”

  3. IBC, then Inspection needed every = “5”

  4. Pressure Vessel, then Inspection needed every =“5”

2

Next pressure valve test date 

Next pressure valve test date  = Last Pressure Valve test date + 1 Year 

3

Rep. Val

Rep Val. = Stated Val. - (Stated Val. x Dep% x Age)

4

Adj Rep Val.

If Rep. Val. >= max dep, then Adj Rep Val = Rep. Val

Else Adj Rep Val = max dep value

5

Age

If Asset Type = Leased, then Age = Decimal value(Current Date - MFG Date)/365.25. 

ElseIf Asset Type = Owned, then Age = (Current Date - MFG Date)/365.25)

ElseIf Asset Type = NVOCC, Age = Blank

6

No. of Years on lease

If Asset Type = Owned. Field is blank

Else, (Current Date - Lease on Hire Date)/365.25 → Give number up to 2 decimal value

7

Transports Class 8 Goods

If the Product field is empty, then keep the field blank.

   

If the Product field has value, then if Hazard class = 8, then Transports Class 8 Goods = “Yes”. Else, “No”


Will be Triggered - Whenever the product against the asset is changed

8

NVOCC Return Date

If Status = Active, then keep the field empty

Else, Mention the date on which the Status was market InActive

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article