An Outstanding Purchase Order Report lists line items with unreceived quantities under a given vendor or for a given SKU. This can be helpful in determining which orders need to be cancelled or what orders need updates/help with booking dates.
If we believe a supplier has not received POs from us (either via email or via EDI) then we can generate an OOR for them to cross-check their system against our report to confirm if anything is missing. Based on their response we can determine what course of action is required to fix the problem.
If a supplier advises us that a product is EOL (end of life), Obsolete or unavailable due to some other restriction, we can send them an OOR for this SKU to ask the supplier to confirm what we can cancel. Doing so will prevent customer orders being assigned to POs that won't be received and help with the open to buy (OTB).
To ensure we keep a steady stream of stock and avoid assigning SOs to POs that are not current in a supplier's system, we should cancel old POs unless they are on backorder with the supplier. To do this we send an OOR of POs that are older than 3 months to all applicable suppliers requesting cancellation. If they cannot cancel, we should update the PO with the relevant ETA.
Open item tab and select any sku
Open any sku on the item card
Click on the number next to “Qty. on Purch. Order” on any SKU page
Filter the search results by “Location code” (if needed) and “Outstanding Quantity” (>0). Make sure that you’re filtering for the “Buy from Vendor Code” or the SKU itself “No.)
Set filters as necessary: I.e. outstanding orders by vendor number (BOSCH) for AOL locations
On the Excel sheet you export, the only columns you typically need are:
Document No.
Line No.
Buy from Vendor No.
No. (SKU)
Location Code
Description
Quantity
Outstanding Quantity
Expected Receipt Date
Status / Comment
7. Control + E and save into your file
8. Import into a google doc and rename as the vendor and date created