How to run an inventory usage report that shows Sales, Adjustments & Build Assembly

FSAC

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.

Acctd4

Is this one any help ?:

This is just from out of the Sample file so obviously is a bit limited in terms of what's in it but it can be modified further eg for certain Items (I've modified it to specific Suppliers here) & you can remove any columns you don't want. You can also drill down on any number to see ALL the transactions - including adjustments, item receipts, POs, SOs, Bills & Invs:

(And of course, it can also be exported to Excel 😊)

You'll find this report under the Reports dropdown menu > Inventory