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

Advance warehouse

(1) Share

Report

Posted on by Jack Carter

110

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

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Yi Yong 2,545 Super User 2025 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.

Was this reply helpful? Yes No
Jun Wang 8,200 Super User 2025 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.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,232 Super User 2025 Season 2 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

Was this reply helpful? Yes No
Alexander Drogin 262 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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 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

Was this reply helpful? Yes No
Jack Carter 110 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.

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,545 Super User 2025 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.

Was this reply helpful? Yes No
Suggested answer

Alexander Drogin 262 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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (0)

Report

Advance warehouse

Agree with Yi Yong.

And if it is a quantity issue, you can use Item Journal to adjust it directly.
If it is a location, bin or zone issue, try item reclassification journal

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Jack Carter 110 on at

Like (0)

Report

Advance warehouse

@Yi Yong I am unsure how this happened, but I was able to post a negative adjustment from the Warehouse Item Journal without specifying the Zone and Bin. The system posted the negative entry to the adjustment bin. However, when I attempted to post a positive adjustment, it returned an error, requiring me to define the Zone and Bin.

@YUN ZHU
I have advanced warehousing enabled with Directed Put-away and Pick turned on, which typically prevents posting entries directly through the Item Journals.

@Alexander Drogin
I also tried performing the black magic, but it seems that it failed in this case. The system threw an error: "The Bin Content does not exist."

For further clarity, let me explain my issue:

I have an item, ITEM0001, with an inventory quantity of 10. This quantity is reflected both in the Item Ledger Entries and the Warehouse Entries, stored in BIN001. My goal was to adjust the inventory by reducing it to 0 in both the Item Ledger and Warehouse Entries.

To achieve this, I went into the Warehouse Item Journal to make a negative adjustment. However, I mistakenly left the Zone and Bin fields empty, which resulted in a -10 adjustment to the adjustment bin instead of BIN001.

Realizing the error, I made the correct entry—a negative adjustment of 10 from BIN001. This action removed 10 from BIN001 and added it to the adjustment bin, resulting in a net quantity of 0 in the adjustment bin.

While this appears correct from the Warehouse Entries perspective, the Item Ledger Entries still show an open quantity of 10. When I run the "Calculate Warehouse Adjustments" on the Item Journal for ITEM0001, nothing appears for adjustment because the adjustment bin now shows a quantity of 0 for ITEM0001.

Could you please advise on how to resolve this discrepancy in the Item Ledger Entries?

Was this reply helpful? Yes No