Skip to content
Learn
Presentations P-00000 to P-00999
Where the cost on the Costings tab came from

Where the cost on the Costings tab came from

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.

Last updated on
The two GL codes on an item, and which one your journal used — transcriptWhere the cost on the Costings tab came from — transcript