Skip to content

Stores & inventory: find where the bin card and the system disagree

Ask for stock against the bin card, whether a GRN was posted, or which dyes expire next month. The agent reads Dynamics 365 stock, Odoo receipts and your registers, and shows what it used. Any note or message it drafts waits for an admin to approve or decline.

Works from: GRN, Issue note, Bin card, Stock ledger

What goes wrong in the store, from the gate to the issue counter

The store sits between the gate and the line. When a receipt or an issue is posted late, the bin card, the ERP and the rack drift apart, and the next department plans on stock that is not there.

  • Goods received on Friday, GRN posted on Tuesday

    A truck reaches the gate late on Friday, and the full GRN waits for the next working day or later. Until it is posted, the bin card and the system are both wrong, and planning counts on stock that is not yet in. The playbook calls such a GRN fictional, and says to re-weigh cotton bales that differ from the invoice before posting. Contracts under International Cotton Association rules set a deadline for weighing.

    28 days

    Under ICA rules, raw cotton must be weighed within 28 days of arrival. Bales not weighed in time are declared at average gross invoice weight plus 1.5%, whatever they really weigh.

    Source: International Cotton Association (ICA), Bylaws and Rules of the International Cotton Association, January 2025 Edition (opens in a new tab), 2025.

  • Leftovers, scrap and old stock that nobody decides on

    Fabric and trims left from closed orders, cut waste returned to the store, yarn bought for a count you no longer run, spares for a machine that has gone. Each holds bin space and the owner’s cash, and the stores manager waits on Sourcing and Finance for a decision. In Bangladesh, factories whose wastage runs above the permitted rate are liable for extra duty and VAT, so issues, returns and scrap must be on record.

    27%

    Maximum wastage rate Bangladesh’s Ministry of Commerce set in December 2021 for basic knitwear (30% for special items, 4% for sweaters and socks). Producers whose wastage runs higher incur supplementary duty and VAT on the excess.

    Source: USDA Foreign Agricultural Service, Bangladesh Increases Ready Made Garment Wastage Rate (opens in a new tab), 2022.

  • The bin card, the system and the rack give three different numbers

    A knitting or dyeing requisition arrives, the ERP shows the lot in stock, and the bin is half empty. The store keeper walks the racks, recounts and writes a reconciliation note while the line waits. At month-end, the same gaps hold up the close. The playbook says to look at posting first: an issue posted late or never, then a GRN posted late. Pilferage comes last.

  • Dyes and chemicals that expire on the shelf

    A batch arrives with no expiry date on record, the newest stock sits nearest the door, and the old one is found out of date when the dye house refuses it or an auditor asks. The playbook calls expired chemicals the most expensive write-off. ZDHC’s Supplier to Zero manual (2026) asks participating facilities for a chemical inventory list updated at least monthly, with purchase dates and, where available, expiry dates.

How the stores agent works through a receipt, a count and a close

It reads Odoo transfers, Dynamics 365 stock and registers you connect or upload: GRNs, issue notes, bin cards, count sheets, the chemical inventory list. Each answer cites its sources; each note or message it drafts waits for an admin to approve or decline.

  • On-hand stock from Dynamics 365, set beside the bin card

    Reads your ERP

    Ask for a material and the agent reads its on-hand quantity by site and warehouse in Dynamics 365, with the time it was fetched; on Odoo or another ERP, upload a stock report as Excel or CSV. When the bin card is in a Google Sheet or an uploaded Excel file, it sets the bin-card balance beside the system figure and says whether they agree. A hand-written bin card has no text to read, and the agent says so.

    Ask“How much 30/1 combed cotton yarn do we hold in the yarn store, and does the bin card agree with the system?”

  • Cycle-count variances, totalled from your count sheet

    Answers with sources

    Upload the cycle count log as Excel or CSV, with columns for month, store, category, item, unit, system, physical, variance and value. The agent sums the variance value for the month, store and category you name, and the quantity one item at a time, because buttons in gross and thread in cones do not add up. It cites the rows. If a column marks lines over the playbook’s 2%, it counts them for one store and month.

    Ask“Total last month’s cycle-count variance value for buttons in the trims store, and list the lines still marked unexplained.”

  • A receipt checked against the PO, the invoice and the COA

    Reads your documents

    Upload the PO, the supplier invoice, the weighment slip and the COA or HVI report as text PDFs or Excel files. The agent sets them beside the GRN in your register, lists the differences it finds in quantity, weight, batch or quality status, and cites the document for each. It quotes the playbook for cotton: absorb a gap under 0.5%, raise anything above it with the vendor. A scanned invoice has no text to read.

    Ask“Check GRN 5512 against the PO, the supplier invoice and the HVI report, and list the differences in bales, weight and HVI values.”

  • The month-end stock summary, built as a spreadsheet

    Creates files

    Upload the month’s stock ledger as Excel or CSV. The agent builds the stock summary as a real spreadsheet from its rows: opening, receipts, issues and closing for each item, as the ledger records them, with the rows cited. Ask for one total, such as a category’s closing value or the value in an “over 90 days” ageing-bucket column, and it sums it from the rows. Ask for one more column and it edits that part only.

    Ask“Make October’s stock summary for the trims store from the ledger, and total the value in its “over 90 days” bucket.”

  • The dyes and auxiliaries nearest expiry, listed for the dye house

    Acts in your tools

    From your chemical inventory list, uploaded or in Google Sheets, the agent lists the dyes and auxiliaries expiring this month or next, with batch, quantity, location and expiry as recorded, and names any batch with no expiry. It drafts a WhatsApp message asking the dye house to use the expiring batches first, and an email to QA to retest those that cannot be used in time. An admin approves or declines each draft.

    Ask“Which dyes and auxiliaries expire this month or next? Draft a message asking the dye house to use those batches first.”

