ERPNext

ERPNext

ERPNext Raven Framework Cloud Frappe HR Learning CRM Builder Insights Education Helpdesk Wiki Drive Books Gantt Print Designer Lending School Studio
Learn Discuss Website
Edit
Open in ChatGPT
Ask ChatGPT about this page
Open in Claude
Ask Claude about this page

Item Dashboard stock does not match the Stock Ledger or Stock Balance report

The Stock Levels on the Item dashboard can show a quantity that the Stock Ledger or Stock Balance report does not show. Or it shows "No Stock Available Currently" while the report shows stock. This page explains why the two can differ and how to make them match again.

Where to find Stock Levels: open the Item, then the Inventory tab (v16) or the Dashboard tab (v15).

What you see

One of these:

  • The Item dashboard shows stock, but the Stock Ledger is empty and the Stock Balance report shows nothing for the item.
  • The Stock Balance report shows a balance, but the Item dashboard shows:
No Stock Available Currently
  • The Item dashboard does not list all the warehouses that the Stock Balance report lists.
  • Repost Item Valuation fails with:
combine() argument 2 must be datetime.time, not None

Why this happens

ERPNext keeps stock in two places:

  • Stock Ledger Entry: one row for each stock movement, with its posting date and time. The Stock Ledger and Stock Balance reports read these rows. They show the balance as on the To Date you select in the report filters.
  • Bin: one record for each item and warehouse. It holds the current quantity: Actual Qty, Reserved Qty, Ordered Qty, Projected Qty and more. ERPNext updates the Bin each time you submit or cancel a stock transaction. The Item dashboard reads only the Bin.

The Bin takes Actual Qty from the last stock ledger entry, by posting date and time. That entry can be in the future. So the two can differ for these reasons:

  1. A future-dated entry. If a stock transaction has a posting date after today, the Bin already shows the quantity after that entry. The Stock Balance report with today as To Date does not include it.
  2. The dashboard hides warehouses with zero quantity. It lists a warehouse only when at least one quantity in the Bin is not zero. A warehouse with a balance today but zero after a future-dated entry does not show.
  3. The Bin is out of date. The Bin was not updated after a change to the stock ledger. For example, someone deleted stock ledger entries directly in the database, a submission was interrupted, or a repost failed. ERPNext versions before v16.14.0 and v15.104.3 also had a bug: a repost did not reset the Bin to zero when no stock ledger entry was left for the item and warehouse.

Cases 1 and 2 are correct behavior. Case 3 needs a fix.

Example: a future-dated entry

Al Noor Foodstuff Trading LLC receives 60 cartons of Mango Juice 1 L Carton (Case of 12) into Jebel Ali Main Store - ANF on 15-10-2026. Then the store keeper submits a Stock Reconciliation that sets the quantity to 0, but posts it on 02-11-2026 by mistake.

On 23-10-2026:

  • The Stock Balance report, with To Date 23-10-2026, shows a balance of 60.
  • The Item dashboard shows "No Stock Available Currently". The Bin already has the quantity after the 02-11-2026 reconciliation, which is 0.

Screenshot to add: 01-item-dashboard-no-stock.png

Screenshot to add: 02-stock-balance-shows-60.png

How to fix it

Step 1: Compare the Bin with the Stock Ledger

  1. Open the Stock Ledger report.
  2. Set Item and Warehouse. Set From Date to the first stock transaction of the item, and To Date to a date far in the future, for example 31-12-2027.
  3. Look at the Balance Qty of the last row. This is the quantity the Bin must have.
  4. Look at the Posting Date of the last rows. If a date is after today, you have case 1.

Screenshot to add: 03-stock-ledger-future-entry.png

  1. Go to Bin (type "Bin List" in the search bar) and filter by Item Code and Warehouse.
  2. Compare Actual Qty with the Balance Qty from step 3.

Screenshot to add: 04-bin-list-actual-qty.png

Step 2: Check the Stock Ledger Variance report

The Stock Ledger Variance report finds stock ledger entries whose balance does not add up. For each item and warehouse, it adds the Qty Change and the Change in Stock Value of every entry, and compares the running total with the Qty After Transaction and Balance Stock Value stored on the entry. It shows the first entry where the two differ.

  1. Go to Stock workspace → Audit Reports → Stock Ledger Variance, or type "Stock Ledger Variance" in the search bar.
  2. Set Company. To check one item, also set Item and Warehouse.
  3. Optional: set Difference In to see one type of difference only:
  • Quantity (A - B): the balance quantity is wrong.
  • Value (G - D): the balance value is wrong.
  • Valuation (I - K): the valuation rate does not match the balance value divided by the balance quantity.
  1. Look at the rows. Each row is one item and warehouse with a difference. A value in A - B, G - D or I - K that is not zero shows what is wrong. The Posting Date, Voucher Type and Voucher No show the first entry where it went wrong.

