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

Advance warehouse

(1) Share

Report

Posted on by Jack Carter

100

Hi everyone,
I mistakenly posted a negative adjustment entry using the Warehouse Item Journal, which has resulted in a negative quantity showing in the adjustment bin. My location is set up as an advanced warehouse location.
Now, I need to make a positive adjustment to balance the quantity, but Business Central is not allowing me to make a positive adjustment through the Warehouse Item Journal.
Could someone please guide me on how to resolve this issue and correct the adjustment bin's quantity?
Thanks in advance!

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

All responses (8)

Answers (0)

Suggested answer

Alexander Drogin 8 on at

Like (0)

Report

Advance warehouse

Ah, you hit this nasty warehouse journal posting gap! It is a bug to my opinion, it must not be allowed to post journal lines without a bin code on a WMS location. Nonetheless, this possibility exists, and validation blocking it are implemented only on the UI level, in the journal page itself. And not without issues, apparently.

Now you can do one not quite obvious workaround. Enter a line with quantity -10, it will change the entry type to negative adjustment. Change the type to positive adjustment, but keep the quantity negative and post. Entry will be posted on the adjustment bin as a positive adjustment with quantity = 10.

Some black magic from BC.
Suggested answer

Yi Yong 1,528 Super User 2024 Season 2 on at

Like (0)

Report

Advance warehouse

Hello,

I don't think you can negative adjustment on Warehouse Item Journal without specifying Zone and Bin.

You might want to double-check on the warehouse entries.
Jack Carter 100 on at

Like (0)

Report

Advance warehouse

I mistakenly made a negative adjustment of -10 in the Warehouse Item Journal without defining a zone or bin on the lines. This resulted in the adjustment being applied to the adjustment bin only.
Now, I’m trying to correct this by creating a positive adjustment of 10 in the Warehouse Item Journal, again without specifying a zone or bin. However, the system shows an error (screenshot attached).

Can someone guide me on how to reverse this adjustment from the adjustment bin without affecting quantities in other bins? Leaving the quantity in the adjustment bin as is will cause issues when running the "Calculate Warehouse Adjustment" function on the Item Journal, as it will include this quantity from the adjustment bin.
Suggested answer

YUN ZHU 74,218 Super User 2024 Season 2 on at

Like (0)

Report

Advance warehouse

I remember that it was possible to register positive quantity in Warehouse Item Journal.

I'm also curious what the error message is?

Hope this helps.

Thanks.

ZHU
Alexander Drogin 8 on at

Like (0)

Report

Advance warehouse

What is the exact error message that the warehouse item journal gives you? You should not be worried about negative quantities in the adjustment bin, it's just a virtual container, and you can't post directly on it. When a warehouse operation is posted in the journal, all standard verifications are skipped for adjustment bins, so the error must be related to the actual warehouse bin where you want to post your operation.
Suggested answer

Khushbu Rajvi. 5,496 on at

Like (1)

Report

Advance warehouse

If you get some hint: https://community.dynamics.com/forums/thread/details/?threadid=94001433-f001-ef11-a1fd-6045bdeefb06

https://community.dynamics.com/forums/thread/details/?threadid=23e135d8-db4d-420f-b54f-cd63483823a0
Jun Wang 7,465 Super User 2024 Season 2 on at

Like (0)

Report

Advance warehouse

Did you get an error when trying to do positive adjustment? Please share it so experts could advise.
Suggested answer

Yi Yong 1,528 Super User 2024 Season 2 on at

Like (0)

Report

Advance warehouse

Hello,

You can't post adjustment to adjustment bin in Warehouse Item Journal.

You need to use Item Journal -> Run Cost Adjustment.

https://yiyongonbc.com/2024/12/25/dynamics-365-business-central-introduction-to-warehouse-management-part-2/#2-adjusting-in-directed-warehouse

When you made adjustments using Warehouse Item Journal, you need to finish off with Item Journal -> Run Cost Adjustment.

Otherwise, your warehouse entries will not match with item ledger entries and the inventory value will be inaccurate.