If I give a 100% discount the discount % field cannot display this as it is set to <9.99. I can’t change this through Dev Mode.
Can this be changed somewhere? if so how do I do that
I usually check what the precision is on the decimal in the database and it is decimal(6,2) so it should support 123.45.
In that case you are usually safe to use Extended Properties you can find it via Menu Search and then you can load the table and adjust the format, it would adjust it everywhere (globally). If you ever need it specific to a UI then you use Customization to Set Extended Properties.
In this scenario I would pick Extended Properties via Menu Search, given that it has enough precision to hold 123.45 – then the question is test to make sure Epicor doesnt allow you do enter 999% discount. If so, then you may need to control it via a BPM to not allow > 100
If anyone wants to learn more about Epicor’s Format and what is stored in the database…
1 Like
I just went into Order Entry Developer Mode to take a screen shot showing the format as <9.99 and greyed out. What I noticed was Mask Input nn.nn was not greyed out, never noticed this before. I changed the Mask input to nnn.nn and tested it out. It worked!
Usually you are supposed to use Tools → Wizards → Extended Properties because you changed it on the text-box, what about the user who uses Paste Insert, Update (Grid) – Ext Props target the EpiBinding and not the control.
While Extended Properties Maintenance targets it globally - Updatable Dashboards what not…
Whatever works for you 
nice
I went into Extended Properties and updated all 4 tables for Quote and Order Entry to display >>9.99. Thank you