How to avoid negative inventory quantity?

kenl

Hello,

Is there any setup in Navision 4.0 to avoid /block negative inventory quantity for an item ?

Thanks,

Ken

Shenpen

In standard Navision, you can set Items to Reserve = Always.

However, it can make things a little bit complicated, f.e. if you have inventory, but your sales order is still reserved from a purchase order, you cannot ship. You have to test it.

My opinion is that reservations should not be used because they are too complex.

You can also use bins granule. You never have negative inventory in a bin, so just set up a bin for every location. Warehouse documents like Inventory Pick or Warehouse Pick don't even suggest to pick negative inventory, so you can catch the problem with it earlier.

Another idea is programming - simply some code to Codeunit 22 or to Item Ledger Entry - OnInsert, that throws an error if inventory would go negative.

f.e. code to Item Ledger Entry - OnInsert:

If Quantity<0 then begin
Item.GET("Item No.");
Item.SETFILTER("Location Filter","Location Code");
Item.CALCFIELDS("Inventory");
If Item.Inventory + Quantity<0 then error('Bad move, baby');
end;

Something like this, but I would rather catch the problem earlier, not when posting...