Customize Opportunity/Quote Entry screen's Quantities EpiUltraGrid section (TotalSellPrice column)


(Erik) #1

Can anyone think of a way to customize the Opportunity/Quote Entry’s “Quantities” EpiUltraGrid section so that the TotalSellPrice is the multiplication of Qty * Doc Unit Price, and if the user changes the Quantity or Doc Unit Price, then the TotalSellPrice is updated to reflect the new numbers?

All these columns are contained in an EpiUltraGrid Collection and the data looks like it comes from the Erp.QuoteQty table. When I query this table, the TotalSellPrice is zero (0) on all the records, so in theory, populating this column with an actual number seems be harmless.

Here are screenshots describing it visually…

(Jose C Gomez) #2

A bpm should be straight forward to do this, Data Directive on QuoteQty

(Erik) #3

That’s what I thought at first too. But where exactly would you apply a BPM, in this scenario?

(Jose C Gomez) #4

Data Directive on QuoteQty (I think that’s the table you are looking at there)