I have a quote form that I have added one column to.  This form is based
on temporary tables.  I was able to add the columns with no problem.  I
have an EEP that runs on exit from the Quantity field.  Prior to adding
the new column, it worked in the same row immediately on exiting the
field. Now I have to go to the next row and key through the quantity
field before it triggers.  I have shown the EEP from before and after
adding the new column.

 

Before new column

RECALC VARIABLES

SELECT (SUM(ItemExtPrice)), (SUM(ModelExtWgt)) INTO +

vSubTotal INDIC ivSubTotal, +

vTotalWeight INDIC ivTotalWeight, +

FROM tQuoteDetail2 WHERE QuoteID = .vQuoteID

SET VAR vTotalAmount = (.vSubTotal + .vFreightAmount)

RECALC VARIABLES

RETURN

 

After new column

RECALC VARIABLES

SELECT (SUM(ItemExtPrice)), (SUM(ModelExtWgt)), (SUM(PalletExtCharge))
INTO +

vSubTotal INDIC ivSubTotal, +

vTotalWeight INDIC ivTotalWeight, +

vTotalPalletChrg INDIC ivTotalPalletChrg +

FROM tQuoteDetail2 WHERE QuoteID = .vQuoteID

SET VAR vTotalAmount = (.vSubTotal + .vFreightAmount)

RECALC VARIABLES

RETURN

 

As you can see, I just added the pallet charges to the form.  This EEP
is in the Quantity field of the Quotedetail section. 

 

Jim

Reply via email to