A requisition, a trim shortage and a truck after hours

  • A requisition the bin cannot fill

    Yarn store in-charge

    Knitting asks for a yarn lot. The system shows it in stock, and the rack is nearly empty.

    1. Asks

      “The system shows lot 2207 in stock but rack B4 is nearly empty. What do the GRNs, the issue notes and the bin card say since the last count?”

    2. The agent

      Reads the yarn’s on-hand quantity for the yarn store in Dynamics 365 with its fetch time: the item’s total, not the lot’s. An uploaded stock report with a lot column gives lot 2207’s line. Reads the GRN and issue registers, the bin card in Google Sheets and the last count log, sets the figures side by side and lists the movements since that count. Quotes the playbook’s order of causes: a late or missing issue posting, a late GRN, then pilferage.

    3. Result

      One answer with the system figure, the bin card and the movements recorded since the count, each with its source. The in-charge checks for unposted issue notes before anyone calls it a loss.

  • Trims short at the issue counter

    Trims store in-charge

    The sewing line asks for 12,000 buttons for PO 4471, and the bin card shows about 9,000.

    1. Asks

      “PO 4471 needs 12,000 buttons by the BOM and the bin shows about 9,000. Check the BOM, our stock and any open PO, and draft an email to Sourcing.”

    2. The agent

      Reads the BOM you uploaded, the button’s on-hand quantity in Dynamics 365 or your stock report, and any open purchase order for it in your uploaded or Google Sheets PO list. Sets required, on hand and on order side by side. Quotes the playbook: if the shortage is real, it is an emergency purchase with the cost impact noted, and no substitute without Merchandising and QA sign-off. Drafts the email to Sourcing with each figure and its source.

    3. Approval

      The stores manager, as department admin, approves or declines the email. It is sent only if approved, and the decision stays in the audit trail.

    4. Result

      If approved, the email is sent to Sourcing with the BOM requirement, the stock figure and any open PO quantity side by side, each with its source, and the playbook’s rule on substitute buttons quoted.

  • A truck at the gate before the weekend

    Receiving store keeper

    Cotton bales arrive late on the last working day before the weekend, with time to count them but not to weigh every bale or draw the HVI sample.

    1. Asks

      “The bales for PO 7310 are in and counted. Weighing and HVI wait for the next working day. Put a note on the receipt: partial count, provisional stack C2 in the bale godown, full GRN after the weekend.”

    2. The agent

      Finds the Odoo receipt whose source document is PO 7310 and reads its partner, status and scheduled date, with its fetch time. Quotes the playbook’s edge case for a vehicle that arrives too late for a full GRN: a partial GRN with a provisional location now, the full GRN on the next working day, and the bin card reconciled after. Drafts a note on that stock transfer with the bale count, the stack and the open steps, using only what the store keeper gave it.

    3. Approval

      The note waits for the stores manager, the department admin, who approves or declines it. It is written to the Odoo receipt only if approved. With another ERP, the same note can be drafted as a row in your GRN sheet in Google Sheets, with the same approval.

    4. Result

      If approved, the note is written to the Odoo receipt for PO 7310, with the bale count, provisional stack C2 and the steps still open before the full GRN.

The price of a stock figure nobody trusts

