Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Future Stock Report?
Morning all,
My company sells mainly from stock in the warehouse (as opposed to drop shipping). We regularly have a situation where stock runs out in the warehouse but we have a series of purchase orders that are due over the next 3 months.
i.e. 30 on PO ETA 1st Sept, 30 on PO ETA 1st Oct etc etc etc
I need a report that shows the following information (for lots of items)
________Qty In_Qty________On______________________<-----Due---->
Item____Stock__Allocated___Order___Balance__________1-Sep____1-Oct
#1______10______5________0________5_______________10_______10
#2______100_____100______150_____-150_____________75_______75
Basically I need a report that my sales office (and directors) can look at and at a glance see if we have stock of an item, if we are oper sold, and if we are over sold WHEN the stock is going to come in.