Hi all,
I want to start reporting using the Average Cost, a field which is not typically available to most of our users.
For this reason, I have created a separate form so that I now have "Lapwing - Sales Order" which is available to all users and "Lapwing - Sales Order with Average Cost" which is available to only managers.
I can see the average cost on my form and also on the xml.
But for whatever reason, this field isn't an available option to report on when building a Transaction Saved search. Any idea why?
Here I am trying to find Average Cost as a field for the results of my search. Ctrl + F also finds no results.
I also tried to use a formula, but that returns invalid field
Does the saved search perhaps also use the default form which is not the manager only form? And if so, how can I specify for my search to use the form that does include the average cost?