Can someone tell me the difference between QuoteDtl.Discount, QuoteDtl.DocDiscount, QuoteDtl.DspDiscount, and QuoteDtl.DocDspDiscount?

I’ve been tasked with “removing the Quote Detail discounts and there detrimental follow-on effects” from the Quote Entry Line screen. I’ve been working on EPICOR for all of 2 months now, on E10.200.27. After seeing a bit of what goes on behind the scenes with this form, two things come to mind… One is that there are way too many interconnected parts in this screen for a EPICOR newbie like me to wade mindlessly into. Two is the number of very similar field names that populate this form (like I asked about in the subject). I’m beginning to pine for the days or yor (.net programming in Visual Studio). But I have to admit this is an interesting challenge. I’ve read through several posts concerning this very topic, but I haven’t seen any mention of the ‘Dsp’ prefix that I see in the QuoteDtl EpiBindings in the customization of our screen. Here’s an example of what I’m talking about.

image

The weird thing is that the ‘Dsp’ fields aren’t in the QuoteDtl table in the ERP TEST db. They aren’t in the Data Dictionary Viewer either. They only show up in the EpiBindings. That’s fairly confusing to me, but I really wanted to know about the difference between the ‘Discount’ and the ‘DocDiscount’ fields for example. I’m going to do a deep dive into some documentation tonight, and hopefully something will magically appear… Sorry for babbling on, and thanks in advance!

Dsp is display. This is primarily for currency issues. The Dsp is a form field and not a data field. The Dsp is a calculated field as an example is your field from the Quote Detail.Document Display Expected Unit Price (I believe).

Your base currency may be USD and your customer could be CAD. The display amount would be in Canadian Dollars but the database field would be in US Dollars. The conversion rate is also stored (if I remember correctly) so as to recreate
the original currency display.

Charlie

To add to what @CTCharlie said, the fields with the Doc prefix are the ones tnat hold the value in the customers currency.