Net Pricing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Keanie - 25 Oct 2005 01:53 GMT

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.

Reply to this Message

Arvin Meyer [MVP] - 25 Oct 2005 03:53 GMT

In a query, create a column like this:

NetPrice: IIf(IsNull([NetPrice1],[NetPrice2],[NetPrice1]))

Signature

Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

> 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
[quoted text clipped - 6 lines]
>
> Hope this makes sense.

Reply to this Message

Al Camp - 25 Oct 2005 04:02 GMT

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.

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

> 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
[quoted text clipped - 8 lines]
>
> Hope this makes sense.

Reply to this Message