cancel
Showing results for 
Search instead for 
Did you mean: 

Number Conversion Problem B1 8.8

former_member209771
Active Participant
0 Kudos

Hello All,

I am getting XML data from a Website and transferring these information to SAP B1 8.8 in a 64 bit server, as Orders etc.

But the problem is with numbers.

1) When it is coming in SAP B1 as a multiple of 100. Say in price is 20 in XML , when it is showing in SAP B1 it is showing 2.000,00 ( Server is in GERMAN SETTING).

2) When it is coming in SAP B1 as a multiple of 100. Say in price is 1 in XML , when it is showing in SAP B1 it is showing 10,000.00 ( Server is in AUSTRALIA SETTING).

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello

Solution may goes :

1. You may convert the xml file before you apply it in SAP B1, by replaceing the decimal points, It is an easy replace function

(replace comma to nothing, the point to comma)

or

2. You may change the server decimal settings to the same as SAP B1 decimal settings. (after you changed this you have to restart the addon/service which processes these files).

To do:

in Windows: start menu/RUN and enter INTL.CPL

change the money and number thousand and decimal separators as SAP B1. -> there will be no converion problem any more.

Regards

János

former_member209771
Active Participant
0 Kudos

Thank you for reply.

I cannot change Server Settings or SAP Setting, anything I Have to do with C# by my code.

Edited by: Surojit Kundu on Sep 17, 2010 9:29 AM