Four ways a raw-material purchase goes wrong
Cotton, yarn, dyes and trims are bought on a rate, a promised date and a test report. Each sits somewhere else: the PO in the ERP, the vendor’s last email, a WhatsApp chat, a folder of PDFs.
“Where is my yarn?” Open POs chased by phone and WhatsApp
Every confirmed PO has a promised ETA, but the real status sits in the vendor’s emails, a WhatsApp chat and a forwarder’s note. On imported cotton, yarn and dyes, the date also moves with how fast a bank opens the LC. The playbook says a slip of three or more working days means telling PPC to re-plan. When the team checks dozens of POs by hand, a slip often reaches PPC only when the material fails to arrive.
15–20 days
Time Bangladeshi banks short of US dollars were taking to open import LCs in early 2023, in some cases 30 days, against at most three working days before, a yarn maker’s managing director said.
Source: The Daily Star (Bangladesh), Dollar crisis puts textile millers in a tight spot (opens in a new tab), 2023.
A test report that does not cover the lot on the truck
The PO asks for HVI on cotton, a USTER report on yarn, a COA on dyes and chemicals, an OEKO-TEX or buyer-RSL certificate on trims. What comes can be a report on the vendor’s letterhead, a certificate for another lot, a COA “to follow after dispatch”, or organic cotton whose transaction certificate never comes. If it is used anyway, the spinning floor or dye house finds it later, and the mill may face a buyer claim.
16,100 t
Organic cotton imported from India with no transaction certificates issued, as the Bangladesh Textile Mills Association complained to India’s Textile Ministry. The certifier was suspended for six months. Reported in 2022.
Source: The Hindu BusinessLine, India’s organic certification procedures under cloud as APEDA penalises 3 more agencies (opens in a new tab), 2022.
A new quote, and nobody sure what you paid last time
A vendor quotes for 30s combed yarn, and the purchase officer needs the last comparable purchase: rate, vendor, date, incoterm and payment terms. That history sits in old POs, an Excel rate register and email threads. Imported cotton, yarn and dyes are usually priced in US dollars, so what you paid in taka or rupees also moved with the exchange rate. When cotton moves fast, an old rate means little without its date.
113%
Year-on-year rise in the monthly average price of Shankar-6 cotton in India in May 2022, a peak month, while yarn prices rose only 45%, according to India Ratings and Research.
Source: The Financial Express (India), Cotton prices will continue to stress yarn spinners’ working capital, liquidity: India Ratings (opens in a new tab), 2022.
Vendor scorecards rebuilt by hand, so habit picks the vendor
The playbook sets a quarterly scorecard per category: quality 40, on-time delivery 30, price 15, responsiveness 10, documentation 5. Building it means pulling dates, short shipments and test rejections out of several files, so it runs late or not at all. Orders drift to the vendor everyone knows until it holds over 40% of a category’s volume, the playbook’s warning line. If it fails, there is no approved alternate.
From RFQ to arrival: what the sourcing agent does when asked
It works from what you connect: your open-PO export or follow-up sheet, quotes, test reports and Odoo stock transfers. Each answer names the PO, file, rows or transfer it used. A vendor chase or a transfer note waits for an admin to approve or decline it.
A vendor’s stock transfers in Odoo, with a note an admin approves
Reads your ERP
From Odoo the agent reads stock transfers: reference, partner, status, scheduled date and source document, with the time each was fetched. By vendor name it lists all that partner’s transfers, returns included; a receipt shows by its reference (WH/IN/00231). It can draft a note on one, such as “revised ETA 14 Dec, BL awaited”, but never move its date. An admin approves or declines it; it is written only if approved.
Ask“List the Odoo transfers for partner Sunrise Yarns with reference, status, scheduled date and source document. Which WH/IN receipts are past their scheduled date?”
Test reports and certificates read against the PO and the lot
Reads your documents
Upload HVI and USTER reports, COAs, SDSs and trim certificates. Ask about a lot and the agent quotes what the report on file certifies and its issue date, and points out where its lot, count, blend or date differ from the PO. For dyes and chemicals it finds the ZDHC MRSL conformance level or ECO PASSPORT certificate, with its MRSL version. If nothing covers the lot, it says so. A scanned report has no text to read.
Ask“Is there a USTER report on file for lot 4471 against PO 2290? What count and CV% does it state, and when was it issued?”
Late and short deliveries by vendor, counted from your PO export
Answers with sources
Upload your PO and receipt export as Excel or CSV, with committed and actual dates, a quarter column and a status column marking each delivery Late, Short or On time. Ask about a vendor and quarter and it counts the rows marked Late and those marked Short, calculated from the rows, and lists the late ones with both dates. It works out no lead time from the dates and scores no vendor itself.
Ask“How many of vendor V20417’s deliveries in Q3 does our export mark Late, and how many Short? Show committed against actual dates for the late ones.”
An RFQ comparison sheet, with what you last paid beside it
Creates files
Upload an RFQ’s quotes and the agent lays them side by side in a spreadsheet: rate, currency, incoterm, lead time, payment terms, MOQ and the test report offered. A last-rate column shows what you last paid for the same material, from your uploaded rate register, with PO, vendor and date. Freight, duty and LC finance-cost columns follow the playbook’s landed-cost comparison, filled only where a quote states them.
Ask“Make a comparison sheet for the four quotes on RFQ 0398 for reactive dyes: rate, lead time, payment terms, MOQ and our last rate paid.”
The chase for a BL number, drafted for approval
Acts in your tools
Ask the agent to chase a late PO and it prepares the email, sent through Gmail or Outlook, or the WhatsApp Business message: the PO, the committed date, and a request for the BL or AWB number and a revised ETA. It can also prepare the new status as an update to your open-PO follow-up sheet in Google Sheets. An admin approves or declines each one, and nothing is sent or written unless approved.
Ask“PO 2315 is five days past its ETA. Draft an email to the vendor asking for the BL number and the revised ETA.”
A low quote, a missing BL and a quarter-end scorecard
One quote sits well below the rest
Purchase officer
Four quotes are in for 30s combed yarn, and one is 8% or more below the next: the gap the playbook says to question.
Asks
“Compare the four quotes on RFQ 0412 and set each against what we last paid. What do we have on file for the cheapest vendor?”
The agent
Reads the four quotes and your uploaded rate register for the same count, and builds a comparison sheet: rate, incoterm, lead time, payment terms, MOQ, and the last rate paid with its date and vendor. For the cheapest vendor it works through the playbook’s three checks before a switch: test-report parity, lead times on the last three shipments, and any default in the last 12 months. It names each check the files on record cannot answer.
Result
The sourcing head decides with the comparison sheet and the gaps in front of them, not on the headline rate alone.
The vendor says “shipped”, but there is no BL
Purchase officer
A dye-chemical PO is four working days past its ETA, and the vendor’s rep has messaged your WhatsApp Business number that it has shipped.
Asks
“Draft a WhatsApp message to the vendor on PO 2290 asking for the BL number and revised ETA, and update our follow-up sheet.”
The agent
Reads the PO’s row and committed date in your open-PO follow-up sheet in Google Sheets, and the vendor’s last message on it in your connected WhatsApp Business account. Notes the playbook’s rule that a shipment without a BL or AWB is not shipped. Drafts the WhatsApp message with the PO number, the committed date and both requests, and prepares the new status for that row.
Approval
Both wait as actions. The sourcing head, as department admin, approves or declines each one. The message is sent and the row updated only if approved, and the audit trail records who decided.
Result
The message asking the vendor in writing for proof of shipment is sent, and the slip written to the follow-up sheet with today’s date, only if the head approves. If the head declines, nothing is sent or written.
The quarterly scorecard for yarn vendors
Sourcing head
Quarter end. The yarn vendors’ scorecard is due, and the bottom quartile goes on an improvement plan.
Asks
“Start this quarter’s yarn scorecard with V20417 and V20388: how many Q3 deliveries does our export mark Late or Short, and how many test results Fail?”
The agent
Reads the PO follow-up export and the test-result list, each uploaded as Excel with vendor and quarter columns. Builds a sheet with the playbook’s five weighted factors, then for each vendor named counts the Q3 export rows marked Late and those marked Short, and the test rows marked Fail, calculated from the rows, and lists the rows behind each. Other yarn vendors follow as the team names them. Price, responsiveness and documentation stay with your team.
Result
A scorecard row for each vendor you name, each count with its rows, ready for the quarterly review the playbook sets.
What late lots, false certificates and a falling currency cost
Published figures on late raw material, certificates without documents behind them and currency risk, each cited at the source. They are not Mavick results. A pilot starts by recording your own numbers for the KPIs below, and reads them again at the end.
Fewer POs that go quiet past their ETA
7 of 20 t
Daily yarn output at one Bangladeshi spinning mill, Simco Spinning, against its 20-tonne capacity, owing to a raw-material shortage while fibre imports were delayed. Early 2023, as the press reported.
How the agent helps
When asked, the agent lists the open POs past their committed date in your follow-up sheet, and a vendor’s Odoo transfers past their scheduled date, and can find the vendor’s last email on any of them. It drafts the chase for the BL or a revised ETA; an admin approves or declines it, and it is sent only if approved.
Track: Open-PO ageing: POs over 30 days past ETA with no status update
Source: The Daily Star (Bangladesh), Dollar crisis puts textile millers in a tight spot (opens in a new tab), 2023.
Fewer lots taken in on a certificate alone
50 of 900
Transaction certificates one Indian organic-cotton certifier had issued (900) against those with documents behind them (50), found by India’s organic evaluation committee. The certifier lost its accreditation in 2022.
How the agent helps
The agent reads the report or certificate on file against the PO: lot, count, blend, standard and issue date, and says when none is on file. It drafts the request for the testing-lab original the playbook insists on; an admin approves or declines it, and it is sent only if approved. It does not judge whether a document is genuine.
Track: Incoming lots released with the testing-lab original on file
Source: The Hindu BusinessLine, India’s organic certification procedures under cloud as APEDA penalises 3 more agencies (opens in a new tab), 2022.
Currency exposure on open POs, set out before payment
35%
An estimate in USDA’s Dhaka post report: the taka’s sharp fall over the past year eroded working capital in Bangladesh’s textile and garment industries by about 35%, making it harder for smaller units to open LCs for raw materials.
How the agent helps
Upload your open-PO sheet and ask which POs are in dollars or euros. The agent lists them with the dates on record, and totals each currency you name, calculated from the rows. It drafts the hedge request the playbook asks for at PO confirmation, as an email an admin approves or declines. The hedge itself stays with Treasury & Banking.
Track: Foreign-currency POs with a hedge request at confirmation
Source: USDA Foreign Agricultural Service, Cotton and Products Annual, Bangladesh (Report BG2026-0003) (opens in a new tab), 2026.
What to baseline before a pilot
Measure each one before the pilot starts, then again at its end.
| KPI to baseline | Why it matters |
|---|---|
| PO ETA accuracy, % delivered on time | The playbook targets 90% or better. Below 80%, it reads the vendor choice or the lead-time buffer as wrong. |
| Vendor quality pass rate on first sample | The playbook targets 97% or better. Below 95%, the vendor goes on an improvement plan. |
| PO cycle time, RFQ to PO issue | The time from RFQ to PO issue. The playbook targets five working days or fewer for a stocked spec, and ten for a new one. |
| Open-PO ageing | The playbook’s target is zero POs more than 30 days past ETA with no status update. Each one is a date PPC may still be planning on. |
| Yarn cost against the cotton spot price | The playbook tracks the gap weekly. A widening gap reads as yarn vendors taking more margin. |
What the agent works from
Records it reads
- Vendor master
- RFQ and vendor quotations
- Purchase order
- Open-PO follow-up sheet
- Rate register
- Vendor scorecard
- HVI, USTER or COA test report
- SDS and ZDHC MRSL certificate
In your ERP
Reads Odoo stock transfers (reference, partner, status, scheduled date, source document); a receipt shows by its reference, such as WH/IN. Drafts a note or source document on one; an admin approves or declines it, and it is written only if approved. POs, vendors and rates come from Excel or CSV uploads or a Google Sheet. The demo shows what your Odoo holds.
One ERP connection serves the whole factory: SAP Business One, SAP S/4HANA, Odoo, Oracle NetSuite, Microsoft Dynamics 365, WFX Cloud ERP or Datatex NOW. This agent reads only the records named above; we check yours on the call.
In your tools
Finds a vendor’s last email on a PO in Gmail or your recent Outlook mail, or the last message on your WhatsApp Business number, when you ask. Drafts vendor chases and requests for lab originals, and prepares rows for your follow-up sheet or vendor scorecard in Google Sheets. An admin approves or declines each one; it runs only if approved.
Tools named today: Gmail, Outlook, Google Sheets, Slack and WhatsApp Business.
Never made up
- Vendor rates, quotations or negotiated terms
- PO numbers, quantities or delivery commitments
- Test-report results and certificate numbers
- Market prices for cotton, yarn, dyes or chemicals
If it is not in your connected data, the agent says so.
Belongs to another department
- Physical receipt, the GRN and stock on handStores & Inventory
- Payment release and vendor ageingFinance & Accounts
- LC opening and trade financeTreasury & Banking
- Pricing and quotes to buyersCosting & Pricing
What the Sourcing & Procurement playbook covers
SOP: from RFQ to PO
Send the RFQ to at least three approved vendors, naming the spec, quantity, delivery window, incoterm, payment terms and the test report required: HVI for cotton, USTER for yarn, a COA for chemicals. Compare landed cost, not headline price. Issue the PO through the vendor master; an off-master vendor needs a one-time onboarding sign-off. Get acceptance and ETA in writing.
Decision rule: the cotton spot price moves over 5% in a week
The response depends on how much cotton you hold. Covered for the next 30 days: no immediate action. Covered for 7 to 30 days: lock the next 30 days’ need now. Under 7 days of cover: lock at once, even at an unfavourable price, because the alternative is a stockout.
KPI: no vendor above 40% of a category’s volume
The playbook treats one vendor above 40% of a category’s volume as a warning sign. It names long approval chains as the way that concentration grows, and says to pre-approve alternates each quarter so the mill can switch fast when it must.
Edge case: the COA and your own test disagree
Block the lot and re-test it in-house. Share both reports with the vendor, then decide in writing whether to reject the lot or accept it with a deviation. The playbook is plain that a failed lot is never used just because the vendor insists.
Written as general textile practice and reviewed by four independent AI models. Not yet signed off by a human subject-matter expert. Upload your own SOPs and standards, and every answer shows which source it used.
Ten questions it ships with
The template’s starter questions. Your team can edit them, or ask in its own words.
Open POs with this vendor
List the open purchase orders with this vendor — quantity, rate, committed delivery date, and how much has been received so far.
Vendor performance on lead time
How has this vendor performed on lead time and short shipments over the last several orders? Show committed versus actual delivery dates.
Quoted rate against the last purchase
This vendor has quoted a rate for the material. How does it compare with what we last paid for a comparable purchase, and when was that?
Materials on the critical path
Which materials for this order are on the critical path, what is the status of each PO, and which one would delay production first if it slipped?
Test reports on file for a lot
Is there a test report or certificate on file covering the lot being received against this PO? Tell me what it certifies and its issue date.
Compare quotes for an RFQ
Compare the quotes received against this RFQ — rate, lead time, payment terms, and minimum order quantity — and lay out the trade-offs.
Vendor scorecard summary
Summarise this vendor’s scorecard: quality rejections, on-time delivery, and any recurring issues recorded against them.
Purchases pending against a plan
For the current production plan, which raw materials have been ordered, which are still to be raised, and which have arrived?
Rate movement on a key material
Show how the rate we have paid for this material has moved across our recent purchases, with dates and vendors.
Multi-currency PO exposure
Which open purchase orders are denominated in foreign currency, what is the total exposure per currency, and when does each fall due?
Sourcing & Procurement: questions before a demo
Can it tell us whether a vendor’s test report covers the lot on the truck?
Yes, when the report is a file with text. It sets the report’s lot, count, blend, standard and issue date beside the PO and the delivery note on file, and says where they differ or when nothing covers the lot. It does not judge whether a report is genuine or check it with OEKO-TEX, GOTS or the lab. The playbook’s rule holds: a report on the vendor’s letterhead is not a test report. The agent can draft the email asking for the lab’s original; an admin approves or declines it, and it is sent only if approved. A scanned report has no text to read, so ask for the lab’s PDF.
We run Odoo. Can the agent read our POs, or raise, change or cancel one?
From Odoo it reads stock transfers: reference, partner, status, scheduled date and source document. Asked for a vendor, it lists all that partner’s transfers; a receipt shows by its reference. The POs themselves do not reach the sourcing agent from Odoo or any other ERP, so upload an open-PO export as Excel or CSV, or keep the follow-up in a Google Sheet. It never raises, changes or cancels a PO. To call off an order, it drafts the cancellation request to the vendor as an email. On an Odoo receipt it can draft a note, such as a revised ETA. An admin approves or declines each, and it runs only if approved.
Can it run our PO approval chain?
No. Mavick’s approvals cover only what the agent drafts, such as a vendor email, a sheet row or a note on an Odoo receipt: an admin approves or declines each one. Your PO sign-off stays in your ERP or your current process. If your open-PO export or follow-up sheet has an approval-status column, the agent tells you from it where a PO sits; it reads no POs from any ERP. It can also quote the playbook’s cycle-time target, five working days from RFQ to PO for a stocked spec, to measure your sign-off against.
Can it give us today’s cotton price, or tell us when to buy?
No. It has no market feed and never makes up a price for cotton, yarn, dyes or chemicals. If your team keeps NY futures, KCA spot or MCX readings in a Google Sheet, or uploads a weekly market note, it reads them and cites the date. It does not forecast prices or say when to buy. It can quote the playbook’s rule for a move of more than 5% in a week, which ties the response to the days of cotton you hold. The decision stays with the sourcing head.
Will Finance or Costing see our quotes and negotiated terms?
Not the files you keep in Sourcing. Quotes, rate registers and negotiated terms uploaded to Sourcing stay there unless someone shares a file across the factory; the costing agent cannot read them. The factory’s ERP connection is shared, but each agent reaches only its own part of it; for Sourcing, that is Odoo stock transfers. The boundary runs both ways: the sourcing agent cannot read the files and sheets connected to Stores or Finance, such as the GRN register or payment records. Asked when a vendor will be paid, it says Finance & Accounts owns payment release.
Does it watch vendor emails and WhatsApp for late shipments?
No. It reads Gmail, Outlook or WhatsApp Business messages only when someone asks, for example for the vendor’s last message on a PO. It reads only the WhatsApp Business number you connect; chats on your team’s personal phones are not visible to it. Nothing checks an inbox or a chat between questions, and it sends no reminders. When you ask which POs are past their ETA, it compares the committed dates on record with today’s date and lists them. If a date is not in your connected data, it says so.
Bring Sourcing & Procurement. We’ll build it on the call.
Book a 30-minute demo (opens in a new tab)- support@mavick.si
- Demo calendar
- calendly.com/safock/30min (opens in a new tab)