Re-order points

  • 1
  • Question
  • Updated 3 years ago
  • Answered
HI,

I think that this is probably pretty easy but I can't for the life of me work it out..... We want to weekly produce a report that shows all the inventory parts that have hit their re-order point so that every Friday we can do one large order? Any help will be appreciated :)
Photo of Tara Murnane

Tara Murnane

  • 388 Points 250 badge 2x thumb

Posted 5 years ago

  • 1
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,684 Points 10k badge 2x thumb
Hi Tara

Reports > Inventory > Inventory Status by Supplier

There is an "Order" column which displays a tick if On hand is less than or equal to reorder point.

Graham Boast  0409317366
Reckon Accredited Consultant
graham@reckonhelp.com.au
http://reckonhelp.com.au/remotesupport.htm
Photo of Tara Murnane

Tara Murnane

  • 388 Points 250 badge 2x thumb
Thanks Graham, but this produces a 252 page report for us, is there any way that we can show only parts that have hit re-order point and need to be ordered?

we can do it , in Desktop, but hope fully Graham , can resolve it.

Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,684 Points 10k badge 2x thumb
Hi Tara

Unfortunately, the report doesn't have the ability to filter by the "Order" column.

Workaround is to download the file to Excel, then use excel's filtering ability to display only the lines with a tick in the order column.


Graham Boast  0409317366
Reckon Accredited Consultant
graham@reckonhelp.com.au
http://reckonhelp.com.au/remotesupport.htm
Photo of Broni K Beerling

Broni K Beerling

  • 758 Points 500 badge 2x thumb
I also need to run this report - problem being is you can only run it for inventory parts as assembly items dont show :(

This conversation is no longer open for comments or replies.