How to translate words from the database

These data should also be "internationalized". If people working in the same company from different countries are using the program, these data should also be in the language of the user. A user in Germany sending out an invoice should have the messages in German, a user in Norway in Norwegian.
As it is now there is only one choice.
To fix this you need to introduce a country table and add the different translations to the appropriate tables so that these messages can be written in the language of the user.

All the user interface is subject to translation, so FA user sending out an invoice in Germany can have messages in German.  The document printout language is defined on target basis (e.g. for invoices you can set document language per customer branch). But unfortunatelly FA does not support multi-language texts stored in database, so e.g. item names will not not be translated.
Janusz

Yes, and then the phrase "Payment due within 10 days" taken from the database would appear in the PO file as

msgid "Payment due within 10 days"
msgstr "whatever it is in your language"

and whenever this phrase appeared in the combo boxes it would be translated to your language.

So my question is: Is there a way to fix this?

Some places are easy to find and some are difficult to find.
The Account Types page is an example.
On the screen 2 of the combo boxes can easily be translated as you say, but the 2 others are difficult to find.

The 2 easy ones are found in the "while" statement starting around line 133 in the file /frontaccounting/gl/manage/gl_account_types.php.
In the label_cell function calls around line 150 the _() are inserted as shown below. When the correct translations are inserted in the PO file, they are translated correctly.
I found that the ($parent_text) could not be empty. You have to assign it some value. Otherwise it returns the whole PO file.

while ($myrow = db_fetch($result))
{

    alt_table_row_color($k);

    $bs_text = get_account_class_name($myrow["class_id"]);
    $parent_text = "-";
    if ($myrow["parent"] == '-1')
    {
        $parent_text = "-";
    }
    else
    {
        $parent_text = get_account_type_name($myrow["parent"]) . " ";
    }

    label_cell($myrow["id"]);
    label_cell(_($myrow["name"]));//   here the _() is put
    label_cell(_($parent_text));//   here the _() is put
    label_cell(_($bs_text));//   here the _() is put
    inactive_control_cell($myrow["id"], $myrow["inactive"], 'chart_types', 'id');
    edit_button_cell("Edit".$myrow["id"], _("Edit"));
    delete_button_cell("Delete".$myrow["id"], _("Delete"));
    end_row();
}
--------------------------------------------------------------------------------------------------------------------------------------------
The 2 combo boxes at the bottom of the page are more difficult to handle. I have not managed to find out where to introduce the _(). I have tried several places in the "gl_account_types.php" file and in the ui_lists.php file and the gl_db_account_types.inc file but I cannot find out where to put them.

Do you have any suggestions where to put the _()?

Placed content in Wiki