Screenshot to add: 05-stock-ledger-variance.png

If the report shows no row for the item, the stock ledger is correct. A wrong quantity on the Item dashboard then comes from the Bin or a future-dated entry: go to Step 3 or Step 4.

If the report shows a row for the item, the stock ledger itself is wrong. Fix it with Step 5. Then do Step 4 to update the Bin.

To see every entry of one item and warehouse with these checks, open the Stock Ledger Invariant Check report.

Step 3: Fix a future-dated entry

If the last entry has a wrong future date:

  1. Open the transaction from the Voucher # column of the Stock Ledger.
  2. Cancel it and amend it.
  3. Set the correct Posting Date and Posting Time. To change them, select Edit Posting Date and Time first.
  4. Submit it.

The Item dashboard now shows the same quantity as the Stock Balance report for today.

If the date is correct, nothing is wrong. To see the same number in both places, set the To Date of the Stock Balance report to the date of the last entry.

Step 4: Recalculate the Bin

If the Bin Actual Qty is different from the last Balance Qty in the Stock Ledger, recalculate the Bin:

  1. Open the Bin record for the item and warehouse.
  2. Click Recalculate Values (in v15: Recalculate Bin Qty).

Screenshot to add: 06-bin-recalculate-values.png

  1. Check the message "Bin Values Recalculated" (in v15: "Bin Qty Recalculated").

ERPNext sets Actual Qty from the last stock ledger entry. If there is no stock ledger entry, it sets Actual Qty to 0. It also recalculates the reserved, ordered, planned and projected quantities.

Screenshot to add: 07-bin-after-recalculate.png

  1. Reload the Item and check Stock Levels on the Inventory tab (v15: Dashboard tab).

Step 5: Repost the valuation if the ledger itself is wrong

If the Stock Ledger Variance report shows the item, or the Balance Qty or values in the Stock Ledger are wrong, run Repost Item Valuation (the job that recalculates the stock ledger and the accounting entries from a date). For example, this can happen after a backdated entry or a failed repost.

A repost changes the Stock In Hand and stock expense accounts in the Trial Balance and the Balance Value in the Stock Balance report.

From the Stock Ledger Variance report:

  1. In the report, select the check box of each row to repost.
  2. Click Create Reposting Entries.
  3. Read the message and click Yes.

ERPNext makes one Repost Item Valuation for each row. It starts from the Posting Date and Posting Time of the first wrong entry. The message "Reposting entries created" lists them.

Screenshot to add: 08-stock-ledger-variance-create-reposting.png

  1. Wait until each entry has Status Completed.
  2. Run the Stock Ledger Variance report again. The item must not show now.
  3. Do Step 4 again.

Manually:

  1. Go to Stock → Repost Item Valuation and click + Add Repost Item Valuation.
  2. Set Based On to Item and Warehouse.
  3. Set Item Code, Warehouse and Company.
  4. Set Posting Date to the date of the first wrong entry. Also set Posting Time.
  5. Click Save, then Submit.
  6. Wait until Status is Completed. Then do Step 4 again.

If the repost fails with combine() argument 2 must be datetime.time, not None, the Posting Time is empty. Amend the entry, set Posting Time, and submit it again.

How to prevent it

  • Do not post stock transactions with a future date. If you must, tell your team, because the Item dashboard will show the quantity after that date.
  • Do not delete Stock Ledger Entries, Bins or stock transactions directly in the database. To undo a transaction, cancel it.
  • If you run your own server, keep ERPNext updated. Versions v16.14.0 and v15.104.3 fix a case where a repost left the old quantity in the Bin.
  • Check Repost Item Valuation for entries with Status Failed and fix them.
  • Run the Stock Ledger Variance report once a month, for example before you close the books.
  • In v16.28.0 and later, you can let ERPNext do this check each week. Go to Stock Reposting Settings and select Auto Repost Incorrect Valuation Entries (Weekly). ERPNext then scans the Stock Ledger Variance for the current fiscal year and makes the reposts for you.

If this does not fix it

Raise a support ticket if:

  • Recalculate Values does not change the Bin, or the quantity comes back after a few transactions.
  • Repost Item Valuation fails with an error other than the one on this page.

Include:

  • The item code and the warehouse.
  • The quantity on the Item dashboard, the Bin Actual Qty, and the last Balance Qty in the Stock Ledger.
  • A screenshot of the Stock Ledger report with the filters visible.
  • A screenshot of the Stock Ledger Variance report for the item and warehouse.
  • The name of the failed Repost Item Valuation entry and its Error Log, if any.
  • Whether anyone changed stock data directly in the database or with a custom script.
Last updated 2 hours ago
Was this helpful?
Thanks!