User field on Sales Order screen

Question

Hi ALL, 
 There is a field called "User" on the Top right on the Sales Order Entry screen. Can we pass the values of that field from the BOI programming? 
 And Can please tell me that it stores into which table? 
 
 Please help me by giving hint to resolve this issue. 
 
 Thanks 
 SF

Beevet · Answer

I figured this out thanks to this post by Kevin M, who credited David Speck: 
 https://www.sagecity.com/us/sage100_erp/f/sage-100-business-object-interface/174328/pre-totals-script---accessing-item-information-using-olines-getchildhandle-itemcode/445343#445343 
 The trick was to add a ReadAdditional call before calling the child handle. I added one line, which was 
 retVal = oBusObj.ReadAdditional("UserCreatedKey") 
 immediately before 
 Set oUser = oBusObj.AsObject(oBusObj.GetChildHandle("UserCreatedKey")) 
 
 Now the UDFs for names are filled. 
 I do not know why this was needed. I did find the SY_USER table in MAS_System folder. Everything looked like it was supposed to, there were no name changes or anything else obvious to me. I suspect something changed in the underlying Sage code that is now different that requires this call? 
 Thank you for considering this. 
 Chris

Sage 100

User field on Sales Order screen

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING