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