How to run an inventory usage report that shows Sales, Adjustments & Build Assembly
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.
- All Categories
- 6.7K Accounts Hosted
- 5.9K Reckon Accounts (Desktop)
- 3.2K Reckon One
- 144 Reckon Payroll Upgrade for Reckon One 🚀
- 10 Reckon Invoices App
- 1.1K Reckon Payroll App & Web
- 12 Payroll App - Help Videos
- 18 Reckon Mate App
- 14 Reckon Insights
- 107 Reckon API
- 946 Payroll Premier
- 115 Payroll Premier upgrade to Reckon Payroll ⤴️
- 326 Point of Sale
- 1.9K Personal Plus and Home & Business
- 68 About Reckon Community