Skip to content
A manufactured item shows RM 0 cost

My manufactured item shows RM 0 cost, or its margin looks too good

“The cables we made show RM 0 in Stock Balance.” Or the same thing seen from the other end: the sales invoice for something your workshop made shows a margin that looks far too good. Neither is a glitch. When a production step is finalised, BigLedger moves the quantities — materials out, finished item in — and carries none of the materials’ cost across. The finished item keeps whatever unit cost it already had at that location, and an item made there for the first time had none.

This page is for the accountant who values what came off the line, and for the planner or supervisor who noticed the number first. In about ten minutes you will know which case you have, how to give the item the cost you decide, and what to do if it has already been sold.

The one-minute check

  1. Read the cost a sale will use. Open Stock Adjustment › Reset MA and start a new one for the company and the finished item, dated today, without saving it: the form shows the item’s company-wide moving average, which is what a sales invoice’s cost of goods reads. RM 0 means it has never been costed. A figure unchanged since the last run means it carries last run’s cost, whatever the materials cost this time.
  2. Open Stock Balance at the location where the job ran. The materials’ quantities have fallen and the finished item’s has risen, and no unit cost has moved: the value left inventory and arrived nowhere. Its MA Price column is that location’s figure, which a Reset MA does not change (below), so do not use it to judge whether the item has been costed.

If step 1 reads the cost you expected, the job is not your problem: the margin you are looking at comes from somewhere else (see The margin report and the P&L don’t agree).

Meet the job

GadgetSphere Distribution (GSD) makes a house-brand braided charging cable in its workshop at GS-KV-01. Its first run of 2,000 cables took RM 3,300 of material out of stock: bulk cable, connectors and retail boxes. After the last step was finalised, the 2,000 finished cables carried RM 0. Invoiced to a corporate customer at RM 4.50 each, that sale shows a margin of RM 9,000 instead of RM 5,700. The step-by-step ringgit is on Manufacturing in Depth.

Why the finished item has no cost

Finalising a process instance writes one ordinary stock line per input (out) and per output (in), each with an amount of zero. Costing ignores that zero, so each item is valued at its own running cost: the materials leave at theirs, the finished item comes in at its own — RM 0 if it was never costed. Neither cost moves, and nothing in the manufacturing module posts a journal, so the RM 3,300 is not in work-in-progress or anywhere else. The mechanism, with sources, is What moves stock, and at what value.

The same is true of a coil finished on the Packing Order applet’s Auto Coil screens. A Stock Conversion is different again: today its FINAL moves no stock at all.

Fix it: decide the cost, then set it with Reset MA

Deciding the cost is your job; the software will not do it. For the cables: RM 3,300 of materials over 2,000 cables is RM 1.65 each. Add labour and overhead per cable if your costing policy absorbs them; BigLedger records the work logs and machine time but values neither. Take the material figure from what actually left stock — the instance’s actual quantities at the materials’ unit costs — not from the planned quantities.

Before you start, check the company has default GL codes for RESET_MA and STOCK_BALANCE in Chart of Account › Companies › Default GL Codes. Without them, FINAL still reports success and the cost still changes, but the journal is refused in the background and nothing tells you (Stock Adjustment, Reset MA).

  1. Stock Adjustment › Reset MA › CREATE. Choose the company, the finished item and the date. The date decides what the reset does, so pick it deliberately: the form reads the company quantity and moving average as at that date, and the finished cables are dated when their last step was finalised. Date it on or after that finalisation and before the first sale (Reset Moving Average).
  2. Type 1.65 in New Unit Cost. The other three cost boxes fill in; with 2,000 cables held at that date, Adjustment Total is RM 3,300. There is no quantity to enter: a Reset MA never changes quantity.
  3. FINAL. BigLedger resets the item’s company moving average and posts a journal for Adjustment Total: debit the stock account (STOCK_BALANCE), credit RESET_MA. That journal is what puts the cables’ value in the ledger. Then open Ledger And Journal and confirm it is there.

What a Reset MA does not change: it writes no movement at any location, so the MA Price that Stock Balance shows per location keeps the figure it had. The company figure is the one a sale reads.

Restrict Reset MA to finance: it revalues stock on the balance sheet in one press.

If the item has already been sold

A sales invoice’s cost of goods is written onto its line a moment after FINAL, at the company moving average as at the line’s date. An invoice finalised before your Reset MA was costed at RM 0, which is where the RM 9,000 margin came from.

Date the reset before the sale. A reset dated between the last finalisation and the invoice slots into the item’s history before the sale, and BigLedger re-works the cost stored on every later line, the invoice’s included — the same replay a back-dated purchase sets off (FAQ: a back-dated purchase changed my margins). Its Adjustment Total is worked on the 2,000 cables held at that date, so its journal is the full RM 3,300. This was read in the code, not tried: read the invoice line’s cost after the reset to confirm.

A reset dated today, after the cables have gone, reads a quantity of zero. Its Adjustment Total is zero and it posts no journal, which here is expected, not the GL-code failure above. It still sets the cost the next run and the next sale will carry, but it reprices nothing already sold and puts none of the RM 3,300 in the ledger.

Either way, cost of sales is a period figure, not the invoice’s: agree with your auditor how the month’s cost of sales is corrected for what went out at RM 0, and do it before the month is closed.

What success looks like

  • A new Reset MA form for the item, dated today, shows the company cost you set (do not save it).
  • Ledger And Journal shows the Reset MA journal, for Adjustment Total, to the stock account — unless the item had none left at the reset’s date.
  • The next invoice for the item, and any invoice dated after a back-dated reset, shows the new cost of goods.

Common mistakes

  • Reading Stock Balance’s MA Price as the item’s cost. It is one location’s figure, and a Reset MA does not move it; the sale reads the company figure.
  • Dating the reset before the last step was finalised. The form then finds none of the finished stock, so Adjustment Total and its journal come out wrong.
  • Taking a missing journal after a reset with no stock left for the GL-code failure. A zero Adjustment Total posts nothing, by design.
  • Resetting today and expecting last week’s invoice to change. Only a reset dated before the sale reprices it.

Keep it from coming back

The cost of a manufactured item is whatever it carries before the job, so this is a standing job for the accountant, not a one-off repair:

  • After every first run of a new item, before its first sale, decide the cost and Reset MA. The supervisor’s part is to tell you the day a new item’s last step is finalised.
  • A second run comes in at the cost the item already carries — RM 1.65 for the cables — whatever the materials cost that time. Revisit the figure when material prices move, not only when something looks wrong.
  • At month end, read the company cost of every item finalised that month before the close. Best practice 1 and the module’s checks worth doing carry the routine.

If your accounts carry work-in-progress, that figure is keyed separately at month end; see Where a work-in-progress figure goes instead.

Related

Last updated on