Before you start

  • You need Inventory Management and View on Procurements.

Steps

  1. In the sidebar, select Catalog & Inventory › Project Materials. "Procurement Projects" opens: "View and manage projects with unfulfilled procurement items".

    Step 1. Procurement Items with Shortages, with one row expanded to show its projects.
    Step 1. Procurement Items with Shortages, with one row expanded to show its projects.
  2. Type in "Search items..." or choose a category.

  3. Select the chevron on a row. "Projects using this item:" lists each project with its stage (for example "Stage: Material Allocation") and its Required, Blocked and Issued quantities.

  4. Select a project's name to open the project.

  5. To export, select Export, then the format.

Result

The card Procurement Items with Shortages shows each item with Category, On hand, Available Qty, Blocked Qty, Issued Qty and Shortage. A shortage above 0 shows in orange. With none: "No items with shortages" and "All procurement items are fulfilled".

The export file is named after "Project-Materials".

Purchase orders for the shortages are raised in the Purchase module. See Create a purchase order.

If something is different

  • The sidebar says Project Materials, the page says Procurement Projects: it is the same page.
  • A project's materials are missing: they show here only when a project's lines need more than you hold. See the project's own Material Allocation stage. See Allocate materials to a project.
  • No Export button: you do not have Can export lists.