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

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

(1) Share

Report

Posted on by Curator

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

All responses (3)

Answers (0)

Curator 54 on at

Like (1)

Report

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

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.
Suggested answer

Jainam M. Kothari 8,842 on at

Like (1)

Report

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

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.
Suggested answer

Teddy Herryanto (Th... 13,732 Moderator on at

Like (1)

Report

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

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.