Hi Good People of this Forum,
I would like to ask for some help in making a custom report as I am clueless about using SQL.
A large percentage of my business is based on consignment, and so having inventory transfers is saving me the trouble of tracking this using Excel. However, I would like to be able to generate a report based on stock of various items currently at a particular customer’s “warehouse” instead of clicking on each inventory item one at a time, in other words, I need to make a warehouse stock report. I imagine that this kind of report would probably be useful for those who have several inventory locations as well.
Any and all help is much appreciated!