Wednesday, August 20, 2014

Leveraging Extended Pricing For Multiple "Percent Of" Methods

For me, extended pricing is normally brought in to the conversation when there is a need for date specific/promotion based pricing.  However, I had a co-worker ask about a scenario recently that made me consider extended pricing in a new way.

In the scenario, the client needed the following price structure:
  • Flat Retail Price
  • Flat Wholesale Price
  • Discounts based on Wholesale Price (% Off)
They did not want to maintain all three of these items as flat amounts (which would be needed if using standard Dynamics GP pricing, since you can only have on price "method" per item price list).

So, to accomplish this in Extended Pricing, here is what we did...
  • Establish the Base Price Book to contain the Wholesale Prices of items
    • The Price Type in this case would be Net Price since it is a fixed dollar amount
    • This will allow it to be treated as the List Price of the item
  • Establish a Wholesale Price Sheet
    • The Price Type in this case would be Percent of List as 100%, and it would be set to Base Adjusted Price on- Base Price Book
    • This may seem redundant, but I thought it would make for better visibility in terms of what is assigned to customers and items in terms of pricing
  • Establish a Retail Price Sheet
    • The Price Type in this case would be Net Price, with the fixed dollar amount
  • Establish a Discount Price Sheet(s)
    • The Price Type in this case would be Percent of List, with Base Adjusted Price On Base Price Book
In this case, the client could update the Base Price Book and automatically update any number of discount price sheets automatically. 

Christina Phillips is a Microsoft Certified Trainer and Dynamics GP Certified Professional. She is a senior managing consultant with BKD Technologies, providing training, support, and project management services to new and existing Microsoft Dynamics customers. This blog represents her views only, not those of her employer.



1 comment:

Annie said...

Hi Christina
Thank you for the tip!
I am trying out the extended pricing with price sheets in different currencies (USD and SGD). There is no marking for convert functional price in SOP.

I was trying to do an invoice in SOP for Aaron Fitz in Fabrikam and selected SGD.
Noted that the price was calculated using SGD pricelist converted to USD.

When it is marked, it does not have any difference in behavior because the invoice header is SGD...
Both scenarios give the wrong price.
Appreciate if you can provide some guidance?

Thank you so much