Decreasing Stock Values

Hi Guys

Been search the net but couldn't find anything.

I have stock items - that is assigned to different parts i've used a vlookup to match parts to the stock item but im having a issue reporting on it

1. At what point the stock level would need to be replenished ie On which part would stock needs to be ordered
2. If you can view the spreadsheet i attached the table in yellow - i don't know how to populate it according to current stock levels , i need it to show positive value when current stock levels allow and for it to show negative value when stock is not available

If im not making sense/hard understanding please let me know. So i can try to better explain my issue

Thanks and regards

Re: Decreasing Stock Values

Hi

Thanks for the response, i figured out a solution i'm sure its not the best solution but its doing what i need it to do.

Im sorry i meant to explain -
("But in the Orders and Stock levels you seem to repeat the heading
[TABLE="class: cms_table, width: 280"]

[TD="class: cms_table_xl66, width: 40, align: right"]38[/TD]
[TD="class: cms_table_xl66, width: 40, align: right"]48[/TD]
[TD="class: cms_table_xl66, width: 40, align: right"]48[/TD]
[TD="class: cms_table_xl66, width: 40, align: right"]38[/TD]
[TD="class: cms_table_xl66, width: 40, align: right"]48[/TD]
[TD="class: cms_table_xl66, width: 40, align: right"]38[/TD]
[TD="class: cms_table_xl66, width: 40, align: right"]58 ")
[/TD]

[/TABLE]

That was not stock levels but different types of boats which linkes up to a certain part, each boat requires a different qty of each part.

Once again thanks for the Response