Home Page link  

Quantity on Hand filter for Inventory Wizard Worksheets

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Quantity on Hand filter for Inventory Wizard Worksheets Scan Do 12-06-2005
Posted by Scan Do on December 6, 2005, 10:14 am
Please log in for more thread options
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. <sigh>

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.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=c1d314bb-6606-42cc-b361-66a9bb1fda2e&dg=microsoft.public.pos

Posted by Jason Hunt on December 6, 2005, 5:48 pm
Please log in for more thread options
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:


> 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.

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:


> 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.

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.

--

Jason Hunt
Advanced Computer Systems



Posted by Jason Hunt on December 6, 2005, 6:19 pm
Please log in for more thread options
Small correction to avoid confusion:

> Of course these out of stock
> items will not match, but what's wrong with putting the out of stock
> items on sale?

Should be "out of stock items will match"

--

Jason Hunt
Advanced Computer Systems



Posted by Marc Wagner on December 6, 2005, 6:28 pm
Please log in for more thread options
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
www.gmroii.net



> 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:
>
>
>> 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.
>
> 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:
>
>
>> 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.
>
> 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.
>
> --
>
> Jason Hunt
> Advanced Computer Systems
>
>



Posted by Rob on December 6, 2005, 8:21 pm
Please log in for more thread options
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 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
> www.gmroii.net
>
>
>
>> 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:
>>
>>
>>> 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.
>>
>> 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:
>>
>>
>>> 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.
>>
>> 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.
>>
>> --
>>
>> Jason Hunt
>> Advanced Computer Systems
>>
>>
>
>



Similar ThreadsPosted
RMS3 Suggestion- Inventory Wizard by filter November 18, 2007, 9:16 am
Add "Quantity" to filter list for Inventory Wizards January 12, 2006, 2:00 pm
Inventory On Hand Quantity Overwrite April 15, 2008, 4:08 pm
Display quantity updates through Inventory Wizard on Item Movement August 23, 2005, 10:50 am
quantity on hand & quantity sold in one report? January 30, 2007, 9:46 am
When does the quantity on hand.... August 31, 2006, 5:21 pm
On hand quantity in HQ May 15, 2007, 9:25 am
On-hand quantity in HQ November 1, 2007, 11:39 am
set sale schedule by quantity on hand June 4, 2007, 6:25 pm
Discrepancies between on-hand quantity and item movement report September 12, 2007, 12:24 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap