Quantity on Hand filter for Inventory Wizard Worksheets

I'm not trying to say that your suggestion isn't useful, however I don't quite see this as a big issue .. here's why:

You must have a criteria to determine which items are on sale (e.g. All items from Supplier X, or All items in Category Y, or All Items where Last Sold date is less than Z). Of course these out of stock items will not match, but what's wrong with putting the out of stock items on sale? I can't think how it would negatively affect anything. The items will never get sold if they're not in stock. I have a feeling that the main reason for your suggestion is the second part:

This is what the "Stock on hand" option is for (at the top of the item selection screen in the Label Wizard.) Add all the items you want to print labels for (which is probably going to be the same criteria that you just used to put the items on sale with,) then at the top of the window click the "Stock on-hand" option, and then click "Set Quantity". Now if you look at the Print List on the right-hand side, the Qty will be equal to the stock on hand. Note you must do "Set Quantity" button *after* adding the items to the Print List.

Hope this helps.

Small correction to avoid confusion:

Should be "out of stock items will match"

I found the inability to filter by qty on hand for making items active or inactive as a real set back.

For example making items that = 0 on hand inactive.

Granted it can be done outside the system's functionality but that doesn't seem right!

Regarding QTY on hand as a filter...

I was even more surprised that in HQ transfer planer... you cannot set the qty to move from store A to B as the qty on hand in the store it is being transferred from... but perhaps I missed that somewhere?

Marc Wagner

MARC WAGNER, I haven't seen a post from you for the longest time, I thought you fell off the end of the earth (seeings how GTA is pretty close), where have you been?

We all miss your - MICROSOFT ROCKS!!! comments on the Private NG.

Rob

I just tried your suggestions but they don't seem to work. What wizard are you running that lets you select "All Items where Last Sold

The > I'm not trying to say that your suggestion isn't useful, however I don't

The worst thing is that the competition is getting better and we are getting left behind.

Demoralizing!

I can get a better road map for "The Sims" - work that out.

IB

I was wrong about the "Last Sold" bit. I saw "Last Updated", and didn't pay close enough attention to what I was reading.

Marc is right that you can run an SQL query to mark items as inactive based on Last Sold. However it is rather silly that this is not doable within the Manager interface.

As for the labels, I'm not sure how the "Stock on Hand" option is slow. If the Qty to print gets set to 0, then it will not print any labels for that item. This means you can leave those items in the list to be printed, so long as you use the "Stock on Hand" option.

I also realized now that there is no "Sale Price" filter on the Label Wizard. That is just stupid .. no excuses for Microsoft there :)

I've voted for your message on 12/7; it makes the most sense.

Rob... thanks for making me feel like a million bucks :-)

I always tried telling my mom that at some point I'd run out of things to say... I think that is what happened.

Marc Wagner

Marc,

I was beginning to think that I didn't ROCK anymore!! ;-)

Marc, what the hell you been doing? Did you give up on us? Are you still up in the tundra? ;-)

Come on back to the dark side!! ;-(