How to add User ID to Detail By Source Report.

Sage 100 ERP

Sage 100 ERP
Welcome to the product group for Sage 100 ERP. Share discussions, questions, and best practices with other Sage 100 ERP users. Sage 100 ERP is the most comprehensive feature-rich management suite for mid-sized and smaller distributors and manufacturers.

How to add User ID to Detail By Source Report.

  • I would like to add the User ID to each journal entry listed on the Detail By Source Report. I can see that there is a field called "UserUpdatedKey" in the GL_GeneralJournalHistory table. How can I link the table and insert that field into the Detail By Source Report in the General Ledger module. I'm working in MAS 90 version 4.30 and the table that is used to create the Detail By Source Report is the GL_DetailBySourceWrk table. This should be an "easy customization" of a standard MAS 90 report. Right? 

  • Yes you would think but the issue is that the UserUpdateKey is something like 0000050 when I am guessing you want the User ID. You might need to add the table to the report because I can find no way to create a UDF that will pull the 3 digit user code.

  • Hi Big Louie,

     

    Yes I want to add the User ID and not the key. But how do you add a field (User ID) from a history file (GL_JournalHistory) so that the User ID gets populated into the workfile (GL_DetailBySourceWrk) that the General Ledger Detail By Source report is generated from?

  • Create a UDF in the works table that pulls the UserUpdatedKey from the GJ_JournalHistory. Then after updating the ODBC open the report and verify database. Then add the SY_User table and link on the UserKey. This should do it.

  • Big Louie,

     

    Thanks for the instructions - I did exactly what you said, and the User ID now prints on the General Ledger Detail By Source report. Thanks for your help.