Skip to main content
Solved

Adding column to stock items grid

  • October 20, 2025
  • 12 replies
  • 69 views

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.

12 replies

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

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • 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.


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

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • 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.


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

Where will it get its value?


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

The user. 


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

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.


alexx
Jr Varsity II
Forum|alt.badge.img
  • Jr Varsity II
  • 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.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 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. 


darylbowman
Captain II
Forum|alt.badge.img+15
  • Answer
  • October 20, 2025

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.


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

I will give it a go


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

This worked! thanks so much