Hello everyone!
Hope you're all happy, safe and well.
Is it possible to create a System Report that will return results of all the transmittals the logged in user received? We have one already that shows issued transmittals (see below) but is it possible to edit this to show transmittals received instead? Any help gratefully received! Many thanks. Chris
START WITH Transmittal SELECT Id, DistributionOrder.DateReceived, Code, LineItems.Reason.Name, IssuedTo.FirstName, IssuedTo.Surname, LineItems.DateToReturn, AcceptedStatus, LineItems.DateAcknowledged, LineItems.DateReturned, LineItems.Document.Code + ' ' + IFNULL( LineItems.Document.Middle, '' ) Number, LineItems.Document.Revision, LineItems.Document.Name WHERE AuditDetails.Person.Id = $Session.Person.Id AND AuditDetails.AuditDef.ActionType = 1 AND AuditDetails.AuditDate = @IssueDate AND AcceptedStatus = @AcceptedStatus ORDER BY DistributionOrder.DateReceived DESC
Bump!