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

Epicor ERP 10
, , ,
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…

2018-04-05_12_32_30_OpportunityQuoteEntryScreen
2018-04-05_12_32_30_OpportunityQuoteEntryScreen.png773×645 154 KB

2018-04-05_12_32_30_OpportunityQuoteEntryScreen_DeveloperView
2018-04-05_12_32_30_OpportunityQuoteEntryScreen_DeveloperView.png777×626 167 KB

2

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

3

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

4

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