Monday, October 8, 2012

Dynamics GP - Extended Pricing Logic

This is the logical flow of pricing checks in Dynamics GP Extended pricing.
If two prices are setup for an item in the same way, the date is the tiebreaker.
Only dates less than or equal to the sale date are considered.
If the start date is the same, it will use the price with the closest ending date.
If two prices are setup identical, GP will display an error message saying it cannot calculate a price.
The default selling UofM is taken from the Cards>Inventory>Price List> Default Selling UofM field even when using Extended Pricing.
If a price sheet is marked as "Promotional" a prompt will appear to allow the user to choose the promotional price at the time of sale.
If using Price Breaks, be sure to cover all quantity ranges.
If using Myridas Extended Pricing Enhancements, be aware that it works in addition to GP's extended pricing. Be careful not to duplicate pricing/promotions across both modules.

Example:
12 Cases of Bread are sold to Aaron today

If the answer to any of these questions is "Yes" that's where the price is taken, and no more further checks are done.
Price Check Logic:

Direct Assignment:
Does a Price for this many Cases of Bread exist on a Customer Assigned active Price Sheet before today's date?
Does a Price for this many Cases of Bread exist in a Price Group on a Customer Assigned active Price Sheet before today's date?

Book Check:


Does a Price for this many Cases of Bread exist on an active Price Sheet before today's date in a Customer Assigned Price Book?
Does a Price for this many Cases of Bread exist in a Price Group on a Customer Assigned active Price Sheet before today's date in a Customer Assigned Price Book?


Basebook Catch all:


Does a Price for this many Cases of Bread exist on an active Price Sheet before today's date in the BASEBOOK?
Does a Price for this many Cases of Bread exist in a Price Group on an active Price sheet before today's date in the BASEBOOK?

If the answer is "No" to all of these questions, Dynamics GP will not find a price, and will return 0.
If prices are required in the system, an error message will display "A price can't be found for item Bread. Because the system is setup to require prices, you must remove the item."


Additional Notes concerning Extended Pricing and Myridas Pricing Enhancements
  • Each promotion/deal is checked independently
  • If a criteria are met for multiple promotions, they will all trigger
  • Ensure that promotions do not overlap if they are not meant to
  • Frees added by promotions are not taken into account
  • Promotional-priced items are not taken into account unless “Include Promotion Priced Items in Aggregate Count” is set in the Extended Pricing Extras Setup window
  • Does not work on returns
  • Aggregate Pricing only controls which book pricing should be taken from. Regular Extended pricing logic is used against the book, and sheets.
 

1 comment:

  1. Hi,
    Great article!
    Is there a sql script to report on all pricing based on selected customer?
    Many thanks

    ReplyDelete