SELECT
  LTRIM(RIGHT(CONVERT(varchar(6), [ie].[Invoice_Number],100),7)) AS [Invoice#]
  --, FORMAT([ie].[DateTime], 'MM-dd-yyyy')        AS [Void_Date]
  , CONVERT(varchar(10),REPLACE(CONVERT(varchar(10), [ie].[DateTime],101),'/','-')) AS [Void_Date]
  , LTRIM(RIGHT(CONVERT(varchar(20), [ie].[DateTime],100),7))   AS [Void_Time]
  , [ie].[ItemNum]                AS [Item_#_Removed]
  , [inv].[ItemName]
  , '$' + CONVERT(VARCHAR(18), CAST([ie].[Amount] AS MONEY))  AS [Amount]
  , CONVERT(VARCHAR(10), CAST([ie].[Quantity] AS INT))    AS [Quantity]
  , LTRIM(RIGHT(CONVERT(varchar(20), [ie].[Reason_Code],100),14)) AS [Reason_Code]
FROM
  Invoice_Exceptions AS [ie]
  JOIN inventory AS [inv]
  ON [ie].[ItemNum] = [inv].[ItemNum]
  AND [ie].[DateTime] >= @Yesterday AND [ie].[DateTime] < @PeriodEnd
ORDER BY DateTime ASC

SELECT
CONVERT(varchar(10),REPLACE(CONVERT(varchar(10), [E].Exception_DateTime,101),'/','-')) AS [Date],
LTRIM(RIGHT(CONVERT(varchar(20), [E].Exception_DateTime,100),7))   AS [Time], 
CONVERT(VARCHAR(10), CAST([E].Cashier_ID AS INT)) AS [Cashier_ID],
LTRIM(RIGHT(CONVERT(varchar(25), [P].shortDescription,100),25)) AS [Description],
LTRIM(RIGHT(CONVERT(varchar(50), [E].Reason_Code,100),50)) AS [Reason] 
FROM 
Exceptions AS [E]
JOIN Permissions AS [P]
ON [P].PermissionID = [E].Exception_Type and Exception_Type IN (20,21,36) 
    AND [E].Exception_DateTime >= @Yesterday AND [E].Exception_DateTime < @PeriodEnd
ORDER BY Exception_DateTime ASC