Vendor Costs — Editor

Costing by invoice — this tab is keyed by invoice (NetSuite's internal vessel number, e.g. SKL/RE/93/2026), the level at which the factory actually bills. A container often holds several invoices, so the same container number appears once per invoice. Freight and Duty come in automatically from the Monday Master Container Tracker, matched invoice-to-invoice (board item_name) — the board books each invoice's own sea/air/delivery freight and duty, so this is far more accurate than splitting a container total. To override, download the template, enter Freight Cost / Other Charges against an invoice and upload it back — typed figures always beat the board, and invoices you leave out keep what they have. Spreading this across items by CBM share is the next step; that allocation isn't built yet.

Origin shows where each invoice shipped from — resolved from the shipment's vendor (the same country that drives its duty) and, across all history, from the board's supplier. Use 🌍 Set supplier origins to fill in any supplier that isn't mapped yet; the confident ones are pre-filled.

How this is built — for each Item Receipt (one per invoice / inbound shipment) we take the invoice's freight from the Monday board (sea + air + delivery) and spread it across the receipt's line items weighted by CBM. CBM comes from NetSuite's inbound-shipment lines (not Monday's). A line's share = its CBM ÷ the receipt's total CBM; that share of the freight ÷ the line's sets gives the freight per set — the cost to move one single set. Click a receipt to see every line. Coverage follows NetSuite's CBM, which is recorded for tracked/recent shipments.

What this shows — every costed receipt line where the stored freight allocation (the number the FIFO engine actually priced with, from the ledger's receipt lines) is above the threshold. Landed $/Pc includes freight and licence; the Goods $/Pc column backs both out so you can see what the freight sits on top of. Amber rows are estimates (borrowed CBM, SKU average, or lane rate — hover the Source cell for the full story); white rows are measured from the receipt's own shipment. Search, the vendor filter, and Export all operate on the entire result set, not the visible page.

How to read this — FIFO On Hand is the ledger's current closing quantity per class (seed + receipts − the sales it knows about). Grid Owned is the same figure the Inventory Grid shows today: 5 warehouse locations + RE26 pick/staging + FBA in-stock & inbound + FC reserved + Walmart WFS (customer-order reserved excluded — FIFO already deducted those sales too). Both sides are sets. UNDER rows are the curious ones: physical units exist that FIFO never heard of. OVER is expected-ish — wholesale orders FIFO doesn't see, plus lost/damaged/MIA units over the years. This screen only shows the gaps; nothing is baked in or adjusted.

How to read this — Units come from the Inventory Grid's own location columns (the same 14 non-overlapping columns behind its Total Units — customer-order reserved and RE26 87/88/89 excluded, as the grid excludes them). Each class's units are valued at its current FIFO cost: latest closing average cost per piece × pieces per set. Classes with no FIFO cost (never onboarded, or missing a pack size) show as unvalued — counted, never dropped. Walmart WFS is always ~19h behind by design (its sync runs after the grid's 5:15 AM ET rebuild). Display only; nothing is written anywhere.