Hello,

I am editing the standard Expense Accrual Report to add the following fields; Approved Date, Last Submitted Date, BI Manager, BI Manager ID, Employee Email Address. I add these to all relevant queries and bring them in on the report design page, and the report runs without error. However, after adding these columns, transactions with the Approval Status 'Unassigned' are removed from the report, the remainder of the data ties exactly to the standard report without the additional fields.

I'm not understanding what is happening to cause these transactions to be removed. Aside from running two versions and unioning back in the unassigned data using another tool, is there a way to add these fields without sacrificing data?

Thanks