Developer forum

Forum » Integration » Number conversion on custom fields

Number conversion on custom fields

E-mail notifications
Lars Bo Wassini Dynamicweb Employee
Lars Bo Wassini
Reply
Posted on 19/11/2024 12:50:31

We are using a custom decimal field in the live integration, but it seems that this does not obey the "Number format culture" setting. This means that when the value of the field is transfered in US format - but without decimals, the result is converted wrong.
Fields that have decimals is converted as expected.

Number in BC: 4.299,00
XML: CDATA[4,299]
Value in DW: 4,3
 
Would it be possible to
a) Have the Code Unit in BC add the decimals [2,299.00]?
b) Have the live integration use the "Number format culture" setting for all decimals fields?
c) Have another culture format setting specific for the date/time in log file.
 
 
Thanks
 
Lars Bo Wassini

Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 19/11/2024 17:50:15
Reply

Hi Lars,

a) yes, usually it rerurns the prices with decimals, even if it is 00, try to check with the latest versions 1.2.0.43/1.2.0.44
      <column columnName="OrderLinePriceWithVat"><![CDATA[3,650.00]]></column>
You can set the formatting rules in the currency/general ledger setup (for LCY) settings for the decimals in BC, they are called: "Amount decimal places" and "Unit-Amount decimal places": 2:2 or 2:5

https://doc.dynamicweb.com/Default.aspx?ID=12877#31628


b) "Number format culture" is used in the decimals prices conversions

c) not yet possible as it is hardcoded

Let me know what is your exact issues/requests problems
BR, Dmitrij

 

You must be logged in to post in the forum