How To View a Part Waterfall
A part's waterfall lists, date by date, everything that will use the part (demand: open orders and work orders) and everything that will bring it in (supply: open POs and build orders), with the quantity on hand projected after each one. Use it to see when a part will run short.Updated Nov 9 2026
Before you start
- Any user who can open part records can view the waterfall. Create PQuote on the page needs purchasing access to be useful.
-
Open the waterfall
- Go to Parts > Lists > Part List (the page is headed Parts).
- Click the filter search bar (Filter or search…), choose Prcpart, type the full part number, pick the part from the suggestions, and click Apply (1).
- Click the part number in the PrcPart column. The part record opens.
- In the part's left menu, open ACTIVITY and click Waterfall. The page opens on the Standard waterfall.
-
Read the standard waterfall
- There is one table per warehouse, headed Waterfall for location and the warehouse code.
- The Starting row shows the quantity on hand now. The row under it shows how much is already picked (Total Picked) and how much is On Shelf.
- Each row after it is one demand or supply, in date order:
- Demand (left side): Order, Order Part, Customer, Qty Need, Piece, Picked, Entry Date and Work Start Date. Ship Date and Due Date are hidden at first: add them with +/- Columns. Point at an order number to see its tags, status and customer PO.
- Date and Projected QOH (middle): the date the row counts on and the quantity on hand after it. A negative Projected QOH means the part runs short on that date.
- Supply (right side): PO, Supplier, Qty Gain and the piece. Point at a PO to see whether the vendor acknowledged it.
- (expiring bins) rows: stock in a bin that expires on that date is counted as used up then. A negative Projected QOH on such a row comes from expiring stock, not from an order.
- To count forecasts or vendor returns too, tick Include forecasts or Include vendor returns at the top. Cetec remembers these ticks for you the next time.
-
Switch to the allocation waterfall
- At the top right of the waterfall, click Switch to Allocation Waterfall (on a narrow screen, scroll right to see it).
- The Allocation waterfall shows demand and supply as Cetec's last allocation run matched them, with the Bin each demand is allocated from. The table heading gives the time of that run (Allocation as of …); orders entered since then aren't in it yet, so its totals can differ from the standard waterfall.
- Click Switch to Standard Waterfall to go back.
-
Act on a shortage
- Under the waterfall, at the bottom right, click Create PQuote to start a purchase quote for this part. Cetec creates the PQuote straight away and opens it.
- ACTIVITY > Orders W/need in the same left menu lists only orders already due (ship date or work start date today or earlier) that aren't fully picked and that the stock on hand can't cover. It can be empty while the waterfall shows orders using the part.