Getting User Code

Question

I am trying to change the user code on orders importing through ROI's Insynch based on the customer no. To get the user code do you use "oSession" I wouldn't think so because the actual user is not actually in the session right? And I shouldn't use "oBusObj" either because it is in another table, not the header correct? I do not see any examples of going into the SY_User table from the header to pull the value.

Kevin M · Accepted Answer

If you have a "who did the data entry" value in the source system, ask ROI to push that into a UDF. 
 The Sage fields for user created / user updated are system controls tracking who does what (audit trail of data entry activities) which is completely unrelated to who is "used per customer". Don't try and repurpose Sage fields. Custom data logic is what UDF's are meant for.

jepritch · Answer

There is no User Code field in the stock Sage 100 so, I'm assuming the lookup above either retrieves the code from the UserCreatedKey, or User Code is a UDF. 
 I'm not sure the intention, but possibly it would be better to implement a UDF for this purpose? Or if you are always basing the user code on the customer, possibly associate a UDF on the customer table with the appropriate user code and then use that in this lookup or wherever it is needed? 
 E

Sage 100

Getting User Code

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING