web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / D365 FO WHS picking er...
Supply chain | Supply Chain Management, Commerce
Unanswered

D365 FO WHS picking error: on-hand shows 4 available, but pick says only 0 available

(2) ShareShare
ReportReport
Posted on by AC-03111124-0 2

Hi everyone,

I have an issue in Dynamics 365 Finance and Operations / Warehouse Management.

When I try to pick item 102218, the system shows the following error:

“4 cannot be picked because only 0 is/are available from the inventory for item 102218 and dimensions: Site=10, Warehouse=40, Location=40C20, Inventory status=Avail, License plate=000LP0006655860. Please check physical on-hand.”

The strange thing is that the on-hand quantity looks available for the same dimensions:

  • Item: 102218
  • Site: 10
  • Warehouse: 40
  • Location: 40C20
  • Inventory status: Avail
  • License plate: 000LP0006655860
  • Physical inventory: 4
  • Available physical: 4
  • Physical reserved: 0

I have already checked the usual causes:

  • No open warehouse work for this item / license plate
  • No active reservation found
  • ReservPhysical = 0
  • ReservOrdered = 0
  • Work lines were checked
  • Inventory transactions were checked
  • Inventory transaction origin was checked
  • On-hand list was checked
  • WHSInventReserve was checked
  • Warehouse management on-hand cleanup was executed
  • Consistency check was tested
  • Quality orders / blocking were checked
  • Sales orders / delivery reminders were checked

Earlier we found an inconsistency in WHSInventReserve for another inventory dimension related to PP70 / Receipt. There were orphaned positive values in AvailPhysical and AvailOrdered, while InventSum and InventTrans showed zero. Those values were corrected, and now WHSInventReserve and InventSum seem to be aligned for the current active stock.

At the moment, the remaining visible on-hand is:

  • Warehouse: 40
  • Location: 40C20
  • Inventory status: Avail
  • License plate: 000LP0006655860
  • Quantity: 4

However, the system still says that only 0 is available when trying to pick.

Has anyone seen a similar issue where InventSum / on-hand shows available physical quantity, but the picking process still says that 0 is available?

Which tables or processes should I check next? Could this still be related to WHSInventReserve, reservation hierarchy, license plate inventory, work creation history, or another WHS cache / consistency issue?

Any suggestions would be appreciated.

Categories:
Dynamics 365 Supply Chain Management
I have the same question (0)
  • Assisted by AI
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 2,654 Moderator on at
    The error “4 cannot be picked because only 0 is/are available…” in Dynamics 365 Finance & Operations Warehouse Management usually indicates a mismatch between on-hand (InventSum) and WHS reservation logic. Even though the on-hand inquiry shows 4 available, the picking engine relies on WHSInventReserve and reservation hierarchy checks, which can block the work creation if inconsistencies exist.
    🔍 Deep Analysis of Root Causes
    • WHSInventReserve misalignment Even after cleanup, orphaned or stale records in WHSInventReserve can cause the system to think no quantity is available for picking.
    • Reservation hierarchy mismatch If the reservation hierarchy is configured to reserve at a different level (e.g., batch, location, or license plate), the picking process may fail to recognize the available stock.
    • License plate inventory cache Sometimes the license plate on-hand cache does not refresh correctly after adjustments, leading to discrepancies between InventSum and WHS work creation.
    • Work creation history If previous work was created and canceled, residual reservations may remain hidden in InventTrans or WHSWorkLine.
    • Consistency between InventSum and InventTrans On-hand inquiry shows InventSum values, but picking validates against InventTrans. If InventTrans records are not properly closed, the system blocks picking.
    🧭 Step-by-Step Solution
    1. Recalculate inventory
      • Run Inventory management → Closing and adjustment → Recalculate inventory for the item.
      • This clears stale InventSum values and aligns with InventTrans.
    2. Check WHSInventReserve table
      • Use SQL or Data Management to query WHSInventReserve for item 102218.
      • Ensure no negative or orphaned reservations exist for Site=10, Warehouse=40, Location=40C20, License plate=000LP0006655860.
    3. Validate reservation hierarchy
      • Confirm that the hierarchy matches your picking strategy (e.g., LP-based vs. location-based).
      • If hierarchy expects batch or serial, but stock is only at LP level, picking will fail.
    4. Clear warehouse work cache
      • Navigate to Warehouse management → Periodic → Clean up → Work creation history cleanup.
      • This removes residual work lines that may block availability.
    5. Run consistency check for WHS
      • Execute the Consistency check specifically for WHSInventReserve and InventTrans.
      • Correct any mismatches found.
    6. Test picking again
      • After cleanup and recalculation, retry the picking process.
      • If still blocked, temporarily move the stock to a new license plate/location and re-register it to refresh WHS caches.
  • Assisted by AI
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 2,654 Moderator on at
    Here’s a SQL query example you can use to directly identify mismatched or blocking records in WHSInventReserve for your item and license plate. This will help confirm whether hidden reservations are preventing the pick, even though InventSum shows 4 available.
    -- Check WHSInventReserve entries for item 102218
    SELECT 
        ItemId,
        InventDimId,
        Qty,
        ReservPhysical,
        ReservOrdered,
        AvailPhysical,
        AvailOrdered,
        WorkId,
        CreatedDateTime,
        ModifiedDateTime
    FROM WHSInventReserve
    WHERE ItemId = '102218'
      AND InventDimId IN (
            SELECT InventDimId
            FROM InventDim
            WHERE SiteId = '10'
              AND InventLocationId = '40'
              AND WMSLocationId = '40C20'
              AND InventStatusId = 'Avail'
              AND LicensePlateId = '000LP0006655860'
        )
    ORDER BY ModifiedDateTime DESC;
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 173 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 104 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 102 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans