We are looking for a way to streamline reporting for each supplier.
Currently before we place a stock order, I run a fast report of each item from that specific supplier over a set date (Usually last 3 months to date and 12 months to date). I will start with the starting quantity of a date range, then +/- stock for every bill (item receipt) and inventory adjustment, then subtract current stock on hand which will give me a true item usage amount over the set period of time.
I can't find any obvious report that will allow me to calculate the above because sales reports only allow for sales (invoices) and adjustments (credits) and don't take into account items used as part of a build assembly. Is there any way to simplify this or is this an area of Reckon that is lacking in reporting ability?
In the perfect world I would like to be able to pull a report and bring the data across to a spreadsheet which I can then make it auto populate other inventory order sheets etc.
