Update Item Purchase Rate with last Purchase Bill price

Update Item Purchase Rate with last Purchase Bill price

Hi everyone.

I need to keep track of my "most recent cost" or "last cost" per item, so I can establish Sales Prices based on cost.

Has someone created a workflow/custom function to accomplish this?
Can someone guide me to a workaround?

Our business is another one that need a solution from ZOHO to be able to establish automatic pricing based on "markup on cost" rather than on sales price.

Any help will be greatly appreciated.