Inventroy, blocked for distribution

Linda_Nilsson

Hallo!

We have a few articles, with positive inventory, but to a certain level they are blocked for distribution. For an example, there is an item with 17 on costumer order, there is an inventory of 17, but the system only creates a picking for 7 items.

In this special case, we manually adjust inventory up to 20, to be able to pick the outstanding 10 items.

There is no outstanding quantity, reserved quantity or any special settings to the stock keeping unit. We have the same item on other units, were there hasn’t been a problem.

Has anyone seen this before? We have Navision Attain 3.10.

kine

can you look to the Item Ledger Entires for that item and filter only Open entries? Are there some differences between the entires? (quantity, cost and price is normal - are there some others differences?)

Linda_Nilsson

I've checked the table, and there are 3 open entries. The sum of their remeining quantities, are the same as the inventori, which should be right. I can't identify any strange values.

kine

Try to use zoom function to the Item Card and search for value 10... (the value which is "blocked")...

vanrofi

What is the bin content for this item?

If there's a difference you can try to use the calculate whse adjustment in an item journal. If this doesn't give any record, you have a serious problem (unidentified difference between inventory and whse inventory).

If there is no difference, you can check if these 10 items lay on a bin that is not set up for picking or that is blocked.

Did you check the availability per location?

If this doesn't help, I'll come over to investigate this....

kine

I know cases, when record is not found correctly with filters etc... may be that it is example. Please try run this SQL query (original value is 0):

UPDATE [$ndo$dbproperty] SET diagnostics = 131072

For example it helps me when I wanted to post sales order with item with item tracking, I know that the Lot No. has quantity 100, but it said me that there is no enough quantity on the stock. When I looked into the Entries, there were 2 entries. One with Quantity which the error show as available and rest. It looked as the second entry is not counted. After the executing the SQL query and closing and opening DB, the sales order was posted without problems. Same solution works for situations, when 2 transfer entries are created sometime when posting transfer order... etc..

Tantawan

Hi kine

I've also face the same problem. As I am not a programmer, can I apply SQL query suggested by you to Navision 4.0? Any suggestion will be very much appricated.

Thanks is advance,

ara3n

When you create a pick document from warehouse management. The pick routine checks and sees what you else you've allready picked. So make sure you don't have any open picks for other documents.

ecclectic

check type of bin they are in. it might be in a bin where u cannot pick them automatically. use bin contents to find out where they r