Skip to content
/products

frontq.app

Custom Building

Supplier onboarding before the ERP.

Industry
Chemicals ยท global manufacturer
For
Procurement, legal and risk teams, and their suppliers
Stack
SvelteKit PostgreSQL Drizzle ORM Better Auth pg-boss Hetzner

Brief

New suppliers answer a due-diligence questionnaire that today travels as a macro-heavy Excel workbook by email, and a shared service re-keys the answers into SAP.

Suppliers now answer through a signed link with no account, questions appear and disappear by rule, and requestors, legal and risk owners review it in a separate internal app before the supplier record is created.

Problem

The workbook is not really a form. It is an application, with a rule engine, a scoring sheet and an escalation table, built competently in the wrong runtime. It travels from requestor to supplier to risk owners and back, one email attachment per step, and the current state of a request exists only in whichever copy someone is holding.

Bank details travel by email, answers never expire and nothing keeps an audit trail. When a supplier cannot use the procurement portal, a shared service types the answers into the ERP by hand.

Solution

The requestor creates a request and the system builds the questionnaire from the rules. The supplier opens an expiring link, answers only the questions that apply and uploads bank and tax documents.

Answers are scored against the escalation rules. Unfavourable ones go to the right owner group with the question, the answer and the supplier's explanation, to approve or reject with a reason. The finished package of answers, evidence, approvals and audit log exports in the shape master data needs.