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

FSAC
FSAC Member Posts: 1 Novice Member Novice Member

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.

Answers

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,754 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited October 2022

    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

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)