Can K1000 Asset Management perform calculations?
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?
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