search-icon

New report that will show stock status of ALL orders to be filled

started a topic 3 months ago

Please develop a report that will include all basic data for what is on a customer order and what’s the relating stock situation, something like this:

 

Order #

Customer

SKU

Product

Quantity Required Total

OnHand

Allocated

Available

On Order

203341

STS 

710461

HD Ultra Minidome 

2.00

2

2

0

10

 

As per the current work-around, you need to run 2 reports, export and stitch them together, apply some data consolidation formulas, then a VLOOKUP formula. It’s a lot of heavy lifting and it would be great if Dear could do it. And this will be recognizing that not all Sales Orders will be filled with stock obtained on Purchase Orders created via the Reorder Backorder function.


Thanks for considering.

Cam.


2 people like this idea
  • This is a great idea. It is a sales report that that includes information from stock availability and you'd be great to even have hyperlinks to the PO and SO.

Login or Signup to post a comment

2 people like this idea
Log in or Sign up to post a comment