Skip to main content
Solved

Count Reports number


Chamath Kuruppuarachchi
Hero (Partner)
Forum|alt.badge.img+12

Hi All, 

I am seeing this weird behaviour in count reports window. I want to adjust it in from the count report 1 to 50 but it is not filtering correctly. Instead of 1,2,3 it shows as 1,10,11. 

Is there a way to over come this, customer wants to see them in a sequence and unable to query for the count reports 1..50 as it would not show those count reports.

Thanks,
Chamath

Best answer by KethakaG

Hi ​@Chamath Kuruppuarachchi ,

This behaviour can be seen throughout the system and an idea has already been added: 

https://community.ifs.com/ideas/sorting-of-alphanumeric-text-id-fields-treat-numbers-as-number-49225

As a workaround, I would suggest you to introduce a custom field that would add the Count Report No to a larger number like 100000.

Custom field’s output would be, 100001, 100002, …, 100010, …

Then you may sort that column to see the records in a sequence.

Regards,
Kethaka

View original
Did this topic help you find an answer to your question?

3 replies

KethakaG
Superhero (Employee)
Forum|alt.badge.img+14
  • Superhero (Employee)
  • 134 replies
  • Answer
  • May 16, 2025

Hi ​@Chamath Kuruppuarachchi ,

This behaviour can be seen throughout the system and an idea has already been added: 

https://community.ifs.com/ideas/sorting-of-alphanumeric-text-id-fields-treat-numbers-as-number-49225

As a workaround, I would suggest you to introduce a custom field that would add the Count Report No to a larger number like 100000.

Custom field’s output would be, 100001, 100002, …, 100010, …

Then you may sort that column to see the records in a sequence.

Regards,
Kethaka


Chamath Kuruppuarachchi
Hero (Partner)
Forum|alt.badge.img+12

Hi ​@KethakaG Thank you for the information. You mean add a custom event to generate the count report? or create a separate custom field?

Thanks,

Chamath


KethakaG
Superhero (Employee)
Forum|alt.badge.img+14
  • Superhero (Employee)
  • 134 replies
  • May 16, 2025

Hi ​@Chamath Kuruppuarachchi ,

I meant a separate custom field.

Regards,
Kethaka


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings