You can add multiple price list for the same product by differing unit .
CRM -> Settings -> Product Catalog -> Price Lists.
Create a new price list then assign an existing product to the price list, products can belong to multiple price lists without any issues. You then specify the price list in the opportunity which'll reference the specific products.
You need to add custom lookup to pricelist for this. and then make filter based on the lookup field.
And back to topic, you need to create multi pricelist and then add pricelist items. pricelist items will lookup to your product entity.
Hi Dynamics CRM 31,
If you create n to 1 trelationship with account, it will create pricelist at account level. Try it by settings->customize->customize system-> Entity-> pricelist-> create n to 1 relationship.
This might be helpful, if so mark this as "Answer" or "Vote as helpful"
Dynamics CRM 31, opportunities don't really "become accounts" in the standard CRM data model. You create opportunities for accounts, some of which may be of relationship type "prospect" and others might already be existing "customers". Accounts do have a standard field for the default price list to be used.
In a scenario where you'd want to change the relationship type of the account from "prospect" to "customer" when the first opportunity for them is won, you could trigger a workflow that updates the related account upon opportunity status change. At the same time you could also set the account's default price list to be the same as the one used on the won opportunity. Then the next time you create a new opportunity for this account, it could automatically be using the same default price list.