cost as % of price??

can the cost of an item be entered as a percentage of the selling price on the item properties tab? Example: Florist - most arrangements are custom made, no two bouquets are the same. Just put in RMS 3 months ago, and using for other items in retail, but having trouble adapting to customized items.

Reply to
melody
Loading thread data ...

Melody,

The only free way of doing this is to create a SQL Trigger that will update the cost every time a new item is added it does your calculation. Which could be based on a valued entered in an empty field you do not use i.e. MSRP, SubDesc (1 2 or 3) and so on... For example: Price = $10 % of Price = 55% Whenever the item is updated or created it could calculate the as such: Price * SubDescription1 = Cost $10 * .55 = $5.50

Your RMS Partner should be able to help with creating an SQL Trigger.

Rob

"melody" wrote:

Reply to
Rob

You might want to take a look at using a Kit Item...

Reply to
Glenn Adams [MVP - Retail Mgmt]

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.