WHY Consumable device quantity shows different in list view than from view

mihirlimje867
Tera Guru

Here, the quantity is showing 192 on list view:

mihirlimje867_0-1741349072925.png

 

 

Here, the quantity is showing 1 on the form view:

mihirlimje867_1-1741349158827.png

 

 

 

Could you please let me know why this is happening?

Thank you in advance.

1 ACCEPTED SOLUTION

SK Chand Basha
Giga Sage

Hi @mihirlimje867 

 

  • The UI Policy "Quantity readonly until model and category qualify the asset and are not bundle" is the cause of this behaviour.

Refer this KB

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1638632

 

Mark it helpful and Accept Solution!! If this helps you to understand.

View solution in original post

3 REPLIES 3

SyedMahemoH
Tera Expert
Hi mihirlimje867
I Hope you are doing well!

Once Checked Aggregation in List View.
Check if the Quantity field in the list view is using an aggregation function like SUM(), COUNT(), or a related function.
If aggregation is applied, the list view might be summing up quantities across multiple related records, whereas the form view is showing only the individual record's value.

If Not Try This once 
Open the list layout configuration.
Check if an aggregate function (like SUM) is applied.
If needed, change it to display the actual field value.

mihirlimje867
Tera Guru

Hello @SyedMahemoH ,

Yes, I have used the aggregate COUNT function in the OnAfter transform map script.
But first, I stored the count value in a newly created variable, and then I updated the target.quantity field.

I want to list view quantity value on the form view as well.

Thank you for your response

SK Chand Basha
Giga Sage

Hi @mihirlimje867 

 

  • The UI Policy "Quantity readonly until model and category qualify the asset and are not bundle" is the cause of this behaviour.

Refer this KB

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1638632

 

Mark it helpful and Accept Solution!! If this helps you to understand.