set price as % of msrp

I have a re-occuring issue of changing Price A,B&C to be a % of msrp.

Interestingly, RMS has a MSRP field on the Item Price tab and it has a wizard function which does nothing with MSRP. As a matter of fact, MSRP is used in no fuction in RMS I can find.

I'm aware half the retail world uses cost to compute price and the other half uses msrp to compute price.

Are there any solutions to this outside putting MSRP in the Price field and then using the wizard? This is not a solution for me sice I use the Price as it is intended, as a fuction of marging and cost.

Anybody figured this one out?

Is Microsoft even interested?

Reply to
Richard
Loading thread data ...

Hi Richard....I don't think there were many retailers in the operating room when Frankenstein was being put together.... - unfortunately there are many shortcomings to the inventory wizard....let's hope version 3 has addressed these, as they have been frequently pointed out in this newsgroup. Until RMS provides better built-in tools in terms of reporting, price management, and printing tools, RMS users will be forced to edit XML files in notepad and take crash courses in SQL....nevertheless, this newsgroup/forum has been invaluable and a great aid to the RMS community (but I still think it doesn't make up for software shortcomings)

Anyway, you can use a SQL statement to set price a, b and c to be calculated based on what you assign in MSRP. If your pricing rules are straightforward

- meaning all items regardless of dept, category or margin should have their price a, b and c affected by the same % off MSRP, you can try the following statement.

As with all SQL update queries, backup your database before running.

Let's say your price scheme is price a = 10% off msrp, price b = 20% off msrp, price c = 30% off msrp. your udpate query is

update item set pricea = msrp * .9, priceb = msrp * .8, pricec = msrp * .7

If your discount schemes are dependent on dept, category, margin, supplier or other factors you will need to include a where constraint in your update statement.

H> I have a re-occuring issue of changing Price A,B&C to be a % of msrp. >

Reply to
convoluted

Richard, We have made replications of the Price Wizard for some of our programs before. I am certain we could deliver the ability to base your Price Levels off of MSRP through customization. If you are at all interested, please give me a call at 1-888-267-RITE or drop me an email at snipped-for-privacy@rite.us.

Reply to
rsakry

Thanks. I can put the SQL solution to use personally, but I'm hesitant to hand this sledge-hammer to my inventory person. I agree with you, RMS needs some additional thinking to address its real world use.

I c> Hi Richard....I don't think there were many retailers in the operating room

Reply to
Richard

If you need to do this on a recurring basis our power tool for RMS will handle it. First define your formulas in the price calculator:

formatting link
This updates ABC prices automatically for all new item adds.

Whenever a MSRP changes you can click the recalculate button by item:

formatting link
Or recalculate prices for all component items in a matrix with one click.

Power Ops installer:

formatting link
Request installer password: support @ digitalretailer.com

Digital Retail Solutions

formatting link
-- v1.x/2.x compliant add-ins from $49 Trial downloads --
formatting link
Search this newsgroup --
formatting link

Reply to
DRS Support

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.