Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

% of List Price vs Currency Amount

Posted on by 15

HI All,

What are the Pros & Cons of each pricing method and what are the right questions to ask when deciding on which to use.

We were using % of List and some of our Inventory was moved to Currency Amount - which caused some issues. We also use Multi Currency 

  • Josh Page Profile Picture
    Josh Page on at
    RE: % of List Price vs Currency Amount

    I can't recommend one specifically since that is a business decision however %markup options tend to work well for this type of need. You could then adjust via a percentage increase between the two price levels. Again though this one is a business decision.

  • eklouda Profile Picture
    eklouda 15 on at
    RE: % of List Price vs Currency Amount

    Thank you so much Josh. We update prices yearly but not by a certain percentage.

    However we have retail vs wholesale which is a percentage increase from wholesale. What would you recommend for this type of structure?

  • Suggested answer
    Josh Page Profile Picture
    Josh Page on at
    RE: % of List Price vs Currency Amount

    Below is the Different Price methods. It isn't so much that each has different pro's and con's but that each method calculates differently and can serve a bit of a difference purpose depending on the item. For example lets say the purchase price fluctuates wildly for item X you might want to use a %markup method to ensure that you are always selling at 200%. Now lets say item Y has been the same price for years and is not expected to change, in that case you may just want to use Currency Amount.

    The following table explains how each price method calculates prices.

    Price method

    Equation and description

    =========================

    Currency Amount

    Flat amount

    Enter a flat currency amount for each unit of measure in the price list.

    =========================

    % of List Price

    List price x price percentage

    For each unit of measure, enter a percentage of the item’s list price that’s used to calculate prices. For example, the distributor’s list price for a single can is $0.20, and you want to sell single cans at 250% of list. All single cans are sold at $0.50 (250% x $0.20). You can specify a different list price for each currency, if needed.

    =========================

    % Markup–Current Cost

    Current cost x (100% + price percentage)

    Enter a percentage based on the current cost of each unit of measure. Each time you receive a shipment of an item, the price being charged for the item changes according to the item’s current cost when it was received. For example, the current cost for single cans is routinely updated each time you receive a shipment. If you enter 150% as the price for Can, the price for single cans will always be 250% (100% + 150%) more than you paid for your last shipment.

    =========================

    % Margin–Current Cost

    Current cost + [(current cost x price percentage)/(100% - price percentage)]

    Enter the profit percentage you want to achieve, based on the current cost of the item being sold. Each time you receive a shipment, the current cost for the item is updated and the price changes accordingly. For example, suppose you’ve entered a profit of 25%. The price for single cans will always be 25% more than the current cost.

    =========================

    % Markup–Standard Cost

    Standard cost x (100% + price percentage)

    The prices you charge for each unit of measure are updated only when you update the standard cost. Because the standard cost is updated periodically, the standard cost doesn’t always match the amount you most recently paid for an item. For example, if you enter 150% as the price for a single can, the price for single cans will always be 250% (100%+ 150%) more than the standard cost.

    =========================

    % Margin–Standard Cost

    Standard cost + [(standard cost x price percentage)/(100% -price percentage)]

    The profit percentage you want to achieve is entered, based on the standard cost. Each time the standard cost is updated, the price changes, as well. For example, suppose you’ve entered a profit of 25%. The price for single cans will always be 25% more than the standard cost.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans