I have some Expense Categories set as 'Rate is Required' and a default Rate applied in the Subsidiary sublist on the Expense Category.
Looking at the XML of an Expense Report, the data entered into the 'Rate' and 'Quantity' fields on the Expense sublist show up as {rate} and {quantity}.
However, when I create a Saved Search for Expense Reports (with Main Line set to False) I cannot get any data from 'Quantity'. 'Rate' doesn't appear on the drop down list, and formula fields for {rate} or {quantity} do not return results.
I can get the amount from the line using Amount Net of Tax, but I need to know the number of miles claimed (i.e. the Quantity).
I looked to see if I can get the Rate from the Expense Category, and then calculate the Miles from the Amount / Rate, but the Rate is not available (presumably because it is in a sublist of the Expense Category).
Surely there must be some way to report on the details entered in Rate / Quantity on Expense Reports?
Or (as a workaround), can I create a custom field on an Expense Category that holds the Rate, and then use this in my search to calculate the miles from the Amount? (This seems a very crude way to achieve what should be a simple and standard reporting requirement).