RE: Per Producer - this report is definitely useful to us, although would be great to have an ‘order cycle’ field, so that we can pull a report based on multiple order cycles at once and sort by that, rather than pulling three different reports (one for each cycle) - although totally understand that we may be the only people running multiple order cycles at one time, so we can handle pulling multiple reports and joining them all together at our end
RE: Per Consumer - It could maybe work as a starting place for our packing slip, but would need a number of additional fields in order to work as a delivery slip (ideally both picking & delivery will be the same thing if we get a report that encompasses it all). The way the report is sorted really doesn’t matter to us, as we will need to put all that info into a pivot table anyway.
These are additional fields above and beyond what is already in ‘Order Cycle Customer Total’ that we would need to make it work:
@openfoodnetwork Thanks! The Customer Totals report is now making beautiful pivot tables. @lin_d_hop The Delivery Report just didn’t quite have the detail we required, but a couple of new fields in the Customer Totals and hey presto we’re in business!