ConnectWise PSA Procurement and Inventory
Overview
Procurement in ConnectWise PSA has a sell side (sales orders and the procurement product items placed on tickets, projects, opportunities and sales orders) and a buy side (purchase orders to distributors such as Ingram or TD SYNNEX). Received stock lands in warehouse bins. Through Conduit the reads are all read tier; creating an adjustment is write; posting it, which actually moves stock, is admin.
Anti-triggers
- Catalog SKU definitions (what a product is, its default price and cost) — use
connectwise-psa-product-catalog. - Quoting — quotes live in ConnectWise CPQ or a quoting tool, not in PSA procurement.
- Agreement billing — agreement additions and recaps are read with
cw_get_agreement_additions,cw_search_agreement_recapsandcw_get_agreement_recap; see the/check-agreementcommand.
MCP Tools
| Tool | Tier | Purpose |
|---|---|---|
cw_search_purchase_orders / cw_get_purchase_order |
read | Buy-side POs (conditions such as closedFlag = false, vendorCompany/name = 'Ingram') |
cw_get_purchase_order_items |
read | PO lines: unit and extended cost, quantity received, receipt status (purchaseOrderId) |
cw_search_sales_orders / cw_get_sales_order |
read | Sell-side sales orders |
cw_get_sales_order_products |
read | Products on a sales order |
cw_search_procurement_products / cw_get_procurement_product |
read | Catalog items placed on a ticket, project, sales order or opportunity, with their own price, cost and margin |
cw_list_warehouses / cw_list_warehouse_bins |
read | Where stock lives |
cw_get_inventory_on_hand |
read | Every catalog item with non-zero stock, one row per bin (negative balances included). Pass warehouseId — scanning every bin is slow |
cw_list_adjustment_types / cw_get_adjustment |
read | Adjustment types and existing adjustments |
cw_create_adjustment |
write | Adjustment header (identifier, typeId, reason); moves no stock |
cw_add_adjustment_detail |
write | One signed line (quantityAdjusted negative removes stock) per item and bin |
cw_close_adjustment |
admin | Posts the adjustment: applies every line to on-hand. Irreversible except by a counter-adjustment |
All search tools take ConnectWise conditions syntax, orderBy, page and pageSize (max 1000). Date literals go in square brackets in UTC: poDate > [2026-01-01T00:00:00Z].
Workflows
Open purchase orders and what is still outstanding
cw_search_purchase_orderswithconditions: "closedFlag = false", ordered bypoDate desc.- For each PO,
cw_get_purchase_order_itemsand compare quantity ordered with quantity received. - Report per vendor: open POs, lines not yet received, and their extended cost. Old open lines are usually either back-ordered or received without being marked.
What has been sold but not ordered
cw_search_procurement_productsfor items on open tickets or projects (conditionson the parent and a not-yet-purchased state).- Cross-check against open POs. Items with no PO line are the procurement backlog.
Stock reconciliation and write-off
cw_list_warehouses, thencw_get_inventory_on_handwithwarehouseId(andcatalogItemIdto narrow).- Compare with the physical count the user supplies. Negative balances are the usual sign of a missed receipt.
- Draft the adjustment and show it: header (
identifier,typeIdfromcw_list_adjustment_types,reason) and every line (item, warehouse, bin, signed quantity). - After approval:
cw_create_adjustment, thencw_add_adjustment_detailper line. LeaveunitCostunset for a write-off so ConnectWise applies average cost. If any detail call fails or times out, stop: read the draft back withcw_get_adjustment, reconcile its lines against the approved list (missing or duplicated lines), and fix them before going on. Never ask to close a draft that is partial or has duplicate lines. cw_close_adjustmentonly after a second, explicit approval. It is the step that moves stock, and it isadmintier.
Gotchas
- Creating is not posting. An adjustment with lines but no close changes nothing; a closed one cannot be edited.
- Signed quantities. To zero a bin holding 7, send
-7, not0. - Serialised items need their serial numbers on the adjustment line (
serialNumbers). - Procurement products are not catalog items. A procurement product is a placed instance with its own price and cost; edit the catalog definition in
connectwise-psa-product-catalog.