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 ThijsYes 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
0
Please sign in to leave a comment.
Comments
0 comments