We have 40 stores and a number of departments and categories and want to send stock take instructions down to store level from HQ. I can create a stock take in sql directly which then appears in Store manager at store level, but want to create a sql query to do this from HQ. Has anyone done this from HQ? Does anyone have a front end app to set the filter for the stock query at HQ?
Any help here would be greatly appreciated