I wonder if any users have a better answer to this problem than the one we are presently using.
Once an item has been booked into stock and a buy price entered the program (if the option has been selected) will mark up the item against a sliding scale "Mark up Matrix" and give a Sell price. The mark up is not a simple 10% on anything up to £5.00 and 7% from £5.00 to £50.00 etc but instead an incremental mark up depending which end of the particular band the buy price falls in. This works fine and is a fair way of attributing mark ups.
My problem is when we receive a request to supply an item to a customer that we do not have in stock. We can get a buy price from the supplier but then we need to know exactly what mark up CAFAM will apply so we can give the customer the price we will be charging him.
At present we have two solutions.
a) We open an existing component record in CAFAM and temporarily edit its buy price to see what the marked up sell price will be. (This is all well and good until we use a record for a £50,000 engine to check the sell price for a £12.50 gasket and then forget to escape without saving the changes)
b) We have created a bogus part number "0" which we have left at zero value so it doesn't effect our stock value and we use this to edit the buy price to find the sell price (This raises questions from our accounts department when they get the annual stock print and see this particular part)
Any thoughts from anybody would be gratefully appreciated.
JD - Any chance of an additional menu choice in the Stores section to "Check Sell Price", a simple two fields, enter the buy price and it populates the sell price against the mark up matrix.
