Thousands separator in PLD

[Former Member]

Hi All,

We have a scenarion whereby our customer has a company operating internationally throughout various countries in Europe, Japan and in the UK with databases centrally located in the UK. The problem the users are facing is when they print invoices and various marketing documents the amounts are confusing for them because of different thousands separator used between Europe and the UK and only one of these can be applied globally in SAP. The question is as follows:

Is it possible to switch the thousands separator to use depending on which currency you have in the marketing documents. For example, EU and GB uses , and . as separator's respectively. Now say you have an invoice in UK it will look like this 1.500,50 and in Europe it will look like this 1,500.50. Can we then say depending on currency it will use , or . as a thousands separator in the PLD respectively?

Hope you can shed some light on this issue.

Many Thanks,

Matt

[Former Member · Accepted solution]

Hi,

First you have to check how many character it has ( ie. Length) of the amunt field. For Example say (1656432.58) then you have to use the following by using formula field

Substring ( (A Field Name Amount),Length(amount)-7,Length(Amount)-5))

will give you the Ten thousand and thousand

Like that you have to split each and every thing and add your format which ever you want like , (or) .

ok

Regards

PL.Chidambaram