Skip to main content

Notifications

Business Central forum
Suggested answer

how to fix base Qty on warehouse entries

Posted on by 72
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
    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
    Judy Microsoft Employee on at
    how to fix base qty on warehouse entries
    Moved to Business central Forum for more assistance.
  • paul22 Profile Picture
    paul22 72 on at
    how to fix base Qty on warehouse entries
    It is defined as 0.0001.
  • paul22 Profile Picture
    paul22 72 on at
    how to fix base qty on warehouse entries
    correct BC
  • Andre Arnaud de Calavon Profile Picture
    Andre Arnaud de Cal... 283,414 Super User 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
    Jun Wang 4,053 Super User 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.
  • paul22 Profile Picture
    paul22 72 on at
    how to fix base Qty on warehouse entries
    I am getting rounding error.
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 4,053 Super User 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
     
     
     
     
  • paul22 Profile Picture
    paul22 72 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
    Jun Wang 4,053 Super User 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? 

Helpful resources

Quick Links

Upcoming TechTalk: Copilot Capabilities…

Review the Copilot features that are currently available in Dynamics 365 Finance…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,414 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,394 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans