Inventory · Costing

Why a late delivery note can break your margins, and how to stop it

A document keyed in with an old date quietly makes every cost after it wrong. Here is why it happens, and how forward recalculation keeps margins honest.

Every business has the same story. A delivery arrived three weeks ago, the paperwork sat on someone's desk, and today it finally gets entered with its real date. Nothing looks wrong. The stock balance is right. But the cost of every item issued or sold since that delivery is now slightly off, and nobody finds out until the margins look strange at the end of the year.

Why the cost goes wrong

Most stock systems value items at a moving average cost. Each receipt changes the average, and each issue or sale takes the average as it stood at that moment. When a receipt is entered late, the issues that happened after its date were costed with an average that didn't include it.

The usual fix is a manual one: someone runs a costing correction at month end, or worse, nobody does and the error stays in the books. Either way, this month's margin report is built on numbers that were wrong when they were posted.

What forward recalculation does

In PrixERP, posting a document with an earlier date recalculates the cost of every movement after it, in date order. Issues to production, deliveries to customers and transfers all pick up the corrected average, and the accounting entries that depend on them follow.

  • Margins on sales after the late receipt are right, not just the stock value.
  • Production costs that used the item are corrected too.
  • Nobody has to remember to run a correction job.

Catching the rest

Recalculation fixes the cost. It doesn't tell you a document is missing. For that, PrixERP's stock check compares the stock ledger with every document that should have fed it and lists the gaps: what's missing, what shouldn't be there, and what doesn't match. Run it to look, and run it again to fix once you've decided.

Read how receipts are valued in the help: Product Receive, or see the Inventory module.

See it working with your own numbers.

Bring a month of your real documents to the demo. We will show you the ledger entries they produce, and the reports they land in.