on 09-17-2010 8:15 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
9 | |
8 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.