Skip to main content

Notifications

Announcements

No record found.

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.

  • Cezarym Profile Picture
    Cezarym 10 on at
    Business Central: Warehouse entry & Item ledger entry Not Synchronized and how to fix?
    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."
  • bcconsultant14 Profile Picture
    bcconsultant14 44 on at
    RE: Business Central: Warehouse entry & Item ledger entry Not Synchronized and how to fix?

    Hi Geoffrey.

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

  • bcconsultant14 Profile Picture
    bcconsultant14 44 on at
    RE: Business Central: Warehouse entry & Item ledger entry Not Synchronized and how to fix?

    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
    bcconsultant14 44 on at
    RE: Business Central: Warehouse entry & Item ledger entry Not Synchronized and how to fix?

    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!

  • GWixom Profile Picture
    GWixom 20 on at
    RE: Business Central: Warehouse entry & Item ledger entry Not Synchronized and how to fix?

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Business Central: Warehouse entry & Item ledger entry Not Synchronized and how to fix?

    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

  • Suggested answer
    JAngle Profile Picture
    JAngle 48 on at
    RE: Business Central: Warehouse entry & Item ledger entry Not Synchronized and how to fix?

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

    Common over the years of the product it seems

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,187 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,966 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans