/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Can K1000 Asset Management perform calculations?

05/30/2019 300 views

Hello! I am setting up a device asset detail and would like to track the following for cost of each device: unit cost, taxes, fees, and shipping. Is it possible to have fields for each and then a field that totals unit cost + taxes + fees+ shipping?

1 Comment   [ + ] Show comment

Comments

  • I would like to be able to do the same thing but there is no ticket rule attached to Assets. Is there?

All Answers

0

Yes it can and the simple answer is to write a ticket rule to calculate whatever you need and populate the asset field with the answer.

So I would suggest you have the following fields:


Unit Cost - Field A

Taxes - Field B

Shipping - Field C

Total - Field D


First configure the rule so it only runs if field D is null, as that will prevent unnecessary server time.

Then simply write the ticket rule to select A, B and C and the update rule to calculate the value and populate D

We did this with our Asset Depreciation pack and rules so feel free to reach out for more information

Answered 05/31/2019 by: Hobbsy
Red Belt

  • I cant seem to find a ticket rule option in Asset Management.
  • HI hobbsy. How did you do these calculations?
    • Hey, so first you need to know that the ticket rules are in the servicedesk section. Next you need to understand that any code in the Ticket rule is not just related to ticket data, so in our example, we can use it to calculate a field in the Asset table. The select statement will need to select assets rather than tickets, and I would suggest you set the rule so it calculates only when the total field is null. That way only those assets without a total get calculated.
      • Thanks Hobbsy. THat was going to be our approach. Use the data in the ticket to select the asset record and update it.