2 Replies Latest reply on Aug 3, 2009 6:43 AM by TSGal

# Purchase Order Pricing affected by applying a Discount AND  different prices.

### Title

Purchase Order Pricing affected by applying a Discount AND  different prices.

### Post

Hi, I have a situtation that has kept me from not being able to apply a "discount strategy " in the pricing of items to the public  Each day clients are ready to order , and depending on the discount assigned the price changes and the receipt is produced.

Here is the explanation

Table 1

Stockid description baseprice and publicprice

table 2

discounttype, typeof shipment ( can be local or nationa )

table 3

discount type           discount

1                              .25

2                              .28

3                              .30

table 4

type of shipment      percent

1                          3%

2                          9%

how am i able to created a result based on the discount chosen, the  typeofthipment.

1)  Usually what happens is that the price is assigned to the order depeding on the price set on table 1. 2)    therefore, based upon typeofshipment and discounttype and stockid  the product is given a discount type and the final price in the purchase order is recalculated giving a new final price. therefore, table 2 and table 1 must be related (??) so that i can assign a combination and then be able to use formulas to multiply,etc. ???? i thought that i wouldneed the following  table 5
stockid  discountype typofshipment baseprice  2323      1                 1                   120
2323      2                 2                    120
2123       1                2                    120 >question, would i need to do the same  format and repat this item by item ? i hope not  thank i hope you can bring me out of the forest thanks.... thanks.

• ###### 1. Re: Purchase Order Pricing affected by applying a Discount AND  different prices.

what seems complicated to me is that i would need to assing each item, a discountype and typeofshipment.

thuis,

stockid            discountype         typeofshipment

2323                    1                         1

2323                    1                         2

2323                    2                         1

2323                    2                         2

therefore, this would create a final price based upon the discounttype, the baseprice (coming from another table), the type fo shipment ( local or national ).

i hope this explanation is clear.

I dont know how to make the program be abe to look and pick the right item with the right set fo conditions. (for the final price)

thanks

Francisco

• ###### 2. Re: Purchase Order Pricing affected by applying a Discount AND  different prices.

sugarking:

Yes, you may want to put each possible discounttype and typeofshipment in a separate table.  This way, the information could be looked up directly instead of having to calculate each possibility.

In your transaction table, include the discounttype and typeofshipment fields.  The relationship into your lookup file would be based upon stockid, discounttype and typeofshipment, or you could set up a lookup into stockid and discounttype, along with lookup into a second table occurrence based upon stockid and typeofshipment.

TSGal

FileMaker, Inc.