product cost field calculated as unit price in admin PO
My company works with an outside manufacturer, so for every order we receive and sell at UNIT PRICE, we need to generate a PO that we send to our manufacturer with the same SKUS and QUANTITIES from the order but calculated with a custom field called COST. I tried creating a view with the line item table and then creating a rule to calculate the product price and change it to the COST field, however this does not work because the action of calculating product price is not fired off when simply viewing this new view. I am guessing I can do what I want with a combination of views and rules (views to create the PO and rules to change the price) but I can't seem to figure out how. Anyone done somethings similar?