- 4 Posts
- 571 Views
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…