Sort Companies list by ID

sneha · 2013-08-08

We are on 5.0 and we've around 8 companies in our database. The companies are sorted by Name when the user selects "Open Company". But, the user wants to see it in different order. I think, a new filed "ID" can be added to Company table to achieve this. But, not sure where can I write the code in codeunit 1 (or) 2 to sort it by ID?

Thanks for your help!

Luc_VanDyck · 2013-08-09

You can't sort this list through code. The user needs to press Shift-F8 to sort it.

Another option might be to include the ID in the Companyname:
001 - Company Z
002 - Company A

sneha · 2013-08-09

We will append the ID if we create a new companies but, don't we need to rename the company if we need to append the ID against existing companies? I think, it is more dangerous in our case, considering integration, consolidation, etc..

sneha · 2013-08-12

Any more thoughts on how to sort the companies list?

sneha · 2013-09-06

How to hide the inactive companies from the Open Company screen? please suggest..

sneha · 2013-09-10

I've added a new field called "Sort By" to company table. And, added it to keys. Now, I want to sort the Open company window based on my new field "Sort By". Is it possible? please suggest...I don't think changing the primary key is a solution.....

Luc_VanDyck · 2013-09-11

Read my first answer again: "You can't sort this list through code. The user needs to press Shift-F8 to sort it.".

Andwian · 2013-09-20

sneha wrote:

How to hide the inactive companies from the Open Company screen? please suggest..

Specify the Roles with the only active companies.

sneha · 2013-09-20

Thank You Andwian! Yes, I was able to hide the inactive companies but, still not able to sort the companies the way we want without renaming. Sounds like, it is not possible.

Sort Companies list by ID

Comments

Categories