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.
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.
© 2015, Sage Software, Inc. All Rights Reserved. Sage energizes the success of businesses and their communities around the world through the use of smart technology and the imagination of our people. Sage has reimagined business and brings energy, experience and technology to inspire our customers to fulfil their dreams. We work with a thriving community of entrepreneurs, business owners, tradespeople, accountants, partners and developers who drive the global economy. Sage is a FTSE 100 company with 14,000 employees in 24 countries. For more information, visit www.sage.com.
Community Terms of Service | Community Guidelines | Blog List | Community Help