Has anyone figured out how to get the 3-digit user code to print out on Crystal Report forms? I know there is an option you can check in Company Maintenance, Preferences tab, for "Print user logon on Reports," which only prints the user code on reports. I want to include a user code on an invoice form and other forms. I received one suggestion, to include the user code as a sub-report, but that may slow down the processing of printing the forms. I found the user code field in the SY_User table, but can't figure out how to link it to the SO_InvoiceWrk table, or how to otherwise get it to display on the form. Thank you.
(Sage 100 ERP v.4.5 & Crystal v.11.5.)
You need to add the user created key to the work table then link it to SY_User.
© 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