- 4 Posts
- 647 Views
JDE & BIP - Decimal vs Comma in French
We are implementing our first company in Quebec with French Language. The seperator for dollars and cents in French is a comma, however in Canadian French business they use decimal. We have an issue on our invoices where BIPublisher is putting comma in some and decimals in others.
When printing documents with a user set-up as French (F in user profile with special handling of FR which seems to drive the Object Language and therefore drive the XSL file) via BIP and the field is set as numeric then BIP automagically formats it with a , (comma) as decimal separator instead of the . (dot).
If the field is set as text then it prints whatever is on the XML; since we have a mix of field definition (string & numeric) we have numbers shown on the same output with , (comma) and . (dot) for numbers.
Where is this F. setting in BIP that makes that change to occur based on some language happen ? Else we have to go through every BIP amount field and ensure that it is set to string…
@Ariel McGee Hello Ariel Ross,
Can you please confirm if you are talking about embedded BI publisher with JD Edwards or One View Reporting? Also, can you please clarify your requirement, which decimal separator are you expecting system to produce?