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.
cost as % of price??
Dec 15, 2005
2 Replies
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:
You might want to take a look at using a Kit Item...
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required