How are you calculating Sales Price?  Is it a certain markup % over the cost? 

Calculate the Sales Price on the Sales form, not in inventory.  On the Sales form, look up the Cost from the Inventory, and muliptly that times the quantity.

If different inventory items have different markup %, can you make some type of MarkupClass, and then make a database for MarkupClass values to use when calculating Sales price in Sales form.

Example: 
1.  Every inventory item has a MarkupClass value based on type of inventory.

2.  Inventory items: hardware = MarkupClass A, software = MarkupClass C, Packaging = MarkupClass B.

3.  MarkupClass database records: A=20%, B=33%, C=50%

4a.  Sales form does LU of Inventory item fields including Cost and MarkupClass. 

4b.  Sales Price = XLU(....Cost...)  x XLU(......MarkupClass.......)

No time for code, but use @Max() math function, something like this structure:

SalesPrice= @max( @XLU(..ListPrice...) ,   @XLU(...Cost..) * (@XLU(...MarkupClass...) )

Ok, it looks like Im going to need help on the code. Kind of looks like this

If @IsBlank(lp1) then
     lp1 = @max(@XLU(@fn, brp_1, "brpinv!brp_no", "cost"), @XLU(@fn, brp_1, "brpinv!brp_no", "brp list") * (1.3))

I get a type mismatch error with the * multiplier. Would a variable be better?

Bob
Do you never rest? I was not expecting you to get back so fast. Your help is greatly appreciated. I think I will end up using a variable so I can produce the mess you see below. Any criticism or critiquing would also be appreciated.

var vCost as Double
var vPrice as Double
var vBPrice as Double

//vcost is our cost
//vprice = factory list price
//vbprice is our list price

If @isblank(lp1) then {
     vCost = @xlu(@fn, brp_1, "brpinv!brp_no", "cost")
     vPrice = @xlu(@fn, brp_1, "brpinv!brp_no", "list1")
}

if brp_1 = "oliv0038" then
vBPrice = vPrice else
if vCost > 0.00 and vCost < 3.01 then vBPrice = "6.50"
if vCost > 3.00 and vCost < 10.01 then vBPrice = vCost * 2
if vCost > 10.00 and vCost < 20.01 then vBPrice = vCost * 1.9
if vCost > 20.00 and vCost < 30.01 then vBPrice = vCost * 1.8
if vCost > 30.00 and vCost < 40.01 then vBPrice = vCost * 1.7
if vCost > 40.00 and vCost < 50.01 then vBPrice = vCost * 1.6
if vCost > 50.00 and vCost < 60.01 then vBPrice = vCost * 1.5
if vCost > 60.00 and vCost < 70.01 then vBPrice = vCost * 1.4
if vCost > 70.00 and vCost < 100.01 then vBPrice = vCost * 1.3
if vCost > 100.00 then vBPrice = vCost * 1.2

If vPrice > vBPrice lp1 = vPrice
If vBPrice > vPrice lp1 = vBPrice

thanks again for your help!

Thank you Bob
I like your ideas, I like the idea also on having a markup database and not hard coding everything, could you explain that?

Bob
Very very nice! I like being able to adjust pricing on the fly. I even added a date field to the markup form to show the date of the last adjustment. Works beautifully

you note your code as untested is comparable to Burt Rutan saying I think it will fly.
Thank you for your help and words of encouragement. This is what it will look like


var vCost as Double     //vcost is our cost
var vPrice as Double    //vprice = factory list price
var vBPrice as Double  //vbprice is our list price
var vMultiplier as Double   //From MarkUp database
 
If @isblank(lp1) then {
    vCost = @xlu(@fn, brp_1, "brpinv!brp_no", "cost")
    vPrice = @xlu(@fn, brp_1, "brpinv!brp_no", "list1")
    If vCost > 2.99 then {
    vMultiplier = @XLR(@fn, vCost, "MarkUp!LowerLimit", "Multiplier")
   }   
    }
 
vBPrice = vCost * vMultiplier
     If vCost < 3.00 then {
    vBPrice = 6.50 //No multiplier for vCost under $3.00 
    }


If vPrice > vBPrice lp1 = vPrice
If vBPrice > vPrice lp1 = vBPrice

If brp_1 = "oliv0038" Then
lp1 = vPrice