Sage 100

v5.1 Standard I just added a line detail UDF to purchase order entry. By default, the UDF is added to the secondary grid. The client would like to have the field located in the primary grid, in a specific column for all users. Is there a way to get the new UDF field in the correct position of the secondary grid for all users? I know each user could drag the field to the position, but i am looking for a global setting for all users. Does this feature exist?

In Custom Office, if you double-click on the primary grid, you can use the Add Fields tab, although I don't think you can guarantee the position of the column.

I tried that last night and even though I added it to the primary grid, the field appears in the secondary grid of PO Entry. It doesn't matter what grid it is in if we still have to drag it to the correct spot for every user. Also, they want it in a specific position for all users. We are trying to avoid having to log in as every user and modify each PO Entry grid.

All of the grid definitions are stored in SY_GRIDDEFINITION.M4T. I didn't fully test this but once you get your screen customization setup with the fields you want in theory you could go into the this table using DFDM and change the value of the frozen$ field in each PO Grid definition record for the primary grid to be Y. That way users could never move the fields around. I don't know all of the implications downstream that may happen but it may be worth looking into.

Thanks @TimEfinger This is definitely worth looking into.

Good question - Sometimes when I add a UDF it does appear in the primary to the far right for users. I wonder if you place it originally in the primary it will appear. Would be a great feature.

@JeffSchwenk I think this is a bug. Out of habit I always add a detail udf to the secondary grid. I did that in this instance then later came back into the design mode and changed it to the primary grid. When I went into PO Entry, Lines, the UDF still showed in the secondary grid.