Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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.