Sage 100

 View Only

  • 1.  Employee Address

    Posted 01-08-2021 14:00
    I am trying to create a quick (HA) Crystal report to list Dir Dep email addresses for a client.
    HOWEVER - I can't find some of the email addresses I see on the screen ANYWHERE.
    I've got a report listing the email address in the PR_Employee, PR_EmployeePIIWrk, and PR_EmployeeDocuments files.
    There is at least one employee whose email address I can plainly see in the Paperless button (and I deleted it and added it back in) and it does not print from any of those fields.

    What am I missing?

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------


  • 2.  RE: Employee Address

    Posted 01-08-2021 14:05
    You can't pull from Employee Docs, those emails aren't covered in the PII table.  Tried this - didn't work!
    You can type or copy/paste into the employee email in Employee Maintenance and pull those.
    N

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------



  • 3.  RE: Employee Address

    Posted 01-08-2021 16:45
    When in doubt, I make a change to the field in question, save it.  Then I go look in the folders where I suspect the change to be and sort tables by recent dates.  That works almost all the time.  You may DFDM the table.  Perhaps the record is missing some data and Crystal is missing it as a result.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content