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

Warehouse entries and Item ledger entries mismatch due to errored Item reclass

(4) Share

Report

Posted on by Curator

287

Directed pick and put away is NOT turned on.

A warehouse scanner was used to move a quantity of an item from one bin to another - it uses the Item reclass journal on BC. It is item tracked so a lot of lines. For some reason, the transaction errored (a one-off) with the result that not all of the quantity of the item moved to the other bin. Example : 200 moved out of Bin A, only 100 came into Bin B.

Overall, the Inventory level is correct (based off Item ledger entries) but the warehouse entries is incorrect. Thus, I have a mismatch and an incorrect quantity on display in the Bins.

How can I correct this? No access to the warehouse Item journal as Directed pick and put away not enabled. Also, developer stated they cannot write directly to warehouse entries tables even with super permissions. Thus, kinda stuck in limbo.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Teddy Herryanto (Th... 14,302 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You can do Warehouse Item Journal to adjust your warehouse entries.

Use the Calculate Warehouse Adjustment in Item Journal to fix the quantity difference between warehouse entries and item ledger entries.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

you will need to manually reconcile the warehouse bin quantities.

Unfortunately, you can't use the Warehouse Item Journal, and developers can't write directly to Warehouse Entry tables due to system restrictions.

The best workaround is to use the Warehouse Reclassification Journal to manually adjust the bin quantities.

Was this reply helpful? Yes No
Curator 287 on at

Like (1)

Report
Copy link

Link copied!

Unfortunately all replies I have received to this post is to use transactions that can only be used under Directed Pick and Put away (i.e. warehouse Item journal or warehouse reclasssification journal). Directed pick and put away is NOT turned on so these are not available options.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, Although I personally don't recommend it, I hope the information below can give you some tips.

Dynamics 365 Business Central: Can we insert/modify/delete posted data (Posted Documents & Posted Entries) via AL???

https://yzhums.com/54657/

Thanks.

ZHU

Was this reply helpful? Yes No