Net Pricing

  • Thread starter Thread starter Brian Keanie
  • Start date Start date
B

Brian Keanie

Some of my suppliers give me a ListPrice and a Discount from which I can
calculate the NetPrice using a query. Other suppliers give me nothing other
than the NetPrice.

If the NetPrice is to be used in other calculations does this require two
separate "net prices" as in NetPrice1 and NetPrice2. If that is the case how
do you fashion an IF statement to use NetPrice2 when there is no value in
NetPrice1?

Hope this makes sense.
 
Brian,
Seems like a problem in terminology....
I would call all prices from Suppliers as the BasePrice,
all discounts as Discount, and the calculated final price as NetPrice.

Now, rather than try to handle two ways of calculating NetPrice, make all
your pricing conform to the same logic.

Using some sample data...
BasePrice Discount NetPrice
10.00 .10 9.00
10.00 .00 10.00

NetPrice would be calculated for all items exactly the same...
BasePrice * (1 - .10) = NetPrice
or
BasePrice * (1 - .00) = NetPrice

Now NetPrice can be handled just like any other calculation in queries or
reports.
 
Back
Top