Stock issue register and negative balances
Issue slip is signed. The stock register is still on yesterday.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Prepare issue records
Use SKU, opening qty, receipts, issued qty and slip ref in same unit. Check physical stock.
Privacy Remove bank account numbers, PAN, personal phone numbers and emails. Use vendor business names or codes, item codes and approved commercial details.
Whenever I send the next details, use this format. Date: [Date] Stock rule: [Stock rule] I'm attaching stock-issues.xlsx. A. Calculate closing per SKU; flag missing issue ref or negative balance. B. List valid and held rows and reasons; no cross-SKU total if different items. C. Draft stock update rows for stores review, not posting. Use only supplied facts, quotes and approved terms. Flag missing GST, freight, payment days or delivery instead of assuming. Check stock against physical count or software before ordering. A person checks before sending, ordering, paying or posting.
Set it up once. Save the approved format and comparison rules, without vendor records. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
After that, each time: send the new details and confirm the latest approvals and stock.
First time? Try it in a normal chat: paste and send.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep your actual records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:E SKU, opening, receipts, issues, slip reference. Rule [Stock rule]. Give formulas for closing = opening + receipts minus issues, missing or negative inputs, missing issue slip and negative closing; show pass/hold. No stock entry or posting. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual company records.
Run the method locally; check every exception against physical stock, contracts or source records as applicable, and obtain approval before acting.
- P2−2 closing. 5 + 3 − 10.
- P3Slip missing. Issue needs source ref.
- P112 closing. 10 + 5 − 3.
Then send this: Recalculate closing per SKU and check slip references.
Sets negative zero
Reply: "Flag negative."
Invents slip ref
Reply: "Hold missing."
Combines units
Reply: "Per SKU only."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
If your whole team does this, we'll set it up for all of them in one session.