Undefined does not play like an expense type

[Rhoogerh]

I'm trying to write a report that prints the details of existing unsubmitted reports, and it will print all of the lines with defined expense types but refused to include the lines with Undefined expense type.   Anyone else run into this and have a solution?   Back when this report was a query (from query studio), I had put in a filter where [Expense Type] is not missing, so that I would not include the Undefined (as they did not have a set GL account).  Now that I have removed that filter, I still do not get them.  I know I'm missing something simple, and will feel like a stooge when I find out what it is, but I'm running out of time  on this one.  Any assistance is appreciated.

[KevinD]

@Rhoogerh what other data items are on your report? Those might be what are causing Undefined to be "filtered" out. If you could take a screenshot of the columns you have on your report, I might be able to give you an answer just based on seeing what your data items are. 

[Rhoogerh]

Custom Codes are for Division, Legal Entity, Company, and Cost Center.  Not all of those fields are included on the report.  Those that are on the report are:

• Employee
• Account Code 1
• Expense Type Name
• Report Name
• Payment Type
• Posted Date
• Posted Amount (CC Currrency)
• Expense Amt (report)
• Credit Card Currency
• Expense Amt (reimbursement curr)
• Reimbursement Currency
• Sent for Payment Date
• Total (Posted Amount (cc curr))
• All custom fields

Filters set are:

• [Posted Date] in_range
• [Sent for Payment Date] in_range
• [Exclude Parent Entries]
• [Expense Type] is not missing     (- tried without this one . . . no difference)

[KevinD · Accepted solution]

@Rhoogerh try this. Make a copy of the report. Then on the copied version, remove anything that deals with Ledger or Account Code and see if that works. Undefined transactions do not have a ledger or account code associated to them, so adding those items to a report would filter them out. 

Think of each data item as a condition that must be met. In this case, the condition of having an account code is not met by an undefined expense, so therefore it won't appear in the report.

[Rhoogerh]

Thanks . . . that did the trick.  I wondered, as I could enter a GL account for Undefined at the Global level, but not at the individual levels.  I had supposed that the Global value would be passed down, but apparently not.  Appreciate the assist!