I am trying to figure out how to add Sage User names to custom Crystal Reports that the users run in Sage.
It is a custom report like the question said "CUSTOM Crystal Reports". Mostly in the Sales Order module, but need this for any of the modules that a custom report is created in. Mostly the AR_InvoiceHistoryDetail and AR_InvoiceHistoryHeader, but need this for any of the tables that a custom report is created in.
The Invoice History tables will only contain the ID of the person who updated the file. If you want to know who created the original sales order then you would need to do some work. You would need to create a UDF in the sales order files and have it flow to AR Invoice History, other wise you would need to use the Sales Order History files.
The Invoice History tables will only contain the ID of the person who updated the file. If you want to know who created the original sales order then you would need to do some work. You would need to create a UDF in the sales order files and have it flow to AR Invoice History, other wise you would need to use the Sales Order History files.
Further to what BigLouie wrote, I believe AR invoice history's user field might be the ID that posted the sales journal, not who last edited the invoice.
Rick K,
I don't know why that method wouldn't work for you.
Are you wanting to know who printed the report or who created the record?
I want to know who the user is that printed the report.
*Community Hub is the new name for Sage City