Small and medium business | Business Central, N...

how to fix base Qty on warehouse entries

(1) Share

Report

Posted on by CU27091600-0

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

Categories:

Business Central

All responses (14)

Answers (0)

Suggested answer

D365 Business Centr... 17 on at

Like (0)

Report
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 Microsoft Employee on at

Like (0)

Report

how to fix base qty on warehouse entries

Moved to Business central Forum for more assistance.
CU27091600-0 72 on at

Like (0)

Report

how to fix base Qty on warehouse entries

It is defined as 0.0001.
CU27091600-0 72 on at

Like (0)

Report

how to fix base qty on warehouse entries

correct BC
André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at

Like (0)

Report

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 7,377 Super User 2024 Season 2 on at

Like (0)

Report

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 72 on at

Like (0)

Report

how to fix base Qty on warehouse entries

I am getting rounding error.
Suggested answer

Jun Wang 7,377 Super User 2024 Season 2 on at

Like (0)

Report

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 72 on at

Like (0)

Report

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 7,377 Super User 2024 Season 2 on at

Like (0)

Report

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?