Out of Stock Wrong List

[75Rupert]

Hi,

I have this code to list the items that are out of stock. It is not giving correct list.

Can someone please see why?

Thank you

Please Login or Register  to view this content.

[Trebor76]

Hi 75Rupert,

Try changing this line...

Please Login or Register  to view this content.

...to this:

Please Login or Register  to view this content.

Regards,

Robert

[75Rupert]

Thank you so much I couldn't figure it out.

I tried that but it should have only one result yet it yields that same as the Re_Order code.

There is a formula in the Support sheet that makes the shape have the number "1" for items that are out of stock.

I was also trying to figure out when the stock goes negative and how to handle.

Can you please take a look to see if you have an idea about negative stock numbers. Maybe not allowed to take what is not there?

[jindon]

My guess

Please Login or Register  to view this content.

[75Rupert]

Thank you jindon the code works great!

[beyond Excel]

Hi. In OUT type movements, the inventory must be controlled:

Please Login or Register  to view this content.