How to Setup Price List Approval process.
As customer requirement , Whenever any changes happen into price list, that record should go to approval process and once it is approved then new price will be available for order creation. How to achieve price list approval process ? Can any one suggesut ?
As a solution If we go for DB trigger approach to capture the old and new values into a custom table and initiate the custom workflow from custom table. If the approver rejects the change in price, then we need to replace the old value in the base tables through API and if it is approved then new price will be available for order creation ? Can any one suggest below points -