Calculated Field in a portal

[Scott Lafayette]

I have not seen a post that answers this, but direct me if this has already been answered.

I have a line item portal on my invoice layout. extPrice has the following case statement in the definition:

Case ( ProductCode= "ServAgr" ; ( CopiesAllowed * CPC) ; ProductCode= "ServAgrColor" ; ( CopiesAllowed Color * CPC Color) ; ( Quantity * Price ) * ( 1 - ( Discount / 100 ) ))

When the first line item is either one of the two conditional items (servAgr or ServAgrColor), the calculation works AND all other line items will pull the correct price.

It does not work, however, if one of these two conditional items are entered in on any other line except the first one. IN fact, it does not calculate anything for the price.

It does always calculate the correct price for any non conditional item.

Any ideas?

Thank you in advance!

[Fitch]

If all those fields are in the line item table, it will surely work as expected. There's something you're not telling us about what field belongs to what table/TO.

[Scott Lafayette]

First off - THANK YOU! for your response.

I am looking at the tables now - this is what I have:

Current Table ->Orders

Portal ->Order_LineItems (related by OrderID)

ooohhhhhh....

I'm guessing that I know the problem now (although I will not have an immediate solution if this is the problem)

Order_LineItems::Copies Allowed, CPC, Copies Allowed Color and CPC color are ALL in a Tab control on the bottom of the order NOT in the portal.

I am guessing that this is related to only the first line item on any given order? My hunch is that there will be no easy way around this - I may just have to get these fields into the portal so that they can be entered for each new line item?

[Scott Lafayette]

Alright - I think I have my solution. I am just going to combine these two items, add a couple of calculations and should be able to pull this off smoothly. I will post again if I could use more direction.

Again - THANK YOU - I have learned a lot from this forum in the past. This was the first post that I have done, and it definitely helped. I will be back!

[Fitch]

You got it: related fields that are on a layout but not in a portal will show the first matching record of the relationship.