Each figure below is a published one, cited at its source: a retail study, Indian spinning mills rated by ICRA, Bangladesh’s customs bond. They are not Mavick results. Before a pilot, take your own baseline on the stores KPIs underneath, and compare after.

  • A stock figure the line can act on

    65%

    Share of nearly 370,000 inventory records, across 37 stores of one retailer, that researchers found to be inaccurate. A 2008 retail study, not a textile one.

    How the agent helps

    Counting stays with the store keeper. When you ask, the agent sets the Dynamics 365 or stock-report figure, the bin card and the last count side by side and lists the GRNs and issue notes since that count. From an uploaded count sheet with a category column it totals the variance value for the category you name from the rows, so posting delays are checked before a recount.

    Track: Stock-vs-system match % per category

    Source: Harvard Business School (DeHoratius and Raman, Management Science), Inventory Record Inaccuracy: An Empirical Analysis (opens in a new tab), 2008.

  • Less cash held in stock nobody issues

    About 3 months

    Average inventory held by the more than 200 Indian spinning mills ICRA rated, over the five years to 2015; about one month for mills on man-made fibre, because cotton is bought in season and stocked.

    How the agent helps

    From a stock ledger you upload with an ageing-bucket column, such as “over 90 days”, the agent totals the value in that bucket for the category you name from the rows, and builds the aged-stock list as a spreadsheet for the monthly review. How that stock is valued or provided for in the books belongs to Finance & Accounts, and the agent says so.

    Track: Aged-stock %, raw materials over 90 days

    Source: ICRA Limited, Rating Methodology for Indian Textiles Industry – Spinning (opens in a new tab), 2015.

  • Bonded stock that reconciles before the inspection

    2× the duty

    Penalty a Bangladeshi bonded-warehouse owner is bound to by the bond signed with customs under Customs Act section 86, as summarised by the World Bank in 2015. The legal limit, not an average penalty.

    How the agent helps

    Upload the bond register and the GRN and issue registers as Excel or CSV, with UD and item columns. For one UD, one item at a time, since kilos and cones do not add up, the agent totals quantity received and quantity issued from the rows and sets them beside the bond register in a spreadsheet for the store to reconcile. It does not file with customs or certify the result.

    Track: UD closing-stock variance, bond register against physical count

    Source: World Bank Group (Brian J. O’Shea), Bangladesh Bond Warehouse Regime: Assessment + Recommendations (opens in a new tab), 2015.

What to baseline before a pilot

Measure each one before the pilot starts, then again at its end.

Stores & Inventory: the KPIs to baseline before a pilot, and why each matters
KPI to baselineWhy it matters
GRN cycle time, receipt to postedThe playbook’s target is 24 hours or less. Until a GRN is posted, the bin card and the system disagree, and planning works from stock that is not yet in.
Stock-vs-system match % per categoryThe playbook targets 98% or better and calls for a process review below 95%. Agree first whether you count lines or value, because the two give different results.
Aged-stock %Raw material older than 90 days, as a share of stock. The playbook’s target is under 5%. Above 10% of a category’s value, it calls for a write-down decision with Sourcing and Finance.
Inventory turns per year, by categoryThe playbook sets no single target, because it depends on the category. Compare cotton with cotton and trims with trims; a rising figure is better.
Monthly close on timeThe playbook’s target is three working days after month-end. A late close usually means GRNs and issue notes still waiting to be posted.

What the agent works from

Records it reads

  • GRN
  • Issue note
  • Bin card
  • Stock ledger
  • Cycle count log
  • Chemical inventory list (CIL)
  • Gate pass and supplier invoice
  • Chemical COA

In your ERP

Reads on-hand inventory in Microsoft Dynamics 365 (item, site, warehouse, quantity) and stock transfers in Odoo (transfer, partner, status, scheduled date, source document). In Odoo it can draft a note or source document on a transfer; an admin approves or declines it. POs, batches and expiry dates come from an uploaded Excel or CSV export or a Google Sheet.

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

Reads the bin card or GRN register you keep in Google Sheets when you ask. Prepares a row for your discrepancy sheet, a WhatsApp Business or Slack message telling the dye house or the line which lot to use, or an email to QA, Sourcing or a vendor through Gmail or Outlook. An admin approves or declines each one; nothing is sent or written unless approved.

Tools named today: Gmail, Outlook, Google Sheets, Slack and WhatsApp Business.

Never made up

  • Stock quantities, bin locations or batch numbers
  • GRN numbers, issue notes or receipt dates
  • Expiry dates and shelf-life status
  • Stock valuation figures and consumption rates

If it is not in your connected data, the agent says so.

Belongs to another department

