title: I would like to run a query to produce a price list for each customer and product taking into consideration promotional prices and discount prices?
body: <p>We have a number of different promotions (fixed prices and discount %) for each customer.  I want to be able to produce an extract so that we can work out what the price the customer would pay if they were entering a Sales Order direct within Epicor. I then want to use this as part on an internal portal so I will store these prices in a seperate table.</p>
  
  <p>I can extract each item individually i.e. customers &amp; products. but I can't seem to get the logic correct for working out the correct sales price.</p>
  
  <p>This is for Epicor 9.05
  Thanks</p>