Asset Count Calculation Real Time

dvelloriy
Kilo Sage

Hello All,

We have a custom table "u_carton". During the Asset Receiving process, assets are loaded into the Carton.

There are different computers, peripherals associated to each carton.

Requirement is to create a custom field "Asset count" on carton table which will give the exact number of assets associated to a carton. (Carton appears on the asset record as Parent).

I am assuming we need to create a BR on asset table(alm_hardware) which will increment/decrement asset count value based on the data coming and going to/from asset table.

Can someone please advise and provide a script to configure this logic without much impact on performance?

Thanks in advance.

 

5 REPLIES 5

dvelloriy
Kilo Sage

Hello All,

Can someone please advise here?