Struggling here. Ok, I'm doing a transaction search (Sales Order) and trying to pull in the period.

 SELECT      'WDB' AS Company,      EMPLOYEES.NAME AS BMD,      TRANSACTION_LINES.SHIPDATE AS Period,      CUSTOMERS.CUSTOMER_ID AS CustomerID,      CASE WHEN CUSTOMERS.CUSTOMER_ID = 58780 THEN '530-00' ELSE ACCOUNTS.ACCOUNTNUMBER END AS GLAccount,      SUM( TRANSACTION_LINES.NET_AMOUNT ) AS Amount,      CUSTOMERS.NAME AS CustomerName  FROM      TRANSACTIONS TRANSACTIONS      INNER JOIN TRANSACTION_LINES TRANSACTION_LINES       ON TRANSACTIONS.TRANSACTION_ID = TRANSACTION_LINES.TRANSACTION_ID      INNER JOIN CUSTOMERS CUSTOMERS       ON TRANSACTIONS.ENTITY_ID = CUSTOMERS.CUSTOMER_ID      INNER JOIN EMPLOYEES EMPLOYEES       ON TRANSACTIONS.SALES_REP_ID = EMPLOYEES.EMPLOYEE_ID      INNER JOIN ACCOUNTS ACCOUNTS       ON TRANSACTION_LINES.ACCOUNT_ID = ACCOUNTS.ACCOUNT_ID  WHERE      TRANSACTIONS.TRANSACTION_TYPE = 'Sales Order'      AND (TRANSACTIONS.STATUS != 'Billed'      AND TRANSACTIONS.STATUS != 'Closed'      AND TRANSACTIONS.STATUS != 'Cancelled')      AND ACCOUNTS.ACCOUNTNUMBER LIKE '5%'  GROUP BY      'WDB',      EMPLOYEES.NAME,      TRANSACTION_LINES.SHIPDATE,      CUSTOMERS.CUSTOMER_ID,      CASE WHEN CUSTOMERS.CUSTOMER_ID=58780 THEN