SBX - Search With Button

SBX - Forum Post Title

Item Quantity on Hand shows 35, but bin quantity is 0

Microsoft Dynamics NAV Forum

BryanP123 asked a question on 12 Mar 2018 1:31 PM

Question Status

Suggested Answer

I have a particular item that has 35 units on the item card's Quantity on Hand, but it shows 0 quantity in bin. I created a negative adjustment. However, when I post it to GL it says I don't have the inventory to do it. How can I clear out the Quantity on Hand to 0 so it matches bin content which is 0? 

Reply

Have you checked Item Ledger Entry? Do you have 35 items on location X (no warehouse location, so Bin is blank)? A negative adjustment with qty 35, location X is right.

Reply
Suresh Kulla responded on 12 Mar 2018 9:08 PM

Make sure you check in all the locations. Try to filter the Bin Contents table for that particular item and check.

Reply
Robertas Rackauskas responded on 13 Mar 2018 6:11 AM
My Badges

Hi Bryan

if you use advanced warehouse (directed put-away & pick), you might want to run 'Calculate Warehouse Adjustment' from the Item Journal. In this case whenever the adjustment is made on the warehouse level (Bins), someone has to record it on the Item Ledger Entry level, using Calculate Warehouse Adjustment and posting that journal. Only then Bin Contents will match the Item Ledger Entry.

Hope that helps.

Robertas

Reply
BryanP123 responded on 13 Mar 2018 7:15 AM

Hi Robertas,

I have done that. Every time that I try to post the journal adjustment, it tells me that I have insufficient inventory to do it. If I delete the entry then re-run Calculate Warehouse Adjustment, the entry repopulates but still won't let me post when I try.  

Reply
Robertas Rackauskas responded on 13 Mar 2018 8:11 AM
My Badges

Ok, two quick questions:

- When you run the 'Calculate Warehouse Adjustment', what quantity does it give you? Is it 35?

- Go to Item card and click 'Item By Location'. What does it tell you there on the location in question?

Robertas

Reply
BryanP123 responded on 13 Mar 2018 8:54 AM

After I run the Calculate Warehouse Adjustment, the quantity shows 45 on the populated entry.

Item card shows 39 in quantity with a Net Invoice Quantity of 5.

Reply
Robertas Rackauskas responded on 14 Mar 2018 2:48 AM
My Badges

It does seem confusing, although I'm sure there is a logical explanation, just difficult to see without deeper analysis of transactions. I can't think of any plausible scenario where remaining ILE quantity (39) is less than the required adjustment (45). Not sure what Net Invoice Quantity is - that must be a bespoke development.

Robertas

Reply
BryanP123 responded on 19 Mar 2018 5:26 AM

Now, it says that I have 0 quantity on hand but 10 in bin contents. Is there a way that I can add 10 quantity on hand with adding anymore to bin contents?    

Reply
Yvette.C responded on 10 May 2018 12:11 PM
My Badges

Hi Robertas,

We have the same issue here. Do you know where the difference is from normally?

Thanks,

Yvette

Reply
Robertas Rackauskas responded on 11 May 2018 1:57 AM
My Badges
Suggested Answer

Hi Yvette,

normally the reason of discrepancies is adjusting the warehouse quantity (via Whse. Item journal) but not completing it within the ILE (Item Ledger Entry) level, by calculating and posting warehouse adjustments in the Item Journal. The longer ILE-level adjustments are not run, the more difficult is to reconcile the two.

Another reason for discrepancies can be special developments that don't work well, but I can't comment on this for obvious reasons.

Robertas

Reply
Robertas Rackauskas responded on 11 May 2018 1:57 AM
My Badges
Suggested Answer

Hi Yvette,

normally the reason of discrepancies is adjusting the warehouse quantity (via Whse. Item journal) but not completing it within the ILE (Item Ledger Entry) level, by calculating and posting warehouse adjustments in the Item Journal. The longer ILE-level adjustments are not run, the more difficult is to reconcile the two.

Another reason for discrepancies can be special developments that don't work well, but I can't comment on this for obvious reasons.

Robertas

Reply

SBX - Two Col Forum

SBX - Migrated JS