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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Business Central: Warehouse entry & Item ledger entry Not Synchronized and how to fix?

(1) ShareShare
ReportReport
Posted on by

Hi all, 

I have an item ILE=15  &  WE=27 and I found out the gap is due to one SO posted shipment of 12 pcs from Location Warehouse/ bin code '001'.  The warehouse bin mandatory is checked.

I have run the Calculate Warehouse Adjustment on the Item journal and nothing happened.  To fix the issue I need to post a negative adjustment 12 pcs Warehouse/ Bin Code 001.

My questions is:

1. why the Warehouse entry is missing? 

2. could you advise the steps how to post warehouse entry but not impacting the Item ledger entry so that IEL and WE are sync?  Thank you.

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    150 on at

    The last two entries of this thread are useful here: www.navug.com/.../viewthread

    Common over the years of the product it seems

  • Suggested answer
    Community Member Profile Picture
    on at

    Hello,

    Adding to what Josh wrote... I cannot explain with any certainty why the Warehouse Entry is different from ILE. I am also guessing you only have Bin Mandatory for the Location setup and not Directed Pick/Put-Away set to TRUE. My first area to look at is the Posted Shipment. What was the Bin Code entered and Location. If this was filled in correctly,

    I have seen this corrected, from a Microsoft endorsed solution, manually by asking a Partner to do the following:

    Go to Bin Contents

    Change field properties for QUANTITY and QUANTITY (BASE) to editable

    Save

    Go to Bin Contents page/form and update quantities to reflect ILE quantity (i.e. brought from 27 to 15)

    Change field properties back to non-editable

    In the warehouse entries table you see two correcting entries (with no date) for -12, one to correct quantity and the other quantity (base).

    I would read both the article Josh gave you the link to and what I've written and decide the correct approach. Hope this helps but talk to your Partner to assist here.

    Thanks,

    Steve

  • GWixom Profile Picture
    20 on at

    The link from Josh describing how to fix this issue is broken. Do you know of a better link to the article?

  • bcconsultant14 Profile Picture
    44 on at

    Would you mind reposting the link to the article?

    I have the exact same issue and I'm trying to determine why the warehouse entries were not created.

    Thank you!

  • bcconsultant14 Profile Picture
    44 on at

    Ho. Would you mind reposting this article?

    I have the exact same issue and I'm trying to determine why the warehouse entries were not created.

  • bcconsultant14 Profile Picture
    44 on at

    Hi Geoffrey.

    Did you resolve this issue? If so, how did you do that?

  • Cezarym Profile Picture
    36 on at
    Anyone resolve this issue?
    "Calculate Warehouse Adjustments" has no results.
     
    WE has 30 of an item in the warehouse
    ILE has no record of this item in the warehouse.
     
    Also changing the Change field properties to non-editable is not possible when designing the bin contents page.
    Error: "We’ve unlocked the field but other conditions may prevent editing."

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,965 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,125 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 961 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans