updating price / cost

i get several item cost (40-60) changes a week. these are not on po but reflect near future cost increases . i am changing the cost and price in the
"item general tab" because cost, price and margin are changable in the same window. however when making changes in this window rms does not appear to interpit this as an update preventing the use of "last updated" filter in the label wizard. which means i have to go through the agonizingly cumbersom individual label print sequance for each item
any sugestions out there ?
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
One idea I would have would be to use the wizards. While cost and price are two separate wizards, this could be a quick option with the import feature especially if you have frequent updates.
Are you familiar with using imports on the wizards? Are you running a HQ environment?
--
Jocelyn


"jlg" wrote:
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
What costing method are you using? weighted average, last cost, or none? Most users use weighted average, but regardless, if by "item cost changes" and "these are not on po" you mean the vendor has indicated that FUTURE costs will go up (ie starting with your NEXT purchase order), you may want to reconsider manually changing the cost field in the item general tab - - The cost of the item as defined in your received purchase orders should dictate the "cost" value in the item general tab; to update FUTURE costs (those you must use in future POs), update the supplier cost in the SUPPLIER tab of the item's properties - - after updating the supplier cost in the supplier tab all new POs will use that new updated supplier cost.
You can think of the "cost" field in the general tab as either the last cost on a PO, or the weighted average of all past costs used on POs - the idea here is that the system should change the "cost" of your inventory. Another way of viewing cost vs. supplier cost is that "cost" in the general tab is historical cost, whereas cost in supplier tab is future replenishment cost. If you increase the cost in the general tab you may be overstating your true inventory costs - you may want to check with your accountant / auditor for additional guidance on this.
Sorry for the length of this posting, but to get to your actual concern - if you are using Store Operations you can use task 140 Change Item Ordering Info to update supplier costs (costs tracked in the supplier tab)
Hope this helps.....
"jlg" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
I have the same problem. When I receive PO's and have to change prices for items currently in stock, the items don't show up in the label wizard using last updated as the filter. Therefore labels for these items have to be printed one item at a time. Is this a bug, or are we doing something wrong? You would think that changing an items price would be considered updating the item. Craig

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Craig - If you are updating cost based on a weighted average via importing item qty with a PO - you can print labels based on a PO. This is much easier than using the last updated.
--
Jocelyn


"Craig" wrote:
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
"jocelynp" wrote:

not offer a method to change the "Supplier Cost" on the supplier tab of an item other than going to each item look up code and manually changing the"Supplier Cost". RMS does allow you to change the item's original cost on the general tab (the cost that is affected by PO received costs) through the "wizard". But, it does not have a method within a wizard to change the "Supplier Cost" on the supplier tab of the item (this is the cost that displays on a PO). This makes for painstaking work for a retailer dealing with supplier cost changes on matrix items. Suppose one has a Levi jean in stock in sizes 32-42 waist and lengths 30"-32"-34"-36" and it costs the retailer $24.00. Levi then notifies the retailer that the cost has risen $2. The retailer now must go to each item of the matrix and change the "Supplier Cost" to $26.00. The fastest way that I have found to change the supplier cost on every matrix item is to go to Database\Suppliers\Vendor Properties\Items Supplied. Here you are able to change "Supplier Cost" via copy and paste. "Supplier Cost" can be changed on the receipt of a PO of course if the configuration file is checked accordingly. But this method does not change the "Supplier Cost" on the entire matrix...just the items placed and received on the PO. When a retailer receives a "Supplier Cost" change, he or she ideally would like to make one blanket change on the matrix to change the "Supplier Cost" of all matrix components.
It seems this problem could be solved with a wizard called "change Supplier Cost".
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Manager, Wizards, Inventory Wizards, Task 140: Change item ordering info. Choose Item from these suppliers, pick one supplier, generate the worksheet. Click Export button and create a file for use with Excel. Fill in cost column with updated prices then return to the same worksheet and click Import. If satisfied with the results, click Commit.
Digital Retail Solutions www.digitalretailer.com/RMSaddins -- v1.x and 2.x compliant Trial downloads -- www.digitalretailer.com/trial Search this newsgroup -- http://tinyurl.com/2lmk4w

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
"Cost" vs "Supplier Cost"

not offer a method to change the "Supplier Cost" on the supplier tab of an item other than going to each item look up code and manually changing the"Supplier Cost". RMS does allow you to change the item's original cost on the general tab (the cost that is affected by PO received costs) through the "wizard". But, it does not have a method within a wizard to change the "Supplier Cost" on the supplier tab of the item (this is the cost that displays on a PO). This makes for painstaking work for a retailer dealing with supplier cost changes on matrix items. Suppose one has a Levi jean in stock in sizes 32-42 waist and lengths 30"-32"-34"-36" and it costs the retailer $24.00. Levi then notifies the retailer that the cost has risen $2. The retailer now must go to each item of the matrix and change the "Supplier Cost" to $26.00. The fastest way that I have found to change the supplier cost on every matrix item is to go to Database\Suppliers\Vendor Properties\Items Supplied. Here you are able to change "Supplier Cost" via copy and paste. "Supplier Cost" can be changed on the receipt of a PO of course if the configuration file is checked accordingly. But this method does not change the "Supplier Cost" on the entire matrix...just the items placed and received on the PO. When a retailer receives a "Supplier Cost" change, he or she ideally would like to make one blanket change on the matrix to change the "Supplier Cost" of all matrix components.
It seems this problem could be solved with a wizard called "change Supplier Cost".
"bill H" wrote:

not offer a method to change the "Supplier Cost" on the supplier tab of an item other than going to each item look up code and manually changing the"Supplier Cost". RMS does allow you to change the item's original cost on the general tab (the cost that is affected by PO received costs) through the "wizard". But, it does not have a method within a wizard to change the "Supplier Cost" on the supplier tab of the item (this is the cost that displays on a PO). This makes for painstaking work for a retailer dealing with supplier cost changes on matrix items. Suppose one has a Levi jean in stock in sizes 32-42 waist and lengths 30"-32"-34"-36" and it costs the retailer $24.00. Levi then notifies the retailer that the cost has risen $2. The retailer now must go to each item of the matrix and change the "Supplier Cost" to $26.00. The fastest way that I have found to change the supplier cost on every matrix

you are able to change "Supplier Cost" via copy and paste. "Supplier Cost" can be changed on the receipt of a PO of course if the configuration file is checked accordingly. But this method does not change the "Supplier Cost" on the entire matrix...just the items placed and received on the PO. When a retailer receives a "Supplier Cost" change, he or she ideally would like to make one blanket change on the matrix to change the "Supplier Cost" of all matrix components.

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

The procedure as outlined updates the Supplier Cost. Isn't that what you are trying to do?
The General tab cost in Item Properties should be calculated by RMS based on the cost update setting you have defined in Manager, File, Configuration, Inventory tab. This entry will update automatically as you receive items on purchase orders.
Digital Retail Solutions www.digitalretailer.com/RMSaddins -- v1.x and 2.x compliant Trial downloads -- www.digitalretailer.com/trial Search this newsgroup -- http://tinyurl.com/2lmk4w
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Thanks Jocelyn, but what I need to do is print labels only for the items that I changed(updated)the retail price, I do print labels for all items on the PO without any problem. It's the items that I change retail price on that are a pain in the neck. For those items I have to go into the items properties and print price change labels individually. RMS seems to give you the option of printing these items in the label wizard using last updated as the filter, however when I try to use this filter it returns nothing. So I'm stuck printing each label manually. I hope they address this in future fixes. Craig

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Craig, I too have that problem. When i need to print new labels for a group of items that just came in, and there is a price change and I want to print new labels for the stock still on the shelf, I receive the PO, Commit, then go into label wizard, print labels from that po. I click add all, then click the "Number of labels to print" Stock-on-hand", then click set quantity and it prints labels for everything on the shelf. I think this is what you want to do?
Bud
--
If we can''''t pet it, you don''''t want it.


"Craig" wrote:
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Bud, that's close to what I need to do. Not all items on any given PO have price increases on them, if I would commit and then print labels for all stock on hand it would waste a lot of labels. So for the items that do have an increase, I go into that items properties from the PO, change the retail price, go to labels, select stock on hand, print labels, and finally back to the PO to keep receiving. This is my procedure for each item on a PO that has a price increase. I've got pretty fast at doing it this way, but it would be soooo much better if the label wizard did what it was supposed to by selecting last updated. Craig

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Craig, I just remove the items from the wizard i don't want to print labels for. We have mixed products, so I just highlight the ones I want to not print labels for, remove then just print labels for the items that need to be.
Bud
--
If we can''''t pet it, you don''''t want it.


"Craig" wrote:
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Thanks Bud, but that won't work for me since I still need to print labels for the items I received and don't want to print labels for items on the shelf that don't have price changes for them Craig

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Craig,
I also tried using the last updated' field to no avail. It sure would be nice if there was an easy way to select only items with price changes to print labels.
Marc

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.