Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

how to fix base Qty on warehouse entries

(1) ShareShare
ReportReport
Posted on by 22
Hello, 
 
I am having issue with couple of Sku's where my bin contents are off due to wrong conversion to base qty. is it possible to fix base Qty on the warehouse entries. 
 
here we picked 60 displays from 11-17-f4 and moved to 03-03-c6 but base qty is off.  Now my bins contents are in decimals but on ledger entry says 3000 pcs and bin content 1.2 displays instead of 60 displays.
 
How can I fix this?

Thank you
  • Suggested answer
    D365 Business Central Functional Consultant Profile Picture
    17 on at
    how to fix base qty on warehouse entries
    Hi Paul,
    You can post negative adjustment entry of such items and once the adjustment entry is posted you can follow the below steps.
    • Take the exact count of inventory with base and Item's another UOM.
    • Post the Positive Adjustment Entry of a counted location-wise inventory
      • Note: Before posting, kindly update the correct UOM quantity in the Item Unit of Measure Table of the respective items only through the configuration package without validating the field.
    I hope this will help.
  • Judy Profile Picture
    Microsoft Employee on at
    how to fix base qty on warehouse entries
    Moved to Business central Forum for more assistance.
  • CU27091600-0 Profile Picture
    22 on at
    how to fix base Qty on warehouse entries
    It is defined as 0.0001.
  • CU27091600-0 Profile Picture
    22 on at
    how to fix base qty on warehouse entries
    correct BC
  • André Arnaud de Calavon Profile Picture
    292,884 Super User 2025 Season 1 on at
    how to fix base qty on warehouse entries
    Hi Paul,
     
    Are you using Dynamics 365 SCM or Dynamics 365 BC? The screenshot seems to come form a Business Central application, correct?
  • Suggested answer
    Jun Wang Profile Picture
    7,624 Super User 2025 Season 1 on at
    how to fix base Qty on warehouse entries
    go to the item card, and the go to the UOM page, check if a rounding precision is defined at the bottom of the page.
  • CU27091600-0 Profile Picture
    22 on at
    how to fix base Qty on warehouse entries
    I am getting rounding error.
     
  • Suggested answer
    Jun Wang Profile Picture
    7,624 Super User 2025 Season 1 on at
    how to fix base Qty on warehouse entries
    I don't recommend force change the qty. you could try the following
     
    go to warehouse physical inventory journal, and calculate the qty of that item for the c6 bin, 
    if the qty is still 60 in the calculated qty field in the pieces UOM, then update it to 3000 on the qty field with correct UOM. 
    this way, BC could do a positive adjustment of the difference. Post it and then go to item journal to calculate the warehouse adjustment and post it.
     
    Jun Wang
     
     
     
     
  • CU27091600-0 Profile Picture
    22 on at
    how to fix base Qty on warehouse entries
    I tried to move but only what 1.2 displays.  is it possible to force qty on the posted warehouse entries?  through conf pack or any other journal.  once that base qty is fixed it will correct all the transaction after that move related to that bin. 
  • Jun Wang Profile Picture
    7,624 Super User 2025 Season 1 on at
    how to fix base Qty on warehouse entries
    this is a weird issue. the item ledger entries are showing the correct number. what happens if you move the item from c6 back to F4? 

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,758 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans