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.

More Content