Skip to Content
Apr 13, 2017 at 09:08 AM

Stock Query & Reports


Hi Gurus,

I am needing some help with two reports, please take a look at the requirements below and let me know if you can assist?

1. A report for average monthly sales as well as displaying 3, 6 or 12 months (not a rolling report). It needs to contain:

Group Name, Item number, Item description, Average sales, Highest unit sales qty & value within monthly, 3,6,12 months sales, Item cost and Total Cost (Average sales * item cost)

2. Is it possible to use the average sales to generate an additional report such as one containing:
Min stockholding (Average *factor 1.5)
Max stockholding holding (Min stock holding * factor 3)
Model stockholding (Min + Max / 2)
Total value of model stock (Model stock * item cost)
Total value of max stock (Max Stock * Item cost)