How Phase 2 works: upload your Master Lot file, then either upload a Final Result Phase 1 .xlsx or fall back to the Phase 1 result currently in memory.
When falling back to memory, the same hide toggles from the Result page are applied here (Skip/Done, No Audit/No Variance, Negative). When uploading a file, toggles start off so the file is the source of truth — adjust as needed.
Downloaded workbook keeps Master Lot, Formula Lot, Tips, and Tips 2 hidden. Unmatched rows are listed below and downloadable separately.
Master Lot
Odoo lot export (Product, Lot/Serial Number, numeric ID)
Final Result Phase 1 (optional)
Skip to use the result already in memory from Phase 1
Applied to every row in "Final Phase 2". Please re-enter / verify before each download — defaults to empty on purpose.
Location is required before download.
Filename will include the scope (e.g. _AdjPlus.xlsx).
Not Enough Qty — Details
SKUs where total positive Avl Qty across all lots can't cover the audit shortage.
Awaiting input
Upload a Master Lot file (and optionally a Phase 1 result), then press Generate to compute Not Enough Qty items.
Tips — Phase 2
- Phase 2 — Lot ID, Counted Qty & Final Export
- 1. Master Lot stays untouched. Sheet "Master Lot" is your raw Odoo lot export (Product, Lot/Serial Number, numeric ID column, etc.). Paste fresh exports in — nothing here is overwritten.
- 2. "Formula Lot" is rebuilt from scratch on every run: Product (A) and Lot/Serial Number (B) referenced from Master Lot, Concat (C) = Product & " " & Lot, Lot ID (D) referenced from Master Lot's numeric ID column.
- 3. "Final Result" gets two extra columns: Lot ID (J) = VLOOKUP(SKU & " " & Lot, 'Formula Lot'!C:D, 2, FALSE), Counted Qty (K) = IF(Status Adj = "Adj Minus", Variance × -1, Variance).
- 4. Location is asked once — applied to every row in this batch's "Final Phase 2" output.
- 5. "Final Phase 2" is the import-ready sheet: Location · Product · Lot/Serial Number (kept as TEXT so leading zeros aren't lost) · Lot/Serial Number/ID · Counted Quantity.
- 6. Rows with no matching Lot ID in Master Lot are flagged in the on-screen summary; their Lot/Serial Number/ID column is left blank instead of #N/A.
- 7. Re-run any time Master Lot or Phase 1 result changes — Formula Lot, Final Result and Final Phase 2 are all regenerated.
Downloaded workbook contains: Final Result (with Lot ID + Counted Qty), Final Phase 2 (Location · Product · Lot · Lot ID · Counted Qty), Missing in Qty File, and Sistem Qty Mismatch (visible). Master Lot, Formula Lot, Tips, and Tips 2 are included but hidden. VBA macros are not included — the formulas in the workbook do the same job.