Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formatted Search - Auto Refresh

Hi, all,

I have a formatted search which formula is LineTotal = Qty * Price.

When user modify Qty or Price, I would like the LineTotal Auto-Refresh.

However, I can only set Auto Refresh when either "Qty" or "Price" is changed.

Any suggections?

Thanks

Former Member
Former Member replied

hi,

If pVal.Formtype="sss" and pVal.BeforeAction = True And pVal.InnerEvent = False And pVal.EventType = SAPbouiCOM.BoEventTypes.et_VALIDATE Then

Select Case pVal.ItemUID

Case "3" 'Matrix ItemUID

Select Case pVal.ColUID

Case "11", "14" 'Qty Col and Price Col

oMatrix = SBO_Application.Forms.Item(pval.formuid).Items.Item("3").Specific

oEdit = oMatrix.Columns.Item("11").Cells.Item(pval.row).Specific

Dim Qty as Double=oedit.value

oEdit = oMatrix.Columns.Item("14").Cells.Item(pval.row).Specific

Dim xyz

xyz = Split(oEdit.Value, " ", -1)

dim Price as double=cdbl(xyz(1))

oEdit = oMatrix.Columns.Item("21").Cells.Item(pval.row).Specific

oEdit.value=Qty*Price

End Select

End Select

End If

regards,

varma

Edited by: Varma on Oct 6, 2008 11:41 AM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question