Dashboard ideas

Follow

Geoff Poitras

• April 16, 2020 05:13

For our application the following would be helpful in the dashboard.

1.  Active SKU's which are at risk of stockout and NOT on order with a supplier.  This would include items with no sales velocity (such as a new SKU recently added), with a stock quantity of zero.

2.  Purchase orders which are 100% (or greater) filled and not closed / in a completed status.  This would help clearn up the list of open PO's.  In our case we have 170+ open PO's.  If I spent 20 minutes to open all of them, I would likely find a few that I could close out.

3.  Open Purchase orders which have been open past the set supplier lead time, or a user set number for the dashboard - this allows a quick reference as to which supplier we should follow up with without having to go back into each PO or pull a backorder report. 

0

• 

  Bob Kahn

  • April 18, 2020 15:57

  On #1 we just filter stock to <0 and you get the same result so we don't need this report.  Certainly would NOT want those with no sales velocity.

  #2 would be nice

  #3 neutral.  We don't have as many open purchase orders so we can keep up with them.

   

   

   

  0

  Comment actions Permalink

Please sign in to leave a comment.