use non-stock item price as multiplier in Price list GI

I was hoping to be able to build a pricelist GI where it will look at the last cost and then multiply by a number to mark the price up. If this number was a constant for all items, that would be easy, but I want to be able to have different markups for different item classes. I also want colleagues to be able to easily alter the markups without editing the gi. 

I had hoped to create a 'dummy' non stock item for each item class and the pull the 'last cost' for the dummy item and use this as the markup multiplier for the pricelist GI. I plan on hard coding the relevant ones in. If I could do it in SQL it would be a select statement within the select statement to find me the hard coded margin numbers. (Below demo sql is not using the right tables and assumes two classes, but hopefully explains what I'm trying to get)

For the multiplier: 

If  [ClassID] = A, Select [last cost] from [inventory items] where [inventory ID] = [12345], Select [last cost] from [inventory items] where [inventory ID] = [54321]

This will mean that if our sales manager wants to alter the margin on a particular class of product, all he has to do is go to the dummy stock item and alter the last cost (the multiplier) and all items in the pricelist GI will update to the new figures with the new mark-up.

Hi @DanielStarke, @Naveen B 

Instead of using a custom field, may be use can use an attribute and set the markup as default value ( no need to make the attribute mandatory) on Item class profile?

Regards,

@vkumar  Yes, OOB we can use UDF fields in Item Class screen. :)

@DanielStarke  Do you see any challenges/impacts with this approach?