Checkingsession 

Template of Stock Quantity per Location

Import your Odoo RAW export. We pivot, split categories into G1 / G2 / G3, and hand back a clean Final Result workbook.

List of Master Product

Checking latest file…

Required before import. Must match a value in RAW column A and use the format PREFIX/SUFFIX (e.g. BB/Stock). The prefix is prepended to the downloaded filename.

Drop your RAW file here

Accepts .xlsx and .xlsm. We'll list every sheet so you can pick the one that contains the raw export.

How it works
  1. 1Enter Location & pick RAW. Type your Location (e.g. BB/Stock) — it must match RAW column A. We open the workbook and auto-select the sheet named 'Raw'.
  2. 2Confirm header mapping. All 11 required columns are mapped, including Location, Product/DP Code and Product/Sales Price. Saved mappings are reused.
  3. 3Pivot per Product/ID. One row per Product/ID: Available Quantity is summed, Sales Price is averaged, Location & DP Code are carried through.
  4. 4Final Result. Visible: Barcode (E), Internal Ref (F), Name (G), Sales Price (H), G2 (J), UOM (M), Saldo (N), Fisik (O), Selisih (P), Indicator (Q). Location (A), Product/ID (B), Product (C), DP Code (D), G1 (I), G3 (K), Category (L) stay hidden for traceability.
  5. 5Download. Filename is <Location>_LocationQty_Audit_<YYYYMMDD_HHmmss> in GMT+7. Selisih & Indicator are live Excel formulas — the count changes when Fisik is edited.