Requisition-to-PO Converter & Issuer

The problem this kills

Approved requisitions land in your inbox, in a shared sheet, or in an approval queue - and then a human has to retype them into the ERP or into emailed PO documents, line by line. You squint at which lines go to which supplier, you look up the contract price for each item, you check the payment terms and remit-to address, you tally the totals, and you hope you copied the part numbers correctly. Multiply that by every supplier, every cost center, every currency, and PO creation becomes a slow, error-prone grind that holds up the whole buying cycle.

Worse, the same requisition line sometimes gets converted twice, suppliers that are on hold slip through, and a price that doesn't match the contract goes out the door before anyone notices. The cost of a typo here is a wrong order, a wrong price, or a duplicate PO with a real supplier.

This Implementation Plan gives you a tool that does the mechanical grouping, pricing, and drafting for you - while keeping a buyer firmly in control of what actually gets issued.

What you'll build

A private web app for your buying team that:

• Imports approved requisitions (supplier, items, quantity, price, cost center) plus your supplier master (terms, currency, remit-to, contacts) and your contract price lists - from your system or from a Google Sheet / CSV.
• Auto-groups requisition lines into draft purchase orders by supplier, ship-to location, and currency, consolidating many requisitions to one supplier into a single clean PO.
• Applies contract pricing and supplier terms automatically, and flags any price that doesn't match the contract, any supplier that's inactive or on hold, and any order that misses a minimum-order rule.
• Lets a buyer review and edit every draft - check supplier, prices vs. contract, terms, and totals - then click Issue.
• On Issue: assigns a PO number, generates a PDF, emails it to the supplier, and records everything in an audit trail.
• Exports issued POs as a CSV in your ERP's PO-import column format, and stores the PDFs.

What's inside the Implementation Plan

• It starts by interviewing you about your business. Before it builds anything, the plan makes the AI agent ask you about your real requisition fields, your supplier-code and part-number conventions, how you decide ship-to and currency, your minimum-order and consolidation rules, and your messiest exceptions - then it reads back a short tailored spec for your thumbs-up. You get a tool shaped to how you buy, not a generic template.
• A clear, copy-paste prompt for every build step - you never have to write code.
• A data model and validations tuned to your answers (supplier status, contract-price checks, multi-currency, min-order, duplicate guards).
• The full human-in-the-loop issue flow: draft, review, edit, Issue.
• PDF generation and supplier emailing via Resend.
• The no-API fallback so you can build the whole thing today: import from Sheets/CSV, export issued POs as ERP-ready CSV and PDFs.
• A verification checklist so you know it actually works.

The governance it includes (this is the point)

• Login so only your buying team can use the tool.
• Row-level security so each organization (and, if you want, each buyer's cost centers) only ever sees its own requisitions and POs.
• A complete audit trail: who imported what, who edited a draft, who issued a PO, and exactly when.
• A hard human-in-the-loop gate: the AI drafts and prices the PO, but nothing becomes a PO of record, gets a PO number, or reaches a supplier until a buyer reviews and clicks Issue.
• Duplicate guards: each requisition line carries a unique line id and can be converted to a PO only once, so the same request can never be ordered twice.

Who it's for

Buyers and procurement coordinators who today copy approved requests into the ERP or into emailed PO documents by hand. If you live between an approval queue and a purchasing system - and you're tired of being the human retyping machine - this is for you. No developer required.

You've got this - paste the first prompt and let the agent interview you.