What the Stores & Inventory playbook covers

  • SOP: from the gate pass to the bin card

    Gate pass and invoice at the gate. Count, check and weigh per bag. At the receiving bay, sample cotton for HVI and yarn for USTER testing, and match the batch number on each chemical drum to the one on its COA. Post the GRN in the system within 24 hours of receipt, then allocate the bin by category and update the bin card.

  • Decision rule: a category more than 2% out

    Look for the cause in this order: an issue posted late or not at all, a GRN posted late, then physical pilferage. The first two are process problems and come first; pilferage is rare but real. Over 5% on any category goes to the stores manager, Finance and the plant head for a physical recount and a system audit.

  • KPI: the month closed within three working days

    The playbook’s target for the monthly close is three working days after month-end. Before the close, every open GRN and issue is posted, stock is reconciled against the system for each category, and the aged-stock report is run with its FIFO exceptions.

  • Heuristic: FIFO is set by the bin layout

    Cotton, yarn, fabric and trims go out first in, first out, because lot age matters; dyes and chemicals go first-expired, first-out. The playbook’s rule of thumb: FIFO is enforced by bin layout, not by policy memos, so make the oldest bin the easiest one to issue from.

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.

  • Stock on hand for a material

    What is the stock on hand for this material by batch and location, and does the bin card agree with the system?

  • GRN detail for a receipt

    Was a GRN raised for this receipt? Show what it recorded — quantity, batch, date, and any deviation noted.

  • Chemicals nearing expiry

    Which chemicals or materials in stock are near expiry or ageing past our policy? Show quantity and location for each.

  • Issues against an order

    What was issued against this order over the period, to which department, and on which issue notes?

  • Cycle count variances

    What did the last cycle count find, which variances are still unexplained, and how large is each?

  • Month-end stock summary

    Prepare a month-end stock summary from the ledger and count sheets: opening, receipts, issues, closing, and variances by category.

  • Slow-moving stock

    Which items have had no movement in the last few months? Show quantity, value and last movement date.

  • Materials below reorder level

    Which materials are below their reorder level right now, and is there an open purchase order against each?

  • FIFO compliance on a material

    For this material, were issues made in FIFO order? Show the batches issued against their receipt dates.

  • Consumption against plan

    Compare actual material consumption for this order with the planned consumption from the BOM, and show the variance by item.

Stores & Inventory: questions before a demo

Can the agent post a GRN or correct a stock quantity in our ERP?

No. Mavick does not post GRNs, change stock quantities, move bins or write off a batch in any ERP. The one ERP write the stores agent can draft is a note or source document on a stock transfer in Odoo, such as a note that a receipt was only partly counted, or the reason for a variance. A department admin approves or declines it, and nothing is written unless it is approved. On any other ERP it writes nothing. For the adjustment itself, the agent builds the reconciliation sheet and can draft a message to the person who posts it, which an admin also approves or declines.

We keep bin cards by hand at each rack. What can the agent check?

Only what is connected. A hand-written bin card, or a photo of one, has no text the agent can read. It can still read on-hand stock in Dynamics 365 or an uploaded stock report, and the GRN registers, issue registers and count sheets you connect or upload. Once bin balances are typed into a Google Sheet or an Excel file, it sets them beside the system figure and lists where they differ. Keep the table on the first sheet of the workbook; a table holds up to 5,000 rows, so upload a large ledger store by store.

Can it read our barcode scanner, weighbridge or RFID tags?

No. Mavick does not connect to scanners, scales, weighbridges, RFID readers or cameras, and it does not count racks. If a scanner export or a weighbridge slip is saved as a file you upload, or the readings are typed into a Google Sheet, the agent reads them there and cites them. A weighment slip that exists only on paper, or as a scanned image, has no text to read.

Will it remind us before a dye or chemical expires?

No. It answers when someone asks; it does not watch expiry dates or send reminders. Ask which dyes and auxiliaries expire this month or next, and it lists them from your chemical inventory list or stock sheet with batch, quantity and location as recorded. If a batch has no expiry date on record, it says so and does not guess one. The playbook says to record expiry on every receipt, so the list is only as complete as your GRNs.

We run SAP. Can the agent read our stock from it?

No. The stores agent reads two things from a factory ERP: on-hand quantities by item, site and warehouse in Microsoft Dynamics 365, and stock transfers such as receipts in Odoo. SAP Business One and SAP S/4HANA give it no records at all. Export a stock report from SAP as Excel or CSV and upload it, or keep the balances in a Google Sheet, and the agent works from that copy and cites the rows. It does not forecast demand or set reorder levels. The demo shows how an SAP stock report is set up for your store.

Will the stores agent see Sourcing’s vendor quotes or Finance’s stock valuation?

No. The stores agent sees only what is connected to the stores department, and that boundary is built into how Mavick holds and retrieves every file and record. Sourcing’s quotes and Finance’s provisions stay in their own departments. The ERP connection is shared across the factory, but each department sees only the data its work concerns. Asked how stock is valued in the books, the agent says Finance & Accounts owns it.

Bring Stores & Inventory. We’ll build it on the call.

Book a 30-minute demo (opens in a new tab)
Email
support@mavick.si