Display of price, amount, percent is truncated

[Former Member]

Hallo,

how to display the numeric(19,6)-fields with all regular digits?

In an UDF (on system Form, e.g. SalesOrder-column U_MyPrice ) it looks like

600

600,1

600,12

instead of

600,00

600,10

600,12

for example.

Can anybody help me?

(PS: I don't want to handle it converted to an string / alphanumeric field.)

Kind regards

Christian

[Former Member · Accepted solution]

How are you declared in form the field "U_MyPrice" ?

[Former Member · Accepted solution]

Hallo Sierdna,

well, it's declared as "price"-field. But it also happens on percent and amount and so on.

Kind regards

Christian

[Former Member · Accepted solution]

Do u thing it has something to do with the Document Rounding settings..??

Vasu Natari.

[Former Member · Accepted solution]

Only for example... I saved xml for "Company Details" form.

Item property supp_zeros="0"... try to change it in your form..

<item uid="24" type="16" left="197" tab_order="470" width="166" top="165" height="15" visible="1" enabled="1" from_pane="1" to_pane="1" disp_desc="0" right_just="0" description="" linkto="" forecolor="-1" backcolor="-1" text_style="0" font_size="-1" supp_zeros="0" AffectsFormMode="1">
  <AutoManagedAttribute /> 
- <specific TabOrder="470">
  <databind databound="1" table="OADM" alias="IncomeTax" /> 
  </specific>
  </item>

[Former Member]

Search SDK Help for supp_zeros.

Select <Specific> Element.

[Former Member]

Ok. It's nice.

Best Regards Cristian

Sierdna

[Former Member]

In this sample from SDK I found what this property can bee applyed to whole matrix item:

<Item uid="Matrix1" description="" disp_desc="0" enabled="1" from_pane="0" 
      height="130" left="5" linkto="" right_just="0" 
      SelectionMode ="1" tab_order="0" to_pane="0" top="5" 
      type="127" visible="1" width="245">
    <autoManagedAttributes /> 
     <Specific AffectsFormMode="1" SelectionMode="0" 
      backcolor="-1" font_size="-1" forecolor="-1" layout="0" 
      supp_zeros="0" 
      text_style="-1" titleHeight="21">
    <columns>
   <action type="add">
    <column AffectsFormMode="1" backcolor="-1" description="" 
            disp_desc="0" editable="0" right_just="0" title="#" 
	    type="16" uid="#" val_off="N" val_on="Y" visible="1" 
	    width="20">
     <databind alias="" databound="0" table="" /> 
     <ExtendedObject /> 
    </column>
    ...
   </action>
  </columns>
 </Specific>
</Item>

[Former Member]

Hi Sierdna,

I tried to find this Specific-property for the Matrix, but I couldn't find it. Would be interesting, can you find it in the SDK? Maybe it's wrong or just possible in XML-way (but I dont think so).

Best regards too

Christian

[Former Member]

From SDK:

"supp_zeros = Specifies whether or not to remove zero padding for it_EDIT, it_EXTEDIT items."

[Former Member]

Hello Sierdna!

it's an iteresting way, but I found it only on "row"-level:

( (EditText)( (Matrix)form.Items.Item("38").Specific ).Columns.Item("U_MyPrice").Cells.Item(3).Specific ).SuppressZeros = false;

Do you think it's possible to assign it to the hole column?

Kind regards

Christian

[Former Member]

Sierdna,

after assigning one single row with "supp_zeros" all rows are displayed in this way! You solved it!

Christian

[Former Member]

Hi,

Plz go to Admistration>System Initialization>General Settings There in the Display tab u can find all the settings which u require to change.

Make the correct rounding settings.

Hope it helps,

Vasu Natari.

[Former Member]

Thanks vasu,

but I thin, that was not my question. For example amounts are configured as having 2 digits. The UDF just display me 1 digit, when the value is 600.10 -> "600,1" (in german). That's not fine....

Kind regards

Christian

[Former Member]

Make sure u used the correct sub type when u added ur UDF like Price,Rate, Quantity .... etc..

Vasu Natari.

[Former Member]

Hello Vasu,

it's declared (in subtype) as price-field.

Your fields don't look as I descibed?

(I have PL 46 (2005 A SP01))

Christian