Quantity on Hand filter for Inventory Wizard Worksheets

Dec 06, 2005 9 Replies

Posted on behalf of Digital Retail Solutions:



We got another complaint today (over 100 now on this particular issue) regarding the fact RMS does not include any Quantity on Hand filter for ANY Inventory Wizard Worksheets. This wastes countless hours (all year long) sifting thru items you don't even have in stock. Absolutely maddening to end-users. I have sent this suggestion to MBS numerous times. Ironically the fix to this is so simple it's dumbfounding why it hasn't crept into a hotfix during the last 2 years (after I first suggested it). I haven't seen 1.3 yet but I seriously doubt it made it into that. They would have said something I'm sure. In stock only filter:



1) Either add a checkbox to each wizard that allows you to check off "in-stock items" only before displaying the worksheet or remove them by checking this off on the worksheet. Or
2) Include a quantity on hand column in the worksheet itself so you could click on the column header and sort the zero items to the bottom. Put yourself in the retailers's shoes: Imagine trying to put any group of items on sale in RMS but not have the ability to focus on just the items in stock. Like I said --- maddening. Then --- after you do mark the items down using the wizard -- guess what else doesn't have a QOH filter? The Label Wizard! That means you can't print price labels for everything you just put on sale that are in stock. You really shouldn't have to buy an add-in for this and we shouldn't have to write one. ;-) As it is now you have to purchase RR's item change wizard and RITE's label utility. This stuff falls too close to basic functions to warrant $700+ ifor add-ins just to put some items on sale and print labels. We almost wouldn't mind writing this type of add-in (The Mardowns Controller for RMS), but the only way to sell something like this quickly is price it cheap (say $99) and sell a bunch of them. We can't do that because we have NO ABILITY to reach RMS end-users outside of our own. Catch-22. You can't write cheap, fast turnaround add-ins because you can't reach the end users (all of them). For this to work you would need MBS to send mailers to all end-users or make the mailing list available to resellers

-- and that ain't gonna happen either. Catch-22.


---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.



formatting link


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

formatting link

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

formatting link

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!! ;-(

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required