Skip to main content
Solved

Adding column to stock items grid

  • October 20, 2025
  • 12 replies
  • 133 views
  • Translate All

Forum|alt.badge.img

I am needing to add a custom “Sort Code” column in the Stock Items screen (IN2025PL). I am a new user and seem to be stuck. 

Best answer by darylbowman

I would add an Attribute (CS205000) and assign it to the applicable Item Classes (IN201000). When an Item Class is chosen on an Item, the new attribute will be available on the ‘Attributes’ tab.

Then you can add the attribute column to the GI.

View original

12 replies

darylbowman
Captain II
Forum|alt.badge.img+17

This screen is a Generic Inquiry. I would recommend watching a ‘getting started’ video for GIs.

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • October 20, 2025

I have watched the videos and still cant find how to add a custom sort code column maybe I am watching the wrong ones. I have reached out to a rep but really wanted to get this solved. Once I get it I will know if forever though.

Translate

darylbowman
Captain II
Forum|alt.badge.img+17

What exactly do you mean by a custom sort code column?

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • October 20, 2025

A new column, to be named 'sort code', that will contain a numerical value. This column's purpose is to allow the data to be sorted in descending order based on its values.

Translate

darylbowman
Captain II
Forum|alt.badge.img+17

Where will it get its value?

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • October 20, 2025

The user. 

Translate

darylbowman
Captain II
Forum|alt.badge.img+17

The only way this is possible is if you add a custom field (or attribute) to the Stock Item itself (IN202500), which you would add the the GI’s ‘Results’ tab.

From the sound of things, I’m not sure this is what you’re going for, but you cannot edit values in a GI. True GIs are only ever readonly. There are screens that look very much like GIs that you CAN edit, but they are not true GIs.

Translate

alexx
Varsity I
Forum|alt.badge.img
  • Varsity I
  • October 20, 2025

Does the data show anywhere on the stock items files? It can’t just pull info that doesn’t exist in a file.

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • October 20, 2025

That makes perfect sense. I now understand that a Generic Inquiry is read-only.

Where exactly on the Stock Items file (IN202500) can I add that custom field so that it holds the value I need to assign? I keep looking for UDF or something.

I also spent some time in Customization Projects but failed there first. Makes since that I should create a data field or something. 

Translate

darylbowman
Captain II
Forum|alt.badge.img+17

I would add an Attribute (CS205000) and assign it to the applicable Item Classes (IN201000). When an Item Class is chosen on an Item, the new attribute will be available on the ‘Attributes’ tab.

Then you can add the attribute column to the GI.

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • October 20, 2025

I will give it a go

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • October 20, 2025

This worked! thanks so much

Translate