Inventory - weighted average missing or incorrect

Inventory - weighted average missing or incorrect

Goal

This article explains how to fix stock value when the weighted average cost per stock unit is missing or incorrect on an article card. During a stock count, the quantity you enter overwrites the current on-hand balance. The stock value is calculated as quantity × weighted average cost per stock unit. Any value entered in the Cost per sales unit field is ignored by the standard stock count action. Use the steps below to reset and restore the correct weighted average cost and stock value.

Idea
Always add a clear reason in the comment field for audit purposes. This helps reviewers understand why the correction was made.

Procedure

Scenario A: The weighted average cost per stock unit is incorrect.

Step 1: Understand why stock count cannot fix the value

If the weighted average cost per stock unit is wrong, the stock value will also be wrong. A normal stock count cannot correct this because the system uses the current weighted average cost value to calculate stock value. Follow the steps below to reset and restore the correct value.


Step 2: Empty the stock (Withdrawal)

Open the inventory function on the article card. Enter the full on-hand quantity in the Quantity field. Select Type: Withdrawal. In the cost field, enter the value currently shown in the Weighted average cost per stock unit field.


Step 3: Add a comment and confirm

Describe the reason for this action in the comment field (for example: “Reset due to incorrect weighted average cost”). Click OK.


Step 4: Verify stock is empty

The on-hand quantity is now 0 and the stock value is 0.


Step 5: Restore the stock (Inbound delivery)

Add the correct quantity back. Select Type: Inbound delivery. Fill in Cost per sales unit using the price from the price row.


Step 6: Add a comment and confirm

State the reason for the restoration in the comment field. Click OK.


Step 7: Confirm the result

The on-hand quantity is restored. The stock value and the weighted average cost per stock unit are now correct.


Warning
This action changes the stock value. All transactions are recorded in the stock log.


Scenario B: The weighted average cost per stock unit is missing.

Step 8: Understand why stock count cannot fix the value

If the weighted average cost per stock unit is missing, the stock value will be wrong. A normal stock count cannot correct this because the calculation uses the (missing) weighted average value. Follow the steps below to reset and restore the correct value.


Step 9: Open Inventory on the article card

Open the stock inventory function using the button at the top right of the article card.


Step 10: Empty the stock (Withdrawal)

Enter the on-hand quantity. Select Type: Withdrawal. Leave the cost field empty (the value is 0).


Step 11: Add a comment and confirm

Enter the reason in the comment field. Click OK.


Step 12: Verify stock is empty

The on-hand quantity is now 0.


Step 13: Restore the stock (Inbound delivery)

Open the inventory function again. Enter the correct quantity. Select Type: Inbound delivery.


Step 14: Enter the correct cost and confirm

Fill in Cost per sales unit using the price from the price row. Add the reason in the comment field. Click OK.


Step 15: Confirm the result

The on-hand quantity is restored. The weighted average cost per stock unit and the stock value are now correct.


Warning
This action changes the stock value. All transactions are recorded in the stock log.

    • Related Articles

    • Adjust inventory directly from the resource card

      Goal This article explains how to adjust stock directly from the article card using the Inventory function. You can perform three actions: Withdrawal (manual stock out), Inbound delivery (manual stock in), and Stock count (inventory). Each action ...

    • Troubleshooting - The calculation show no or incorrect price

      Goal This guide helps you fix cases where the calculation shows no price or an incorrect price. In most cases, some input is missing or wrong. Follow the steps below to check the three most common causes inside your quotations or orders. Tip: See the ...

    • Troubleshooting - The calculation shows nothing or incorrect result

      Goal Use this guide to fix cases where the calculation shows no result or gives an incorrect result. In most cases, one or more required fields are missing or set incorrectly. These checks apply when you calculate inside quotations, orders, or ...

    • Why are certain menu items or buttons missing?

      Issue: You are unable to see a specific module in the menu (e.g., Invoicing or Settings) or a specific button is missing (e.g., Convert to Invoice). Cause: User Roles and Permissions The visibility of modules and the ability to perform specific tasks ...

    • Troubleshooting - No article need is shown or article need is wrong

      Goal This article helps you fix cases where no article need is shown or the article need is incorrect because material consumption is missing or wrong in a calculation. If material consumption is not calculated, material cost will be zero and there ...