Set decimal places in qty field

Thijs Geeris

In the itemmaster I created a field which is called U_DecPlaces. This is an optionfield with the numbers 0 till 4.

Depending on this field I want to show the decimal places of the quantity field in the salesorderline on the layout. Is this possible? If possible where do I have to put the code?

See also screenshot.

Thanks. Thijs

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/tgeeris/Dec_Places_Qty.JPG]Dec_Places_Qty.JPG[/url]

Philipp Knecht

Hi Thijs
Yes this is possible.
Use the generatescript like:
Dim decplaces As String = ""
decplaces = decplaces.PadRight(DataBand("U_DecPlace"),"0")
textBoxXY.Value = LD.FStr(DataBand("MyField"),"#." & decplaces)
hth