Sage 100

Am I overlooking something -- trying to add the user code (not name) of the Sage 100 user who created a record onto the SO Header. I can get the full name but apparently not the code -- or am I overlooking something? Edit: Should have been clear - was looking to add the three char user code to the SO Header Panel via Custom Office. Solution below (v2015)

What steps are you taking?

There should be a UserCreatedKey field in SO_SalesOrderHeader.

You can link the UserCreatedKey to the SY_User table to get the UserCode.

The User Updated key in the record is a 10 digit key used to access the user file. Maybe a UpdateUserCode UDF in the record, and a script to use the 10-digit-key to SY_USER file to get the code.

Link as per the attached file.

I'm trying to add it to the SO Header not a report.

Isn't the user code already on the SO header???

That field on the screen is the Created User ""Login in"", not the User Code. However, (in v2016); in Customizer, you can ADD any field from the ""UserCreatedKey"" Entity. Press Show ALL to toggle from UDF Fields to existing data fields.

There's also this: http://community.90minds.com/2011/05/27/add-user-name-to-mas90-custom-report/

We have created a script to pull in the user name as well (pre-2016). @MarcCregan

That looks like a 2016 field. This customer is on 2015.

Looking to add the field via custom office to a panel. On version 2015 Standard

Found the solution - I used @MadelineStefanou table and had to also click ""show all"". Once I did the field appeared. Tested works