No sooner did I post an example of our software used to produce economic order quantities; I got a telephone call telling me that this is fantastic and the best thing since sliced bread (sliced bread is something, by the way; I do not like; I prefer unsliced) but the example used of EOQ is too complex, and he would like a simpler example.
So here is a simple example, I want the code of a stationery product that is about $6 for BIC Australia. That is a fairly common problem.
So what I could do is go to the register reports and select a full listing
I now ask for BIC but note it does not have a question cost price, with adhoc reporting you do not need to worry as it is not required.
I then get this excel listing.
I go over the column labeled Wholesale price
Press on the top Sort & Filter
Then press select turn off all the costs.
Then I click on all the costs that are about $6.
In this case, there is only one, and it is listed immediately here.
The code I wanted was 41330, pretty nifty.
With adhoc reporting, the information you get is limited only by your imagination.