Multi-Language with shared data

MarkD33

We have a client that just acquired 2 foreign companies. They already have a multi-company setup and, in order to keep their Chart of Accounts consistent, we decided to turn off the DataPerCompany property in the GL Account table.

Now, they've acquired 2 companies in foreign countries (non-English speaking). Since the DataPerCompany property is set to NO (thus sharing the GL Accounts across all companies), the GL account names can only be English or Spanish, regardless of whether the company is in Mexico or the US.

Has anyone ever run into this situation before?

Mark

DenSter

That's what you get when you turn off that property. You can only have one value for each field across the antire database. I personally think it's not a smart thing to turn that property off for any master table, because now you have users from both (or all) companies with the ability to modify the data in that table, and who's to say which one should win. There are many discussions around this property in this forum, so you can search for it and read what's been said.

The multilanguage functionality is for field captions, not for field values. The only way I see how you could have more than one language is to have description/name fields for both languages, and display only the relevant one in the forms/reports.

MarkD33

Thanks for the reply Dan. We came to a similar conclusion also. I was hoping that there might have been another option that we hadn't come up with.

Thanks again.

Mark