New report that will show stock status of ALL orders to be filled
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.
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.