Skip to content
Set up your item master so every module reads it the same way · presentation 4 of 5 · for the whole-system operator — you run the books Read the transcript · Back to the series

These slides need JavaScript to advance one at a time. Without it every slide is shown below, one after another, each with its own player — or read the transcript, which carries the same steps and every word.

Set up your item master so every module reads it the same way · presentation 4 of 5

Where the cost on the Costings tab came from

You can say, for each figure on an item's Costings tab, which process last wrote it and how old it is…

A tab that only displays

Step 1 — Start from the fact that the tab computes nothing

You will ask a better first question.

  • Open an item's Costings tab and you see a row per company with several…
Screen capture pending the demo tenant

Doc Item Maintenance, an item's Costings tab, one row per company

Step 2 — Trust the moving average as of the last finalised document

You will know exactly how current one figure is.

Where this step sits
    flowchart TD
  s1["1. Start from the fact that the…"]
  s2["2. Trust the moving average as of…"]
  s3["3. Read the weighted average as a…"]
  s4["4. Expect moving average and FIFO to…"]
  s5["5. Know the four columns that are…"]
  s6["6. Answer the cost that changed for…"]
  s1 --> s2
  s2 --> s3
  s3 --> s4
  s4 --> s5
  s5 --> s6
  classDef here fill:#1e40af,stroke:#1e40af,color:#ffffff,font-weight:bold;
  class s2 here;

Step 3 — Read the weighted average as a last-month figure

You will stop expecting one column to move.

Where this step sits
    flowchart TD
  s1["1. Start from the fact that the…"]
  s2["2. Trust the moving average as of…"]
  s3["3. Read the weighted average as a…"]
  s4["4. Expect moving average and FIFO to…"]
  s5["5. Know the four columns that are…"]
  s6["6. Answer the cost that changed for…"]
  s1 --> s2
  s2 --> s3
  s3 --> s4
  s4 --> s5
  s5 --> s6
  classDef here fill:#1e40af,stroke:#1e40af,color:#ffffff,font-weight:bold;
  class s3 here;

Step 4 — Expect moving average and FIFO to disagree

You will stop treating a difference as an error.

What this step names
  1. FIFO is maintained by a different processor
  2. From a different mechanism — the first-in-first-out register baskets
  3. Updated on purchase-side
  4. Sales-side documents — and it is kept independently of the moving average

Columns with nothing behind them

Step 5 — Know the four columns that are empty everywhere

You will not build anything on sand.

What this step names
  1. LIFO
  2. Manual cost
  3. Replacement cost
  4. The landed-cost columns appear on the tab with headings and cells like…

When yesterday's number moves

Step 6 — Answer the cost that changed for a closed month

You can settle an argument that recurs every month end.

What this step names
  1. Somebody reports on a period
  2. Comes back a week later
  3. The cost is different

NarrationSlide 1 of 10

Left and right arrows, or the space bar, move between slides; f is full screen and Esc leaves it. Clicking the left or right half of a slide pages it. Play and pause belong to you — nothing moves on by itself unless you tick the box above.