Returning a Value from a Data View

[josecgomez]

A few things,
If you are just trying to have an incremental Key take a look at the existing Epicor Solution to accomplish this here’s a walk through

Auto Sequence Customer ID

@Gabriel011212 Here’s a quick video tutorial of how to do this as well as the “code” needed. This works for Customer but can be done for pretty much any module in Epicor. Note that this is done in Post Processing on Customer.GetNew() because in pre-processing we don’t yet have a Customer row. The video may take a few minutes to render in HD (you-tubes fault) It is a simple one line widget [image] [image] [image] new Ice.Lib.NextValue(Db).GetNextSequence("CustIDSeq").ToString("00000")

Further more, if you want to maintain your own (for some reason) then the approach should be a BPM and not UI. Simple put a Post Processing BPM on GetaNewUD11 that does what your SQL query does that is find the Max of whatever and then assign that to your Key Field.