Adding User Names to Crystal Reports

I am trying to figure out how to add Sage User names to custom Crystal Reports that the users run in Sage.

Parents
  • 0

    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.

  • 0 in reply to Rick K

    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.

  • 0 in reply to BigLouie

    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.

Reply Children