Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

How to a UDF from GL_DetailPosting to Journal Drill Down

Posted By Rob.Swenson over 9 years ago

Hi,

I have a UDF (USER_KEY_CREATE) created in GL_DetailPosting that stores the user key of the person who creates a journal entry. I am trying to get the UDF field to display on the journal drill down field of GL account inquiry. I had assumed that the GL drill down would include UDFs created in GL_DetailPosting (because I assume it is drawing its data from that file) but I don't have an option to add fields in custom office. Ideally, I would like the user's name associated with the user ID to display if possible with scripting.

MAS 200 Ver 4.5

Thank you for any help.

Rob

0 BigLouie over 9 years ago

A sweet girl helped me with this so I'll pass it on and help you. Here is a script I use in Sales Order to write out the user's first and last name to a UDF.

sFirst="":sLast="":sKey="":sCKey=""

retVal=oBusObj.GetValue("UserCreatedKey",sCKey)

SetoUser=oBusObj.AsObject(oBusObj.GetChildHandle("UserCreatedKey"))

retVal=oUser.getvalue("UserKey$",sKey)

retVal=oUser.getvalue("FirstName$",sFirst)

retVal=oUser.getvalue("LastName$",sLast)

If sKey=sCKey then

retVal=oBusObj.SetValue("UDF_FIRST$",sFirst)

retVal=oBusObj.SetValue("UDF_LAST$",sLast)

end if
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

How to a UDF from GL_DetailPosting to Journal Drill Down

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING